Re: Recovery conflict message lost in user session for 9.3 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Recovery conflict message lost in user session for 9.3
Date
Msg-id 27964.1448554468@sss.pgh.pa.us
Whole thread Raw
In response to Recovery conflict message lost in user session for 9.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Responses Re: Recovery conflict message lost in user session for 9.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-bugs
> bench=# fetch hcur;
> server closed the connection unexpectedly
>     This probably means the server terminated abnormally
>     before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.

> Now in the standby log I see:
> FATAL:  terminating connection due to conflict with recovery
> DETAIL:  User query might have needed to see row versions that must be
> removed.
> HINT:  In a moment you should be able to reconnect to the database and
> repeat your command.

> However this is not transmitted to the standby user's session, so
> leaving an unhelpful message about why the session got killed.

Please check to see if commit db6e8e162 fixes this.

            regards, tom lane

pgsql-bugs by date:

Previous
From: ntpt@seznam.cz
Date:
Subject: BUG #13785: Postgresql encoding screw-up
Next
From: Mark Kirkwood
Date:
Subject: Re: Recovery conflict message lost in user session for 9.3