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!

MariaDB Did Not Start Up After Upgrade

Discussion in 'Database Discussion' started by linux4me2, Jun 10, 2018.

Tags:
  1. linux4me2

    linux4me2 Well-Known Member

    Joined:
    Aug 21, 2015
    Messages:
    201
    Likes Received:
    47
    Trophy Points:
    28
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    I'm using WHM/cPanel 70, and I decided to take the plunge and do the upgrade from MariaDB 10.1 to 10.2 using the MySQL/MariaDB upgrade tool in WHM.

    During Step 7 of the upgrade process, I got the following error:
    Code:
    MariaDB did not start up after upgrade; there may be a problem in /etc/my.cnf. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 863.
    There were also several warnings about the following unknown setting in /etc/my.cnf, carried over from version 10.1:
    Code:
    innodb_use_sys_malloc=0
    I checked my old, pre-upgrade /etc/my.cnf file, and the setting for innodb_use_sys_malloc was in there, so it was carried over by the upgrade process. Commenting that line out in /etc/my.cnf and clicking the "Retry" button in WHM's MySQL/MariaDB upgrade tool allowed me to successfully upgrade to MariaDB 10.2, and MariaDB restarted just fine.

    The MySQL/MariaDB upgrade tool output made it easy to find the issue, but things would have gone smoother had I commented that line out before running it the first time. I'm posting this in case someone else is planning to do the upgrade and wants to take the precaution of commenting that line out before running the upgrade.

    The innodb_use_sys_malloc setting was removed in MariaDB 10.2, which was the source of the problem. You can read the details here.
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,066
    Likes Received:
    214
    Trophy Points:
    173
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @linux4me2


    Thank you for posting your experience and the resolution to this issue for others. I am glad you were able to identify the issue and get MariaDB 10.2 added.

    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