Topic: Boot errors

[ElFroggio]

Hi,

I get the following errors on boot:

Code: [Select]

Jun 12 19:00:38 ethelbert ntpd[4825]: ntpd 4.2.2p1@1.1570-o Mon Dec  9 14:35:05 UTC 2013 (1)
Jun 12 19:00:38 ethelbert ntpd[4825]: logging to file /dev/stdout
Jun 12 19:00:42 ethelbert mysql.init: ERROR 1060 (42S21) at line 108: Duplicate column name 'File_priv'
Jun 12 19:00:42 ethelbert mysql.init: ERROR 1060 (42S21) at line 114: Duplicate column name 'Grant_priv'
Jun 12 19:00:42 ethelbert mysql.init: ERROR 1060 (42S21) at line 115: Duplicate column name 'Grant_priv'
Jun 12 19:00:42 ethelbert mysql.init: ERROR 1060 (42S21) at line 116: Duplicate column name 'Grant_priv'
Jun 12 19:00:42 ethelbert mysql.init: ERROR 1060 (42S21) at line 127: Duplicate column name 'ssl_type'
Jun 12 19:00:42 ethelbert kernel: br0: port 1(eth0) entering forwarding state
Jun 12 19:00:42 ethelbert mysql.init: ERROR 1061 (42000) at line 138: Duplicate key name 'Grantor'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1054 (42S22) at line 164: Unknown column 'Type' in 'columns_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 186: Duplicate column name 'type'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 196: Duplicate column name 'Show_db_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 213: Duplicate column name 'max_questions'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 223: Duplicate column name 'Create_tmp_table_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 226: Duplicate column name 'Create_tmp_table_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 320: Duplicate column name 'Create_view_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 323: Duplicate column name 'Create_view_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 326: Duplicate column name 'Create_view_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 332: Duplicate column name 'Show_view_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 335: Duplicate column name 'Show_view_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 338: Duplicate column name 'Show_view_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 355: Duplicate column name 'Create_routine_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 358: Duplicate column name 'Create_routine_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 361: Duplicate column name 'Create_routine_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 367: Duplicate column name 'Alter_routine_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 370: Duplicate column name 'Alter_routine_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 373: Duplicate column name 'Alter_routine_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 376: Duplicate column name 'Execute_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 379: Duplicate column name 'Execute_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 392: Duplicate column name 'max_user_connections'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 401: Duplicate column name 'Create_user_priv'
Jun 12 19:00:43 ethelbert mysql.init: ERROR 1060 (42S21) at line 423: Duplicate column name 'Routine_type'
Jun 12 19:00:43 ethelbert mysql.init: @hadGrantPriv:=1
Jun 12 19:00:43 ethelbert mysql.init: 1
Jun 12 19:00:43 ethelbert last message repeated 7 times
Jun 12 19:00:43 ethelbert mysql.init: @hadShowDbPriv:=1
Jun 12 19:00:43 ethelbert mysql.init: 1
Jun 12 19:00:43 ethelbert last message repeated 7 times
Jun 12 19:00:43 ethelbert mysql.init: @hadCreateViewPriv:=1
Jun 12 19:00:43 ethelbert mysql.init: 1
Jun 12 19:00:43 ethelbert last message repeated 7 times
Jun 12 19:00:43 ethelbert mysql.init: @hadCreateRoutinePriv:=1
Jun 12 19:00:43 ethelbert mysql.init: 1
Jun 12 19:00:43 ethelbert last message repeated 7 times
Jun 12 19:00:43 ethelbert mysql.init: @hadCreateUserPriv:=1
Jun 12 19:00:43 ethelbert mysql.init: 1
Jun 12 19:00:43 ethelbert last message repeated 7 times
Jun 12 19:00:43 ethelbert mysql.init: waiting for mysqld to restart

I do not know if this related to me installing openvpn-bridge and phpki. It may have been there before. I have not looked at the /var/log/messages in a while.

MySQL must be somewhat working because I can see my websites:

http://www.sritch.com and http://www.foto-biz.com

Any suggestion on how to fix the mysql errors?

Thanks

Syv

[TerryF]

Read relevant reports etc

http://forums.contribs.org/index.php?topic=48013.0

[ElFroggio]

Read relevant reports etc

http://forums.contribs.org/index.php?topic=48013.0

Now that I know where to look for in the messages, I checked and this error messages started to happen on 28-Apr-2014. They were not there before. This sme8 is at least a year old and not part of an upgrade, but a fresh install.

Is there a log that shows when contribs were installed?

Thanks

