The secondary Archive Manager was down several times.
Following message appeared in ARCHMGR.OUT.
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
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.
Add following parameters to set twice of default MySQL timeout value:
Then restart MySQL and then Archive Manager.