Thread hangs in VisibleBufferedInputStream.readMore
От | Oliver Hitz |
---|---|
Тема | Thread hangs in VisibleBufferedInputStream.readMore |
Дата | |
Msg-id | 20090428061649.GA5531@net-track.ch обсуждение исходный текст |
Ответы |
Re: Thread hangs in VisibleBufferedInputStream.readMore
|
Список | pgsql-jdbc |
Hi all, I have recently upgraded from postgresql 7.4.7 to 8.3.7. Since then, I have experienced in our application a thread that hangs forever. The problem is quite difficult to trace, since the program hangs very irregularly. Sometimes it hangs after 10 minutes already, sometimes only after two days. After searching the archives, I thought this was maybe connected to batch inserts and batch updates. Since the thread in question is doing a lot of batch updates and inserts, I changed it to do normal updates/inserts. But without success. I have also upgraded to the latest version of the JDBC driver, compiled from CVS, because I saw there was some improvement regarding DescribeStatement messages. No success, either. The call stack of the hanging thread is as follows: "MonitoringThread" prio=1 tid=0x00007f40187ac350 nid=0x41e7 runnable [0x0000000045157000..0x0000000045157e20] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:135) at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:104) at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73) at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:259) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1205) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194) - locked <0x00007f4047a7ab08> (a org.postgresql.core.v3.QueryExecutorImpl) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) Any hints on how I could go about debugging this issue? BTW, I am using Java 1.5.0_18-b02 from Sun on Debian Lenny on an AMD64 platform. Thanks in advance! Oliver
Вложения
В списке pgsql-jdbc по дате отправления: