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

            Activity

              People

              • Assignee:
                wlad Vladislav Vaintroub
                Reporter:
                manjot Manjot Singh
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: