From: | Péter Kovács <maxottovonstirlitz(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Finding out on exactly what I am stuck |
Date: | 2009-04-09 21:48:09 |
Message-ID: | fdeb32eb0904091448i5c7f3e15sbfcf92f26336137d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I've got a JDBC client which got hung in reading response to a DML statement:
[junit] "Thread-11201" prio=1 tid=0x0000002ac9df56e0 nid=0x3995
runnable [0x0000000041a70000..0x0000000041a70db0]
[junit] at java.net.SocketInputStream.socketRead0(Native Method)
[junit] at java.net.SocketInputStream.read(SocketInputStream.java:129)
[junit] at
org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:135)
[junit] at
org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:104)
[junit] at
org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
[junit] at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:259)
[junit] at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1166)
[junit] at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
[junit] - locked <0x0000002ab85b1918> (a
org.postgresql.core.v3.QueryExecutorImpl)
[junit] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
[junit] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
[junit] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
I can also identify a couple of back-end processes presumably related
to the client:
postgres 14727 9868 0 22:34 ? 00:00:00 postgres: pkovacs
chemaxon 127.0.0.1(12496) idle in transaction
postgres 14735 9868 0 22:34 ? 00:00:00 postgres: pkovacs
chemaxon 127.0.0.1(12497) idle in transaction
postgres 14737 9868 0 22:34 ? 00:00:00 postgres: pkovacs
chemaxon 127.0.0.1(12498) UPDATE waiting
postgres 14738 9868 0 22:34 ? 00:00:00 postgres: pkovacs
chemaxon 127.0.0.1(12499) idle
postgres 14739 9868 0 22:34 ? 00:00:00 postgres: pkovacs
chemaxon 127.0.0.1(12500) idle
postgres 14740 9868 0 22:34 ? 00:00:00 postgres: pkovacs
chemaxon 127.0.0.1(12501) idle
Please, could you suggest me a couple of things which I can/should
check and how I can do it? (Locks/contention would be an obvious
candidate, but I am fairly sure that the database has only one client:
mine.)
Thanks
Peter
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2009-04-09 21:59:28 | Re: Finding out on exactly what I am stuck |
Previous Message | Tom Lane | 2009-04-09 16:05:21 | Re: pg_toast |