MySQL - BulkInsert error alarms from Data_Engine probe

book

Article ID: 4664

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

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.

Cause

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

Environment

UIM 8.5 or later

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