7.2 psql

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

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

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

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

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