Postgres Pro
Downloads
Home   >   mailing lists

Thread: 7.2 psql

7.2 psql

From
"Henshall, Stuart - WCP"
Date:
Hi,
    I've recetnly compiled postgresql 7.2 and seem to be having some
problems with the psql. (win98 se on a P3 900, cygipc 1.11)
$ uname -a
CYGWIN_98-4.10 BX3551TC 1.3.9(0.51/3/2) 2002-01-21 12:48 i686 unknown
Client:
$ psql template1
Segmentation fault (core dumped)
Server:
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  incomplete startup packet

Sorry for lack of detail but I'm busy :( and was wondering if this is a
release problem or just my system.
- Stuart

Re: 7.2 psql

From
Jason Tishler
Date:
Stuart,

On Mon, Feb 04, 2002 at 03:02:17PM -0000, Henshall, Stuart - WCP wrote:
>     I've recetnly compiled postgresql 7.2 and seem to be having some
> problems with the psql. (win98 se on a P3 900, cygipc 1.11)
> $ uname -a
> CYGWIN_98-4.10 BX3551TC 1.3.9(0.51/3/2) 2002-01-21 12:48 i686 unknown
> Client:
> $ psql template1
> Segmentation fault (core dumped)
> Server:
> DEBUG:  pq_recvbuf: unexpected EOF on client connection
> DEBUG:  incomplete startup packet
>
> Sorry for lack of detail but I'm busy :( and was wondering if this is a
> release problem or just my system.

I can reproduce the above.  From the following stackdump (from  psql):

$ cat psql.exe.stackdump
Exception: STATUS_ACCESS_VIOLATION at eip=6108D4A4
eax=0A010462 ebx=0A010462 ecx=0000006D edx=00000000 esi=0022FC98 edi=0A010462
ebp=0022FC14 esp=0022FC08 program=C:\cygwin\bin\psql.exe
cs=001B ds=0023 es=0023 fs=003B gs=0000 ss=0023
Stack trace:
Frame     Function  Args
0022FC14  6108D4A4  (0A010462, 00000000, 0000006D, 61033C93)
          ^^^^^^^^
..

we can conclude that the crash is inside of the Cygwin DLL.  Why?
Because the Cygwin DLL is based at 0x61000000.  At first glance, it
appears that the 7.2 psql is tickling a Cygwin bug.  BTW, if I connect
to a 7.2 backend from a 7.1.3 psql, then all appears to be OK.

I will build a debuggable DLL from the latest Cygwin CVS and continue
debugging.  I will report back when I have more info (unless someone
else beats me to it).

Jason

Re: 7.2 psql

From
Jason Tishler
Date:
Stuart,

On Wed, Feb 06, 2002 at 10:18:49AM -0500, Jason Tishler wrote:
> On Mon, Feb 04, 2002 at 03:02:17PM -0000, Henshall, Stuart - WCP wrote:
> > Client:
> > $ psql template1
> > Segmentation fault (core dumped)
> I can reproduce the above.  From the following stackdump (from  psql):
>
> [snip]
> I will build a debuggable DLL from the latest Cygwin CVS and continue
> debugging.  I will report back when I have more info (unless someone
> else beats me to it).

The above is fixed by the following:

    http://cygwin.com/ml/cygwin-patches/2002-q1/msg00199.html

Hopefully, this patch or a better one will be committed into Cygwin CVS
soon.

Jason

Re: 7.2 psql

From
Jason Tishler
Date:
Stuart,

On Wed, Feb 06, 2002 at 01:12:00PM -0500, Jason Tishler wrote:
> Hopefully, this patch or a better one will be committed into Cygwin CVS
> soon.

BTW, with this patch, Cygwin PostgreSQL 7.2 passes all regression tests.

Jason

Re: 7.2 psql

From
Dave Page
Date:

> -----Original Message-----
> From: Jason Tishler [mailto:jason@tishler.net]
> Sent: 06 February 2002 18:16
> To: Henshall, Stuart - WCP
> Cc: 'pgsql-cygwin@postgresql.org'
> Subject: Re: [CYGWIN] 7.2 psql
>
>
> Stuart,
>
> On Wed, Feb 06, 2002 at 01:12:00PM -0500, Jason Tishler wrote:
> > Hopefully, this patch or a better one will be committed into Cygwin
> > CVS soon.
>
> BTW, with this patch, Cygwin PostgreSQL 7.2 passes all
> regression tests.

Did you find it did not previously? It did here on a couple of different
systems...

Regards, Dave.

Re: 7.2 psql

From
Jason Tishler
Date:
Dave,

On Wed, Feb 06, 2002 at 09:13:21PM +0000, Dave Page wrote:
> > -----Original Message-----
> > From: Jason Tishler [mailto:jason@tishler.net]
> > Sent: 06 February 2002 18:16
> > To: Henshall, Stuart - WCP
> > Cc: 'pgsql-cygwin@postgresql.org'
> > Subject: Re: [CYGWIN] 7.2 psql
> >
> > BTW, with this patch, Cygwin PostgreSQL 7.2 passes all
> > regression tests.
>
> Did you find it did not previously? It did here on a couple of different
> systems...

No.  The above was just meant to indicate that all is well once Cygwin
is patched to fixed this problem.

Jason

Re: 7.2 psql

From
Jason Tishler
Date:
Stuart,

On Wed, Feb 06, 2002 at 01:12:00PM -0500, Jason Tishler wrote:
> On Wed, Feb 06, 2002 at 10:18:49AM -0500, Jason Tishler wrote:
> > On Mon, Feb 04, 2002 at 03:02:17PM -0000, Henshall, Stuart - WCP wrote:
> > > Client:
> > > $ psql template1
> > > Segmentation fault (core dumped)
> > I can reproduce the above.  From the following stackdump (from  psql):
> >
> > [snip]
> > I will build a debuggable DLL from the latest Cygwin CVS and continue
> > debugging.  I will report back when I have more info (unless someone
> > else beats me to it).
>
> The above is fixed by the following:
>
>     http://cygwin.com/ml/cygwin-patches/2002-q1/msg00199.html
>
> Hopefully, this patch or a better one will be committed into Cygwin CVS
> soon.

A better solution has been checked into Cygwin CVS:

    http://cygwin.com/ml/cygwin-cvs/2002-q1/msg00127.html

Please try the next Cygwin snapshot when available and report back to
the list.

Thanks,
Jason