| From: | Felipe Schnack <felipes(at)ritterdosreis(dot)br> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | deadlocks |
| Date: | 2003-06-17 21:10:06 |
| Message-ID: | 20030617181006.5fbceed1.felipes@ritterdosreis.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all!
I'm having a very strange deadlock problem in PostgreSQL 7.3.2 under RedHat Linux. All connections to this database come from Tomcat's 4.1.24 connection pooling mechanism, and for some reason frequently I have lots of INSERTs in "waiting" state. But what they're writing for?? To me seems one insert is waiting for the other one... anyone have tips on how can I find what's my problem? Here is a listing I got on my server using "ps -ax |grep post"
30132 ? S 0:01 postgres: postgres w2 192.168.5.54 INSERT waiting
30133 ? S 0:01 postgres: postgres w2 192.168.5.54 idle in transactio
30145 ? S 0:00 postgres: postgres w2 192.168.5.54 idle in transactio
30168 ? S 0:00 postgres: postgres w2 192.168.5.54 INSERT waiting
30180 ? S 0:00 postgres: postgres w2 192.168.5.54 INSERT waiting
30183 ? S 0:01 postgres: postgres w2 192.168.5.54 idle
30184 ? S 0:00 postgres: postgres w2 192.168.5.54 idle
30185 ? S 0:00 postgres: postgres w2 192.168.5.54 INSERT waiting
--
/~\ The ASCII Felipe Schnack (felipes(at)ritterdosreis(dot)br)
\ / Ribbon Campaign Analista de Sistemas
X Against HTML Cel.: 51-91287530
/ \ Email! Linux Counter #281893
Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter(at)ritterdosreis(dot)br
Fone: 51-32303341
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew J. Kopciuch | 2003-06-17 21:11:05 | Re: tsearch - v2 new dict |
| Previous Message | Mike Aubury | 2003-06-17 21:05:06 | Re: ss_family in hba.c |