I have had this problem since 1.8.8 but I upgraded to 1.8.9 to see if the problem would go away
I have multiple scripts which use zabbix_sender to send "stuff" to the zabbix server I also have one script which uses the RUBY API to create "items" in zabbix if they are missing (this is NEW) after adding these API calls after a few hours the zabbix server stops accepting data from other agents and from the zabbix_senders.
At first I saw my disk was filling up so I stopped zabbix did a mysqldump, restored the database and restarted zabbix. Now before the daemon locks up I get these messages in the log:
15721:20111201:102702.610 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix_server [15721]: ERROR [file:db.c,line:1574] Something impossible has just happened.
15723:20111201:102702.610 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix_server [15723]: ERROR [file:db.c,line:1574] Something impossible has just happened.
I have multiple scripts which use zabbix_sender to send "stuff" to the zabbix server I also have one script which uses the RUBY API to create "items" in zabbix if they are missing (this is NEW) after adding these API calls after a few hours the zabbix server stops accepting data from other agents and from the zabbix_senders.
At first I saw my disk was filling up so I stopped zabbix did a mysqldump, restored the database and restarted zabbix. Now before the daemon locks up I get these messages in the log:
15721:20111201:102702.610 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix_server [15721]: ERROR [file:db.c,line:1574] Something impossible has just happened.
15723:20111201:102702.610 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=1 and table_name='events' and field_name='eventid']
zabbix_server [15723]: ERROR [file:db.c,line:1574] Something impossible has just happened.
Comment