Bug #12501 Information schema problems
Submitted: 10 Aug 2005 15:18 Modified: 14 Sep 2005 12:00
Reporter: Joerg Bruehe Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.11 OS:MacOS (OS X 10.4 (x86), also FreeBSD)
Assigned to: Sergei Glukhov CPU Architecture:Any

[10 Aug 2005 15:18] Joerg Bruehe
Description:
Release build of 5.0.11, based on ChangeSet
  1.1950.1.1 05/08/06 03:10:35 kent@mysql.com +1 -0
  make_win_src_distribution.sh:
    Added missing backslashes

Test suite failure:

system_mysql_db_fix            [ fail ]

Errors are (from PATH/mysqltest-time) :
ERROR 1054 (42S22) at line 26: Unknown column 'Grant_priv' in 'where clause'
ERROR 7 (HY000) at line 28: Error on rename of './test/#sql-ae7_2.MYD' to './test/user.MYD' (Errcode: 2)
ERROR 1054 (42S22) at line 33: Unknown column 'Grant_priv' in 'field list'
ERROR 1146 (42S02) at line 67: Table 'test.procs_priv' doesn't exist
ERROR 1146 (42S02) at line 68: Table 'test.procs_priv' doesn't exist
ERROR 1146 (42S02) at line 70: Table 'test.procs_priv' doesn't exist
ERROR 1146 (42S02) at line 72: Table 'test.procs_priv' doesn't exist
ERROR 1054 (42S22) at line 94: Unknown column 'Type' in 'columns_priv'
ERROR 1060 (42S21) at line 100: Duplicate column name 'type'
ERROR 1054 (42S22) at line 108: Unknown column 'Show_db_priv' in 'where clause'
ERROR 1054 (42S22) at line 110: Unknown column 'Alter_priv' in 'user'
ERROR 1054 (42S22) at line 121: Unknown column 'Show_db_priv' in 'field list'
ERROR 1054 (42S22) at line 161: Unknown column 'Grant_priv' in 'user'
ERROR 1054 (42S22) at line 247: Unknown column 'Create_view_priv' in 'where clause'
ERROR 1054 (42S22) at line 254: Unknown column 'Repl_client_priv' in 'user'
ERROR 1054 (42S22) at line 261: Unknown column 'Create_view_priv' in 'user'
ERROR 1054 (42S22) at line 271: Unknown column 'Create_view_priv' in 'field list'
ERROR 1054 (42S22) at line 277: Unknown column 'Create_routine_priv' in 'where clause'
ERROR 1054 (42S22) at line 284: Unknown column 'Show_view_priv' in 'user'
ERROR 1054 (42S22) at line 291: Unknown column 'Create_routine_priv' in 'user'
ERROR 1054 (42S22) at line 299: Unknown column 'Create_routine_priv' in 'field list'
ERROR 1054 (42S22) at line 313: Unknown column 'Create_user_priv' in 'where clause'
ERROR 1054 (42S22) at line 315: Unknown column 'Alter_routine_priv' in 'user'
ERROR 1054 (42S22) at line 316: Unknown column 'Create_user_priv' in 'field list'
ERROR 1064 (42000) at line 472: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
 version for the right syntax to use near 'CHARACTER SET utf8' at line 42
At line 96: Result length mismatch

Occurred:  osx-tiger-x86-5.0-cluster.log   ps-protocol
It is the only failure during this test run!

Note that it is quite similar to bug#11177, but has no preceding failure.

Also quite similar, but with preceding other failures:

system_mysql_db_fix            [ fail ]

Errors are (from PATH/mysqltest-time) :
ERROR 1054 (42S22) at line 26: Unknown column 'Grant_priv' in 'where clause'
ERROR 1146 (42S02) at line 67: Table 'test.procs_priv' doesn't exist
ERROR 1146 (42S02) at line 68: Table 'test.procs_priv' doesn't exist
ERROR 1146 (42S02) at line 70: Table 'test.procs_priv' doesn't exist
ERROR 1146 (42S02) at line 72: Table 'test.procs_priv' doesn't exist
ERROR 1054 (42S22) at line 94: Unknown column 'Type' in 'columns_priv'
ERROR 1060 (42S21) at line 100: Duplicate column name 'type'
ERROR 1054 (42S22) at line 108: Unknown column 'Show_db_priv' in 'where clause'
ERROR 1054 (42S22) at line 247: Unknown column 'Create_view_priv' in 'where clause'
ERROR 1054 (42S22) at line 277: Unknown column 'Create_routine_priv' in 'where clause'
ERROR 1054 (42S22) at line 313: Unknown column 'Create_user_priv' in 'where clause'
ERROR 1064 (42000) at line 472: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8' at line 42
At line 96: Result length mismatch

Occurred: cane-linuxthreads-5.0-max.log   normal

How to repeat:
Test suite failures.
[14 Sep 2005 12:00] Sergei Glukhov
Verified on latest tree(osx-tiger-x86 +  ps-protocol, cane-linuxthreads + normal)
Can't repeat
[28 Sep 2005 1:05] Lou Picciano
Readily, consistently reproducible using MySQL Administrator (WinXP) against v5.0.13 RC (Solaris 9)!
[28 Sep 2005 2:17] Lou Picciano
...but now totally disappeared after running install script and mysql_fix_privilege_tables...