The Spectrum Archive Manager is hanging and the following error message was found in the $SPECROOT/SS/DDM/ARCHMGR.OUT file:
May 03 09:28:47 : ArchMgr started as user '#####' May 03 09:28:47 : ArchMgr validating database. May 03 09:29:15 : ArchMgr successfully connected to MySQL service May 03 09:29:15 : ArchMgr loaded DDM database with landscape handle 0x100000 May 03 09:29:19 : ArchMgr has successfully connected to the SpectroSERVER. May 03 09:29:19 : ArchMgr has successfully advertised CORBA Event Service. May 03 09:29:19 : ArchMgr is now ready on port 0xbafe, precedence 10 SPC-SHD-29021: ************************************************************************** The following output is intended to facilitate debugging, please forward to CA technical support. The files listed are not part of the customer installation of SPECTRUM. ************************************************************************** May 03 09:30:37 ERROR TRACE at ModelArchDBImp.cc(4851): doSqlQuery/mysql_query: Failure executing query: INSERT DELAYED IGNORE INTO event(model_h, utime, counter, clk_seq, version, node_id, user_key, type, severity, vardata_string) VALUES(1379596,1525303436,5581261,725,1,'\0PV•dy',5,104005745,70,'\0\0\0\0\0\0\0\0\0\0\0\0<hostName>+\0\0\0\0æI\0\0Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared . . .
:Cleared :Cleared :Cleared :Profile SQL-PECON, instance XX.YY.WW.ZZ has 0.48 page reads per second\0\0\0\0\0\0\r\0\0\0<IP_Address>e\0\0\0\0\0\0\0\0\00h\0\0\0\0\0\0\0\0\0SQL-PECON-page_readsi\0\0\0\0\0\0 \0\0\0sqlserverj\0\0\0\0\0\0\0\0\0Primary_Hub_nameq\0\0\0\0\0\0\0\0\04.2:34D3\0\0\0\0\0\0\0EX26233061-80861B3\0\0\0\0\0\0\0C3\0\0\0\0\0\0\0') Native Error: 1153, Got a packet bigger than 'max_allowed_packet' bytes May 03 09:30:41 ERROR TRACE at DDMDbIf.cc(2915): Aborting database transaction. May 03 09:30:41 ERROR TRACE at CsEventMgr.cc(1752): Event Log Manager: Error attempting to log event to database. . May 03 09:30:43 : Closing database May 03 09:30:43 : ArchMgr is shutting down... May 03 09:30:43 : ArchMgr has successfully shut down.