zabbix_server 1.4.4 die: Query failed:Result is NULL

[Dmitriy Kirhlarov]

78943:20080206:145128 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)
78943:20080206:145128 Query failed:Result is NULL
78925:20080206:145128 One child process died. Exiting ...
78925:20080206:145130 ZABBIX Server stopped

[Alexei]

What's your database engine? Oracle?

[Dmitriy Kirhlarov]

# uname -rs; pkg_info -Ix zabbix; pkg_info -Ix postgres
FreeBSD 7.0-20071107-SNAP
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.5_1 PostgreSQL database (client)
postgresql-server-8.2.5_2 The most advanced open-source database available anywhere


Now I get new crash:

80862:20080206:160035 Get value from agent failed. Error: Cannot connect to [10.25.0.69:10050] [Interrupted system call]
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
80862:20080206:160035 Query::select dhostid,druleid,ip,status,lastup,lastdown from dhosts where ip='10.25.0.69' and dhostid>=100000000000000*0 and dhostid<=(100000000000000*0+99999999999999)
80862:20080206:160035 Query failed:PGRES_FATAL_ERROR:server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.