On Wed, 2008-11-26 at 18:02 +0530, Pavan Deolasee wrote:
> I think whats happening is that
> ResolveRecoveryConflictWithVirtualXIDs() is failing to abort
> the open transaction
>
>
> Btw, ISTM that SIGINT works only for statement cancellation. So if the
> transaction is in idle state, SIGINT has nothing to cancel and hence
> also fails to abort the transaction.
[If I read this correctly this second post is the cause of the first
problem, so we have one problem, rather than two.]
Understood; yes that seems to be a problem.
I will propose a solution later today. (I've been tied up with a few
things over last few days, but I'm free of that now).
-- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support