Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Fixed
-
2.5.19
-
None
Description
By default the mariadbmon configuration will attempt to manage the event subsystem of MariaDB and it will query for all active events. If the event scheduler is disabled in MariaDB, the query will fail with an error. In this case mariadbmon will log the following errors:
2022-03-09 08:09:32 error : [mariadbmon] Could not query events of 'server2': Query 'SELECT Event_schema, Event_name FROM information_schema.EVENTS WHERE Status = 'ENABLED';' failed: 'Cannot proceed, because event scheduler is disabled'. Event handling can be disabled by setting 'handle_events' to false.
|
2022-03-09 08:09:32 error : [mariadbmon] Could not query events of 'server3': Query 'SELECT Event_schema, Event_name FROM information_schema.EVENTS WHERE Status = 'ENABLED';' failed: 'Cannot proceed, because event scheduler is disabled'. Event handling can be disabled by setting 'handle_events' to false.
|
2022-03-09 08:09:32 error : [mariadbmon] Could not query events of 'server4': Query 'SELECT Event_schema, Event_name FROM information_schema.EVENTS WHERE Status = 'ENABLED';' failed: 'Cannot proceed, because event scheduler is disabled'. Event handling can be disabled by setting 'handle_events' to false.
|
2022-03-09 08:09:32 error : [mariadbmon] Could not query events of 'server1': Query 'SELECT Event_schema, Event_name FROM information_schema.EVENTS WHERE Status = 'ENABLED';' failed: 'Cannot proceed, because event scheduler is disabled'. Event handling can be disabled by setting 'handle_events' to false.
|
This quickly fills up the log and requires the administrator to disable the event handling to stop them. A better solution would be to log the error only once and then silently wait for the event scheduling to be enabled on the database.