Re: Recovery conflict message lost in user session for 9.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Recovery conflict message lost in user session for 9.3
Date: 2015-11-26 16:14:28
Message-ID: 27964.1448554468@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mark Kirkwood 2015-11-26 21:33:39 Re: Recovery conflict message lost in user session for 9.3
Previous Message ntpt 2015-11-26 12:15:58 BUG #13785: Postgresql encoding screw-up