MariaDB Did Not Start Up After Upgrade

linux4me2

Well-Known Member
Aug 21, 2015
240
64
28
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.