lost synchronization with server: got message type "Z"

From: "Marek Petr" <maper(at)seznam(dot)cz>
To: <pgsql-general(at)postgresql(dot)org>
Subject: lost synchronization with server: got message type "Z"
Date: 2016-09-27 05:27:28
Message-ID: LSg.6QYq.3hOm7bU8VRh.1NwWD0@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2016-09-27 05:44:40 Re: Frequent "pg_ctl status" removing(?) semaphores (unlikely)
Previous Message hariprasath nallasamy 2016-09-27 05:23:21 Re: Incrementally refreshed materialized view