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

Setting event_scheduler to DISABLED causes bogus corruption errors

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 10.0, 10.1, 10.2, 10.3, 10.4
    • N/A
    • Events, Variables
    • None

    Description

      When event_scheduler is set to DISABLED, event-related activities produce ER_EVENTS_DB_ERROR:

      MariaDB [test]> show events;
      		 
      ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start

      At the same time, trying to change the value at runtime produces a different error:

      MariaDB [test]> set global event_scheduler=on;
      		 
      ERROR 1290 (HY000): The MariaDB server is running with the --event-scheduler=DISABLED or --skip-grant-tables option so it cannot execute this statement

      This is confusing, especially when it comes to investigation of real-life problems.
      If we can't distinguish real corruption from the user setting, which is probably the case, maybe it would be best to disallow user to set the option to DISABLED and keep it an internal-only value.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19262 Server error message is unclear if event is created and event_scheduler = DISABLED

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15426 Event scheduler disabled on a slave possibly breaking replication

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16582 mysqldump: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)

          • Major - Major loss of function.
          • Closed

          Activity

            People

              wlad Vladislav Vaintroub
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.