Below the full error from zabbix_server.log

19044:20140113:104628.634 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
19044:20140113:104628.635 slow query: 51.477057 sec, "update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid'"
zabbix_server [19044]: ERROR file:db.c,line:1500 Something impossible has just happened.
19002:20140113:104629.044 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
19043:20140113:104629.044 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
19043:20140113:104629.044 slow query: 50.411193 sec, "update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid'"
19002:20140113:104629.044 slow query: 50.378088 sec, "update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid'"
zabbix_server [19043]: ERROR file:db.c,line:1500 Something impossible has just happened.
zabbix_server [19002]: ERROR file:db.c,line:1500 Something impossible has just happened. 19042:20140113:104629.044 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']

19042:20140113:104629.044 slow query: 50.458446 sec, "update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid'"
19040:20140113:104629.044 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
zabbix_server [19042]: ERROR file:db.c,line:1500 Something impossible has just happened.
19040:20140113:104629.045 slow query: 50.478579 sec, "update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid'"
zabbix_server [19040]: ERROR file:db.c,line:1500 Something impossible has just happened.