-
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