-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Michal Marek wrote: > 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
Whoa! Some clarification here... in my case this was not a big issue... Originally I just needed to make certain that that I was not picking up a problem that was something specific to my setup (which is not exactly standard SuSE). I have run the above without any issues, and as far as I can work out the problem (if it really was a problem) is fixed (for me) with 10.2... I will file a report if you still wish me to, and BTW should it be against original... I cannot say anything about the 10.3 reports as I am still on 10.2. (As I have accumulated number of non-SuSE bits and pieces I am probably going to be late to the 10.3 party as I need to put together a cunning plan to manage the 10.3 upgrade :-) ) So I am not really best placed to comment on these... - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFHC2t4asN0sSnLmgIRAoYlAJ9xu0QMkWyxEv1xdXUiEGHZPegzYQCeKF8G PnIoW8ZRG+KKEg731z1UfhQ= =UVJd -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
