On 5-Sep-06, at 7:00 PM, Joshua D. Drake wrote:
Tom Lane wrote:
Dave Cramer <[EMAIL PROTECTED]> writes:
On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote:
Yes they are using a connection pool. A java based one.
Since java has it's own protocol implementation, this is totally
unrelated to any libpq error messages.
Another important point that we've not been given information on:
when pgAdmin/libpq starts failing like this, exactly what is
happening
with the connection pool? Is it still able to issue queries, and
if not what happens exactly?
No, when this happens everything stops. The only thing they get
back is that message until they reboot the server. The web app (via
java/connection pool), pgAdmin both give the same error.
Which now that I think about it, seems odd if the message is coming
from libpq yes?
Yes, this is very odd, AFICS, this message does not exist in the java
driver. So.... it would be interesting to get the actual logs from
the client.
Sincerely,
Joshua D. Drake
regards, tom lane
---------------------------(end of
broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly