Ad Widget

Collapse

zabbix-server doesn't reopen lost connection in postgresql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • EvilShadow
    Junior Member
    • Mar 2007
    • 13

    #1

    zabbix-server doesn't reopen lost connection in postgresql

    When postgresql server is restarted, zabbix-server doesn't reconnect to database, but just logs such messages:
    Code:
     31401:20091028:012009 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    server closed the connection unexpectedly
            This probably means the server terminated abnormally
            before or while processing the request.
     [select httptestid,name,applicationid,nextcheck,status,delay,macros,agent from httptest where status=0 and nextcheck<=1256685609 and mod(httptestid,1)=0 and
     httptestid between 000000000000000 and 099999999999999]
     31401:20091028:012009 [Z3005] Query failed: [0] Result is NULL [select count(*),min(nextcheck) from httptest t where t.status=0 and mod(t.httptestid,1)=0 an
    d t.httptestid between 000000000000000 and 099999999999999]
     31401:20091028:012009 [Z3005] Query failed: [0] PGRES_FATAL_ERROR: [select count(*),min(nextcheck) from httptest t where t.status=0 and mod(t.httptestid,1)=
    0 and t.httptestid between 000000000000000 and 099999999999999]
    lots of them.
    zabbix-server version 1.6.6 from lenny-backports
    Last edited by EvilShadow; 28-10-2009, 01:29.
  • richlv
    Senior Member
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Oct 2005
    • 3112

    #2
    you might want to comment/vote on https://support.zabbix.com/browse/ZBX-18
    Zabbix 3.0 Network Monitoring book

    Comment

    Working...