Make WordPress Core

Opened 4 years ago

Last modified 8 months ago

#36646 new defect (bug)

Tests failing with MySQL versions greater than 5.6.17, possibility to do with transactions?

Reported by: cookiesowns Owned by:
Milestone: Awaiting Review Priority: normal
Severity: normal Version:
Component: Build/Test Tools Keywords: reporter-feedback
Focuses: Cc:
PR Number:


It appears that our test-suite leveraging WP_UnitTest cases are failing when MySQL is upgraded to a version greater than 5.6.17.

It's known to be failing on 5.7.11, as well as 5.6.2X. After some debugging it seems that this has to do with transactions not properly being handled, so if we interface with the database using WPDB manually, data remains from a previous test, thus breaking our test-suite.

I'm not sure how exactly to debug this, but will to help reproduce and resolve this issue.

All of the WP_UnitTest libraries are fully up to date from trunk.

Change History (3)

#1 @jdgrimes
4 years ago

Can you isolate a particular test that we can use to reproduce this error? I have a feeling that something may be causing the transactions to be committed unexpectedly, but we can't be sure what it is until we identify the specific code needed to reproduce this bug.

#2 @ocean90
3 years ago

  • Keywords reporter-feedback added
  • Version trunk deleted

#3 @netweb
3 years ago

WordPress' Travis CI tests now include a MySQL 5.6.x version in the test matrix, this is currently only the HHVM job:

Currently this is MySQL 5.16.30 https://travis-ci.org/aaronjorbin/develop.wordpress/jobs/137440082#L501

At the moment though 1 test fails and another errors there are no issues using MySQL 5.6.30

Note: See TracTickets for help on using tickets.