Re: Win32 hard crash problem

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Magnus Hagander <mha(at)sollentuna(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Win32 hard crash problem
Date: 2006-09-05 22:21:12
Message-ID: 20060905222112.GU21195@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joshua D. Drake wrote:
> Alvaro Herrera wrote:
> >Tom Lane wrote:
> >>"Joshua D. Drake" <jd(at)commandprompt(dot)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.

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

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Browne 2006-09-05 22:24:28 New Linux Filesystem: NILFS
Previous Message Jeremy Drake 2006-09-05 22:11:42 Re: Win32 hard crash problem