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
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 |