Upgrade to MariaDB Failed (Home >> Software >> MariaDB/MySQL Upgrade)

LUN

• September 07, 2015 04:06

Hi,

• 

  cPanelMichael

  • September 07, 2015 17:20

  Hello :) Could you verify if you used "WHM Home >> Software >> MariaDB/MySQL Upgrade" or if you used the unsupported custom workaround first? Do you notice any error messages in /var/lib/mysql/$hostname.err when the upgrade fails or when restarting MySQL? Thank you.

  0
• 

  LUN

  • September 07, 2015 18:21

  Hi, Yes I have used "WHM Home >> Software >> MariaDB/MySQL Upgrade" and not the unsupported method. MySQL doesn't start. When I type mysql in terminal I get this. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) And for error messages I get this. cat: /var/lib/mysql/.err: No such file or directory Thanks for helping me.

  0
• 

  cPanelMichael

  • September 07, 2015 18:53

  Please don't use "cat" for error logs, as it will output the entire log. Try using a command such as "tail -200 /var/lib/mysql/$hostname.err" to see the last 200 lines from the log file. Note that $hostname is referring to the hostname of your server. Thank you.

  0
• 

  LUN

  • September 08, 2015 11:12

  I just wanted to update here, as I have managed to solve this. Hear is what I did. First I restarted server. Then manually started mysql (service mysql start). Than I cancelled the existing update and again migrated to mysql followed by rebuilding php and Apache. After that again run the migration tool (and pray to god that it will not break) to MariaDB. This should fix the problem. Note : Before upgrading make sure that /etc/my.cnf file is not modified and that it has all the system default settings. I got this error become I have previously added max_connections = 500 to it.

  0
• 

  cPanelMichael

  • September 08, 2015 15:30

  I'm happy to see the issue is now resolved. Thank you for updating us with the outcome.

  0

Please sign in to leave a comment.