ZABBIX Forums  
  #1  
Old 25-01-2010, 13:26
dugrands dugrands is offline
Junior Member
 
Join Date: Dec 2008
Posts: 10
Default 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.
Reply With Quote
  #2  
Old 25-01-2010, 15:27
dugrands dugrands is offline
Junior Member
 
Join Date: Dec 2008
Posts: 10
Default 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?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 17:00.