Hello,
Whenever i run zabbix_server i get the following below in my log files. If anyone can help me out I would appreciate it. I am running Zabbix v1.4.4
and PostgreSQL 8.3.0.
Debug 4:
26631:20080225:104940 In delete_history(trends,10299,1568867028417,0)
26631:20080225:104940 Query [select min(clock) from trends where itemid=10299]
26631:20080225:104940 In delete_history(history,10300,31268736449,0)
26631:20080225:104940 Query [select min(clock) from history where itemid=10300]
26604:20080225:104940 In get_values()
26604:20080225:104940 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 i.nextcheck<=1203965380 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1203965380 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,5)=0 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) order by i.nextcheck]
26604:20080225:104940 End get_values()
26604:20080225:104940 Spent 0 seconds while updating values
26604:20080225:104940 Query [select count(*),min(nextcheck) from items i,hosts h where h.status=0 and h.disable_until<1203965380 and h.errors_from=0 and h.hostid=i.hostid and i.status in (0,3) and i.type not in (2,7,9) and mod(i.itemid,5)=0 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
26604:20080225:104940 No items to update for minnextcheck.
26604:20080225:104940 Nextcheck:-1 Time:1203965380
26604:20080225:104940 Sleeping for 5 seconds
26601:20080225:104940 One child process died. Exiting ...
26604:20080225:104940 Got signal. Exiting ...
26606:20080225:104940 Got signal. Exiting ...
26608:20080225:104940 Got signal. Exiting ...
26610:20080225:104940 Got signal. Exiting ...
26612:20080225:104940 Got signal. Exiting ...
26614:20080225:104940 Got signal. Exiting ...
26616:20080225:104940 Got signal. Exiting ...
26618:20080225:104940 Got signal. Exiting ...
26620:20080225:104940 Got signal. Exiting ...
26622:20080225:104940 Got signal. Exiting ...
26624:20080225:104940 Got signal. Exiting ...
26629:20080225:104940 Got signal. Exiting ...
26633:20080225:104940 Got signal. Exiting ...
26635:20080225:104940 Got signal. Exiting ...
26637:20080225:104940 Got signal. Exiting ...
26639:20080225:104940 Got signal. Exiting ...
26641:20080225:104940 Got signal. Exiting ...
26643:20080225:104940 Got signal. Exiting ...
26645:20080225:104940 Got signal. Exiting ...
26647:20080225:104940 Got signal. Exiting ...
26631:20080225:104940 Got signal. Exiting ...
26601:20080225:104942 ZABBIX Server stopped
Whenever i run zabbix_server i get the following below in my log files. If anyone can help me out I would appreciate it. I am running Zabbix v1.4.4
and PostgreSQL 8.3.0.
Debug 4:
26631:20080225:104940 In delete_history(trends,10299,1568867028417,0)
26631:20080225:104940 Query [select min(clock) from trends where itemid=10299]
26631:20080225:104940 In delete_history(history,10300,31268736449,0)
26631:20080225:104940 Query [select min(clock) from history where itemid=10300]
26604:20080225:104940 In get_values()
26604:20080225:104940 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 i.nextcheck<=1203965380 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1203965380 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,5)=0 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) order by i.nextcheck]
26604:20080225:104940 End get_values()
26604:20080225:104940 Spent 0 seconds while updating values
26604:20080225:104940 Query [select count(*),min(nextcheck) from items i,hosts h where h.status=0 and h.disable_until<1203965380 and h.errors_from=0 and h.hostid=i.hostid and i.status in (0,3) and i.type not in (2,7,9) and mod(i.itemid,5)=0 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
26604:20080225:104940 No items to update for minnextcheck.
26604:20080225:104940 Nextcheck:-1 Time:1203965380
26604:20080225:104940 Sleeping for 5 seconds
26601:20080225:104940 One child process died. Exiting ...
26604:20080225:104940 Got signal. Exiting ...
26606:20080225:104940 Got signal. Exiting ...
26608:20080225:104940 Got signal. Exiting ...
26610:20080225:104940 Got signal. Exiting ...
26612:20080225:104940 Got signal. Exiting ...
26614:20080225:104940 Got signal. Exiting ...
26616:20080225:104940 Got signal. Exiting ...
26618:20080225:104940 Got signal. Exiting ...
26620:20080225:104940 Got signal. Exiting ...
26622:20080225:104940 Got signal. Exiting ...
26624:20080225:104940 Got signal. Exiting ...
26629:20080225:104940 Got signal. Exiting ...
26633:20080225:104940 Got signal. Exiting ...
26635:20080225:104940 Got signal. Exiting ...
26637:20080225:104940 Got signal. Exiting ...
26639:20080225:104940 Got signal. Exiting ...
26641:20080225:104940 Got signal. Exiting ...
26643:20080225:104940 Got signal. Exiting ...
26645:20080225:104940 Got signal. Exiting ...
26647:20080225:104940 Got signal. Exiting ...
26631:20080225:104940 Got signal. Exiting ...
26601:20080225:104942 ZABBIX Server stopped

Comment