Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-4040

Mariadbmon constantly logs errors if event scheduler is disabled

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            markus makela markus makela
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.