zabbix 1.4.4 crash

[Dmitriy Kirhlarov]

58603:20080214:170640 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i where h.hostid=i.hostid and i.key_='zabbix[log]' and i.value_type=1 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)
58603:20080214:170640 Query failed:Result is NULL
58584:20080214:170640 One child process died. Exiting ...

# uname -rsm ; pkg_info -Ix zabbix ; pkg_info -Ix postgres
FreeBSD 7.0-20071107-SNAP amd64
zabbix-1.4.4,1 Application and network monitoring solution
zabbix-agent-1.4.4,1 Application and network monitoring solution
postgresql-client-8.2.6_1 PostgreSQL database (client)
postgresql-server-8.2.6 The most advanced open-source database available anywhere

[Dmitriy Kirhlarov]

71220:20080215:102233 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_ty
pe,h.errors_from,i.snmp_port,i.delta,i.prevorgvalu e,i.lastclock,i.units,i.multiplier,i.snmpv3_securi tyname,i.snmpv3_securitylevel,i.snmpv3_authpassphr ase,i.snmpv3_privpassphrase,i.formula,h.available, i.status,i.
trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_fl ex,h.dns from hosts h, items i where i.nextcheck<=1203070953 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1203070953 and h
.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,9)=0 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) o
rder by i.nextcheck
71220:20080215:102233 Query failed:PGRES_FATAL_ERROR:PANIC: stuck spinlock (0x80190ca80) detected at lwlock.c:379
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.



I know, zabbix_server can reconnect to mysql database. Alexey, is it possible -- extend this functionality to postgresql?

[Dmitriy Kirhlarov]

new crashe

46208:20080216:235011 Query::insert into history (clock,itemid,value) values (1203205811,25536,1203205254000.000000)
46208:20080216:235011 Query failed:PGRES_FATAL_ERROR:ERROR: numeric field overflow
DETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12.

[Dmitriy Kirhlarov]

new crash

46208:20080216:235011 Query::insert into history (clock,itemid,value) values (1203205811,25536,1203205254000.000000)
46208:20080216:235011 Query failed:PGRES_FATAL_ERROR:ERROR: numeric field overflow
DETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12.