Re: Cygwin PostgreSQL Regression Test Problems (Revisited)

Tom,

On Wed, Mar 28, 2001 at 06:06:22PM -0500, Tom Lane wrote:
> Jason Tishler <Jason.Tishler@dothill.com> writes:
> So no queries get executed at all before the backend exits.  Given that
> the backend seems to be exiting normally, one would suppose that the
> backend thinks it is seeing an EOF from the client.  Is there anything
> about "unexpected EOF on client connection" in the postmaster log?

I grep-ed for EOF in postmaster.log but came up empty.  Did I need to
run with debugging turned on to see this error message?  I was running
*without* debugging turned on.

> Another possibility is that the failing psqls are never managing to
> connect in the first place.  Can you attach to one of the stuck psqls
> with gdb and get a backtrace to see where it is?

I get the following backtrace for one of the hung psql processes:

    (gdb) bt
    #0  0x77f682cb in ?? ()
    #1  0x77f1cd76 in ?? ()
    #2  0x6103deee in _size_of_stack_reserve__ ()
    #3  0x6103d84e in _size_of_stack_reserve__ ()
    #4  0x67989978 in pqWait (forRead=0, forWrite=1, conn=0xa010258)
        at fe-misc.c:738
    #5  0x6798287c in connectDBComplete (conn=0xa010258) at fe-connect.c:1103
    #6  0x67981fb1 in PQsetdbLogin (pghost=0x0, pgport=0x0, pgoptions=0x0,
        pgtty=0x0, dbName=0x1a0260e8 "regression", login=0x0, pwd=0x0)
        at fe-connect.c:524
    #7  0x40e43f in main (argc=6, argv=0x1a021ad8) at startup.c:178

On Thu, Mar 29, 2001 at 03:20:59PM +0900, Hiroshi Inoue wrote:
> psql hangs at PQsetdbLogin()(select() in the
> first pqWait() in connectDBComplete()).

Note that my hang seems identical to the one reported by Hiroshi Inoue.

Thanks,
Jason

--
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com