Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19262

Server error message is unclear if event is created and event_scheduler = DISABLED

Details

    Description

      The server throws a somewhat nonsensical error message if an event is created when event_scheduler = DISABLED. For example:

      MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'event_scheduler';
      		 
      +-----------------+----------+
      		 
      | Variable_name   | Value    |
      		 
      +-----------------+----------+
      		 
      | event_scheduler | DISABLED |
      		 
      +-----------------+----------+
      		 
      1 row in set (0.00 sec)
      		 
       
      		 
      MariaDB [(none)]> CREATE EVENT db1.myevent
      		 
          ->     ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
      		 
          ->     DO SELECT NOW();
      		 
      ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start

      The same nonsensical error message is thrown if SHOW EVENTS is executed or if information_schema.EVENTS is queried. For example:

      MariaDB [db1]> SHOW GLOBAL VARIABLES LIKE 'event_scheduler';
      		 
      +-----------------+----------+
      		 
      | Variable_name   | Value    |
      		 
      +-----------------+----------+
      		 
      | event_scheduler | DISABLED |
      		 
      +-----------------+----------+
      		 
      1 row in set (0.01 sec)
      		 
       
      		 
      MariaDB [db1]> SHOW EVENTS;
      		 
      ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start
      		 
      MariaDB [db1]> SELECT EVENT_SCHEMA, EVENT_NAME FROM information_schema.EVENTS;
      		 
      ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start

      The error message should say something like "Cannot proceed because event scheduler is DISABLED."

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29827 Misleading error messages about event scheduler when using --skip-grant-tables

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17718 Setting event_scheduler to DISABLED causes bogus corruption errors

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19265 Server should throw warning if event is created and event_scheduler = OFF

          • Major - Major loss of function.
          • Closed

          Activity

            dlenski Daniel Lenski (Inactive) added a comment -

            The patch for this issue was https://github.com/mariadb/server/commit/6c9a6bad4fe90c8bfcfe6dbf46835a39edc95c6f by wlad. It basically consisted of changing the error message to Cannot proceed, because event scheduler is disabled.

            This results in a highly misleading error message in cases when the event scheduler is not disabled, but other system tables’ state is (apparently) preventing it from working. MDEV-29827

            dlenski Daniel Lenski (Inactive) added a comment - The patch for this issue was https://github.com/mariadb/server/commit/6c9a6bad4fe90c8bfcfe6dbf46835a39edc95c6f by wlad . It basically consisted of changing the error message to Cannot proceed, because event scheduler is disabled . This results in a highly misleading error message in cases when the event scheduler is not disabled, but other system tables’ state is (apparently) preventing it from working. MDEV-29827

            People

              wlad Vladislav Vaintroub
              manjot Manjot Singh (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.