Make WordPress Core

Opened 7 years ago

Closed 4 years ago

#38032 closed defect (bug) (worksforme)

dbDelta() unit tests lock on MySQL 8.0

Reported by: pento's profile pento Owned by:
Milestone: Priority: normal
Severity: normal Version:
Component: Build/Test Tools Keywords:
Focuses: Cc:


Tests_dbDelta fails when running against MySQL 8.0.

WordPress database error Lock wait timeout exceeded; try restarting transaction for query 
                        CREATE TABLE wptests_dbdelta_test (
                                id bigint(20) NOT NULL AUTO_INCREMENT,
                                column_1 varchar(255) NOT NULL,
                                column_2 text,
                                column_3 blob,
                                PRIMARY KEY  (id),
                                KEY key_1 (column_1),
                                KEY compound_key (id,column_1),
                                FULLTEXT KEY fulltext_key (column_1)
                        ) ENGINE=MyISAM
                         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_dbDelta->setUp

Change History (1)

#1 @SergeyBiryukov
4 years ago

  • Milestone Future Release deleted
  • Resolution set to worksforme
  • Status changed from new to closed

Cannot reproduce this on MySQL 8.0.16 or 8.0.19.

See #44384, #44586, and #49344 for other Tests_DB and Tests_dbDelta issues with MySQL 8.0.

Note: See TracTickets for help on using tickets.