[Z3005] query failed: [0]

[avecsi]

Hi All,

19724:20140305:074259.675 executing housekeeper
19713:20140305:104537.160

[Z3005] query failed: [0] result is NULL [select i.itemid,i.type,i.delay,i.delay_flex,i.lastclock,i.interfaceid,h.proxy_hostid from items i,hosts h where i.hostid=h.hostid and h.status=0 and i.status=0 and i.value_type not in (2) and (i.lastclock is not null and i.lastclock<1394015737) and (i.type in (7,13,14,3,5,11,8,10,15) or (h.available<>2 and i.type in (0)) or (h.snmp_available<>2 and i.type in (1,4,6)) or (h.ipmi_available<>2 and i.type in (12)) or (h.jmx_available<>2 and i.type in (16))) and i.flags not in (2) and i.itemid between 0 and 99999999999999]

19713:20140305:104537.160

[Z3005] query failed: [0] PGRES_FATAL_ERROR: [select i.itemid,i.type,i.delay,i.delay_flex,i.lastclock,i.interfaceid,h.proxy_hostid from items i,hosts h where i.hostid=h.hostid and h.status=0 and i.status=0 and i.value_type not in (2) and (i.lastclock is not null and i.lastclock<1394015737) and (i.type in (7,13,14,3,5,11,8,10,15) or (h.available<>2 and i.type in (0)) or (h.snmp_available<>2 and i.type in (1,4,6)) or (h.ipmi_available<>2 and i.type in (12)) or (h.jmx_available<>2 and i.type in (16))) and i.flags not in (2) and i.itemid between 0 and 99999999999999]

19724:20140305:111858.474 housekeeper deleted: 2841069 records from history and trends, 224500 records of deleted items, 594 events, 0 alerts, 0 sessions

19724:20140305:121859.057 executing housekeeper
19724:20140305:154304.581 housekeeper deleted:

9784:20140305:163732.405 executing housekeeper
9784:20140305:195157.239 housekeeper deleted:

9784:20140305:205157.790 executing housekeeper
9784:20140306:004300.641 housekeeper deleted:

9784:20140306:014301.190 executing housekeeper
9784:20140306:045811.905 housekeeper deleted:

Query failed times in the log:
19713:20140305:104537.160
9766:20140305:203537.124
9764:20140305:235536.315
9761:20140306:000536.721
9767:20140306:010537.177
9764:20140306:030536.776
9762:20140306:040536.919
9766:20140306:050537.351
9769:20140306:053537.118

My first thought was that the Housekeeper,but there are errors when the HK did not run.

How can I figure out what causing the query issue?

I am using zabbix-server 2.0.2 and postgresql 9.1

Thanks,
Andrew