Re: [GENERAL] JDBC connections very occasionally hang

2011-10-27 Thread Tom Lane
Karl Wright writes: > ... By the end of that time I usually see between one and three "stuck" > threads, all waiting inside the JDBC driver for a response from the > postgresql server. I can provide a stack trace if requested. How about a stack trace from the connected backend? And what is its

[GENERAL] JDBC connections very occasionally hang

2011-10-27 Thread Karl Wright
Hi folks, I'm seeing something that on the face of it sounds very similar to the issue reported at http://archives.postgresql.org/pgsql-general/2011-10/msg00570.php. I am using Postgresql 8.4, and the problem occurs with both the 8.4 JDBC type-3 driver and the 9.1 JDBC type-3 driver. The test I