-----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 mmarek@novell.com. 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: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org