Syv

[stephdl]

Code: [Select]

less /var/log/yum/yum.log
Do in the start boot you have errors of mysql.init (at the end of the server boot)

[ElFroggio]

Code: [Select]

less /var/log/yum/yum.log
Do in the start boot you have errors of mysql.init (at the end of the server boot)

They appeared after a SME security update:

* openldap
* openldap-server
* krb5-libs
* tzdata
* openldap-clients

That I did on 28-Apr-2014.

Is it worth trying to fix it or just let the boot message/error be?

Thanks

Syv

[stephdl]

Message of 'Duplicate column name' are a well known bugs, but for the following i don't remember

[stephdl]

Message of 'Duplicate column name' are a well known bugs, but for the following i don't remember

This is my log file

Code: [Select]

Jun 13 16:42:02 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 108: Duplicate column name 'File_priv'
Jun 13 16:42:02 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 114: Duplicate column name 'Grant_priv'
Jun 13 16:42:02 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 115: Duplicate column name 'Grant_priv'
Jun 13 16:42:02 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 116: Duplicate column name 'Grant_priv'
Jun 13 16:42:02 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 127: Duplicate column name 'ssl_type'
Jun 13 16:42:03 sme8dev64 smbd[3036]: [2014/06/13 16:42:03.094290,  0] smbd/server.c:1082(main)
Jun 13 16:42:03 sme8dev64 smbd[3036]:   standard input is not a socket, assuming -D option
Jun 13 16:42:03 sme8dev64 mysql.init: ERROR 1061 (42000) at line 138: Duplicate key name 'Grantor'
Jun 13 16:42:03 sme8dev64 mysql.init: ERROR 1054 (42S22) at line 164: Unknown column 'Type' in 'columns_priv'
Jun 13 16:42:03 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 186: Duplicate column name 'type'
Jun 13 16:42:03 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 196: Duplicate column name 'Show_db_priv'
Jun 13 16:42:03 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 213: Duplicate column name 'max_questions'
Jun 13 16:42:03 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 223: Duplicate column name 'Create_tmp_table_priv'
Jun 13 16:42:03 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 226: Duplicate column name 'Create_tmp_table_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 320: Duplicate column name 'Create_view_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 323: Duplicate column name 'Create_view_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 326: Duplicate column name 'Create_view_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 332: Duplicate column name 'Show_view_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 335: Duplicate column name 'Show_view_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 338: Duplicate column name 'Show_view_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 355: Duplicate column name 'Create_routine_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 358: Duplicate column name 'Create_routine_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 361: Duplicate column name 'Create_routine_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 367: Duplicate column name 'Alter_routine_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 370: Duplicate column name 'Alter_routine_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 373: Duplicate column name 'Alter_routine_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 376: Duplicate column name 'Execute_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 379: Duplicate column name 'Execute_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 392: Duplicate column name 'max_user_connections'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 401: Duplicate column name 'Create_user_priv'
Jun 13 16:42:04 sme8dev64 mysql.init: ERROR 1060 (42S21) at line 423: Duplicate column name 'Routine_type'
Jun 13 16:42:04 sme8dev64 mysql.init: @hadGrantPriv:=1
Jun 13 16:42:04 sme8dev64 mysql.init: 1
Jun 13 16:42:04 sme8dev64 last message repeated 3 times
Jun 13 16:42:04 sme8dev64 mysql.init: @hadShowDbPriv:=1
Jun 13 16:42:04 sme8dev64 mysql.init: 1
Jun 13 16:42:04 sme8dev64 last message repeated 3 times
Jun 13 16:42:04 sme8dev64 mysql.init: @hadCreateViewPriv:=1
Jun 13 16:42:04 sme8dev64 mysql.init: 1
Jun 13 16:42:04 sme8dev64 last message repeated 3 times
Jun 13 16:42:04 sme8dev64 mysql.init: @hadCreateRoutinePriv:=1
Jun 13 16:42:04 sme8dev64 mysql.init: 1
Jun 13 16:42:04 sme8dev64 last message repeated 3 times
Jun 13 16:42:04 sme8dev64 mysql.init: @hadCreateUserPriv:=1
Jun 13 16:42:04 sme8dev64 mysql.init: 1
Jun 13 16:42:04 sme8dev64 last message repeated 3 times
Jun 13 16:42:04 sme8dev64 mysql.init: waiting for mysqld to restart

As you can see i have the same errors in other VM, feel free to raise a bug and to help to correct it. I do not believe that your updates are the cause of your log errors.

[ElFroggio]

Thank you

Syv