Ad Widget

Collapse

now and then postgres error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Colttt
    Senior Member
    Zabbix Certified Specialist
    • Mar 2009
    • 878

    #1

    now and then postgres error

    Hello,

    after restart my postgres-server (because of update) i got the following error message now and then..

    Code:
    grep -A2  PGRES_FATAL_ERROR:FATAL /var/log/zabbix/zabbix_server.log
      2561:20160212:105703.954 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [select h.hostid,h.host,h.name,t.httptestid,t.name,t.variables,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries from httptest t,hosts h where t.hostid=h.hostid and t.nextcheck<=1455271023 and mod(t.httptestid,4)=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
    --
      2535:20160212:105704.544 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [select hostid,status from hosts where host='etherpad' and status in (0,1) and flags<>2 and proxy_hostid is null]
      2524:20160212:105704.584 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [begin;]
    --
      2616:20160212:105704.624 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [select escalationid,actionid,triggerid,eventid,r_eventid,nextcheck,esc_step,status,itemid from escalations order by actionid,triggerid,itemid,escalationid]
    --
      2563:20160212:105704.944 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [select h.hostid,h.host,h.name,t.httptestid,t.name,t.variables,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries from httptest t,hosts h where t.hostid=h.hostid and t.nextcheck<=1455271024 and mod(t.httptestid,4)=2 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
    --
    [...]
      2502:20160212:105743.439 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [select hostid,key_,state,filter,error,lifetime from items where itemid=32813]
      2505:20160212:105748.951 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [select hostid,key_,state,filter,error,lifetime from items where itemid=32268]
      2492:20160212:105755.873 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [select refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends from config]
      2526:20160212:105757.512 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [begin;]
    [...]
      2618:20160212:114950.040 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [begin;]
    --
      2533:20160212:115140.970 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [begin;]
    --
      2617:20160212:115946.030 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [begin;]
    --
      2620:20160212:120152.033 [Z3005] query failed: [0] PGRES_FATAL_ERROR:FATAL:  terminating connection due to administrator command
    SSL connection has been closed unexpectedly
     [begin;]
    any ideas why this happen?
    Debian-User

    Sorry for my bad english
Working...