The secondary Archive Manager down several times with MySQL Lost connection error

Document ID : KB000097681
Last Modified Date : 16/08/2018
Show Technical Document Details
Issue:
The secondary Archive Manager was down several times.
Following message appeared in ARCHMGR.OUT.

SPC-SHD-29021:
ERROR TRACE at ModelArchDBImp.cc(4851): doSqlQuery/mysql_query: Failure executing query:
UPDATE landscape SET ft_event_sync_time = 1524467174 - Lost connection to MySQL server during query
Environment:
Spectrum: 10.2.2
OS: Linux
Cause:
Too many event were generated:
mysql> show table status;
The rows # of event table is 3,368,923.
VNM's EventsGenerated attribute is 4,646,792.
 
Resolution:
Add following parameters to set twice of default MySQL timeout value:
$SPECROOT/mysql/my-spectrum.cnf
net_read_timeout=60
net_write_timeout=120

Then restart MySQL and then Archive Manager.