From: | Grant Quimby <grant_quimby(at)dialog(dot)com(dot)au> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Weird pause when running statements |
Date: | 2008-08-06 03:05:41 |
Message-ID: | 1816F2D2ACB8AB469D3FFA6819ADC23B154A8F720F@bnemxbox01.dialoggroup.internal |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Thanks for the help. Appreciate it.
All the best.
Grant Q
________________________________________
From: Oliver Jowett [oliver(at)opencloud(dot)com]
Sent: Wednesday, 6 August 2008 13:01
To: Grant Quimby
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Weird pause when running statements
Grant Quimby wrote:
> From: Oliver Jowett
> <snip>
>> First step would be to work out which half is getting stuck. Try a
>> thread dump on the Java side and a strace on the backend side.
>
> I've checked the Java side with a thread dump. As far as I can tell everything working okay. I've attached it.
>
> As for strace ... It's not connecting to the process for some reason. I'll try and find the server process condition another way. (Any suggestions? ;-)
>
>> What do you mean by "reloading the server configuration"?
>
> pg_ctl reload (via either the command line or the pgAdmin point and click).
Ok - so on the Java side everything does appear normal, it's just
waiting for a query result.
pg_ctl reload just sends a SIGHUP to the postmaster I believe, so if
that manages to wake things up it does sound like something getting
stuck on the server side rather than a driver issue.
I don't think there's much more the -jdbc list can do for you here if
it's a server-side problem, you might want to ask on -bugs? (They're
likely to want server version & platform info at a minimum)
-O
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-08-06 04:32:52 | Re: Weird pause when running statements |
Previous Message | Oliver Jowett | 2008-08-06 03:01:44 | Re: Weird pause when running statements |