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.

Unable to upgrade to MySQL 5.6

Discussion in 'General Discussion' started by autumnwalker123, Jul 8, 2014.

  1. autumnwalker123

    autumnwalker123 Active Member

    Joined:
    Jan 19, 2014
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello, when trying to upgrade to MySQL 5.6 I get the following output.

    Code:
    Beginning MySQL upgrade...
    Running: /usr/local/cpanel/scripts/check_cpanel_rpms --targets=MySQL55,MySQL56 --fix
    [20140708.155932] 
    [20140708.155932] Problems were detected with cPanel-provided files which are RPM controlled. 
    [20140708.155932] If you did not make these changes intentionally, you can correct them by running: 
    [20140708.155932] 
    [20140708.155932] > /usr/local/cpanel/scripts/check_cpanel_rpms --fix 
    [20140708.155932] The following RPMs are missing from your system: 
    [20140708.155932] MySQL56-client-5.6.17-1.cp1142 
    [20140708.155932] MySQL56-devel-5.6.17-1.cp1142 
    [20140708.155932] MySQL56-server-5.6.17-1.cp1142 
    [20140708.155932] MySQL56-shared-5.6.17-1.cp1142 
    [20140708.155932] MySQL56-test-5.6.17-1.cp1142 
    [20140708.155932] 
    [20140708.155932] The following RPMs are unneeded on your system and should be uninstalled: 
    [20140708.155932] MySQL55-client-5.5.37-1.cp1136 
    [20140708.155932] MySQL55-devel-5.5.37-1.cp1136 
    [20140708.155932] MySQL55-server-5.5.37-1.cp1136 
    [20140708.155932] MySQL55-shared-5.5.37-1.cp1136 
    [20140708.155932] MySQL55-test-5.5.37-1.cp1136 
    warning: cannot get shared lock on /var/lib/rpm/Packages 
    [20140708.155932] Removing 0 broken rpms: 
    [20140708.155932] rpm: no packages given for erase 
    404 - HTTP/1.0 404 Not Found 
    [20140708.155933] Downloading http://httpupdate.cpanel.net/RPM/11.42/centos/unknown/x86_64/rpm.md5 
    [20140708.155933] ***** FATAL: 404 - HTTP/1.0 404 Not Found 
    [20140708.155933] The Administrator will be notified to review this output when this script completes 
    Failed while upgrading to 5.6...aborting! MySQL upgrade failed!
    I have tried running /usr/local/cpanel/scripts/check_cpanel_rpms --fix and I get the same FATAL 404 message.

    Thoughts?

    EDIT: I can see that the URL for RPMs are wrong - how do I fix this? I'm also running WHM 11.44 - not 11.42... something isn't right here.
     
    #1 autumnwalker123, Jul 8, 2014
    Last edited: Jul 8, 2014
  2. Eric

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    746
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
  3. autumnwalker123

    autumnwalker123 Active Member

    Joined:
    Jan 19, 2014
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    CentOS 6.5 x86_64.
     
  4. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    What is the output of this command?

    Code:
    # cat /etc/redhat-release
     
  5. autumnwalker123

    autumnwalker123 Active Member

    Joined:
    Jan 19, 2014
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    CentOS release 6.5 (Final)

    - - - Updated - - -

    So the upgrade decided to start after a server reboot.

    Now easyapache is outputting the following and HTTPD / MySQL are both down.

    Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 135
     
  6. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Please submit a ticket using the link in my signature. We can likely find the problem relatively quickly if we have direct access to the server, much quicker than going back-and-forth in a forum. You can post the ticket number here so we can follow up.
     
  7. autumnwalker123

    autumnwalker123 Active Member

    Joined:
    Jan 19, 2014
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Request ID 5199291
     
  8. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    The cause of this problem was InnoDB corruption. MySQL started once InnoDB was disabled.
     
Loading...

Share This Page