| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Kevin Brown <blargity(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Transactions |
| Date: | 2006-03-18 06:49:12 |
| Message-ID: | 13784.1142664552@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Kevin Brown <blargity(at)gmail(dot)com> writes:
> When the "deadlock" occurs:
> kevin(at)ajbit:~> ps -elF | grep postgres
> 1 S postgres 6020 17767 0 75 0 - 10585 - 15136 0 19:57 ?
> 00:00:29 postgres: dli dli 127.0.0.1(39869) idle in transaction
> 1 S postgres 6195 17767 0 76 0 - 10323 semtim 14940 0 20:22 ?
> 00:00:28 postgres: dli dli 127.0.0.1(37735) INSERT waiting
> You can see an insert is just waiting. On what?
I'd bet it's waiting on the "idle in transaction" transaction, which is
waiting for a nonresponding client. But the pg_locks view would tell
you more.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michelle Konzack | 2006-03-18 13:13:43 | Re: Urgent !!! Please Help Me |
| Previous Message | Kevin Brown | 2006-03-18 06:45:44 | Re: Transactions |