Description:
Running make test after compiling 5.0.33 produces a failure in the mysql_upgrade test. This was reported before as Bug #25618
(on 5.0.27) which was marked as a duplicate of Bug #25074. Bug #25074 was closed, but the problem persists in 5.0.33, so I'm filing a new bug report. Output of make test follows.
mysql_upgrade [ fail ]
Errors are (from /home/jkugler/src/mysql-5.0.37/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/mysql_upgrade.result Mon Mar 5 22:40:30 2007
--- r/mysql_upgrade.reject Fri Mar 16 00:29:26 2007
***************
*** 1,127 ****
Run mysql_upgrade once
- mysql.columns_priv OK
- mysql.db OK
- mysql.func OK
- mysql.help_category OK
- mysql.help_keyword OK
- mysql.help_relation OK
- mysql.help_topic OK
- mysql.host OK
- mysql.proc OK
- mysql.procs_priv OK
- mysql.tables_priv OK
- mysql.time_zone OK
- mysql.time_zone_leap_second OK
- mysql.time_zone_name OK
- mysql.time_zone_transition OK
- mysql.time_zone_transition_type OK
- mysql.user OK
- @hadGrantPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadShowDbPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateViewPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateRoutinePriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateUserPriv:=1
- 1
- 1
- 1
- 1
- 1
Run it again - should say already completed
- @hadGrantPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadShowDbPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateViewPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateRoutinePriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateUserPriv:=1
- 1
- 1
- 1
- 1
- 1
Force should run it regardless of wheter it's been run before
- mysql.columns_priv OK
- mysql.db OK
- mysql.func OK
- mysql.help_category OK
- mysql.help_keyword OK
- mysql.help_relation OK
- mysql.help_topic OK
- mysql.host OK
- mysql.proc OK
- mysql.procs_priv OK
- mysql.tables_priv OK
- mysql.time_zone OK
- mysql.time_zone_leap_second OK
- mysql.time_zone_name OK
- mysql.time_zone_transition OK
- mysql.time_zone_transition_type OK
- mysql.user OK
- @hadGrantPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadShowDbPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateViewPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateRoutinePriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateUserPriv:=1
- 1
- 1
- 1
- 1
- 1
--- 1,3 ----
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Result from queries before failure can be found in r/mysql_upgrade.log
Stopping All Servers
Shutting-down Instance Manager
How to repeat:
Compile and run make test
Suggested fix:
Make the tests stricter about which option files they use.