Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

[CPANEL-23547] MySQL down after failed MariaDB upgrade

Discussion in 'Database Discussion' started by Jeff P., Nov 7, 2018.

  1. Jeff P.

    Jeff P. Well-Known Member

    Joined:
    Feb 2, 2016
    Messages:
    52
    Likes Received:
    10
    Trophy Points:
    8
    Location:
    Daytona Beach, Florida, USA
    cPanel Access Level:
    DataCenter Provider
    After cpanel update today to latest version. and after trying a forced update and deleting my.cnf.

    Been stuck on this during a MySQL Upgrade attempt:

    upload_2018-11-7_16-10-33.png
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Jeff P.

    Jeff P. Well-Known Member

    Joined:
    Feb 2, 2016
    Messages:
    52
    Likes Received:
    10
    Trophy Points:
    8
    Location:
    Daytona Beach, Florida, USA
    cPanel Access Level:
    DataCenter Provider
    [root@ns1 ~]# service mysql restart
    Redirecting to /bin/systemctl restart mysql.service
    Failed to restart mysql.service: Unit not found.
    [root@ns1 ~]# service mysqld restart
    Redirecting to /bin/systemctl restart mysqld.service
    Failed to restart mysqld.service: Unit not found.
    [root@ns1 ~]#
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Jeff P.

    Jeff P. Well-Known Member

    Joined:
    Feb 2, 2016
    Messages:
    52
    Likes Received:
    10
    Trophy Points:
    8
    Location:
    Daytona Beach, Florida, USA
    cPanel Access Level:
    DataCenter Provider
    Whostmgr::Dispatch::_do_call("mysqlupgrade", HASH(0x3b5c4a8), HASH(0x3b5e980)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 157
    Whostmgr::Dispatch::dispatch("mysqlupgrade", 1, ARRAY(0x3b5c670)) called at whostmgr/bin/whostmgr.pl line 582
    ) This issue could also hinder mysql_upgrade's ability to run, which could potentially leave MySQL in an unusable state if you proceed.
    Critical: MariaDB enables "strict mode" by default as of version 10.2. Strict mode controls how MariaDB and MySQL handle invalid or missing values in data-change statements such as INSERT or UPDATE. Applications not built with strict mode enabled may cause undesired behavior; please verify applications using MariaDB are compatible before upgrading. More information about strict mode is availablehere.
    Obtained version information from system.
    (XID btx9d5) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2))
    Ensuring the “MariaDB102” repository is available and working.
    checkyum version 22.3
    Ensuring that the package “MariaDB-client” with version matching “10.2” is available.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,272
    Likes Received:
    2,154
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Jeff P.,

    I recommend opening a support ticket if MySQL is not starting so we can quickly access the system and see what's happening. If MySQL is running and that's not a concern at this point, paste the contents from the following files:

    Code:
    /etc/my.cnf
    /var/cpanel/rpm.versions.d/local.versions
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Jeff P.

    Jeff P. Well-Known Member

    Joined:
    Feb 2, 2016
    Messages:
    52
    Likes Received:
    10
    Trophy Points:
    8
    Location:
    Daytona Beach, Florida, USA
    cPanel Access Level:
    DataCenter Provider
    It's a production server with about $15,000 in ads running per day. I dont have time to wait for them.

    What is the safe method of uninstalling MariaDB 10.2 and reinstalling MySQL 5.6?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,272
    Likes Received:
    2,154
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    If you open the ticket now and provide me with the ticket number, I can set it to emergency status since a service is down. It will be investigated right away.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,272
    Likes Received:
    2,154
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    There's no supported downgrade path from MariaDB to MySQL.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. Jeff P.

    Jeff P. Well-Known Member

    Joined:
    Feb 2, 2016
    Messages:
    52
    Likes Received:
    10
    Trophy Points:
    8
    Location:
    Daytona Beach, Florida, USA
    cPanel Access Level:
    DataCenter Provider
    Your Support Request ID is: 10670763

    Also, all MYSQL related controls in WHM are gone. Upgrade, restart, everything.


    Ticket made, could not grant support access:

    Error:WHM Authorization failed with the following error: The server detected that an SSH key for user “root” in Ticket ID “10670763” and Server “1” already exists. Run the following cPanel script and refresh your browser: /scripts/updatesupportauthorizations. You may skip this server or correct the problem and try again.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,272
    Likes Received:
    2,154
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Jeff P.,

    I can confirm the ticket was opened and one of our Technical Analysts was able to access the system to begin the investigation. You should receive another response shortly.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  10. Jeff P.

    Jeff P. Well-Known Member

    Joined:
    Feb 2, 2016
    Messages:
    52
    Likes Received:
    10
    Trophy Points:
    8
    Location:
    Daytona Beach, Florida, USA
    cPanel Access Level:
    DataCenter Provider
    ok I am getting off the server now
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. Jeff P.

    Jeff P. Well-Known Member

    Joined:
    Feb 2, 2016
    Messages:
    52
    Likes Received:
    10
    Trophy Points:
    8
    Location:
    Daytona Beach, Florida, USA
    cPanel Access Level:
    DataCenter Provider
    and thank you!!!!!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  12. Jeff P.

    Jeff P. Well-Known Member

    Joined:
    Feb 2, 2016
    Messages:
    52
    Likes Received:
    10
    Trophy Points:
    8
    Location:
    Daytona Beach, Florida, USA
    cPanel Access Level:
    DataCenter Provider
    The binary disappeared. he got me all fixed up, thanks again!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    cPanelMichael likes this.
  13. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,272
    Likes Received:
    2,154
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi @Jeff P.,

    I'm glad to see it was taken care of. It looks like the upgrade process failed to succeed in installing the MariaDB RPMs. Manually installing the required RPMs solved the issue.

    Note that internal case CPANEL-23547 is open to ensure MariaDB RPMs can be installed prior to removing MySQL when upgrading from MySQL to MariaDB.

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice