From: | "Paulo Scardine" <paulos(at)cimed(dot)ind(dot)br> |
---|---|
To: | "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Killing the backend to cancel a long waiting query |
Date: | 2003-09-22 19:02:57 |
Message-ID: | 05d601c3813c$2296e0c0$6101a8c0@Paulo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-interfaces pgsql-odbc |
I do not know how to do that. I learned that I can send a SIGINT to a
backend to cancel a query, but I dont know how to kill just one transaction.
I have only "pg_getpid" and "pg_killpid" as interfaces to system functions
"getpid" and "kill".
BTW, what information can I get about the current running backends on the
internal structures? Or do I have to ask the OS?
Thank you,
--
Paulo Scardine
----- Original Message -----
From: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>
Subject: Re: [HACKERS] Killing the backend to cancel a long waiting query
>
> Yes, but you may need a way to ensure that the query canceled is the
> same one that you really want to cancel. (imagine come connection
> pooling and bad luck mixed together so that the long running query
> actually ends but another query fires up between the time you lookup the
> long running query and the time you issue the kill...). maybe
> transaction id as well as pid for arguments?
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rémi Zara | 2003-09-22 20:14:18 | Postgresql 7.3.4 compile failes on NetBSD 1.6 mac68k |
Previous Message | Hannu Krosing | 2003-09-22 19:00:43 | Re: PostgreSQL not ACID compliant? |
From | Date | Subject | |
---|---|---|---|
Next Message | Roman Bogorodskiy | 2003-09-23 16:17:50 | troubles with getting data from tables |
Previous Message | Robert Treat | 2003-09-22 18:29:31 | Re: Killing the backend to cancel a long waiting query |
From | Date | Subject | |
---|---|---|---|
Next Message | Nishad Prakash | 2003-09-24 23:06:21 | Trouble compiling for Solaris 8 |
Previous Message | Robert Treat | 2003-09-22 18:29:31 | Re: Killing the backend to cancel a long waiting query |