mysql 5.5.15 changes w/ more automated upgrading

[hostingguy]

maybe thats why he is such a wine-er

[mikeshinn]

Ba dump! Thank you folks, don't forget to tip your waitresses and enjoy the veal!

[hostingguy]

Thank you, thank you - I'll be here all week!

[scott]

The upgrade routine has been moved to be a plesk only event, and this can also be overridden by the ATOMIC_SKIP variable. Additional changes to the upgrade event will strip out the set-variable tokens from my.cnf.

Final testing will be going on this week, and then 5.1.x will be retired.

[hostingguy]

Any chance you could get with Igor from CL and encorporate his changes for the mysql-governor?

[scott]

Is it a separate package, or changes to mysql?

[hostingguy]

the mysql-governor package is seperate, but requires a patch to mysql which I think he has already shared with cPanel for their build. it would be nice to have it included in yours as well so that if we continue to use your mysql then we could possibly still use this governor.

[scott]

I have the patches but they're not compatible with 5.5.16 yet, so I think I'll push 5.5.16 now and work with CL to get them up to 5.5.16 for a later release.

[scott]

If there are any final concerns, recommendations, etc please post them here now, 5.5.x will go live in [atomic] on monday.

[joelunch]

Hi guys I just did this update and now mysql wont start! It looks like I had SIM running which noticed mysql not running so restarted if half way through the update. Now I don't have a clue where to start to fix this. What is your advice? Do I need to restore from backups?

This is the output;

Stopping mysqld: [ OK ]
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
Stopping mysqld: [ OK ]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
error: %post(mysql-server-5.5.16-1.el5.art.x86_64) scriptlet failed, exit status 1
Cleanup : mysql 5/7
Cleanup : mysql-libs 6/7

Dependency Installed:
mysqlclient16.x86_64 0:5.1.57-1.el5.art

Updated:
mysql.x86_64 0:5.5.16-1.el5.art mysql-libs.x86_64 0:5.5.16-1.el5.art mysql-server.x86_64 0:5.5.16-1.el5.art

Complete!


This is the yum output when I tried to reinstall mysql after removing it via rpm;

Downloading Packages:
Running rpm_check_debug
ERROR with rpm_check_debug vs depsolve:
mysql is needed by (installed) mysql-server-5.1.59-1.el5.art.x86_64
mysql is needed by (installed) mysql-server-5.1.59-1.el5.art.x86_64
Complete!
(1, [u'Please report this error in http://bugs.centos.org/set_project.php? ... tegory=yum'])


mysql-server-5.1.59-1.el5.art.x86_64


No when I try to do a reinstall via yum I get the following;

Running Transaction
Installing : mysql 1/2
/usr/local/psa/admin/bin/packagemng: error while loading shared libraries: libmysqlclient.so.15: cannot open shared object file: No such file or directory
Installing : mysql 2/2
/usr/local/psa/admin/bin/packagemng: error while loading shared libraries: libmysqlclient.so.15: cannot open shared object file: No such file or directory

Installed:
mysql.i386 0:5.5.16-1.el5.art mysql.x86_64 0:5.5.16-1.el5.art

Complete!


help?!

[scott]

If I had to guess, its because of an incompatible setting in my.cnf. Things that were deprecated in 5.1 now give you hard errors in 5.5. Try using a default my.cnf.

Also you're missing the compatibility client libraries now because of the way you re-installed it.

[dsoundmn]

I'd like to point out this issue in another post
http://atomicorp.com/forums/viewtopic.php?f=1&t=5462

I'll post my additional details there.
Thanks for getting 5.5.x into the grid!

[LunchBurger]

I'm in another spot of hell. Updated the usual way, sudo yum update. Now I have no way of starting MySQL though it thinks its installed. Am getting the infamous "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"

Pretty panicked and disappointed.


Here's the YUM output: HELP!

Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.5.16-1.el5.art set to be updated
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: php-mysql
---> Package mysql-libs.x86_64 0:5.5.16-1.el5.art set to be updated
---> Package mysql-server.x86_64 0:5.5.16-1.el5.art set to be updated
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-server
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-server
--> Processing Dependency: libaio.so.1()(64bit) for package: mysql-server
--> Running transaction check
---> Package libaio.x86_64 0:0.3.106-5 set to be updated
---> Package mysqlclient16.x86_64 0:5.1.57-1.el5.art set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Updating:
mysql x86_64 5.5.16-1.el5.art atomic 7.4 M
mysql-libs x86_64 5.5.16-1.el5.art atomic 1.1 M
mysql-server x86_64 5.5.16-1.el5.art atomic 16 M
Installing for dependencies:
libaio x86_64 0.3.106-5 base 19 k
mysqlclient16 x86_64 5.1.57-1.el5.art atomic 1.8 M

Transaction Summary
================================================================================
Install 2 Package(s)
Upgrade 3 Package(s)

Total download size: 26 M
Is this ok [y/N]: y
y
Downloading Packages:
(1/5): libaio-0.3.106-5.x86_64.rpm | 19 kB 00:00
(2/5): mysql-libs-5.5.16-1.el5.art.x86_64.rpm | 1.1 MB 00:00
(3/5): mysqlclient16-5.1.57-1.el5.art.x86_64.rpm | 1.8 MB 00:00
(4/5): mysql-5.5.16-1.el5.art.x86_64.rpm | 7.4 MB 00:01
(5/5): mysql-server-5.5.16-1.el5.art.x86_64.rpm | 16 MB 00:02
--------------------------------------------------------------------------------
Total 6.2 MB/s | 26 MB 00:04
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mysqlclient16 1/8
Updating : mysql-libs 2/8
Updating : mysql 3/8
Installing : libaio 4/8
Updating : mysql-server 5/8
Stopping mysqld: [ OK ]
Can't open perl script "s[^set-variable][#set-variable]g": No such file or directory
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
Stopping mysqld: [ OK ]
Can't open perl script "s[^set-variable][#set-variable]g": No such file or directory
f
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
error: %post(mysql-server-5.5.16-1.el5.art.x86_64) scriptlet failed, exit status 1
Cleanup : mysql 6/8
Cleanup : mysql-libs 7/8

Dependency Installed:
libaio.x86_64 0:0.3.106-5 mysqlclient16.x86_64 0:5.1.57-1.el5.art

Updated:
mysql.x86_64 0:5.5.16-1.el5.art mysql-libs.x86_64 0:5.5.16-1.el5.art
mysql-server.x86_64 0:5.5.16-1.el5.art

Complete!

[joelunch]

Ok so it turns out I was able to roll back mysql to the previous version. Thank God. So it looks like the database format change obviously didn't work. If it had worked would we be able to use the new format with older 5.1 mysql? Do you guys have a generic my.cnf file that you recommend to try with 5.5?

Also where is the best place to keep track of announcements warning of major updates like this? Email list?

[scott]

This is the best place to track changes & announcements