El Monday 08 October 2007 23:13:57 Ionut Vancea escribió: > hello, > > On 10/5/07, G T Smith <[EMAIL PROTECTED]> wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > 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). > > > > Because there is an issue with funambol I am running MySQL with case > > sensitivity disabled... > > > > As I do not think this is a change applied at the MySQL end (the mysql > > schema is reasonably consistent across platforms and if this is a case > > of two columns differing by case this it would generate problems on > > Windows) I am not sure whether the update has been applied a second time > > for some reason (then I need not worry) or there has been a change and I > > should have two columns lexically differing only on case or replaced. > > > > Has anyone noticed anything similar? > > yes, I have something similar. After I did the update from 10.2 to > 10.3 mysql doesn't work. It seems that the databases and the tables > are ok, the mysql is starting, but when I tried wordpress, mambo, > mysql.log tells me that mysql restarted during a SELECT. I tried this > SELECT command also in mysql command line, also in phpmyadmin, but I > got the same error and mysqld restarted. I don't know how to fix that. >
I had the same problem than you, i.e, mysql was continuosly restarting after select after upgrading to 10.3 . The logs were showing crashes. My solution was to recompile the binaries linked with (using) mysql-client library. Then all gone well again. I was very worry by that, all my website were down. It seems like an incompatibility somewhere in the libraries. Guillermo > thanks, > > -- > === > Ioan Vancea > http://www.vioan.ro -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
