Secondary ArchMgr is not synced with primary SpectroSERVER

Products

• Spectrum
• Network Observability

Issue/Introduction

After upgrading to 10.3 - have been able to successfully convert DDMDB from MyISAM to InnoDB tables. However, the Secondary Archive Manager is showing errors when attempting to sync to Primary such as the following:

Jan 18 23:10:33 : Failed to sync events. 

Jan 18 23:10:33 : Starting sync of events from primary ArchMgr 

Jan 18 23:10:33 : Last event synchronization time is Jan 18 23:10:33 

Jan 18 23:20:33 ERROR TRACE at CsEventMgr.cc(2528): Failure detaching from primary ArchMgr

Environment

Spectrum 10.3 or later

Cause

In the process of upgrade and conversion of the databases, the Primary and Secondary databases were no longer in sync with each other. 

Resolution

Copy the Primary DDM database to Secondary to ensure the databases are in sync. 

Backup the DDM database on the Primary SpectroSERVER

- Log into the Primary SpectroSERVER system as the user that owns the Spectrum installation

- If on Windows, start a bash shell by running "bash -login"

- Shutdown the Archive Manager
  - Find the process id of the Archive Manager process
  - cd to the $SPECROOT/bin directory
  - Run the following command where <PID> is the process id of the Archive Manager process

./cmdC localhost 1 <PID>

- cd to the $SPECROOT/SS/DDM directory and run the following command to create a backup of the DDM database where <FILE> is a filename to save the backup to:

./ddm_save.pl -f <FILE>

The database backup filename created will be the filename specified in the command above with have a .mbi extention. For example, if the filename specified in the command is "ddm_backup" then the filename created will be "ddm_backup.mbi".

- cd to the $SPECROOT/bin and enter the following command to start the Archive Manager:

./startSS.pl

Load the DDM database backup on the Secondary SpectroSERVER

- Copy the DDM database backup file from the Primary SpectroSERVER system to the $SPECROOT/SS/DDM directory on the Secondary SpectroSERVER system

- Log into the Secondary SpectroSERVER as the user that owns the Spectrum installation

- If on Windows, start a bash shell by running "bash -login"

- Shutdown the Archive Manager
  - Find the process id of the Archive Manager process
  - cd to the $SPECROOT/bin directory
  - Run the following command where <PID> is the process id of the Archive Manager process

./cmdC localhost 1 <PID>

- cd to the $SPECROOT/SS/DDM directory and run the following command to load the backup of the DDM database where <FILE> is a filename of the backup file created on the Primary

./ddm_load.pl -f <FILE>

- cd to the $SPECROOT/bin and enter the following command to start the Archive Manager:

./startSS.pl