| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Danny Abraham" <danny_abraham(at)bmc(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: WHo is locking me? |
| Date: | 2010-03-18 21:02:33 |
| Message-ID: | 4BA24E99020000250002FF13@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Abraham, Danny" <danny_abraham(at)bmc(dot)com> wrote:
> procpid | current_query
>
---------+---------------------------------------------------------------------
> 25936 | <IDLE> in transaction <== This is the locker
> - What exactly is the locker doing?
At the time you ran that, it wasn't doing anything in the database,
but it had not committed or rolled back the transaction it had
previously started.
> - Can I retrieve the Client PID somewhere (then by process name I
> will dive into the code).
If you're on Linux and this is a TCP connection, netstat should make
that easy. Are you?
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vitaly Burshteyn | 2010-03-19 01:23:32 | error |
| Previous Message | Tom Lane | 2010-03-18 19:48:49 | Re: Missing tsearch2 functions |