Check creation procedure of events for non-existent triggers

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Trivial
    • None
    • Affects Version/s: None
    • Component/s: Server (S)
    • None
    • Environment:
      RHEL 5.6

      I am getting loads of events from non-existent triggers with PROBLEM (1) value:

      mysql> select * from events where value=1 and acknowledged=0 limit 10;
      --------------------------------------------------------

      eventid source object objectid clock value acknowledged

      --------------------------------------------------------

      5656244 2 3 196 1314014676 1 0
      5656245 2 3 166 1314014676 1 0
      5656246 2 3 167 1314014679 1 0
      5656247 2 3 107 1314014679 1 0
      5656248 2 3 136 1314014681 1 0
      5656249 2 3 170 1314014681 1 0
      5656250 2 3 110 1314014681 1 0
      5656251 2 3 116 1314014682 1 0
      5656252 2 3 179 1314014683 1 0
      5656253 2 3 130 1314014683 1 0

      --------------------------------------------------------
      10 rows in set (1.64 sec)

      mysql> select * from triggers where triggerid=196;
      Empty set (0.00 sec)

      I am getting this on out production server which is running 1.8.4, but not on testing servers.

      Any ideas how can I help you to debug this issue?

      Thanks,
      Marcel

            Assignee:
            Unassigned
            Reporter:
            Marcel Hecko
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: