Error: Scheduler database is down in the Management log

03/26/2020 10 12306

DESCRIPTION:
Error: Scheduler database is down in the Management log

RESOLUTION:
Problem Definition:


Snippet of the management log:


We see an error  Scheduler database is down  in management log on a HA device.
 
Error
2/20/15 13:20:02 AMC Failure occurred in isJobExistent:Scheduler database is down
Warning 
2/20/15 13:17:56 AMC Caught exception while trying to setup the ApplyForm: org.quartz.SchedulerException: Failed to check status of ApplyChangesJob:Scheduler database is down  
2/20/15 13:17:56 AMC Failure occurred in isJobExistent:Scheduler database is down
Warning
2/20/15 13:12:52 AMC Caught exception while trying to setup the ApplyForm: org.quartz.SchedulerException: Failed to check status of ApplyChangesJob:Scheduler database is down.

 
 
Resolution or Workaround:
 
It is better to perform the below task in a scheduled downtime window so that any user disconnects can be avoided.
 
If you are running a cluster need to carry out these steps on both the nodes we should run this command to stop synchronization: mysql -e 'STOP SLAVE;' 
 
 
 
Mysql troubleshooting

Truncate the database tables
 
Maria DB> TRUNCATE TABLE sessionInformation;
Maria DB> TRUNCATE TABLE failedSignatures;'
Maria DB> TRUNCATE TABLE accessChecks;
Maria DB> TRUNCATE TABLE byteCountSnapshots;
Maria DB> TRUNCATE TABLE epcState;
Maria DB> TRUNCATE TABLE userLockout;
 
 
Repair the tables


mysql -e 'STOP SLAVE;'(only on HA setup)

Maria DB> repair table byteCountSnapshots;
Maria DB> repair table sessionInformation;
Maria DB> repair table failedSignatures;
Maria DB> repair table accessChecks;
Maria DB> repair table epcState;
Maria DB> repair table userLockout;
Maria DB> quit
 
And finally on both nodes, to kick-start synchronization:
 
mysql -e 'RESET MASTER;'
 mysql -e 'RESET SLAVE;'
 /etc/init.d/mysql-replication start


 

Troubleshooting:

Refer the /var/log/aventail/management logs for SQL error and database errors.