Re: Error I don't understand, losing synch with server - Mailing list pgsql-general

From Tom Lane
Subject Re: Error I don't understand, losing synch with server
Date
Msg-id 20047.1142542045@sss.pgh.pa.us
Whole thread Raw
In response to Error I don't understand, losing synch with server  (Scott Ribe <scott_ribe@killerbytes.com>)
Responses Re: Error I don't understand, losing synch with server  (Scott Ribe <scott_ribe@killerbytes.com>)
Re: Error I don't understand, losing synch with server  (Scott Ribe <scott_ribe@killerbytes.com>)
List pgsql-general
Scott Ribe <scott_ribe@killerbytes.com> writes:
> Every once in a while I log this error executing a query:
> message contents do not agree with length in message type "D"
> lost synchronization with server: got message type "O", length 1398030676

This means either that libpq got a corrupt message from the server, or
that libpq itself contains a bug in message parsing.  Given that no one
else has reported similar problems, the idea that your app is somehow
clobbering the libpq message buffer (and thus corrupting the message "in
transit") has to be taken seriously.

You mention pooling so I suppose this is a multi-threaded application
... are you being careful not to let any two threads try to use the same
libpq PGconn at the same time?  libpq itself does not contain any
locking that would make that safe, you need to provide the locking
yourself.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How do I make a timestamp column default to current time
Next
From: CSN
Date:
Subject: Disabling persistent connections?