[opensuse] mysql upgrade ?
I'm thinking of upgrading a production database this weekend as the running version 5.0.51a keeps crashing, see bug 516339. Would anyone care to make a recommendation as to which version to upgrade to? 5.0.x , 5.1.x ? Keep in mind that this is 24h production, I would rather not opt for the bleeding edge stuff. thanks Per -- Per Jessen, Zürich (19.4°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Per Jessen wrote:
I'm thinking of upgrading a production database this weekend as the running version 5.0.51a keeps crashing, see bug 516339. Would anyone care to make a recommendation as to which version to upgrade to? 5.0.x , 5.1.x ? Keep in mind that this is 24h production, I would rather not opt for the bleeding edge stuff.
I ended up choosing 5.1.36, and am now reloading the tables. DUring the upgrade I got the following weird messages: Failed to ALTER DATABASE `#mysql50#.protected` UPGRADE DATA DIRECTORY NAME Error: Table 'mysql.event' doesn't exist Failed to ALTER DATABASE `#mysql50#.tmp` UPGRADE DATA DIRECTORY NAME Error: Table 'mysql.event' doesn't exist I've now also got two databases named '.protected' and '.tmp'. Does anyone what might have happened? thanks Per -- Per Jessen, Zürich (16.2°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 05 September 2009 08:25:22 am Per Jessen wrote:
Per Jessen wrote:
I'm thinking of upgrading a production database this weekend as the running version 5.0.51a keeps crashing, see bug 516339. Would anyone care to make a recommendation as to which version to upgrade to? 5.0.x , 5.1.x ? Keep in mind that this is 24h production, I would rather not opt for the bleeding edge stuff.
I ended up choosing 5.1.36, and am now reloading the tables. DUring the upgrade I got the following weird messages:
Failed to ALTER DATABASE `#mysql50#.protected` UPGRADE DATA DIRECTORY NAME Error: Table 'mysql.event' doesn't exist Failed to ALTER DATABASE `#mysql50#.tmp` UPGRADE DATA DIRECTORY NAME Error: Table 'mysql.event' doesn't exist
I've now also got two databases named '.protected' and '.tmp'. Does anyone what might have happened?
thanks Per
Per, I'm running the following mysql versions on these different servers without any problem. The only annoyance is the latest rpms for mysql don't restart mysql after the upgrade, but all databases are working without error. 19:15 bonza~> rpm -q mysql mysql-5.1.36-41.1 20:46 archangel:~> pmq mysql mysql 5.1.37-1 [17:32 nirvana:/srv/www/avantfax/includes] # rpm -q mysql mysql-5.1.36-41.1 [18:06 nemesis:/etc/ppp] # rpm -q mysql mysql-5.1.36-39.1 -- David C. Rankin, J.D.,P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
David C. Rankin wrote:
Per,
I'm running the following mysql versions on these different servers without any problem. The only annoyance is the latest rpms for mysql don't restart mysql after the upgrade, but all databases are working without error.
19:15 bonza~> rpm -q mysql mysql-5.1.36-41.1
Thanks David - the server is actually running just fine (or at least appears to do so), I was just curious about the upgrade which seems to have left a few things behind. I've asked the same question on the mysql list, but nobody's picked it up yet. /Per -- Per Jessen, Zürich (14.4°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Saturday 05 September 2009 08:25:22 am Per Jessen wrote:
I've now also got two databases named '.protected' and '.tmp'. Does anyone what might have happened?
Per, I've checked and I also have these file left behind on each of my openSuSE mysql updates: [14:47 nirvana:/var/lib/mysql] # l total 63940 drwxr-xr-x 11 mysql mysql 4096 2009-08-30 05:00 ./ drwxr-xr-x 53 root root 4096 2009-09-12 05:01 ../ drwx------ 2 mysql mysql 4096 2009-05-28 02:25 @002eprotected/ drwx------ 2 mysql mysql 4096 2009-05-28 02:25 @002etmp/ Like you, I haven't noticed any problems with mysql operation. Just looks like some trash that was left behind by the upgrade.... -- David C. Rankin, J.D.,P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
David C. Rankin wrote:
On Saturday 05 September 2009 08:25:22 am Per Jessen wrote:
I've now also got two databases named '.protected' and '.tmp'. Does anyone what might have happened?
Per,
I've checked and I also have these file left behind on each of my openSuSE mysql updates:
[14:47 nirvana:/var/lib/mysql] # l total 63940 drwxr-xr-x 11 mysql mysql 4096 2009-08-30 05:00 ./ drwxr-xr-x 53 root root 4096 2009-09-12 05:01 ../ drwx------ 2 mysql mysql 4096 2009-05-28 02:25 @002eprotected/ drwx------ 2 mysql mysql 4096 2009-05-28 02:25 @002etmp/
Like you, I haven't noticed any problems with mysql operation. Just looks like some trash that was left behind by the upgrade....
Thanks, very interesting - do they also show under 'SHOW DATABASES' ? I'm going to drop them, I don't like stuff like that hanging about. /Per -- Per Jessen, Zürich (16.4°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 13 September 2009 07:37:32 am Per Jessen wrote:
David C. Rankin wrote:
On Saturday 05 September 2009 08:25:22 am Per Jessen wrote:
I've now also got two databases named '.protected' and '.tmp'. Does anyone what might have happened?
Per,
I've checked and I also have these file left behind on each of my openSuSE mysql updates:
[14:47 nirvana:/var/lib/mysql] # l total 63940 drwxr-xr-x 11 mysql mysql 4096 2009-08-30 05:00 ./ drwxr-xr-x 53 root root 4096 2009-09-12 05:01 ../ drwx------ 2 mysql mysql 4096 2009-05-28 02:25 @002eprotected/ drwx------ 2 mysql mysql 4096 2009-05-28 02:25 @002etmp/
Like you, I haven't noticed any problems with mysql operation. Just looks like some trash that was left behind by the upgrade....
Thanks, very interesting - do they also show under 'SHOW DATABASES' ? I'm going to drop them, I don't like stuff like that hanging about.
Yep! [22:28 nirvana:/var/lib/mysql] # mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 313 Server version: 5.1.36-log SUSE MySQL RPM Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | .protected | | .tmp | | Krecipes | | avantfax | | egroupware | | gallery2 | | mysql | | test | | web | +--------------------+ 10 rows in set (0.02 sec) -- David C. Rankin, J.D.,P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (2)
-
David C. Rankin -
Per Jessen