Percona Server update error

[OC2PS]

Percona Server updates via webmin/yum return the following error

Error in PREIN scriptlet in rpm package Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64

Your MySQL directory ‘/var/lib/mysql’ has more than one PID file:
-rw-rw---- 1 mysql mysql 5 Apr 6 19:48 /var/lib/mysql/dom.pid
-rw-rw---- 1 mysql mysql 5 Jun 2 15:25 /var/lib/mysql/vps.dom.hu.pid
Please check which one (if any) corresponds to a running server and delete all others before repeating the MySQL upgrade.

error: %pre(Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping Percona-Server-server-55-5.5.32-rel31.0.549.rhel6

Verifying : Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64 1/2
Percona-Server-server-55-5.5.30-rel30.2.508.rhel6.x86_64 was supposed to be removed but is not!
Verifying : Percona-Server-server-55-5.5.30-rel30.2.508.rhel6.x86_64 2/2

Failed:
Percona-Server-server-55.x86_64 0:5.5.30-rel30.2.508.rhel6
Percona-Server-server-55.x86_64 0:5.5.32-rel31.0.549.rhel6

Complete!
… install failed!

Stack:
CentOS 6 64-bit
nginX
Percona MySQL server
PHP 5.4
also running webmin and ISPConfig

[mirfan]

Hi,

What are your steps to upgrade ? Did you remove the old packages before upgrade ?
Let me show you steps to upgrade hopefully it will work.

1. Stop mysqld
2. Remove percona server packages.
3. Install new percona server packages.
4. Run mysql_upgrade
5. Start mysqld

To be on safe side you can take important database backup before upgrade. Look likes you didn’t stopped the mysqld before upgrade.

[OC2PS]

@mirfan;10815

What are your steps to upgrade ?

I was running the upgrade via webmin and assuming that it would go through the sequence of steps correctly.

@mirfan;10815

Look likes you didn’t stopped the mysqld before upgrade.

I focused on the error that says “two PID files”…so are you saying that 2 PID files is not the problem?

P.S. Sorry it took me a bit to reply…got no notification from these forums that someone has posted a reply to this topic…

[OC2PS]

This is the complete upgrade process echo from webmin:

Now updating Percona-Server-server-55 …
Installing package(s) with command yum -y install Percona-Server-server-55 …

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile

• Webmin: webmin.mirror.somersettechsolutions.co.uk
• base: ftp.freepark.org
• epel: mirror.pmf.kg.ac.rs
• extras: ftp.freepark.org
• rpmforge: ftp.lug.ro
• updates: mirror.centos.com.ba
• webtatic: uk.repo.webtatic.com

Setting up Install Process

Resolving Dependencies --> Running transaction check —> Package Percona-Server-server-55.x86_64 0:5.5.30-rel30.2.508.rhel6 will be updated —> Package Percona-Server-server-55.x86_64 0:5.5.32-rel31.0.549.rhel6 will be an update --> Finished Dependency Resolution

Dependencies Resolved
================================================== ==============================
Package Arch Version Repository Size
================================================== ==============================
Updating: Percona-Server-server-55 x86_64 5.5.32-rel31.0.549.rhel6 percona 15 M Transaction Summary ================================================== ==============================
Upgrade 1 Package(s)
Total download size: 15 M

Downloading Packages:
Running rpm_check_debug
Running Transaction Test Transaction
Test Succeeded
Running Transaction

Error in PREIN scriptlet in rpm package Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64

Your MySQL directory ‘/var/lib/mysql’ has more than one PID file:
-rw-rw---- 1 mysql mysql 5 Apr 6 19:48 /var/lib/mysql/dom.pid
-rw-rw---- 1 mysql mysql 5 Jun 2 15:25 /var/lib/mysql/vps.dom.hu.pid
Please check which one (if any) corresponds to a running server and delete all others before repeating the MySQL upgrade.

error: %pre(Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping Percona-Server-server-55-5.5.32-rel31.0.549.rhel6

Verifying : Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64 1/2Percona-Server-server-55-5.5.30-rel30.2.508.rhel6.x86_64 was supposed to be removed but is not!
Verifying : Percona-Server-server-55-5.5.30-rel30.2.508.rhel6.x86_64 2/2

Failed:
Percona-Server-server-55.x86_64 0:5.5.30-rel30.2.508.rhel6
Percona-Server-server-55.x86_64 0:5.5.32-rel31.0.549.rhel6

Complete!
… install failed!

[przemek]

You seem to be hitting this bug: https://bugs.launchpad.net/percona-server/+bug/1201036 This is going to be fixed in 5.5.33.