MySQL - BulkInsert error alarms from Data_Engine probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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.

Environment

UIM 8.5 or later

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