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

Event Scheduler after creation is ENABLED in all 3 servers.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.38-galera
    • N/A
    • Galera
    • Ubunut - 16.04

    Description

      I have configured 3 node Multi Master Galera Cluster in Production, Development, Testing and Stage environments.

      Replication is working fine without any issues.

      Recently, I had a requirement to create event for which I have created one. Post creation, it behaves differently between production and other non-prod instances.

      For production, it's status is ENABLED in all 3 servers
      For non-production, it's status is ENABLED only in the place where I create and other servers it has SLAVESIDE_DISABLED.

      Can you please help me with the behaviour.

      Please find the below script runs across environment.

      CREATE DEFINER = `user`@`%` EVENT IF NOT EXISTS `order_event`
          ON SCHEDULE EVERY 15 SECOND
          STARTS NOW()
          ON COMPLETION PRESERVE ENABLE COMMENT 'Dump filtered data'
          DO
          BEGIN
          END
      

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            raja Rajaa Krishnamurthy
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.