Ever since I migrated to a seperate PostgreSQL server, I've had various issues with dying NAV processes/daemons. The most common one is this error, appearing in servicemon.log after enabling DEBUG in the nav.conf file:
FROM serviceproperty order BY serviceid [2008-10-08 12:38:58] servicemon.py:__init__:61 [Notice] Setting checkinterval=60 [2008-10-08 12:38:58] servicemon.py:__init__:63 [Notice] Reading database config [2008-10-08 12:38:58] servicemon.py:__init__:64 [Notice] Setting up runqueue [2008-10-08 12:38:58] RunQueue.py:__init__:98 [Notice] Setting maxthreads=20 [2008-10-08 12:38:58] RunQueue.py:__init__:100 [Notice] Setting maxRunCount=50 [2008-10-08 12:38:58] db.py:cursor:85 [Critical] Could not get cursor. Trying to reconnect... [2008-10-08 12:38:58] db.py:connect:72 [Notice] Successfully (re)connected to NAVdb [2008-10-08 12:38:58] db.py:query:108 [Debug] Executing: SELECT serviceid, property, value FROM serviceproperty order BY serviced
I even had the servicemon developer over at my office, and he couldn't really tell why I was getting this error as he was able to grab the cursor when issuing it from a python shell. I've made some postgres.conf tweaks to allow harder work, as I have a quite big NAV database. Here are the changes I've made:
work_mem = 98088 maintenance_work_mem = 131072 shared_buffers = 20000 vacuum_cost_delay = 50 checkpoint_segments = 20 checkpoint_timeout = 900 stats_start_collector = on stats_row_level = on max_fsm_pages = 500000 max_fsm_relations = 2000 wal_buffers = 512 max_locks_per_transaction = 512
Even though I've made these changes, I still seem to get:
LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection
.. in my postgresql server logs... The PostgreSQL server itself is a Quad core CPU box with 8GB of ram, and should not be overloaded in any way. Load is ~0.10 at all times.
Any ideas why my PostgreSQL server keeps rejecting cursors and giving me these EOF errors?
Any help appreicated
------------------------------------------------------ Vidar Stokkenes Konsulent Nettverk Seksjon for nettverk og telekom HN IKT - Tromsø
Tlf: 76 16 61 87 / 77 66 99 55 Mobil: 95 87 99 42 e-post: firstname.lastname@example.org:email@example.com [cid:image001.png@01C92945.5BD3A8D0]