[wp-trac] [WordPress Trac] #31537: Database lock timeout in phpunit (fresh install)

[WordPress Trac]

#31537: Database lock timeout in phpunit (fresh install)
------------------------------+-----------------------------
 Reporter:  byron.hawkins     |      Owner:
     Type:  defect (bug)      |     Status:  new
 Priority:  normal            |  Milestone:  Awaiting Review
Component:  Build/Test Tools  |    Version:  trunk
 Severity:  normal            |   Keywords:
  Focuses:                    |
------------------------------+-----------------------------
 After following the [https://make.wordpress.org/core/handbook/automated-
 testing instructions], most of the tests fail with "lock timeout" errors
 in the database. I tried versions 4.1 (revision 30975), 4.1.1 (revision
 31478) and the latest (revision 31602), testing against the included
 `./src/` directory.

 I have MySQL configured to allow 30,000 connection with a timeout of 500
 seconds, and my Ubuntu 14.04 server has 16GB RAM completely available for
 the tests. There is minimal load on the database while the tests are
 executing, so the problem is caused by some kind of direct conflict on the
 `wptests_options` table. Here is a sample of the errors:

 {{{
 WordPress database error Lock wait timeout exceeded; try restarting
 transaction for query
 UPDATE `wptests_options` SET `option_value` = '1' WHERE `option_name` =
 'comments_per_page'
 made by PHPUnit_TextUI_Command::main, PHPUnit_TextUI_Command->run,
 PHPUnit_TextUI_TestRunner->doRun,
 PHPUnit_Framework_TestSuite->run, PHPUnit_Framework_TestSuite->run,
 PHPUnit_Framework_TestCase->run,
 PHPUnit_Framework_TestResult->run, PHPUnit_Framework_TestCase->runBare,
 Tests_Comment_GetCommentsPagesCount->tearDown, update_option
 }}}

 If this problem is caused by an unmet configuration dependency, then that
 requirement needs to be stated plainly on the instruction page for the
 automated tests. Users should be able to simply download and run the
 tests, without having to figure out the required configuration.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/31537>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform