CentOS 7.9.2009 & WHM v100.0.4 breaks mySQL?

macteacher

• November 23, 2021 10:08

I updated my CentOS last night and that freed up the update to v100.0.4. Everything completed without issue, but now I am getting Mariadb service errors: Nov 23 15:53:01 server1.g4vhosting8.com mariadbd[23220]: 2021-11-23 15:53:01 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.13-MariaDB) starting as process 23220 ... Nov 23 15:53:01 server1.g4vhosting8.com systemd[1]: Failed to start MariaDB 10.5.13 database server. Nov 23 15:53:01 server1.g4vhosting8.com systemd[1]: mariadb.service failed. What is the best way to fix this?

• 

  cPanelAnthony

  • November 23, 2021 15:46

  Hello! Do you get any output if you run the following command? /scripts/restartsrv_mysql
  If you run this next command immediately after, do you get further error information? journalctl -xe
  

  0
• 

  macteacher

  • November 23, 2021 16:11

  Anthony, Thank you for the quick response. I just got your response and went to run the commands requested and my hosting company has fixed the issue. I am just checking to see what they needed to do in order to fix. I would like to know what caused the issue and what was done to remedy it (for future reference). I will update when I have more details.

  0
• 

  macteacher

  • November 23, 2021 17:34

  Just to follow-up on this - the hosting provider fixed the issue by moving the MySQL PID file from /run to /mysql. Not sure why an automated update would necessitate this, but it has fixed the issue.

  0
• 

  cPanelAnthony

  • November 23, 2021 19:09

  I'm not sure why an automatic update specifically would cause this issue, but I'm happy to hear it's fixed!

  0

Please sign in to leave a comment.