PDA

View Full Version : i have a problem with insert into history


Shorty Guard
21-10-2004, 09:42
i changed timeout from 5 to 10 in zabbix_suckerd.conf, restart zabbix_suckerd and then had a log like:

011719:20041021:133209 Query failed:Got error -1 from table handler [1030]
011719:20041021:133210 Query::insert into history (clock,itemid,value) values (1098340330,17394,1838.506660)
011719:20041021:133210 Query failed:Got error -1 from table handler [1030]
011719:20041021:133210 Query::insert into history (clock,itemid,value) values (1098340330,17397,5.333330)
011719:20041021:133210 Query failed:Got error -1 from table handler [1030]


until restart it was all right

Alexei
21-10-2004, 09:52
It seems that you database is corrupted.

Use "repair table <table>" statement to fix it.

Proper system restart should never lead to problems with database corruption. You haven't pressed power-off button, have you?;)

Shorty Guard
21-10-2004, 10:45
THX, database was corrupted. Now, it's ok.

P.S.
i haven't pressed power-off button. :D

P.P.S. Is there a way to make zabbix_agentd update configuration without restarting?

Alexei
21-10-2004, 11:14
Is there a way to make zabbix_agentd update configuration without restarting? No, it's no supported yet.