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.
UIM 8.5 or later
This issue can occur with MySQL when a large bulk insert of thousands of rows is being performed.
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