Segmentation fault after upgrading to 1.5.18-1 - Mailing list pgsql-cygwin

From Sebastiano Pilla
Subject Segmentation fault after upgrading to 1.5.18-1
Date
Msg-id loom.20050709T120952-970@post.gmane.org
Whole thread Raw
Responses Re: Segmentation fault after upgrading to 1.5.18-1
List pgsql-cygwin
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

pgsql-cygwin by date:

Previous
From: Reini Urban
Date:
Subject: Re: Postgres 8.0 vs. Postgres 7.4/Cygwin
Next
From: "Ian Oxley"
Date:
Subject: Recall: initdb 'no such file or directory' error