Bug #27191 mysql_upgrade fails in make test
Submitted: 15 Mar 2007 21:41 Modified: 16 Mar 2007 9:35
Reporter: Joshua Kugler (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Compiling Severity:S2 (Serious)
Version:5.0.37 OS:Linux (Linux (tar.gz download))
Assigned to: CPU Architecture:Any

[15 Mar 2007 21:41] Joshua Kugler
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.
[15 Mar 2007 21:42] Joshua Kugler
Forgot to set severity
[16 Mar 2007 9:35] Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Patch for bug #25074 pushed to 5.0.38, 5.1.17 trees which are not available yet. Please wait next release.