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

EVENT fires multiply simultaneously from time to time

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.10
    • None
    • Storage Engine - InnoDB
    • None
    • Windows 11 64

    Description

      • Some time EVENT fires mutiply.
      • For example, 1 second infinte event fires like
        id time (timestamp)
        95992741 45731.01943 xxxxproc1
        95992730 45731.01941 xxxxproc1
        (from custom log table for other purpose)
      • No general log. not using it...
      • Do not know what makes server crazy to multiple event fire at once.
        Suddenly occur several time a day after restart.
      • Ohter case today morning(not above sample) triply fires.
      • At the things heppening, 'Do sleep(2);' just return, never sleeps or get delay. just bypassing.
      • It is not a rare case since several years of bug/issue.
        https://stackoverflow.com/questions/52830686/mariadb-scheduled-event-fires-twice.
      • This makes unexpected dead lock which multiply occurs.

      Attachments

        Activity

          npdmailing@gmail.com Mitchell Lee added a comment - - edited

          When its occured,

          • Doing 'ALTER EVENT event_name ENABLE;' and 'ALTER EVENT event_name DISABLE;' dynamically (by manual, or stmt) while server running.
          • Altering event code and its nested stored procedure not be applied unless entire system reboot. service restart doesn't work.
            Why the...thread keep reused? ini got a thread cache = 0.
          • Want to know how to fully reset/recreate/purge the event thread? any workaround?
          npdmailing@gmail.com Mitchell Lee added a comment - - edited When its occured, Doing 'ALTER EVENT event_name ENABLE;' and 'ALTER EVENT event_name DISABLE;' dynamically (by manual, or stmt) while server running. Altering event code and its nested stored procedure not be applied unless entire system reboot. service restart doesn't work. Why the...thread keep reused? ini got a thread cache = 0. Want to know how to fully reset/recreate/purge the event thread? any workaround?

          People

            Unassigned Unassigned
            npdmailing@gmail.com Mitchell Lee
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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