database connection error

allhost

• December 22, 2014 19:20

Hello All, This is my first thread, and possibly pretty new on WHM :(. My update to the latest WHM got stuck around 50%, doing (Running sanity checks and notifications.), (Processing command `/usr/local/cpanel/scripts/setup_whmxfer_db`), for more than 50 minutes. The page still loads, but nothing is progressing. Of course, all my websites are down due to (database connection error), so, once I try to go the the WHM (from a different window), I do see it is updated, and it shows the latest version of 11.46.1, however, I can not seem to start MySQL, which might be corrupted. What do you think I should be doing next? I do have a server backup but wish to make this the last resort? Any ideas would be highly appreciated? Thank you all,

• 

  Infopro

  • December 23, 2014 00:56

  Of course, all my websites are down due to (database connection error)
  There is no of course, there. Sites shouldn't be going offline during updates to your cPanel. You shouldn't be restoring backups to sites that went offline during an update, either. I can not seem to start MySQL, which might be corrupted.
  How are you trying to start it, that's failing? Why do you think it might be corrupted? Please feel free to open a ticket to cPanel Technical Support for assistance with this. If you wouldn't mind, post the ticket ID back here in this thread. Thanks

  0
• 

  allhost

  • December 23, 2014 01:38

  Thanks InfoPro. Basically, This is what happened. I have 3 sites (wordpress) and all of them showed (database connection error) while WHM is being updated. So weird. While updating cPanel/WHM, I ticked that little box to allow sharing update process with cPanel. I started SQL from WHM menu -->restart services --> SQL services. The first time, it failed, then, worked again and show these errors multiple times.
  [Warning] /usr/sbin/mysqld: Forcing close of thread 22 user: 'eximstats' 18:10:13 [Note] /usr/sbin/mysqld: Normal shutdown 18:09:21 [ERROR] /usr/sbin/mysqld: Can't open file: './whmxfer/sessions.frm' (errno: 24) [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.frm' (errno: 24) 17:33:32 [ERROR] /usr/sbin/mysqld: Can't open file: './modsec/hits.frm' (errno: 24) 17:32:21 [ERROR] /usr/sbin/mysqld: Can't open file: './i326520_wp1/wp_options.frm' (errno: 24) [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/defers.frm' (errno: 24) 17:31:01 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.frm' (errno: 24) 17:31:00 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/failures.frm' (errno: 24)
  Now, I am wondering whether my cPanel/WHM upgrade is completely healthy or not? and how to fix these DB errors? What do you think? Thanks

  0
• 

  triantech

  • December 23, 2014 02:37

  Hello, From the logs, it looks like your eximstats db is corrupt.. you may try to repair it or drop the db and rebuild it.

  0
• 

  allhost

  • December 23, 2014 02:49

  Thanks Triantech. I have gone and repaired all these DB's, restarted SQL and it seems all these error logs are gone. Much appreciated.

  0
• 

  triantech

  • December 23, 2014 12:05

  allhost, Great :)

  0

Please sign in to leave a comment.