On Sun, Dec 27, 2009 at 10:42 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> Thanks for the report. I'll see about a fix.
In the end we are about to use SIGINT for two use cases:
- cancel an idle transaction
- cancel a running query
Previously a backend that was DoingCommandRead == true didn't do
anything upon reception of SIGINT, now it aborts either the running
query or the idle transaction, which is why Kris's example behaves
If we use the same signal for both cases, the receiving backend cannot
tell what the intention of the sending backend was. That's why I
proposed to make SIGINT similar to SIGUSR1 where we write a reason to
a shared memory structure first and then send the signal (see
a few days ago).
There was also some dicussion about how to communicate the
cancellation back to the client when its idle transaction got aborted.
I implemented what I thought was the conclusion of the discussion but
haven't received a reply on it yet.
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2009-12-29 13:33:17|
|Subject: Re: Add subdirectory support for DATA/DOCS with PGXS|
|Previous:||From: Guillaume Lelarge||Date: 2009-12-29 13:12:52|
|Subject: Re: Application name patch - v3|