Ad Widget

Collapse

unexpected EOF on client connection: Zabbix 1.8, postgres 8.3

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dugrands
    Junior Member
    • Dec 2008
    • 13

    #1

    unexpected EOF on client connection: Zabbix 1.8, postgres 8.3

    Hi,
    I just updated my zabbix server from 1.6 to 1.8 and I am now getting the error "unexpected EOF on client connection" in the postgres log file whilst no information is saved in the database. I tried to update to the nigtly build zabbix-1.8.x-9529 and the error is still persistant.
    Increasing zabbix log verbosity is not helping since no information regarding the connections is logged.

    This is a section of my postgres log:
    2010-01-25 14:10:40 CETLOCATION: SocketBackend, postgres.c:323
    2010-01-25 14:10:40 CETLOG: 08P01: unexpected EOF on client connection
    2010-01-25 14:10:40 CETLOCATION: SocketBackend, postgres.c:323
    2010-01-25 14:10:40 CETLOG: 08P01: unexpected EOF on client connection
    2010-01-25 14:10:40 CETLOCATION: SocketBackend, postgres.c:323
    2010-01-25 14:10:40 CETLOG: 08P01: unexpected EOF on client connection

    This is a section of my zabbix log:

    18562:20100125:141040.455 End calculate_item_nextcheck (result:1264425939)
    zabbix_server [18562]: Configuration buffer is too small. Please increase CacheSize parameter.
    18559:20100125:141040.457 One child process died (PID:18562). Exiting ...
    18685:20100125:141040.453 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
    18559:20100125:141042.458 Connect to the database
    18559:20100125:141042.461 Query [txnlev:0] [select oid from pg_type where typname = 'bytea']
    18559:20100125:141042.462 PostgreSQL Server version: 80309
    18559:20100125:141042.462 Query [txnlev:0] [set escape_string_warning to off]
    18559:20100125:141042.462 In free_database_cache()
    18559:20100125:141042.462 In DCsync_all()
    18559:20100125:141042.462 In DCsync_history(history_first:0 history_num:0)
    18559:20100125:141042.462 Syncing history data...
    18559:20100125:141042.462 In DCsync_trends() trends_num:0
    18559:20100125:141042.462 Syncing trends data...
    18559:20100125:141042.462 Syncing trends data...done.
    18559:20100125:141042.462 End of DCsync_trends()
    18559:20100125:141042.462 End of DCsync_all()
    18559:20100125:141042.463 End of free_database_cache()
    18559:20100125:141042.463 In free_configuration_cache()

    I would be grateful for any help, thanks.
  • dugrands
    Junior Member
    • Dec 2008
    • 13

    #2
    zabbix 1.8, postgres 8.3 performance issues

    I have resolved the issue adding CacheSize=64M to the server configuration and everything working fine now.

    However, the web interface is terribly slow and everytime I access the web interface cpu usage spikes like crazy. I have already updated the web frontend to the one in the nightly builds.

    Any ideas or possible solutions please?

    Comment

    Working...