- Products
- Network Security
Next Generation FirewallNext-generation firewall for SMB, Enterprise, and Government
Security ServicesComprehensive security for your network security solution
Network Security ManagerModern Security Management for today’s security landscape
- Advanced Threat Protection
Capture ATPMulti-engine advanced threat detection
Capture Security applianceAdvanced Threat Protection for modern threat landscape
- Access Security
Cloud Edge Secure AccessDeploy Zero-Trust Security in minutes
Secure Mobile AccessRemote, best-in-class, secure access
Wireless Access PointsEasy to manage, fast and secure Wi-FI
SwitchesHigh-speed network switching for business connectivity
- Email Security
Email SecurityProtect against today’s advanced email threats
- Cloud Security
Cloud App SecurityVisibility and security for Cloud Apps
Cloud Firewall (NSv)Next-generation firewall capabilities in the cloud
- Endpoint Security
Capture ClientStop advanced threats and rollback the damage caused by malware
Content Filtering ClientControl access to unwanted and unsecure web content
- Product Widgets
- Product Menu Right Image
- Network Security
- Solutions
- Solutions Widgets
- Solutions Image Widgets
- Solutions Widgets
- Partners
- Partner Widgets
- Partners Image Widgets
- Partner Widgets
- Support
- Support Widget
- Support Image Widgets
- Support Widget
- Products
- Network Security
- Next Generation FirewallNext-generation firewall for SMB, Enterprise, and Government
- Security ServicesComprehensive security for your network security solution
- Network Security ManagerModern Security Management for today’s security landscape
- Advanced Threat Protection
- Capture ATPMulti-engine advanced threat detection
- Capture Security applianceAdvanced Threat Protection for modern threat landscape
- Access Security
- Cloud Edge Secure AccessDeploy Zero-Trust Security in minutes
- Secure Mobile AccessRemote, best-in-class, secure access
- Wireless Access PointsEasy to manage, fast and secure Wi-FI
- SwitchesHigh-speed network switching for business connectivity
- Email Security
- Email SecurityProtect against today’s advanced email threats
- Cloud Security
- Cloud App SecurityVisibility and security for Cloud Apps
- Cloud Firewall (NSv)Next-generation firewall capabilities in the cloud
- Endpoint Security
- Capture ClientStop advanced threats and rollback the damage caused by malware
- Content Filtering ClientControl access to unwanted and unsecure web content
- Product Widgets
- Product Menu Right Image
- Network Security
- Solutions
- Solutions Widgets
- Solutions Image Widgets
- Solutions Widgets
- Partners
- Partner Widgets
- Partners Image Widgets
- Partner Widgets
- Support
- Support Widget
- Support Image Widgets
- Support Widget
Error: Scheduler database is down in the Management log
03/26/2020 
10 People found this article helpful
43,736 Views
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.
Related Articles
- How to secure Virtual Office portal from all external access
- NetExtender users fail to get connected throwing an Error Failed to get vpn protocol on firmware 10.2.1.2 or above due to misconfigured protocol
- Is SRA/SMA appliance vulnerable to CVE-2016-2183 and CVE-2016-5915?
YES
NO