Not the answer you need?
Register and ask your own question!

Percona Server update error

OC2PSOC2PS EntrantCurrent User Role Beginner
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

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    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.
  • OC2PSOC2PS Entrant Current User Role Beginner
    mirfan wrote: »
    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 wrote: »
    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...
  • OC2PSOC2PS Entrant Current User Role Beginner
    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!
  • przemekprzemek Percona Support Engineer Percona Staff Role
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.