Skip site navigation (1) Skip section navigation (2)

Re: Cygwin PostgreSQL Regression Test Problems (Revisited)

From: Jason Tishler <Jason(dot)Tishler(at)dothill(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-ports(at)postgresql(dot)org
Subject: Re: Cygwin PostgreSQL Regression Test Problems (Revisited)
Date: 2001-03-29 15:17:45
Message-ID: 20010329101744.A467@dothill.com (view raw or flat)
Thread:
Lists: pgsql-ports
Tom,

On Wed, Mar 28, 2001 at 06:06:22PM -0500, Tom Lane wrote:
> Jason Tishler <Jason(dot)Tishler(at)dothill(dot)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(dot)Tishler(at)dothill(dot)com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

In response to

Responses

pgsql-ports by date

Next:From: Tom LaneDate: 2001-03-29 15:43:49
Subject: Re: Cygwin PostgreSQL Regression Test Problems (Revisited)
Previous:From: Bruce MomjianDate: 2001-03-29 13:36:48
Subject: Re: [HACKERS] Re: pgmonitor and Solaris

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group