Page 1 of 1

MySQL build broken.

Posted: Tue Mar 14, 2017 3:07 am
by sebas
From my experience with it

mysql.x86_64-5.5.54-36 is broken on Centos Plesk Onyx Version 17.0.17 Update #18, last updated on Mar 13, 2017 03:48 AM on CentOS 6.8 (Final)‬.

Be careful.

Re: MySQL build broken.

Posted: Tue Mar 14, 2017 4:15 am
by Dogs and things
I second this, had to undo the update to make mysql work again.

Re: MySQL build broken.

Posted: Tue Mar 14, 2017 10:17 am
by proinagltd2
Hello

Broken for me too!! how did you roll back??

On Centos 6

Graham

Re: MySQL build broken.

Posted: Tue Mar 14, 2017 10:37 am
by chrismcb
Adding a "me too" to this.

Re: MySQL build broken.

Posted: Tue Mar 14, 2017 11:05 am
by miccor01
Same here...

Here are a couple of steps you can use/modify to revert back:
1) # yum list mysql-server
- Check note the Installed Package and the Available Package
- You will want to downgrade to the Available Package

2) # yum downgrade mysql-server-5.x.xx mysql-5.x.xx mysql-libs-5.x.xx (and any other dependent packages)

If completed successfully...

3) # service mysqld stop
4) # service mysqld start
5) optional: # tail /var/log/mysqld.log

Hopefully MySQL comes back up for you.

Re: MySQL build broken.

Posted: Tue Mar 14, 2017 1:55 pm
by scott
This has been addressed in version:

mysql-server-5.5.54-1193

Thanks for the report!

-Scott

Re: MySQL build broken.

Posted: Tue Mar 14, 2017 4:05 pm
by WillN
Thanks for the quick fix, no trouble after updating.

Re: MySQL build broken.

Posted: Tue Mar 14, 2017 5:31 pm
by scott
There is one more update coming up that fixes a problem if you were using skip-grant-tables (this is normally just if you're trying to reset the root password) in version:

mysql-5.5.54-1193

Re: MySQL build broken.

Posted: Thu Mar 16, 2017 7:12 pm
by micoots
So the latest I see is this:

mysql MySQL client programs and shared libraries New version 5.5.54-1199.el6.art Atomic
mysql-devel Files for development of MySQL applications New version 5.5.54-1199.el6.art Atomic
mysql-libs The shared libraries required for MySQL clients New version 5.5.54-1199.el6.art Atomic
mysql-server The MySQL server and related files New version 5.5.54-1199.el6.art Atomic
mysqltuner MySQL high performance tuning script New version 1.7.1-1141.el6.art Asl-4.0

Is this version OK to install?

It caused me quite a bit of grief upgrading the first time and realising nothing I could do but force install the previous RPM's again.

Thanks.

Re: MySQL build broken.

Posted: Thu Mar 16, 2017 7:30 pm
by micoots
OK. I upgraded MySQL on one of the servers. Seems to have worked OK, started up and accessible.

However, the latest mysqltuner that comes with it is broken:

# mysqltuner
/usr/bin/mysqltuner: line 7: syntax error near unexpected token `newline'
/usr/bin/mysqltuner: line 7: `<!DOCTYPE html>'

Any ideas?