J Sloan wrote: > G T Smith wrote: >> SuSE 10.2 >> >> Did an update today including MySQL security updates. >> >> Found MySQL had failed to reload for some reason. >> Restarted MySQL and got a a duplicate column error message when an >> attempt to update the mysql database tables was applied. (unfortunately, >> error message went before I could take notes and nothing in logs). >> Nothing seems to broken but unable to repeat error (I suspect because >> the database schema update has now been flagged as applied). >> > Yes, I noticed that mysql was dead after the last upgrade on my suse > 10.2/64 server, and a bit of lookikng in the the mysqld log turned up a > complaint about a duplicate column IIRC - but I started it with the rc > script and it has run normally from that point on, so I hadn't give it > too much further thought.
Hi, the 'duplicate column' errors come from mysql_fix_privilege_tables.sql and are in fact harmless (see https://bugzilla.novell.com/228248 , fixed in 10.3). However, it seems that the init script thinks that something failed during the upgrade :-(. Could you try # touch /var/lib/mysql/.run-mysql_upgrade # rcmysql restart ? Also please file a bugreport and assign it to [EMAIL PROTECTED] I'm going to try it myself. thanks, Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
