DBD::mysql::st execute failed: Lost connection to MySQL server

bloatedstoat

Well-Known Member
Jun 14, 2012
173
22
68
Victoria, Australia
cPanel Access Level
Root Administrator
Hello,

Last night the data centre had an issue with a switch which apparently led to the filesystem on our server being rendered read only.
After the switch issue was resolved we rebooted our server and all appears to be running as expected except for the following where we receive errors every 4 hours.

DBD::mysql::st execute failed: Lost connection to MySQL server during query at bin/update_db_cache line 334.
DBD::mysql::st execute failed: Lost connection to MySQL server during query at bin/update_db_cache line 334.

Has anyone come across this before? Is there a fix for this?

Thanks in advance for any help.

----
CENTOS 6.5 x86_64 xenpv
WHM 11.42.0 (build 22)
Load Averages: 0.07 0.17 0.14
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello :)

Do you notice any error messages in /var/lib/mysql/$hostname.err when restarting the MySQL service or when running "/usr/local/cpanel/scripts/update_db_cache" manually?

Thank you.
 

Solokron

Well-Known Member
Aug 8, 2003
851
1
168
Seattle
cPanel Access Level
DataCenter Provider
Code:
140608 00:31:50 mysqld_safe Number of processes running now: 0
140608 00:31:50 mysqld_safe mysqld restarted
140608  0:31:50 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
140608  0:31:50 [Note] Plugin 'FEDERATED' is disabled.
140608  0:31:50  InnoDB: Initializing buffer pool, size = 1.2G
140608  0:31:51  InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 22 4199971154
140608  0:31:51  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 22 4199973037
140608  0:31:51  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
140608  0:31:52  InnoDB: Started; log sequence number 22 4199973037
 

cPanelPeter

Technical Analyst III
Staff member
Sep 23, 2013
575
21
143
cPanel Access Level
Root Administrator
Twitter
Hello,

The above log error shows some possible InnoDB corruption. It also however shows that it may have been repaired. Are you still having issues with running "/usr/local/cpanel/scripts/update_db_cache" manually?

If so, please feel free to open a support ticket using the link in my signature. Please post the ticket number in this thread so we can update it accordingly.
 

Solokron

Well-Known Member
Aug 8, 2003
851
1
168
Seattle
cPanel Access Level
DataCenter Provider
Still occurs.