Mailing-List: contact cygwin-help AT sourceware DOT cygnus DOT com; run by ezmlm Sender: cygwin-owner AT sourceware DOT cygnus DOT com Delivered-To: mailing list cygwin AT sourceware DOT cygnus DOT com Message-ID: <3771FCB1.6FCA20BE@netspace.net.au> Date: Thu, 24 Jun 1999 19:38:57 +1000 From: "Sam O'Connor" Reply-To: Sam AT OConnor DOT net X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.34 i586) X-Accept-Language: en MIME-Version: 1.0 To: dan DOT horak AT email DOT cz, JKraaijeveld AT askesis DOT nl, pgsql-hackers AT postgresql DOT org, pgsql-ports AT postgresql DOT org, cygwin AT sourceware DOT cygnus DOT com Subject: Postgres on NT freezing Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I have been using PostgreSQL 6.4.2 on Debain GNU/Linux for a few months. I am using the Windows ODBC drivers and a C++/MFC client program. I fixed a few bugs in the ODBC drivers and now everything works perfectly. Now the downside. Unfortunately our current client insists on using NT not Linux. I have installed PostgreSQL 6.5 on cygwin 20.1 on NT 4.0 (See "Install log" below for exact versions of the various components.) I am having freeze up problems. I recompiled with both -g and -O2 turned off in the vain that hope it might help. "postmaster -i -d 3" and "postmaster -i -o -F" both exhibit intermittent freeze ups when a new backend starts. In LOG1 below I started the postmaster, connected from psql on my linux box, then quit straight away. Works fine. LOG2 below shows one successful connection followed by one the freezes at InitPostgres. There were dozens of good connections before the one shown here. I restarted "postmaster -i" (no debug messages) and was able to run 8 clients simultaneously producing about 8 connections per second. This was stable. I tried it again a few times and it mostly worked but froze sometimes. Running "postmaster -i -o -F" (no fsync) brought back the instability. I noticed that after a freeze I would be less likely to freeze again if I restarted the ipc-daemon. At one point the ipc daemon was using 25% cpu after I had killed all the crashed backends. My client opens and closes the connection to the back end allot. I tried altering it to keep the connections open (not feasible for our release version) and this made things more stable due to there being fewer connections. So the query handling seems ok, the freeze only happens when a new backend starts. Can anyone suggest anything that I might do to fix this? I realize PG on NT is a young port. I may be able to spend a little time on this myself if someone can point me in the right direction. Thanks for your help Sam O'Connor ========================================================= Install log: ========================================================= Installed: Microsoft Windows NT Workstation 4.0.1381 SP5 Installed: Cygwin Beta 20.1 (full.exe) /sw made /bin with sh.exe made /tmp made etc with passwd & group ln -s cygtclsh80 tclsh80 tclsh Installed: Andy Pipers /usr/local for Cygwin B20 added /usr/local/bin to path in cygnus.bat Installed: EGCS 1.1.2 release for Cygwin B20.1 gcc -v : gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) Installed: IPC for Cygwin32 1.03 added shortcut to ipc-daemon.exe to Startup folder Untared: postgresql-6.5.tar.gz in /usr/local/src copied src/win32/*.h into Cygwin include directories set CFLAGS to "" (no -O2 or -g) in src/template/cygwin32 ./configure make mkdir /usr/local/pgsql mkdir /usr/local/pgsql/data make install set PGLIB, PGDATA, PATH, USER initdb added to data/ph_hba.conf: host all 10.0.0.0 255.255.255.0 trust postmaster -i -d 3 Installed: PostgreSQL ODBC Driver 6.40.0006 ================================================== LOG1 successful backend log: postmaster -i -d 3 ================================================== FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0] binding ShmemCreate(key=52e2c1, size=1073152) /usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 9 /usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 9 /usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 9 /usr/local/pgsql/bin/postmaster: BackendStartup: environ dump: ----------------------------------------- !C:=C:\WINNT\Profiles\Administrator\Desktop COMPUTERNAME=WORM COMSPEC=C:\WINNT\system32\cmd.exe HOMEDRIVE=C: HOMEPATH=\ HOSTNAME=worm HOSTTYPE=i586 INCLUDE=C:\Program Files\Microsoft Visual Studio\VC98\atl\include;C:\Program Files\Microsoft Visual Studio\VC98\mfc\include; C:\Program Files\Microsoft Visual Studio\VC98\include LIB=C:\Program Files\Microsoft Visual Studio\VC98\mfc\lib;C:\Program Files\Microsoft Visual Studio\VC98\lib LOGONSERVER=\\WORM MACHTYPE=i586-pc-cygwin32 MAKE_MODE=UNIX MSDEVDIR=C:\Program Files\Microsoft Visual Studio\Common\MSDev98 NUMBER_OF_PROCESSORS=1 OS2LIBPATH=C:\WINNT\system32\os2\dll; OS=Windows_NT OSTYPE=cygwin32 PATH=/usr/local/pgsql/bin:/usr/local/pgsql/bin:/sw/CYGWIN~1/H-I586~1/bin:/usr/local/bin:/WINNT/system32:/WINNT:/Program File s/Microsoft Visual Studio/Common/Tools/WinNT:/Program Files/Microsoft Visual Studio/Common/MSDev98/Bin:/Program Files/Microsoft Visu al Studio/Common/Tools:/Program Files/Microsoft Visual Studio/VC98/bin PATHEXT=.COM;.EXE;.BAT;.CMD PGDATA=/usr/local/pgsql/data PGHOME=/usr/local/pgsql PGLIB=/usr/local/pgsql/lib PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 6 Model 0 Stepping 0, CyrixInstead PROCESSOR_LEVEL=6 PROCESSOR_REVISION=0000 PROMPT=$P$G PWD=/usr/local/pgsql/data SHELL=/bin/sh SHLVL=1 SYSTEMDRIVE=C: SYSTEMROOT=C:\WINNT TEMP=C:\TEMP TERM=cygwin TMP=C:\TEMP USER=administrator USERDOMAIN=WORM USERNAME=Administrator USERPROFILE=C:\WINNT\Profiles\Administrator WINDIR=C:\WINNT _=/usr/local/pgsql/bin/postmaster POSTPORT=5432 POSTID=2147483647 PG_USER=administrator IPC_KEY=5432000 ----------------------------------------- /usr/local/pgsql/bin/postmaster child[2528]: starting with (/usr/local/pgsql/bin/postgres -d3 -v131072 -p template1 ) FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0] debug info: User = administrator RemoteHost = 10.0.0.100 RemotePort = 5271 DatabaseName = template1 Verbose = 3 Noversion = f timings = f dates = Normal bufsize = 64 sortmem = 512 query echo = f InitPostgres /usr/local/pgsql/bin/postmaster: BackendStartup: pid 2528 user administrator db template1 socket 9 Error semaphore semaphore not equal 0 Error semaphore semaphore not equal 0 Error semaphore semaphore not equal 0 Error semaphore semaphore not equal 0 proc_exit(0) [#0] shmem_exit(0) [#0] exit(0) /usr/local/pgsql/bin/postmaster: reaping dead processes... /usr/local/pgsql/bin/postmaster: CleanupProc: pid 2528 exited with status 0 =============================================== LOG2 failed backend log: postmaster -i -d 3 ----------------------------------------------- note: "Error semaphore semaphore not equal 0" =============================================== exit(0) /usr/local/pgsql/bin/postmaster: reaping dead processes... /usr/local/pgsql/bin/postmaster: CleanupProc: pid 2589 exited with status 0 /usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 9 /usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 9 /usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 9 /usr/local/pgsql/bin/postmaster: BackendStartup: environ dump: ----------------------------------------- !C:=C:\WINNT\Profiles\Administrator\Desktop COMPUTERNAME=WORM COMSPEC=C:\WINNT\system32\cmd.exe HOMEDRIVE=C: HOMEPATH=\ HOSTNAME=worm HOSTTYPE=i586 INCLUDE=C:\Program Files\Microsoft Visual Studio\VC98\atl\include;C:\Program Files\Microsoft Visual Studio\VC98\mfc\include; C:\Program Files\Microsoft Visual Studio\VC98\include LIB=C:\Program Files\Microsoft Visual Studio\VC98\mfc\lib;C:\Program Files\Microsoft Visual Studio\VC98\lib LOGONSERVER=\\WORM MACHTYPE=i586-pc-cygwin32 MAKE_MODE=UNIX MSDEVDIR=C:\Program Files\Microsoft Visual Studio\Common\MSDev98 NUMBER_OF_PROCESSORS=1 OS2LIBPATH=C:\WINNT\system32\os2\dll; OS=Windows_NT OSTYPE=cygwin32 PATH=/usr/local/pgsql/bin:/usr/local/pgsql/bin:/sw/CYGWIN~1/H-I586~1/bin:/usr/local/bin:/WINNT/system32:/WINNT:/Program File s/Microsoft Visual Studio/Common/Tools/WinNT:/Program Files/Microsoft Visual Studio/Common/MSDev98/Bin:/Program Files/Microsoft Visu al Studio/Common/Tools:/Program Files/Microsoft Visual Studio/VC98/bin PATHEXT=.COM;.EXE;.BAT;.CMD PGDATA=/usr/local/pgsql/data PGHOME=/usr/local/pgsql PGLIB=/usr/local/pgsql/lib PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 6 Model 0 Stepping 0, CyrixInstead PROCESSOR_LEVEL=6 PROCESSOR_REVISION=0000 PROMPT=$P$G PWD=/usr/local/pgsql/data SHELL=/bin/sh SHLVL=1 SYSTEMDRIVE=C: SYSTEMROOT=C:\WINNT TEMP=C:\TEMP TERM=cygwin TMP=C:\TEMP USER=administrator USERDOMAIN=WORM USERNAME=Administrator USERPROFILE=C:\WINNT\Profiles\Administrator WINDIR=C:\WINNT _=/usr/local/pgsql/bin/postmaster POSTPORT=5432 POSTID=2147483614 PG_USER=administrator IPC_KEY=5432000 ----------------------------------------- /usr/local/pgsql/bin/postmaster child[2590]: starting with (/usr/local/pgsql/bin/postgres -d3 -v131072 -p mentor ) /usr/local/pgsql/bin/postmaster: BackendStartup: pid 2590 user administrator db mentor socket 9 FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0] debug info: User = administrator RemoteHost = 127.0.0.1 RemotePort = 1084 DatabaseName = mentor Verbose = 3 Noversion = f timings = f dates = Normal bufsize = 64 sortmem = 512 query echo = f InitPostgres Error semaphore semaphore not equal 0 Error semaphore semaphore not equal 0 Error semaphore semaphore not equal 0 Error semaphore semaphore not equal 0 StartTransactionCommand query: set DateStyle to 'ISO' ProcessUtility: set DateStyle to 'ISO' CommitTransactionCommand StartTransactionCommand query: set geqo to 'OFF' ProcessUtility: set geqo to 'OFF' CommitTransactionCommand StartTransactionCommand query: set ksqo to 'ON' ProcessUtility: set ksqo to 'ON' CommitTransactionCommand StartTransactionCommand query: select oid from pg_type where typname='lo' ProcessQuery CommitTransactionCommand StartTransactionCommand query: SELECT * FROM released_document WHERE document_id = 2 ProcessQuery CommitTransactionCommand StartTransactionCommand query: SELECT popup_id, content FROM popup WHERE document_id = 2 AND document_version = 0 ORDER BY popup_id ProcessQuery CommitTransactionCommand StartTransactionCommand query: SELECT link_id, type, vector FROM link WHERE document_id = 2 AND document_version = 0 ProcessQuery CommitTransactionCommand StartTransactionCommand query: SELECT section_number, name FROM section WHERE document_id = 2 AND document_version = 0 ORDER BY section_number ProcessQuery CommitTransactionCommand StartTransactionCommand query: SELECT text, textel_number, type FROM typed_textel WHERE document_id = 2 AND document_version = 0 AND section_number = 0 ORDE R BY textel_number ProcessQuery CommitTransactionCommand StartTransactionCommand query: SELECT text, textel_number, type FROM typed_textel WHERE document_id = 2 AND document_version = 0 AND section_number = 1 ORDE R BY textel_number ProcessQuery CommitTransactionCommand StartTransactionCommand query: SELECT text, textel_number, type FROM typed_textel WHERE document_id = 2 AND document_version = 0 AND section_number = 2 ORDE R BY textel_number ProcessQuery CommitTransactionCommand StartTransactionCommand query: SELECT text, textel_number, type FROM typed_textel WHERE document_id = 2 AND document_version = 0 AND section_number = 3 ORDE R BY textel_number ProcessQuery CommitTransactionCommand pq_recvbuf: unexpected EOF on client connection proc_exit(0) [#0] shmem_exit(0) [#0] exit(0) /usr/local/pgsql/bin/postmaster: reaping dead processes... /usr/local/pgsql/bin/postmaster: CleanupProc: pid 2590 exited with status 0 /usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 9 /usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 9 /usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 9 /usr/local/pgsql/bin/postmaster: BackendStartup: environ dump: ----------------------------------------- !C:=C:\WINNT\Profiles\Administrator\Desktop COMPUTERNAME=WORM COMSPEC=C:\WINNT\system32\cmd.exe HOMEDRIVE=C: HOMEPATH=\ HOSTNAME=worm HOSTTYPE=i586 INCLUDE=C:\Program Files\Microsoft Visual Studio\VC98\atl\include;C:\Program Files\Microsoft Visual Studio\VC98\mfc\include; C:\Program Files\Microsoft Visual Studio\VC98\include LIB=C:\Program Files\Microsoft Visual Studio\VC98\mfc\lib;C:\Program Files\Microsoft Visual Studio\VC98\lib LOGONSERVER=\\WORM MACHTYPE=i586-pc-cygwin32 MAKE_MODE=UNIX MSDEVDIR=C:\Program Files\Microsoft Visual Studio\Common\MSDev98 NUMBER_OF_PROCESSORS=1 OS2LIBPATH=C:\WINNT\system32\os2\dll; OS=Windows_NT OSTYPE=cygwin32 PATH=/usr/local/pgsql/bin:/usr/local/pgsql/bin:/sw/CYGWIN~1/H-I586~1/bin:/usr/local/bin:/WINNT/system32:/WINNT:/Program File s/Microsoft Visual Studio/Common/Tools/WinNT:/Program Files/Microsoft Visual Studio/Common/MSDev98/Bin:/Program Files/Microsoft Visu al Studio/Common/Tools:/Program Files/Microsoft Visual Studio/VC98/bin PATHEXT=.COM;.EXE;.BAT;.CMD PGDATA=/usr/local/pgsql/data PGHOME=/usr/local/pgsql PGLIB=/usr/local/pgsql/lib PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 6 Model 0 Stepping 0, CyrixInstead PROCESSOR_LEVEL=6 PROCESSOR_REVISION=0000 PROMPT=$P$G PWD=/usr/local/pgsql/data SHELL=/bin/sh SHLVL=1 SYSTEMDRIVE=C: SYSTEMROOT=C:\WINNT TEMP=C:\TEMP TERM=cygwin TMP=C:\TEMP USER=administrator USERDOMAIN=WORM USERNAME=Administrator USERPROFILE=C:\WINNT\Profiles\Administrator WINDIR=C:\WINNT _=/usr/local/pgsql/bin/postmaster POSTPORT=5432 POSTID=2147483613 PG_USER=administrator IPC_KEY=5432000 ----------------------------------------- /usr/local/pgsql/bin/postmaster child[2591]: starting with (/usr/local/pgsql/bin/postgres -d3 -v131072 -p mentor ) /usr/local/pgsql/bin/postmaster: BackendStartup: pid 2591 user administrator db mentor socket 9 FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0] debug info: User = administrator RemoteHost = 127.0.0.1 RemotePort = 1085 DatabaseName = mentor Verbose = 3 Noversion = f timings = f dates = Normal bufsize = 64 sortmem = 512 query echo = f InitPostgres =========================================================== End of log =========================================================== -- Want to unsubscribe from this list? Send a message to cygwin-unsubscribe AT sourceware DOT cygnus DOT com