Postgres Pro
Downloads
Home   >   mailing lists

Thread: Segmentation fault after upgrading to 1.5.18-1

Segmentation fault after upgrading to 1.5.18-1

From
Sebastiano Pilla
Date:
Hi, yesterday I upgraded my cygwin on Windows XP to the 1.5.18-1 version, and
now the previously installed postmaster (7.4.5-1) doesn't start anymore. It was
working fine before the upgrade.

The environment seems correctly set up:

admin@DATA ~
$ env | grep CYGWIN
CYGWIN=server

and the cygserver service is running:

admin@DATA ~
$ ps -ef
     UID     PID    PPID TTY     STIME COMMAND
   admin     776       1 con  19:11:17 /usr/bin/bash
  SYSTEM    2936       1   ?  12:06:11 /usr/bin/cygrunsrv
  SYSTEM     928    2936   ?  12:06:11 /usr/sbin/cygserver
   admin    3624     776 con  12:10:29 /usr/bin/ps

However, when I start postmaster it runs for a few seconds only and then stops.
I upped the log level, and here's the result of starting postmaster manually:

admin@DATA ~
$ postmaster -D /var/postgresql/data -i
2005-07-09 12:12:34 [3672] DEBUG:  00000: postmaster: PostmasterMain: initial
environ dump:
LOCATION:  PostmasterMain, postmaster.c:659
2005-07-09 12:12:34 [3672] DEBUG:  00000: --------------------------------------
---
LOCATION:  PostmasterMain, postmaster.c:661
2005-07-09 12:12:34 [3672] DEBUG:  00000:       HOMEPATH=\Documents and
Settings\admin
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       MANPATH=/usr/local/man:/usr/man:
/usr/share/man:/usr/autotool/devel/man::/usr/ssl/man:/usr/X11R6/man
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       APPDATA=C:\Documents and
Settings\admin\Application Data
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       HOSTNAME=DATA
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       TERM=cygwin
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       PROCESSOR_IDENTIFIER=x86 Family
6 Model 5 Stepping 2, GenuineIntel
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       WINDIR=C:\WINDOWS
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       TEXDOCVIEW_txt=cygstart %s
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       TEXDOCVIEW_dvi=cygstart %s
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       USERDOMAIN=DATA
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       OS=Windows_NT
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       ALLUSERSPROFILE=C:\Documents and
Settings\All Users
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       USER=admin
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       TEMP=/cygdrive/c/DOCUME~1/admin/
LOCALS~1/Temp
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       COMMONPROGRAMFILES=C:\Program
Files\Common Files
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       QTJAVA="C:
\WINDOWS\System32\QTJava.zip"
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       USERNAME=admin
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       TEXDOCVIEW_pdf=cygstart %s
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       PROCESSOR_LEVEL=6
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       PATH=/usr/local/bin:/usr/bin:/
bin:/usr/X11R6/bin:/cygdrive/c/WINDOWS/system32:/cygdrive/c/WINDOWS:/cygdrive/c/
WINDOWS
/System32/Wbem:/cygdrive/c/Program Files/Support Tools/:/cygdrive/c/Program
Files/JDK142/bin:/cygdrive/c/Program Files/JAD1.5.8e:/cygdrive/d/tools/ant/bin:/
cygdrive/
c/Program Files/pdftotext
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       FP_NO_HOST_CHECK=NO
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       PWD=/home/admin
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       SYSTEMDRIVE=C:
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       CYGWIN=server
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       TEXDOCVIEW_html=cygstart %s
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       USERPROFILE=C:\Documents and
Settings\admin
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       PS1=\[\033]0;\w\007
        \033[32m\]\u@\h \[\033[33m\w\033[0m\]
        $
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       LOGONSERVER=\\DATA
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       PROCESSOR_ARCHITECTURE=x86
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       !C:=C:\Documents and
Settings\admin
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       SHLVL=1
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       HOME=/home/admin
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       PATHEXT=.COM;.EXE;.BAT;.CMD;.
VBS;.VBE;.JS;.JSE;.WSF;.WSH
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       HOMEDRIVE=C:
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       !D:=D:\cygwin\bin
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       PROMPT=$P$G
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       OLDPATH=D:\oracle\ora10g\bin;D:
\oracle\ora10g\jre\1.4.2\bin\client;D:\oracle\ora10g\jre\1.4.2\bin;D:
\oracle\ora92\jre
\1.4.2\bin\client;D:\oracle\ora92\jre\1.4.2\bin;D:\oracle\ora92\bin;D:
\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program
Files\Oracle\jre\1.1.8\bin;C
:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Support
Tools\;C:\Program Files\JDK142\bin;C:\Program Files\JAD1.5.8e;c:\program
files\ruby18
1\bin;d:\tools\ant\bin
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       COMSPEC=C:\WINDOWS\system32\cmd.
exe
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       TMP=/cygdrive/c/DOCUME~1/admin/
LOCALS~1/Temp
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       SYSTEMROOT=C:\WINDOWS
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       CVS_RSH=/bin/ssh
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       PROCESSOR_REVISION=0502
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       MAKE_MODE=unix
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       TEXDOCVIEW_ps=cygstart %s
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       INFOPATH=/usr/local/info:/usr/
info:/usr/share/info:/usr/autotool/devel/info:/usr/autotool/stable/info:
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       PROGRAMFILES=C:\Program Files
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       NUMBER_OF_PROCESSORS=1
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       SESSIONNAME=Console
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       COMPUTERNAME=DATA
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       OLDPWD=/etc
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       _=/usr/bin/postmaster
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000:       TZ=WEST-1WEDT-2,M3.5.0/2,M10.5.
0/3
LOCATION:  PostmasterMain, postmaster.c:664
2005-07-09 12:12:34 [3672] DEBUG:  00000: --------------------------------------
---
LOCATION:  PostmasterMain, postmaster.c:666
2005-07-09 12:12:34 [3672] DEBUG:  00000: searching PATH for executable
LOCATION:  FindExec, findbe.c:194
2005-07-09 12:12:34 [3672] DEBUG:  00000: could not stat "/usr/local/bin/
postgres": No such file or directory
LOCATION:  ValidateBinary, findbe.c:66
2005-07-09 12:12:34 [3672] DEBUG:  00000: found "/usr/bin/postgres" using PATH
LOCATION:  FindExec, findbe.c:215
2005-07-09 12:12:35 [3672] DEBUG:  00000: invoking IpcMemoryCreate(size=9469952)
LOCATION:  CreateSharedMemoryAndSemaphores, ipci.c:73
Segmentation fault (core dumped)

And here's the stackdump:

admin@DATA ~
$ cat postgres.exe.stackdump
Exception: STATUS_ACCESS_VIOLATION at eip=610028AA
eax=00000000 ebx=61258F10 ecx=00000030 edx=000001A8 esi=000001A8 edi=61259000
ebp=0022E948 esp=0022E910 program=D:\cygwin\bin\postgres.exe, pid 3672, thread
main
cs=001B ds=0023 es=0023 fs=003B gs=0000 ss=0023
Stack trace:
Frame     Function  Args
0022E948  610028AA  (00000000, 61258D10, 0022E978, 6101F5E8)
0022E978  6101171C  (61156488, 61258D10, 0022E9C8, 61010F4E)
0022E9A8  61011CED  (61154A78, 61156448, 611D8458, 61154A78)
0022E9E8  61011E38  (61154A78, 00000000, 000007B6, 00002000)
0022EA28  6108E3FD  (00000000, 00002000, 0022EA68, 10016700)
0022EA58  610844FF  (0022EA78, 0022EA7C, 0022EA88, 0053F2C3)
0022EA88  0055945A  (00001538, 00000000, 00001538, 10016620)
0022EEE8  0053D258  (00000004, 100101C0, 0022EF18, 61087959)
0022EF18  00506FFD  (00000004, 61157690, 10010090, 7C919AF0)
0022EFD8  61004DD2  (0022EFF0, 00000000, 00000000, 00000000)
0022FF88  6100594F  (00000000, 00000000, 00000000, 00000000)
End of stack trace

I tried tinkering with the /etc/cygserver.conf file, but I'm not making any
progress because I don't know exactly what I should change... Any help is
*greatly* appreciated.

Sebastiano Pilla

Re: Segmentation fault after upgrading to 1.5.18-1

From
Jason Tishler
Date:
Sebastiano,

On Sat, Jul 09, 2005 at 10:17:55AM +0000, Sebastiano Pilla wrote:
> Hi, yesterday I upgraded my cygwin on Windows XP to the 1.5.18-1
> version, and now the previously installed postmaster (7.4.5-1) doesn't
> start anymore. It was working fine before the upgrade.
>
> [snip]
>
> And here's the stackdump:
>
> admin@DATA ~
> $ cat postgres.exe.stackdump
> Exception: STATUS_ACCESS_VIOLATION at eip=610028AA
> eax=00000000 ebx=61258F10 ecx=00000030 edx=000001A8 esi=000001A8 edi=61259000
> ebp=0022E948 esp=0022E910 program=D:\cygwin\bin\postgres.exe, pid 3672, thread
> main
> cs=001B ds=0023 es=0023 fs=003B gs=0000 ss=0023
> Stack trace:
> Frame     Function  Args
> 0022E948  610028AA  (00000000, 61258D10, 0022E978, 6101F5E8)

The above indicates that PostgreSQL is crashing inside of the Cygwin
DLL.  Unfortunately, one cannot conclude whether the bug is in Cygwin or
PostgreSQL without further debugging.  FWIW, Cygwin 1.5.18-1 has a newer
version of Doug's Lea malloc which is more sensitive to problem like
double-free errors.  See the Cygwin mailing list for more details, if
interested.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: Segmentation fault after upgrading to 1.5.18-1

From
Jason Tishler
Date:
On Mon, Jul 11, 2005 at 09:32:26AM -0400, Jason Tishler wrote:
> On Sat, Jul 09, 2005 at 10:17:55AM +0000, Sebastiano Pilla wrote:
> > Hi, yesterday I upgraded my cygwin on Windows XP to the 1.5.18-1
> > version, and now the previously installed postmaster (7.4.5-1)
> > doesn't start anymore. It was working fine before the upgrade.
> >
> > [snip]
> >
> > And here's the stackdump:
> >
> > admin@DATA ~
> > $ cat postgres.exe.stackdump
> > Exception: STATUS_ACCESS_VIOLATION at eip=610028AA
> > eax=00000000 ebx=61258F10 ecx=00000030 edx=000001A8 esi=000001A8
> > edi=61259000 ebp=0022E948 esp=0022E910
> > program=D:\cygwin\bin\postgres.exe, pid 3672, thread main
> > cs=001B ds=0023 es=0023 fs=003B gs=0000 ss=0023
> > Stack trace:
> > Frame     Function  Args
> > 0022E948  610028AA  (00000000, 61258D10, 0022E978, 6101F5E8)
>
> The above indicates that PostgreSQL is crashing inside of the Cygwin
> DLL.  Unfortunately, one cannot conclude whether the bug is in Cygwin
> or PostgreSQL without further debugging.  FWIW, Cygwin 1.5.18-1 has a
> newer version of Doug's Lea malloc which is more sensitive to problem
> like double-free errors.  See the Cygwin mailing list for more
> details, if interested.

The above problem should be fixed in the latest Cygwin snapshot:

    http://cygwin.com/ml/cygwin/2005-08/msg00249.html

Is someone willing to download the 2005-Aug-06 snapshot:

    http://cygwin.com/snapshots/

try it, and report back to the list?

Thanks,
Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: Segmentation fault after upgrading to 1.5.18-1

From
Jason Tishler
Date:
On Sun, Aug 07, 2005 at 11:23:33AM -0400, Jason Tishler wrote:
> On Mon, Jul 11, 2005 at 09:32:26AM -0400, Jason Tishler wrote:
> > On Sat, Jul 09, 2005 at 10:17:55AM +0000, Sebastiano Pilla wrote:
> > > Hi, yesterday I upgraded my cygwin on Windows XP to the 1.5.18-1
> > > version, and now the previously installed postmaster (7.4.5-1)
> > > doesn't start anymore. It was working fine before the upgrade.
> > >
> > > [snip]
> > >
> > > And here's the stackdump:
> > >
> > > admin@DATA ~
> > > $ cat postgres.exe.stackdump
> > > Exception: STATUS_ACCESS_VIOLATION at eip=610028AA
> > > eax=00000000 ebx=61258F10 ecx=00000030 edx=000001A8 esi=000001A8
> > > edi=61259000 ebp=0022E948 esp=0022E910
> > > program=D:\cygwin\bin\postgres.exe, pid 3672, thread main
> > > cs=001B ds=0023 es=0023 fs=003B gs=0000 ss=0023
> > > Stack trace:
> > > Frame     Function  Args
> > > 0022E948  610028AA  (00000000, 61258D10, 0022E978, 6101F5E8)
> >
> > The above indicates that PostgreSQL is crashing inside of the Cygwin
> > DLL.  Unfortunately, one cannot conclude whether the bug is in Cygwin
> > or PostgreSQL without further debugging.  FWIW, Cygwin 1.5.18-1 has a
> > newer version of Doug's Lea malloc which is more sensitive to problem
> > like double-free errors.  See the Cygwin mailing list for more
> > details, if interested.
>
> The above problem should be fixed in the latest Cygwin snapshot:
>
>     http://cygwin.com/ml/cygwin/2005-08/msg00249.html
>
> Is someone willing to download the 2005-Aug-06 snapshot:
>
>     http://cygwin.com/snapshots/
>
> try it, and report back to the list?

Someone on the Cygwin mailing list was:

    http://cygwin.com/ml/cygwin/2005-08/msg00279.html

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: Segmentation fault after upgrading to 1.5.18-1

From
VT Student
Date:
Hi

I tried the August 9 snapshot of cygwin1.dll.

I replaced the cygwin1.dll with Aug 09 snapshot of the same and just
run the initdb again (making sure that cygwin server is running too),
and it worked !

Thank you all for your help .. it really helped me a lot.

-Jeetendra Soneja.