ZABBIX Server crash on 1.4.5

[kisielk]

The other day our ZABBIX Server process suddenly stopped, this is not the first time either.

The output in the log was:


19068:20080503:095543 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_commun
ity,i.snmp_oid,h.useip,h.ip,i.history,i.lastvalue, i.prevvalue,i.hostid,h.status,i.value_type,h.error s_from,i.snmp_port,i.
delta,i.prevorgvalue,i.lastclock,i.units,i.multipl ier,i.snmpv3_securityname,i.snmpv3_securitylevel,i .snmpv3_authpassphras
e,i.snmpv3_privpassphrase,i.formula,h.available,i. status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i .delay_flex,h.dns fro
m hosts h, items i where h.hostid=i.hostid and i.key_='zabbix[log]' and i.value_type=1 and h.hostid>=100000000000000*0 an
d h.hostid<=(100000000000000*0+99999999999999)
19068:20080503:095543 Query failed:Result is NULL
19027:20080503:095543 One child process died. Exiting ...


Does anyone have any idea what this might be? We're still in the evaluation stage of ZABBIX, and while the software is great, the crashes are a bit worrysome.

[toteleiche]

Some problem here.

Crashes in various intervals, log shows no information about the reason.
MySQL error log is also empty.

Thanks form the help

[l4ncel0t]

hello,
I have the same problem on postgresql

the log from postgresql
postgres[9453]: [58-1] user=zabbix,db=zabbix ERROR: numeric field overflow
postgres[9453]: [58-2] user=zabbix,db=zabbix DETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12.
postgres[9453]: [58-3] user=zabbix,db=zabbix STATEMENT: update trends set num=90, value_min=9386.550000, value_avg=2847314417608342.500000,
postgres[9453]: [58-4] value_max=256258297582640512.000000 where itemid=19052 and clock=1209398400
postgres[9453]: [59-1] user=zabbix,db=zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
postgres[9453]: [59-2] user=zabbix,db=zabbix STATEMENT: update items set
postgres[9453]: [59-3] nextcheck=1209400212,prevvalue=lastvalue,prevorgva lue='5125166200424251392.000000',lastvalue='256258 297582640512.000000',lastcl
postgres[9453]: [59-4] ock=1209400192 where itemid=19052
postgres[9453]: [60-1] user=zabbix,db=zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
postgres[9453]: [60-2] user=zabbix,db=zabbix STATEMENT: select distinct function,parameter,itemid,lastvalue from functions where itemid=19052

I tried to extend the numeric field but it don't change anything

[l4ncel0t]

hum not the same problem but it crash zabbix server too

[Robert Wagnon]

Mine doesn't crash, but it stops collecting some data. Anywhere from 4 hours to 48 hours.

See my recent post regarding "CPU" for more information.