Re: JDBC connections very occasionally hang

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karl Wright <daddywri(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: JDBC connections very occasionally hang
Date: 2011-10-28 04:44:40
Message-ID: 13866.1319777080@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Karl Wright <daddywri(at)gmail(dot)com> 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
state as shown by the pg_stat_activity and pg_locks views? It's hard
to tell from what you say here whether the problem is on the server or
client side, which is surely the first thing to isolate.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Satoshi Nagayasu 2011-10-28 04:51:58 Re: pglesslog for Postgres 9.1.1
Previous Message Ben Chobot 2011-10-28 04:22:10 Re: User feedback requested on temp tables usage for Hot Standby