| Bug #44493 | Fix InnoDB owned 5.0 tests with imperfect cleanup | ||
|---|---|---|---|
| Submitted: | 27 Apr 2009 12:53 | Modified: | 4 Aug 2009 23:55 |
| Reporter: | Matthias Leich | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.0, 5.1, 6.0 | OS: | Any |
| Assigned to: | Matthias Leich | CPU Architecture: | Any |
[27 Apr 2009 15:41]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/72841 2731 Matthias Leich 2009-04-27 Fix for Bug#44493 Fix InnoDB owned 5.0 tests with imperfect cleanup Details: innodb-autoinc-optimize Add DROP TABLE which is missing (Backport of fix from 5.1) innodb_notembedded Take care that the disconnects of additional sessions are completed. innodb Reset the modified value of global.innodb_thread_concurrency to its's original value (Backport of fix from 5.1). Backport of some code/comments from 5.1 with the goal to reduce the differences between 5.0 and 5.1 version. Note: The merge 5.0 -> 5.1 for innodb-autoinc-optimize and innodb should be a "null" merge = no changes in 5.1.
[6 May 2009 14:55]
Matthias Leich
The pushed fix for Bug#43309 Test main.innodb can't be run twice corrected the issue within t/innodb.test. ==> No need to touch this test.
[6 May 2009 15:09]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/73508 2735 Matthias Leich 2009-05-06 Fix for Bug#44493 Fix InnoDB owned 5.0 tests with imperfect cleanup Details: innodb-autoinc-optimize Add DROP TABLE which is missing (Backport of fix from 5.1) innodb_notembedded Take care that the disconnects of additional sessions are completed. Note: The merge 5.0 -> 5.1 for innodb-autoinc-optimize should be a "null" merge = no changes in 5.1.
[30 Jul 2009 17:31]
Matthias Leich
Pushed to mysql-pe mysql-5.1-bugteam The push to mysql-5,0-bugteam will follow soon.
[30 Jul 2009 20:01]
Matthias Leich
Pushed to mysql-5.0-bugteam
[4 Aug 2009 13:55]
Bugs System
Pushed into 5.0.85 (revid:davi.arnaut@sun.com-20090804135315-6lfdnk4zjwk7kn7r) (version source revid:davi.arnaut@sun.com-20090804135315-6lfdnk4zjwk7kn7r) (merge vers: 5.0.85) (pib:11)
[4 Aug 2009 19:51]
Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090804194615-h40sa098mx4z49qg) (version source revid:kristofer.pettersson@sun.com-20090730162704-3f9d8107zlgouyne) (merge vers: 5.4.4-alpha) (pib:11)
[4 Aug 2009 20:45]
Bugs System
Pushed into 5.1.38 (revid:davi.arnaut@sun.com-20090804204317-ggodqkik7de6nfpz) (version source revid:davi.arnaut@sun.com-20090804204317-ggodqkik7de6nfpz) (merge vers: 5.1.38) (pib:11)
[4 Aug 2009 23:55]
Paul DuBois
Test case changes. No changelog entry needed.
[1 Oct 2009 5:59]
Bugs System
Pushed into 5.1.39-ndb-6.3.28 (revid:jonas@mysql.com-20091001055605-ap2kiaarr7p40mmv) (version source revid:jonas@mysql.com-20091001055605-ap2kiaarr7p40mmv) (merge vers: 5.1.39-ndb-6.3.28) (pib:11)
[1 Oct 2009 7:25]
Bugs System
Pushed into 5.1.39-ndb-7.0.9 (revid:jonas@mysql.com-20091001072547-kv17uu06hfjhgjay) (version source revid:jonas@mysql.com-20091001071652-irejtnumzbpsbgk2) (merge vers: 5.1.39-ndb-7.0.9) (pib:11)
[1 Oct 2009 13:25]
Bugs System
Pushed into 5.1.39-ndb-7.1.0 (revid:jonas@mysql.com-20091001123013-g9ob2tsyctpw6zs0) (version source revid:jonas@mysql.com-20091001123013-g9ob2tsyctpw6zs0) (merge vers: 5.1.39-ndb-7.1.0) (pib:11)
[5 Oct 2009 10:50]
Bugs System
Pushed into 5.1.39-ndb-6.2.19 (revid:jonas@mysql.com-20091005103850-dwij2dojwpvf5hi6) (version source revid:jonas@mysql.com-20090930185117-bhud4ek1y0hsj1nv) (merge vers: 5.1.39-ndb-6.2.19) (pib:11)
Description: innodb-autoinc-optimize Add DROP TABLE which is missing (Backport of fix from 5.1) innodb_notembedded Take care that the disconnects of additional sessions are completed. innodb Reset the modified value of global.innodb_thread_concurrency to its's original value. (Backport of fix from 5.1) Depending on if the InnoDB colleagues agree a backport 5.1 -> 5.0 of other improvements of innodb.test might be also done. How to repeat: Please execute ./mtr --check-testcases innodb-autoinc-optimize \ innodb In case of innodb_notembedded the reproduction of the problem is complicated, because we need high additional load on the testing box and the test following after innodb_notembedded must be very sensitive to the number of current sessions. Example: Let's assume the test following innodb_notembedded starts with something like let $count_sessions= query_get_value(SHOW STATUS LIKE 'Threads_connected', Value, 1); --echo # Number of current sessions: $count_sessions So if the disconnects belonging to innodb_notembedded are not completed, the following test will fail with an unexpected number of connected threads. Please have a look at http://forge.mysql.com/wiki/How_to_Create_Good_Tests#Risky_handling_around_additional_sess... where such effects and the usual solution are explained.