Make WordPress Core

Opened 4 years ago

Closed 3 months ago

#36646 closed defect (bug) (wontfix)

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

Reported by: cookiesowns Owned by:
Milestone: 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 (4)

#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
4 years ago

  • Keywords reporter-feedback added
  • Version trunk deleted

#3 @netweb
4 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

#4 @desrosj
3 months ago

  • Milestone Awaiting Review deleted
  • Resolution set to wontfix
  • Status changed from new to closed

This appears that it was only an issue with HHVM jobs. Since support for HHVM was removed from WordPress in 2017 (and there has been a lack of reporter feedback), I’m going to close this out.

Note: See TracTickets for help on using tickets.