Koozali.org: home of the SME Server

Problems with MySql after upgrade to SME 7.2

Offline tiwang

  • *
  • 21
  • +0/-0
Problems with MySql after upgrade to SME 7.2
« on: December 04, 2007, 08:18:07 PM »
Hi out there
Besides of my small spamd problem after the upgrade from 6.01 to 7.2 I also have discovered errors from some instance of MySql in my logfile after booting up - duplicate colums doesnt sound healty to me:

Dec  4 08:59:55 sme1 atalkd[4001]: zip_getnetinfo for eth0
Dec  4 08:59:55 sme1 fstab-sync[4110]: removed all generated mount points
Dec  4 08:59:56 sme1 10fix_privilege_tables: ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
Dec  4 08:59:56 sme1 10fix_privilege_tables: ERROR
Dec  4 08:59:56 sme1 10fix_privilege_tables:  1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
Dec  4 08:59:56 sme1 10fix_privilege_tables: ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
Dec  4 08:59:56 sme1 10fix_privilege_tables: ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
Dec  4 08:59:56 sme1 10fix_privilege_tables: ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
Dec  4 08:59:57 sme1 10fix_privilege_tables: ERROR 1054 (42S22) at line 87: Unknown column 'Type' in 'columns_priv'
Dec  4 08:59:57 sme1 10fix_privilege_tables: ERROR 1060 (42S21) at line 93: Duplicate column name 'type'
Dec  4 08:59:57 sme1 10fix_privilege_tables: ERROR
Dec  4 08:59:57 sme1 10fix_privilege_tables:  1060 (42S21) at line 103: Duplicate column name 'Show_db_priv'
Dec  4 08:59:57 sme1 10fix_privilege_tables: ERROR 1060 (42S21) at line 120: Duplicate column name 'max_questions'
Dec  4 08:59:57 sme1 10fix_privilege_tables: ERROR 1060 (42S21) at line 130: Duplicate column name 'Create_tmp_table_priv'
Dec  4 08:59:57 sme1 10fix_privilege_tables: ERROR 1060 (42S21) at line 133: Duplicate column name 'Create_tmp_table_priv'
Dec  4 08:59:58 sme1 10fix_privilege_tables: ERROR 1061 (42000) at line 141: Duplicate key name 'Grantor'
Dec  4 08:59:59 sme1 10fix_privilege_tables: @hadGrantPriv:=1
Dec  4 08:59:59 sme1 10fix_privilege_tables: 1
Dec  4 08:59:59 sme1 last message repeated 2 times
Dec  4 08:59:59 sme1 10fix_privilege_tables: @hadShowDbPriv:=1
Dec  4 08:59:59 sme1 10fix_privilege_tables: 1
Dec  4 08:59:59 sme1 last message repeated 2 times
Dec  4 08:59:59 sme1 10fix_privilege_tables: waiting for mysqld to restart

Can anyone tell me if these errors are important?
best regards /ti
...


Offline tiwang

  • *
  • 21
  • +0/-0
Re: Problems with MySql after upgrade to SME 7.2
« Reply #2 on: December 07, 2007, 09:09:55 PM »
thanks - looked just "ugly" to me when it booted up

regards /ti
...