The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL 5.1 -> 5.6 upgrade failed

Discussion in 'Database Discussions' started by indilago, Nov 22, 2014.

  1. indilago

    indilago Registered

    Joined:
    Nov 22, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I just attempted to update MySQL from 5.1 to 5.6 via WHM, and it failed, and now mysql will not start.

    Here is my update log (with my list of tables redacted):

    Code:
    [20141122.125731]   
    [20141122.125731]   Problems were detected with cPanel-provided files which are RPM controlled.
    [20141122.125731]   If you did not make these changes intentionally, you can correct them by running:
    [20141122.125731]   
    [20141122.125731]   > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
    [20141122.125731]   The following RPMs are missing from your system:
    [20141122.125731]   MySQL55-client-5.5.40-1.cp1136
    [20141122.125731]   MySQL55-devel-5.5.40-1.cp1136
    [20141122.125731]   MySQL55-server-5.5.40-1.cp1136
    [20141122.125731]   MySQL55-shared-5.5.40-1.cp1136
    [20141122.125731]   MySQL55-test-5.5.40-1.cp1136
    [20141122.125731]   compat-MySQL51-shared-5.1.73-4.cp1136
    [20141122.125732]    
    [20141122.125732]   The following RPMs are unneeded on your system and should be uninstalled:
    [20141122.125732]   MySQL51-client-5.1.73-4.cp1136
    [20141122.125732]   MySQL51-devel-5.1.73-4.cp1136
    [20141122.125732]   MySQL51-server-5.1.73-4.cp1136
    [20141122.125732]   MySQL51-shared-5.1.73-4.cp1136
    [20141122.125732]   MySQL51-test-5.1.73-4.cp1136
    [20141122.125732]   Removing 0 broken rpms: 
    [20141122.125732]   rpm: no packages given for erase
    [20141122.125734]   Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/5/i386/rpm.md5
    [20141122.125734]   Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/5/i386/MySQL55-devel-5.5.40-1.cp1136.i386.rpm
    [20141122.125735]   Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/5/i386/MySQL55-client-5.5.40-1.cp1136.i386.rpm
    [20141122.125736]   Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/5/i386/MySQL55-server-5.5.40-1.cp1136.i386.rpm
    [20141122.125739]   Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/5/i386/compat-MySQL51-shared-5.1.73-4.cp1136.i386.rpm
    [20141122.125740]   Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/5/i386/MySQL55-test-5.5.40-1.cp1136.i386.rpm
    [20141122.125741]   Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/5/i386/MySQL55-shared-5.5.40-1.cp1136.i386.rpm
    [20141122.125742]   Hooks system enabled
    [20141122.125742]   Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed
    [20141122.125742]   All required 'pre' hooks have been run
    [20141122.125742]   Uninstalling unneeded rpms: MySQL51-devel MySQL51-test MySQL51-client MySQL51-shared MySQL51-server
    [20141122.125746]   Shutting down MySQL. SUCCESS! 
    [20141122.125755]   Installing new rpms: MySQL55-devel-5.5.40-1.cp1136.i386.rpm MySQL55-client-5.5.40-1.cp1136.i386.rpm MySQL55-server-5.5.40-1.cp1136.i386.rpm compat-MySQL51-shared-5.1.73-4.cp1136.i386.rpm MySQL55-test-5.5.40-1.cp1136.i386.rpm MySQL55-shared-5.5.40-1.cp1136.i386.rpm
    [20141122.125756]   Preparing packages for installation...
    [20141122.125757]   MySQL55-devel-5.5.40-1.cp1136
    [20141122.125757]   MySQL55-client-5.5.40-1.cp1136
    [20141122.125758]   MySQL55-server-5.5.40-1.cp1136
    [20141122.125803]   Upgrading
    [20141122.125811]   Looking for 'mysql' as: /usr/bin/mysql
    [20141122.125811]   Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
    [20141122.125811]   Running 'mysqlcheck with default connection arguments
    [20141122.125811]   Running 'mysqlcheck with default connection arguments
    [20141122.125811]   mydbname.tablename                                 OK
    -- redacted table list --
    [20141122.125811]   whmxfer.sessions                                   OK
    [20141122.125811]   Running 'mysql_fix_privilege_tables'...
    [20141122.125811]   OK
    [20141122.125813]   Starting MySQL SUCCESS! 
    [20141122.125818]   compat-MySQL51-shared-5.1.73-4.cp1136
    [20141122.125819]   MySQL55-test-5.5.40-1.cp1136
    [20141122.125823]   MySQL55-shared-5.5.40-1.cp1136
    [20141122.125825]   Prelinking is disabled.
    [20141122.125825]   Checking for and running RPM::Versions 'post' hooks for any RPMs just installed
    [20141122.125826]   All required 'post' hooks have been run
    [20141122.125829]   
    [20141122.125829]   Problems were detected with cPanel-provided files which are RPM controlled.
    [20141122.125829]   If you did not make these changes intentionally, you can correct them by running:
    [20141122.125829]   
    [20141122.125829]   > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
    [20141122.125829]   The following RPMs are missing from your system:
    [20141122.125829]   MySQL56-client-5.6.21-1.cp1142
    [20141122.125829]   MySQL56-devel-5.6.21-1.cp1142
    [20141122.125829]   MySQL56-server-5.6.21-1.cp1142
    [20141122.125829]   MySQL56-shared-5.6.21-1.cp1142
    [20141122.125829]   MySQL56-test-5.6.21-1.cp1142
    [20141122.125831]    
    [20141122.125831]   The following RPMs are unneeded on your system and should be uninstalled:
    [20141122.125831]   MySQL55-client-5.5.40-1.cp1136
    [20141122.125831]   MySQL55-devel-5.5.40-1.cp1136
    [20141122.125831]   MySQL55-server-5.5.40-1.cp1136
    [20141122.125831]   MySQL55-shared-5.5.40-1.cp1136
    [20141122.125831]   MySQL55-test-5.5.40-1.cp1136
    [20141122.125831]   Removing 0 broken rpms: 
    [20141122.125831]   rpm: no packages given for erase
    [20141122.125833]   Downloading http://httpupdate.cpanel.net/RPM/11.42/centos/5/i386/rpm.md5
    [20141122.125833]   Downloading http://httpupdate.cpanel.net/RPM/11.42/centos/5/i386/MySQL56-client-5.6.21-1.cp1142.i386.rpm
    [20141122.125834]   Downloading http://httpupdate.cpanel.net/RPM/11.42/centos/5/i386/MySQL56-test-5.6.21-1.cp1142.i386.rpm
    [20141122.125838]   Downloading http://httpupdate.cpanel.net/RPM/11.42/centos/5/i386/MySQL56-devel-5.6.21-1.cp1142.i386.rpm
    [20141122.125839]   Downloading http://httpupdate.cpanel.net/RPM/11.42/centos/5/i386/MySQL56-shared-5.6.21-1.cp1142.i386.rpm
    [20141122.125840]   Downloading http://httpupdate.cpanel.net/RPM/11.42/centos/5/i386/MySQL56-server-5.6.21-1.cp1142.i386.rpm
    [20141122.125844]   Hooks system enabled
    [20141122.125844]   Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed
    [20141122.125844]   All required 'pre' hooks have been run
    [20141122.125844]   Uninstalling unneeded rpms: MySQL55-test MySQL55-server MySQL55-client MySQL55-shared MySQL55-devel
    [20141122.125850]   Installing new rpms: MySQL56-client-5.6.21-1.cp1142.i386.rpm MySQL56-test-5.6.21-1.cp1142.i386.rpm MySQL56-devel-5.6.21-1.cp1142.i386.rpm MySQL56-shared-5.6.21-1.cp1142.i386.rpm MySQL56-server-5.6.21-1.cp1142.i386.rpm
    [20141122.125850]   Preparing packages for installation...
    [20141122.125850]   MySQL56-client-5.6.21-1.cp1142
    [20141122.125852]   MySQL56-test-5.6.21-1.cp1142
    [20141122.125900]   MySQL56-devel-5.6.21-1.cp1142
    [20141122.125900]   MySQL56-shared-5.6.21-1.cp1142
    [20141122.125901]   MySQL56-server-5.6.21-1.cp1142
    [20141122.125920]   Looking for 'mysql' as: /usr/bin/mysql
    [20141122.125920]   Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
    [20141122.125920]   FATAL ERROR: Upgrade failed
    [20141122.125921]   /usr/bin/mysqladmin: connect to server at 'localhost' failed
    [20141122.125921]   error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
    [20141122.125921]   Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
    [20141122.125921]   Unable to reset root MySQL password. at /usr/local/cpanel/scripts/securemysql line 151.
    [20141122.125923]   Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/ct104.rackster.com.pid).
    [20141122.125923]   error: %post(MySQL56-server-5.6.21-1.cp1142.i386) scriptlet failed, exit status 1
    [20141122.125923] W Error Code: 5
    [20141122.125923] E The following possible errors were detected while installing RPMs:
    [20141122.125923] E 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' %post(MySQL56-server-5.6.21-1.cp1142.i386) scriptlet failed, exit status 1
    [20141122.125923]   The Administrator will be notified to review this output when this script completes
    [20141122.125923]   Checking for and running RPM::Versions 'post' hooks for any RPMs just installed
    [20141122.125923]   All required 'post' hooks have been run
    
     
  2. 24x7ss

    24x7ss Well-Known Member

    Joined:
    Sep 30, 2014
    Messages:
    271
    Likes Received:
    16
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    I would suggest you to check whith MySQL packages are installed on your server and remove the unneeded rpms manually and then try to upgrade again.

    rpm -qa |grep MYSQL
    rpm -e <unneeded-rpms>

    Multiple MySQL servers got installed on your machine which is causing the conflict. You can also try running below command:

    /usr/local/cpanel/scripts/check_cpanel_rpms --fix
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page