-
Incident report
-
Resolution: Won't fix
-
Critical
-
None
-
1.8.11
-
None
-
SLES 11SP1
Received hundreds of notifications that hosts did not receive any data in the last xx seconds (trigger using nodata, therefore evaluated on the server side).
Had a quick look at zabbix-server.log and noticed the following error logs:
[Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+42 where nodeid=1 and table_name='events' and field_name='eventid']
20468:20120416:000132.902 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+42 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20468]: ERROR file:db.c,line:1582 Something impossible has just happened.
20471:20120416:000134.761 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+19 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20471]: ERROR file:db.c,line:1582 Something impossible has just happened.
20463:20120416:000139.912 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+8 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20463]: ERROR file:db.c,line:1582 Something impossible has just happened.
20461:20120416:000139.912 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+3 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20461]: ERROR file:db.c,line:1582 Something impossible has just happened.
20469:20120416:000139.913 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+24 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20469]: ERROR file:db.c,line:1582 Something impossible has just happened.
20460:20120416:000139.913 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+6 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20460]: ERROR file:db.c,line:1582 Something impossible has just happened.
20464:20120416:000149.926 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+26 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20464]: ERROR file:db.c,line:1582 Something impossible has just happened.
20473:20120416:000205.948 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+2 where nodeid=1 and table_name='events' and field_name='eventid']
20458:20120416:000205.948 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+2 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20473]: ERROR file:db.c,line:1582 Something impossible has just happened.
zabbix-server [20458]: ERROR file:db.c,line:1582 Something impossible has just happened.
20472:20120416:000205.949 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+21 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20472]: ERROR file:db.c,line:1582 Something impossible has just happened.
20466:20120416:000206.950 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+13 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20466]: ERROR file:db.c,line:1582 Something impossible has just happened.
20471:20120416:000227.979 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+19 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20471]: ERROR file:db.c,line:1582 Something impossible has just happened.
20426:20120416:000241.101 Sending configuration data to proxy 'xxxxxx'. Datalen 193386
20460:20120416:000313.042 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+9 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20460]: ERROR file:db.c,line:1582 Something impossible has just happened.
zabbix-server [20460]: ERROR file:db.c,line:1582 Something impossible has just happened.
20466:20120416:000315.045 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+13 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20466]: ERROR file:db.c,line:1582 Something impossible has just happened.
20424:20120416:000328.504 Sending configuration data to proxy 'vzugunit8'. Datalen 193507
20472:20120416:000353.099 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+21 where nodeid=1 and table_name='events' and field_name='eventid']
20458:20120416:000353.099 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+2 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20458]: ERROR file:db.c,line:1582 Something impossible has just happened.
zabbix-server [20472]: ERROR file:db.c,line:1582 Something impossible has just happened.
20460:20120416:000407.119 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+9 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20460]: ERROR file:db.c,line:1582 Something impossible has just happened.
20459:20120416:000413.127 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+13 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20459]: ERROR file:db.c,line:1582 Something impossible has just happened.
20461:20120416:000416.131 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+21 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix-server [20461]: ERROR file:db.c,line:1582 Something impossible has just happened.
Could you please let me know if this is a known issue and if I have to do anything about it.
- duplicates
-
ZBXNEXT-1574 Removal of unknown events
- Closed