deadlocks
От | Felipe Schnack |
---|---|
Тема | deadlocks |
Дата | |
Msg-id | 20030617181006.5fbceed1.felipes@ritterdosreis.br обсуждение исходный текст |
Ответы |
Re: deadlocks
|
Список | 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 comefrom 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 onhow 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@ritterdosreis.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@ritterdosreis.br Fone: 51-32303341
В списке pgsql-general по дате отправления: