On 6-Sep-06, at 3:27 AM, Magnus Hagander wrote:

Yes they are using a connection pool. A java based one.
Since java has it's own protocol implementation, this is
unrelated to any libpq error messages.
Another important point that we've not been given information
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
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
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.

Definitly - that error msg showing up in the web app really doesn't make
sense. However, are we sure that the error message is *exactly* the
same, word for word, or is it possible that it's just "the same in what
it says" but with different words? I assume there are screendumps to
verify this ;-)

I looked at the code in the jdbc driver and it doesn't even do this check

Another point that at least I don't know - what kind of connection pool
is it? Is it an external one (like pgpool) to which the java app
connects (using FE/BE protocol, emulating a "proper postmaster" but
pooling access to the database), or is it running inside the app server (like for example .net connection pooling does, which simply means that
when you run the Open() method on the connection object it will pick
something off an *internal* pool)?
It's an internal pool, and the client has told me off list they have removed it and are using the jdbc driver pool.

At this point I'm confused as to what they really are using, but as they have contracted Command Prompt to fix this for them, I am no longer in the private loop.



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to