mysql update to 5.5.16-2.el5.art

[nobody]

Hi guys.

I just saw a mysql update to 5.5.16-2.el5.art from version 5.1.59-1.el5.art on the ASL repo.

Has anyone tried it on plesk 10.3? Are there any known issues ?
Does anyone know the reasons of this update ?
Also should we after this upgrade run a mysql_upgrade ?

Thanks !

[DarkF@der]

I'm to scary to do this update with so many hosting clients on the servers.
Everytime i do mysql update it will be down so i'll wait.

[nobody]

I applied the update on a 1 domain box. With 2 databases and it worked. Just to be sure I run a mysql upgrade for all dbs.

Not applying it still on Plesk server. I'll wait to see how it goes.

[nobody]

Ok got an error...


First of all when mysql-server was installing it posted out on both boxes :

Code: Select all

Running Transaction
  Installing     : mysql-server                                              1/1
Stopping mysqld:  [  OK  ]
mysqld is alive
Stopping mysqld:  [  OK  ]
mysqld is alive
Stopping mysqld:  [  OK  ]
Starting mysqld:  [  OK  ]

But on one box it printed out 2 errors.

Code: Select all

id: cannot find name for group ID 4294967294

and that it cannot find root@localhost password. But plesk only has admin password. On the other plesk box I did not see these 2 errors.


Everything though seems to be working fine up to now. But I know errors do not usually turn out good...

I did a yum reinstall of mysql-server on the box with the 2 errors. It reprinted

Code: Select all

id: cannot find name for group ID 4294967294

Any suggestions ?

Thanks !

[irzyxel]

i got a dependency error with centos 6 cr.

Error: Package: mysql-test-5.5.16-2.el6.art.x86_64 (atomic)
Requires: perl(lib::v1/mtr_timer.pl)
Requires: perl(lib::v1/mtr_misc.pl)
Requires: perl(lib::v1/mtr_stress.pl)
Requires: perl(lib::v1/mtr_gprof.pl)
Requires: perl(lib::v1/mtr_im.pl)
Requires: perl(lib::v1/mtr_process.pl)
Requires: perl(lib::v1/mtr_cases.pl)
Requires: perl(lib::v1/mtr_unique.pl)
Requires: perl(lib::v1/mtr_report.pl)
Requires: perl(lib::v1/mtr_gcov.pl)
Requires: perl(lib::v1/mtr_match.pl)
Requires: perl(lib::v1/mtr_io.pl)

[joelunch]

Now that 5.5.17-1 is out do we need to go to 5.5.16-2 first to utilise its upgrade to the db format? I tried 5.5.16-2 but encountered issues so tolled back to 5.1

[scott]

No it has the same update function in it, you'd just upgrade directly to 5.5.17

[petersphilo]

Updated from 5.1.59 to 5.5.17 on Plesk 9.3; all went perfectly...
Ran mysql_upgrade -u admin -p for good measure, but it reported all ok...
Hope this helps,
Be Well,
Peter

[tkalfaoglu2]

Do we need to remove php-mysql after the 5.5 upgrade?
Because I'm getting:

[root@panel log] # yum reinstall php-mysql
Loaded plugins: allowdowngrade, fastestmirror, priorities
Setting up Reinstall Process
Loading mirror speeds from cached hostfile
* atomic: www6.atomicorp.com
* base: mirror.highspeedweb.net
* centosplus: mirror.us.leaseweb.net
* extras: mirror.anl.gov
* updates: mirrors.login.com
Excluding Packages in global exclude list
Finished
40 packages excluded due to repository priority protections
Installed package php-mysql-5.2.17-1.el5.art.i386 not available.
Nothing to do
[root@panel log] # yum update php-mysql
Loaded plugins: allowdowngrade, fastestmirror, priorities
Loading mirror speeds from cached hostfile
* atomic: www6.atomicorp.com
* base: mirror.highspeedweb.net
* centosplus: mirror.us.leaseweb.net
* extras: mirror.anl.gov
* updates: mirrors.login.com
Excluding Packages in global exclude list
Finished
40 packages excluded due to repository priority protections
Setting up Update Process
No Packages marked for Update
[root@panel log] #