Koozali.org: home of the SME Server

[SOLVED] mysql.init errors logged after upgrade to 8.0b6

Offline Michail Pappas

  • *
  • 351
  • +1/-0
[SOLVED] mysql.init errors logged after upgrade to 8.0b6
« 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
« Last Edit: October 26, 2011, 01:01:58 PM by reqman »

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: mysql.init errors logged after upgrade to 8.0b6
« Reply #1 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
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline Michail Pappas

  • *
  • 351
  • +1/-0
Re: mysql.init errors logged after upgrade to 8.0b6
« Reply #2 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.