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

          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.