Bug #11177 Unknown tables and columns in test
Submitted: 8 Jun 2005 16:26 Modified: 23 Jun 2005 17:06
Reporter: Joerg Bruehe Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.7 OS:HP/UX (HP-UX, 64 bit (HP-PA only))
Assigned to: Jim Winstead CPU Architecture:Any

[8 Jun 2005 16:26] Joerg Bruehe
Description:
First release build of 5.0.7, based on ChangeSet
  1.1940.1.1 05/06/07 08:23:46 igor@rurik.mysql.com +3 -0
  Merge rurik.mysql.com:/home/igor/dev/mysql-4.1-0
  into rurik.mysql.com:/home/igor/dev/mysql-5.0-0

Test failure in both default and "--ps-protocol" test of
- "standard" build on hp3750
- "max" build on hpux11
(in both cases the other passed!)

It might be related to a preceding crash of test "sp" on these machines, but this is just speculation.

Symptom is this:

system_mysql_db_fix            [ fail ]

Errors are (from /home/mysqldev/hp3750-64bit/test/mysql-standard-5.0.7-beta-hpux11.00-hppa2.0w-64bit/mysql-test/var/log/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 272: Unknown column 'Create_routine_priv' in 'where clause'
ERROR 1054 (42S22) at line 308: Unknown column 'Create_user_priv' in 'where clause'
/home/mysqldev/hp3750-64bit/test/mysql-standard-5.0.7-beta-hpux11.00-hppa2.0w-64bit/bin/mysqltest: At line 94: Result length mismatch
(the last lines may be the most important ones)

Ending Tests

How to repeat:
Build + test.
[23 Jun 2005 17:06] Jim Winstead
This is due to the failing sp test.