Re: Win32 hard crash problem

Alvaro Herrera wrote:
> Joshua D. Drake wrote:
>> Alvaro Herrera wrote:
>>> Tom Lane wrote:
>>>> "Joshua D. Drake" <jd@commandprompt.com> writes:
>>>>>>> Fail in what way. Hang, not connect, or get an error msg?
>>>>> Just verified with customer. Once the problem occurs the first time, the 
>>>>> customer will continually get the same error message for each subsequent 
>>>>> connection attempt:
>>>>> server sent data ("D" message) without prior row description ("T" 
>>>>> message)
>>>> During the connection attempt?  I don't think libpq can report that
>>>> message until it tries to do a regular query (might be wrong though).
>>>> Is the client using some application that's going to issue a query
>>>> immediately on connecting?
>>> What I've been wondering all along is whether they are using a
>>> connection pool.
>> Yes they are using a connection pool. A java based one.
> 
> It's quite possible that it's the connection pool that gets confused,
> and not PostgreSQL itself.  It would be interesting if they change the
> connection setting when the "hang" next occurs, to point directly to
> PostgreSQL bypassing the connection pool.

Well except when they are connecting with Pgadmin (which wouldn't go 
through the connection pool) they get the error as well.

Joshua D. Drake

> 
> OTOH the connection pool may be the thing with the TickCounter problem.
> 



-- 
   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240   Providing the most comprehensive  PostgreSQL
solutionssince 1997             http://www.commandprompt.com/