GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Percona Server update error

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Percona Server update error

    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
    Last edited by OC2PS; 07-05-2013, 08:45 AM.

  • #2
    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.

    Comment


    • #3
      Originally posted by mirfan View Post
      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.
      Originally posted by mirfan View Post
      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...

      Comment


      • #4
        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!
        Last edited by OC2PS; 07-10-2013, 03:21 AM.

        Comment


        • #5
          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.

          Comment

          Working...
          X