Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-18

PostgreSQL monitoring [Watchdog]

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.4.2
    • Fix Version/s: 1.4.2, 1.8.2, 1.9.0 (alpha)
    • Component/s: Server (S)
    • Labels:
      None

      Description

      Hi!
      I test Zabbix 1.4 with Postgres.
      When I shutdown DB, Zabbix server died w/o any notification.
      Is it bug or feature?
      Quote:
      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

      http://www.zabbix.com/forum/showthread.php?t=6297

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              alexei Alexei Vladishev
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: