Re: Cancelling idle in transaction state - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Cancelling idle in transaction state
Date
Msg-id 1262363405.19367.15803.camel@ebony
Whole thread Raw
In response to Re: Cancelling idle in transaction state  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Cancelling idle in transaction state
List pgsql-hackers
On Fri, 2010-01-01 at 07:08 -0800, Robert Haas wrote:
> On Jan 1, 2010, at 6:48 AM, Simon Riggs <simon@2ndQuadrant.com> w
> > We could either endlessly repeat this
> >
> > ERROR:  current transaction is aborted because of conflict with
> > recovery, commands ignored until end of transaction block
> 
> +1 for this option.
> 
> > I'm also not sure why we would want to single out Hot Standby to
> > generate the reason "because of conflict with recovery" when no other
> > ERROR source would generate such a reason.
> 
> Well, most times when the transaction is aborted, it's because you did  
> something wrong.  Or at least, the failure is associated with some  
> particular statement.
> 
> If we have other events that can asynchronously roll back a  
> transaction, I would think they would deserve similar handling.  Off  
> the top of my head, I'm not sure if there are any such cases.

Serialization failures, deadlocks, timeouts, SIGINT, out of memory
errors etc..

-- Simon Riggs           www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Cancelling idle in transaction state
Next
From: Tom Lane
Date:
Subject: Re: about some parameters