MYSQL Error messages

Team ,

I am getting an below messages in MySQL log . Please let me know what it is & what action needs to be preferred to resolve this .

please find below 2 separate error messages in the server.

root@frsellpappsnm03:/usr/local/pasi/log # tail ODS_StatusData.log 
1635274916;WARNING;1955;MySql Request Error : INSERT INTO `log` (`msg_type`,`ctime`, `id_host`, `id_service`, `status`, `notification_cmd`, `notification_contact`, `output`) VALUES ('2', '1635274358', 2158, 87936, 'CRITICAL', 'notification_service_par_mail','Exploitation_DSI|19','[ KO ] VSS Writer Error:')
1635274916;WARNING;1955;MySql Request Error : INSERT INTO `log` (`msg_type`,`ctime`, `id_host`, `id_service`, `status`, `notification_cmd`, `notification_contact`, `output`) VALUES ('2', '1635274358', 2158, 87936, 'CRITICAL', 'notification_service_par_mail','Prestataire_cognos_hth_|310','[ KO ] VSS Writer Error:')
1635274916;WARNING;1955;MySql Request Error : INSERT INTO `log` (`msg_type`,`ctime`, `id_host`, `id_service`, `status`, `notification_cmd`, `notification_contact`, `output`) VALUES ('2', '1635274358', 2158, 87936, 'CRITICAL', 'notification_service_par_mail','Service_Delivery_ERP|482','[ KO ] VSS Writer Error:')
1635274916;WARNING;1955;MySql Request Error : INSERT INTO `log` (`msg_type`,`ctime`, `id_host`, `id_service`, `status`, `type`, `retry`, `output`) VALUES ('0', '1635274459', 1994, 46095,  'OK', 'HARD','4','[ OK ] Full Backup')
1635274916;WARNING;1955;MySql Request Error : INSERT INTO `log` (`msg_type`,`ctime`, `id_host`, `id_service`, `status`, `type`, `retry`, `output`) VALUES ('0', '1635274563', 3215, 29737,  'OK', 'HARD','1','HTTP OK: HTTP/1.1 200 OK - 1232 bytes in 0,521 second response time')
1635274916;WARNING;1955;MySql Request Error : INSERT INTO `log` (`msg_type`,`ctime`, `id_host`, `id_service`, `status`, `type`, `retry`, `output`) VALUES ('0', '1635274716', 3922, 34536,  'CRITICAL', 'HARD','4','CRITICAL : 1 Service (s) not started : <br />Background Intelligent Transfer Service [<strong>BITS</strong>]')
1635274916;WARNING;1955;MySql Request Error : INSERT INTO `log` (`msg_type`,`ctime`, `id_host`, `id_service`, `status`, `type`, `retry`, `output`) VALUES ('0', '1635274722', 2507, 22796,  'UNKNOWN', 'HARD','1','Timeout ,Host 10.51.101.33 is Unreachable')
1635274916;WARNING;1955;MySql Request Error : INSERT INTO `log` (`msg_type`,`ctime`, `id_host`, `id_service`, `status`, `type`, `retry`, `output`) VALUES ('0', '1635274803', 1367, 14012,  'OK', 'HARD','1','Physical Memory: 85% used (26.91GB/32.00GB) (<85%) : OK')
1635274916;INFORMATION;1955;File 2_172.238.0.12_1635274916_ODS_StatusData loaded
1635274916;INFORMATION;1955;Listening on ODS_StatusDataFile_Loading
root@frsellpappsnm03:/usr/local/pasi/log # cd -
/var/log/mysql
root@frsellpappsnm03:/var/log/mysql # tail error.log
2021-10-26T19:05:40.229406Z 18 [ERROR] /usr/sbin/mysqld: Table './centstorage/data_bin#P#p2021_10' is marked as crashed and last (automatic?) repair failed
2021-10-26T19:05:40.236735Z 18 [ERROR] /usr/sbin/mysqld: Table './centstorage/data_bin#P#p2021_10' is marked as crashed and last (automatic?) repair failed
2021-10-26T19:05:40.244259Z 18 [ERROR] /usr/sbin/mysqld: Table './centstorage/data_bin#P#p2021_10' is marked as crashed and last (automatic?) repair failed
2021-10-26T19:05:40.252182Z 18 [ERROR] /usr/sbin/mysqld: Table './centstorage/data_bin#P#p2021_10' is marked as crashed and last (automatic?) repair failed
2021-10-26T19:05:40.261046Z 18 [ERROR] /usr/sbin/mysqld: Table './centstorage/data_bin#P#p2021_10' is marked as crashed and last (automatic?) repair failed
2021-10-26T19:05:40.272508Z 18 [ERROR] /usr/sbin/mysqld: Table './centstorage/data_bin#P#p2021_10' is marked as crashed and last (automatic?) repair failed
2021-10-26T19:05:40.278128Z 18 [ERROR] /usr/sbin/mysqld: Table './centstorage/data_bin#P#p2021_10' is marked as crashed and last (automatic?) repair failed
2021-10-26T19:05:41.959765Z 23 [ERROR] /usr/sbin/mysqld: Table './centstorage/data_bin#P#p2021_10' is marked as crashed and last (automatic?) repair failed
2021-10-26T19:05:41.966332Z 23 [ERROR] /usr/sbin/mysqld: Table './centstorage/data_bin#P#p2021_10' is marked as crashed and last (automatic?) repair failed
2021-10-26T19:05:42.275632Z 1149 [ERROR] /usr/sbin/mysqld: Table './centstorage/log' is marked as crashed and last (automatic?) repair failed.

Early response will be appreciated.

Hi @pkelaska thank you for your message to the Percona Forums!

It looks like you have a partitioned table named data_bin and log which seemed to be in a corrupted state. You should go ahead with

REPAIR TABLE data_bin,log EXTENDED

This will recover the data from your tables which are crashed.
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
Please be sure to back up your data before you run the REPAIR TABLE operation. Best of luck!

1 Like