Hello,
From time to time we receive following event from application (Adobe Campaign - former Neolane):
PostgreSQL error: lost synchronization with server: got message type "Z", length 0\n (iRc=-2006)
Last time underlying sql statement was an update.
At the backend side there is:
LOG: unexpected EOF on client connection with an open transaction
From http://doxygen.postgresql.org/fe-protocol3_8c_source.html#l00450 I can read:
444 /*
445 * handleSyncLoss: clean up after loss of message-boundary sync
446 *
447 * There isn't really a lot we can do here except abandon the connection.
448 */
Could something else than network cause this event?
PostgreSQL version:
postgres=# select version();
version
----------------------------------------------------------------------------------------------------------------
PostgreSQL 9.2.13 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-11), 64-bit
(1 row)
Thank you
Marek