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: |
|
Owned by: | |
|---|---|---|---|
| Milestone: | Awaiting Review | Priority: | normal |
| Severity: | normal | Version: | |
| Component: | Build/Test Tools | Keywords: | reporter-feedback |
| Focuses: | Cc: | ||
| PR Number: |
Description
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)
#3
@
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
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.