zenoss/ZenPacks.zenoss.PostgreSQL — Issue #2: Unterminated string error
Author: shaftoe
Created: 2011-11-11 11:15:04+00:00
State: open

Hi folks, we've got Zenoss Core 3.2.0 and Postgres zenpack working OK, but we frequently get this kind of event alerts:

Device: db-master
Component:
Severity: Error
Time: 2011/11/10 23:10:13.000
Message:
postgres failure: Unterminated string starting at: line 1 column 8177 (char 8177)

Clear message comes always 5 minutes later:

Event: 'postgres failure: Unterminated string starting at: line 1 column 8177 (char 8177)'
Cleared by: 'postgres connectivity restored'

After Zenpack install, we've started to get many of those messages into postgres log file:
LOG: unexpected EOF on client connection

Googling around seems to be a client problem:

http://postgresql.1045698.n5.nabble.com/LOG-unexpected-EOF-on-client-connection-td3204658.html

One suggestion is to tweak tcp_keepalive settings for the client.