| Bug #53394 | Tests: perfschema.myisam_file_io fails | ||
|---|---|---|---|
| Submitted: | 3 May 2010 20:43 | Modified: | 4 Aug 2010 20:07 |
| Reporter: | Guilhem Bichot | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Performance Schema | Severity: | S3 (Non-critical) |
| Version: | next-mr-bugfixing,6.0-codebase-bugfixing | OS: | Linux (64) |
| Assigned to: | Marc ALFF | CPU Architecture: | Any |
[3 May 2010 23:49]
MySQL Verification Team
Thank you for the bug report.
Creating var directory '/home/miguel/bzr/6.0-bugfix/mysql-test/var'...
- symlinking 'var' to '/dev/shm/var_auto_O_yu'
Installing system database...
Using server port 41053
==============================================================================
TEST RESULT TIME (ms)
------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.delete [ pass ] 136
perfschema.myisam_file_io [ fail ]
Test ended at 2010-05-03 20:47:35
[4 May 2010 7:45]
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/107245 3162 Marc Alff 2010-05-04 Bug#53394 Tests: perfschema.myisam_file_io fails Before this fix, the test perfschema.myisam_file_io could fail with spurious failures, depending on which test was executed in the same MTR run. With this fix, the test perfschema.myisam_file_io resets the server status variables, to be independent of previous runs. In particular, performance_schema_*_lost now have a predictable value.
[4 May 2010 8:48]
Marc ALFF
Queued into: - mysql-next-mr-bugfixing - mysql-6.0-codebase-bugfixing Doc team: Fixed test script spurious failure only, no impact on the server
[7 May 2010 9:21]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100507091908-vqyhpwf2km0aokno) (version source revid:alik@sun.com-20100507091737-12vceffs11elb25g) (merge vers: 6.0.14-alpha) (pib:16)
[7 May 2010 9:23]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100507091823-nzao4h3qosau4tin) (version source revid:alik@sun.com-20100507091720-ib9r8uny2aeazvas) (pib:16)
[8 May 2010 17:21]
Paul DuBois
Changes for test case. No changelog entry needed.
[16 Jul 2010 13:14]
Marc ALFF
This fix is tagged SR55TEST, but was not merged in 5.5 Changing to need merge
[16 Jul 2010 13:21]
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/113758 3122 Marc Alff 2010-07-16 Bug#53394 Tests: perfschema.myisam_file_io fails Backport from mysql-next-mr (5.6) to mysql-trunk (5.5)
[16 Jul 2010 19:27]
Marc ALFF
Backported in mysql-trunk-bugfixing (5.5)
[22 Jul 2010 16:12]
Paul DuBois
No changelog entry needed.
[23 Jul 2010 12:23]
Bugs System
Pushed into mysql-trunk 5.5.6-m3 (revid:alik@sun.com-20100723121820-jryu2fuw3pc53q9w) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:18)
[23 Jul 2010 12:30]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100723121929-90e9zemk3jkr2ocy) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (pib:18)
[4 Aug 2010 8:04]
Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:alik@sun.com-20100507093958-2y0wy6svnc3zfgqb) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 8:20]
Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:alik@sun.com-20100507093958-2y0wy6svnc3zfgqb) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 20:07]
Paul DuBois
No changelog entry needed.
Description: ./mtr --mem --no-reorder main.delete perfschema.myisam_file_io main.delete [ pass ] 39 perfschema.myisam_file_io [ fail ] Test ended at 2010-05-03 22:25:40 CURRENT_TEST: perfschema.myisam_file_io --- /home/mysql_src/bzrrepos/mysql-next-mr-bugfixing3/mysql-test/suite/perfschema/r/myisam_file_io.result 2010-02-26 16:16:06.000000000 +0300 +++ /home/mysql_src/bzrrepos/mysql-next-mr-bugfixing3/mysql-test/suite/perfschema/r/myisam_file_io.reject 2010-05-03 23:25:40.000000000 +0300 @@ -45,7 +45,7 @@ Performance_schema_cond_instances_lost 0 Performance_schema_file_classes_lost 0 Performance_schema_file_handles_lost 0 -Performance_schema_file_instances_lost 0 +Performance_schema_file_instances_lost 4 Performance_schema_locker_lost 0 Performance_schema_mutex_classes_lost 0 Performance_schema_mutex_instances_lost 0 How to repeat: ./mtr --mem --no-reorder main.delete perfschema.myisam_file_io repeatable with 6.0-codebase-bugfixing ( tor.didriksen@sun.com-20100501100508-snbetlcd63sr7vsp ) and next-mr-bugfixing ( alik@sun.com-20100324081557-wgupgg1xg1qs1l9s )