Topic: 10fix_privilege_tables: ERROR

[SchulzStefan]

I need some help to point me in the right direction:

During the startup I get the following errors in the messages.log:

Aug 23 11:45:14 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
Aug 23 11:45:14 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
Aug 23 11:45:14 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
Aug 23 11:45:14 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
Aug 23 11:45:14 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1054 (42S22) at line 87: Unknown column 'Type' in 'columns_priv'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 93: Duplicate column name 'type'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 103: Duplicate column name 'Show_db_priv'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 120: Duplicate column name 'max_questions'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 130: Duplicate column name 'Create_tmp_table_priv'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 133: Duplicate column name 'Create_tmp_table_priv'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1061 (42000) at line 141: Duplicate key name 'Grantor'
Aug 23 11:45:15 warp 10fix_privilege_tables: @hadGrantPriv:=1
Aug 23 11:45:15 warp 10fix_privilege_tables: 1
Aug 23 11:45:15 warp last message repeated 2 times
Aug 23 11:45:15 warp 10fix_privilege_tables: @hadShowDbPriv:=1
Aug 23 11:45:15 warp 10fix_privilege_tables: 1
Aug 23 11:45:15 warp last message repeated 2 times

Thank's for any reply in advance.

stefan

[chris burnat]

Stephan,  Bugzilla is your friend....
Check :  http://bugs.contribs.org/show_bug.cgi?id=3223

  ------- Comment  #1 From John H. Bennett III  2007-07-30 05:57:05  [reply] -------
These errors have been around for quite some time.  Here is an excerpt from the
script that is run.

more /usr/share/mysql/mysql_fix_privilege_tables.sql
-- This script converts any old privilege tables to privilege tables suitable
-- for MySQL 4.0.

-- You can safely ignore all 'Duplicate column' and 'Unknown column' errors"
-- because these just mean that your tables are already up to date.
-- This script is safe to run even if your tables are already up to date!

Nothing to worry about.
chris

[SchulzStefan]

Chris,

you are right! Bugtracker is the friend of everybody!

Thank you for your reply.

stefan