Ad Widget

Collapse

PostgreSQL monitoring

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • flycat
    Member
    • May 2007
    • 30

    #1

    PostgreSQL monitoring

    Hi!
    I test Zabbix 1.4 with Postgres.
    When I shutdown DB, Zabbix server died w/o any notification.
    Is it bug or feature?
    14416:20070605:114639 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<=1181029599 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1181029599
    and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,6)=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
    14416:20070605:114639 Query failed:Result is NULL
    14410:20070605:114639 One child process died. Exiting ...
    14410:20070605:114641 ZABBIX Server stopped
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    Currently database watchdog works for MySQL only. It also will be implemented for PostgreSQL in 1.4.x.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    Working...