MySQL - BulkInsert error alarms from Data_Engine probe

Document ID : KB000004664
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Issue:

Receiving the below alarm message from the data_engine probe:

QoSData] thread_id: 47642, error: MySQL_BulkInsert::Commit: Lost connection to MySQL server during query (errno:2013) 

Failed to insert QoS data into the database, check that the database is running.

 

 

 

Cause:

This issue can occur with MySQL when a large bulk insert of thousands of rows is being performed. 

Resolution:

This issue can occur with MySQL when a large bulk insert of thousands of rows is being performed. 

The solution is usually to change a setting on the MySQL server itself. 

in the my.cnf file, in the [mysqld] section,you should check if the following key exists: 

net_read_timeout= 

if so, they should double the current value of this key and restart MySQL. 

If it does not exist, then they should add it with a value of 120, e.g. 

net_read_timeout=120