Koozali.org: home of the SME Server

Obsolete Releases => SME Server 8.x => Topic started by: Michail Pappas on October 25, 2011, 12:15:05 PM

Title: [SOLVED] mysql.init errors logged after upgrade to 8.0b6
Post by: Michail Pappas on October 25, 2011, 12:15:05 PM

From the messages log:

Code: [Select]

Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 76: Duplicate column name 'File_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 82: Duplicate column name 'Grant_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 83: Duplicate column name 'Grant_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 84: Duplicate column name 'Grant_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 95: Duplicate column name 'ssl_type'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1061 (42000) at line 106: Duplicate key name 'Grantor'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1054 (42S22) at line 132: Unknown column 'Type' in 'columns_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 154: Duplicate column name 'type'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 164: Duplicate column name 'Show_db_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 181: Duplicate column name 'max_questions'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 191: Duplicate column name 'Create_tmp_table_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 194: Duplicate column name 'Create_tmp_table_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 288: Duplicate column name 'Create_view_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 291: Duplicate column name 'Create_view_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 294: Duplicate column name 'Create_view_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 300: Duplicate column name 'Show_view_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 303: Duplicate column name 'Show_view_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 306: Duplicate column name 'Show_view_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 323: Duplicate column name 'Create_routine_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 326: Duplicate column name 'Create_routine_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 329: Duplicate column name 'Create_routine_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 335: Duplicate column name 'Alter_routine_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 338: Duplicate column name 'Alter_routine_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 341: Duplicate column name 'Alter_routine_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 344: Duplicate column name 'Execute_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 347: Duplicate column name 'Execute_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 360: Duplicate column name 'max_user_connections'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 369: Duplicate column name 'Create_user_priv'
Oct 24 15:48:33 sme-server mysql.init: ERROR 1060 (42S21) at line 387: Duplicate column name 'Routine_type'
Oct 24 15:48:33 sme-server mysql.init: @hadGrantPriv:=1
Oct 24 15:48:33 sme-server mysql.init: 1
Oct 24 15:48:33 sme-server mysql.init: @hadShowDbPriv:=1
Oct 24 15:48:33 sme-server mysql.init: 1
Oct 24 15:48:33 sme-server mysql.init: @hadCreateViewPriv:=1
Oct 24 15:48:33 sme-server mysql.init: 1
Oct 24 15:48:33 sme-server mysql.init: @hadCreateRoutinePriv:=1
Oct 24 15:48:33 sme-server mysql.init: 1
Oct 24 15:48:33 sme-server mysql.init: @hadCreateUserPriv:=1
Oct 24 15:48:33 sme-server mysql.init: 1
Oct 24 15:48:33 sme-server mysql.init: waiting for mysqld to restart

Additional info:

Code: [Select]

# rpm -qf /usr/bin/mysql
mysql-5.0.77-4.el5_6.6


Title: Re: mysql.init errors logged after upgrade to 8.0b6
Post by: cactus on October 25, 2011, 12:58:00 PM

AFAICT this could be normal lognoise from the scripts that are run as part of the post-install and post-upgrade process. The only means that the actions in the script are not being performed as they are already performed in an earlier run.

What is the output of

Code: [Select]

service mysqld status

Title: Re: mysql.init errors logged after upgrade to 8.0b6
Post by: Michail Pappas on October 26, 2011, 01:01:42 PM

Code: [Select]

# service mysqld status
run: /service/mysqld: (pid 3438) 11904s, normally down; run: log: (pid 1609) 11962s

Seems this is a known issue though (see http://bugs.contribs.org/show_bug.cgi?id=5486 ) , so consider this thread closed.