| From: | Chris Gamache <cgg007(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Runaway SELECT |
| Date: | 2002-08-13 15:14:40 |
| Message-ID: | 20020813151440.37503.qmail@web13807.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
<embarassed>Fixed the subject line...</embarassed>
root(at)database:~# ps -auxww | grep SELECT
postgres 10906 99.9 0.4 7596 4008 ? R Jul31 18445:54 postgres:
postg
res database 192.168.2.1 SELECT
Any clues on how to stop this runaway select without having to force the
whole
database down? This was started from an ODBC connection. Obviously the
connection timed out... :)
Can I kill -TERM 10906 ?
Can I kill -KILL 10906 ?
CG
__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert M. Meyer | 2002-08-13 15:25:47 | Re: Leftover processes on shutdown - Debian+JDBC |
| Previous Message | Nick Fankhauser | 2002-08-13 15:09:06 | Leftover processes on shutdown - Debian+JDBC |