Error on ARCHMGR.OUT after upgrade to 10.3
Article ID: 129085
Updated On:
Products
CA Spectrum
Issue/Introduction
After upgrade for Spectrum 10.3.0, we see on all servers,
"Mar 07 00:00:48 ERROR TRACE at ModelArchDBImp.cc(4969): doSqlQuery/mysql_query: Failure executing query:
ALTER TABLE event ADD PARTITION (PARTITION EVENT_7_3_2019 VALUES LESS THAN (1552006800)) - Duplicate partition name EVENT_7_3_2019
Mar 07 00:00:48 ERROR TRACE at ModelArchDBImp.cc(4969): doSqlQuery/mysql_query: Failure executing query:
INSERT INTO partitionlog(table_name, partition_name, values_less_than, creation_time, destroy_time) VALUES('event','EVENT_7_3_2019','1552006800',1551920448,NULL) - Duplicate entry 'EVENT_7_3_2019' for key 'partition_name' "
"Mar 07 00:00:48 ERROR TRACE at ModelArchDBImp.cc(4969): doSqlQuery/mysql_query: Failure executing query:
ALTER TABLE event ADD PARTITION (PARTITION EVENT_7_3_2019 VALUES LESS THAN (1552006800)) - Duplicate partition name EVENT_7_3_2019
Mar 07 00:00:48 ERROR TRACE at ModelArchDBImp.cc(4969): doSqlQuery/mysql_query: Failure executing query:
INSERT INTO partitionlog(table_name, partition_name, values_less_than, creation_time, destroy_time) VALUES('event','EVENT_7_3_2019','1552006800',1551920448,NULL) - Duplicate entry 'EVENT_7_3_2019' for key 'partition_name' "
Environment
CA Spectrum 10.3.0
Resolution
A restart of the archive manager fixes this error.
Feedback
Yes
No
Powered by
