Configuration under Win 2000 and cygwin (bug ?) - Mailing list pgsql-cygwin
| From | michel.bellon@lcie.fr |
|---|---|
| Subject | Configuration under Win 2000 and cygwin (bug ?) |
| Date | |
| Msg-id | OF7FAB718B.A59CC9F0-ONC1256B7C.00531E4B@fr.bureauveritas.com Whole thread Raw |
| Responses |
Re: Configuration under Win 2000 and cygwin (bug ?)
|
| List | pgsql-cygwin |
Hi all I'am trying to tune a Windows 2000 system to support approximately 200 client. In order to test the configuration, I'am using pgbench. With this configuration (the complete file is joined) max_connections = 200 # 1-1024 #port = 5432 #hostname_lookup = false #show_source_port = false #unix_socket_directory = '' #unix_socket_group = '' #unix_socket_permissions = 0777 #virtual_host = '' #krb_server_keyfile = '' # # Performance # sort_mem = 512 # 512 shared_buffers = 30000 # 2*max_connections # min 16 #fsync = true I'am unable to support more than ~25 to 30 client. Two problems : First) with pgbench -c80, one can see in the first log file after only 62 backend startup : 2002-03-14 14:22:22 [2544] DEBUG: CommitTransactionCommand /usr/bin/postmaster: BackendStartup: fork failed: Resource temporarily unavailable Backend startup failed pq_recvbuf: unexpected EOF on client connection (See attached file: FORK_F~1.LOG) second) with pgbench -c40, I have a crash with 2002-02-22 07:03:13 [1776] DEBUG: query: insert into history(tid,bid,aid,delta,time) values(10,1,70266,193,'now') /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: CleanupProc: pid 2936 exited with status 0 FATAL: s_lock(0x1a4e0016) at spin.c:158, stuck spinlock. Aborting. FATAL: s_lock(0x1a4e0016) at spin.c:158, stuck spinlock. Aborting. Stack trace: Frame Function Args (See attached file: FATAL.LOG) Here is my postgres configuration files (See attached file: POSTGR~1.CON) PostgreSQL 7.1.3 Cygwin described in (See attached file: cygwin_conf_diag.txt) Michel BELLON Direction Produits Méthodes Qualité 33 (0)1 40 95 60 35 http://www.lcie.fr Cygwin Win95/NT Configuration Diagnostics Current System Time: Fri Feb 22 18:02:22 2002 Windows 2000 Server Ver 5.0 Build 2195 Service Pack 2 Path: d:\cygwin\usr\local\bin d:\cygwin\bin d:\cygwin\bin d:\cygwin\bin d:\cygwin\bin c:\WINNT\system32 c:\WINNT c:\WINNT\System32\Wbem c:\Resource Kit\ SysDir: C:\WINNT\System32 WinDir: C:\WINNT HOME = `d:\cygwin\home\Administrateur' MAKE_MODE = `unix' PWD = `/home/Administrateur' USER = `Administrateur' ALLUSERSPROFILE = `C:\Documents and Settings\All Users' APPDATA = `C:\Documents and Settings\Administrateur.DOM_LCIE\Application Data' CLIENTNAME = `RAZANAKOTO' COMMONPROGRAMFILES = `C:\Program Files\Fichiers communs' COMPUTERNAME = `HESTIAW2K' COMSPEC = `C:\WINNT\system32\cmd.exe' HOMEDRIVE = `C:' HOMEPATH = `\Documents and Settings\Administrateur.DOM_LCIE' LOGONSERVER = `\\HERA' MANPATH = `:/usr/ssl/man' NUMBER_OF_PROCESSORS = `2' OLDPWD = `/usr/bin' OS2LIBPATH = `C:\WINNT\system32\os2\dll;' OS = `Windows_NT' PATHEXT = `.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH' PROCESSOR_ARCHITECTURE = `x86' PROCESSOR_IDENTIFIER = `x86 Family 6 Model 11 Stepping 1, GenuineIntel' PROCESSOR_LEVEL = `6' PROCESSOR_REVISION = `0b01' PROGRAMFILES = `C:\Program Files' PROMPT = `$P$G' PS1 = `\[\033]0;\w\007 \033[32m\]\u@\h \[\033[33m\w\033[0m\] $ ' SESSIONNAME = `RDP-Tcp#2' SHLVL = `1' SYSTEMDRIVE = `C:' SYSTEMROOT = `C:\WINNT' TEMP = `c:\DOCUME~1\ADMINI~1.DOM\LOCALS~1\Temp' TERM = `cygwin' TMP = `c:\DOCUME~1\ADMINI~1.DOM\LOCALS~1\Temp' USERDOMAIN = `DOM_LCIE' USERNAME = `Administrateur' USERPROFILE = `C:\Documents and Settings\Administrateur.DOM_LCIE' WINDIR = `C:\WINNT' _ = `/usr/bin/cygcheck' HKEY_CURRENT_USER\Software\Cygnus Solutions HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin (default) = 0x00000350 HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\mounts v2 (default) = `/cygdrive' cygdrive flags = 0x00000020 HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\Program Options HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2 HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/ (default) = `d:/cygwin' flags = 0x00000008 HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/bin (default) = `d:/cygwin/bin' flags = 0x00000008 HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/lib (default) = `d:/cygwin/lib' flags = 0x00000008 HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\Program Options a: fd N/A N/A c: hd NTFS 5000Mb 55% CP CS UN PA FC d: hd NTFS 64417Mb 5% CP CS UN PA FC Nouveau nom e: cd N/A N/A m: net NTFS 36847Mb 69% CP CS UN PA FC . /cygdrive user textmode,noumount d:/cygwin / system textmode d:/cygwin/bin /usr/bin system textmode d:/cygwin/lib /usr/lib system textmode Found: d:\cygwin\bin\bash.exe Found: d:\cygwin\bin\cat.exe Found: d:\cygwin\bin\cpp.exe Found: d:\cygwin\bin\find.exe Found: d:\cygwin\bin\gcc.exe Found: d:\cygwin\bin\gdb.exe Found: d:\cygwin\bin\ld.exe Found: d:\cygwin\bin\ls.exe Found: d:\cygwin\bin\make.exe Found: d:\cygwin\bin\sh.exe 751k 2002/01/21 d:\cygwin\usr\local\bin\cygwin1.dll - os=4.0 img=1.0 sys=4.0 "cygwin1.dll" v0.0 ts=2002/1/21 18:48 Cygwin DLL version info: DLL version: 1.3.9 DLL epoch: 19 DLL bad signal mask: 19005 DLL old termios: 5 DLL malloc env: 28 API major: 0 API minor: 51 Shared data: 3 DLL identifier: cygwin1 Mount registry: 2 Cygnus registry name: Cygnus Solutions Cygwin registry name: Cygwin Program options name: Program Options Cygwin mount registry name: mounts v2 Cygdrive flags: cygdrive flags Cygdrive prefix: cygdrive prefix Cygdrive default prefix: Build date: Mon Jan 21 12:48:41 EST 2002 Shared id: cygwin1S3 56k 2000/12/03 d:\cygwin\bin\cygbz21.0.dll - os=4.0 img=1.0 sys=4.0 "cygbz21.0.dll" v0.0 ts=2000/11/21 0:53 621k 2002/01/16 d:\cygwin\bin\cygcrypto.dll - os=4.0 img=1.0 sys=4.0 "cygcrypto.dll" v0.0 ts=2002/1/16 10:54 107k 2002/01/23 d:\cygwin\bin\cygcurl-2.dll - os=4.0 img=1.0 sys=4.0 "cygcurl-2.dll" v0.0 ts=2002/1/23 19:25 73k 2002/01/16 d:\cygwin\bin\cygexslt-0.dll - os=4.0 img=1.0 sys=4.0 "cygexslt-0.dll" v0.0 ts=2002/1/16 10:06 45k 2001/04/25 d:\cygwin\bin\cygform5.dll - os=4.0 img=1.0 sys=4.0 "cygform5.dll" v0.0 ts=2001/4/25 7:28 35k 2002/01/09 d:\cygwin\bin\cygform6.dll - os=4.0 img=1.0 sys=4.0 "cygform6.dll" v0.0 ts=2002/1/9 7:03 18k 2000/10/23 d:\cygwin\bin\cyggdbm.dll - os=4.0 img=1.0 sys=4.0 "cyggdbm.dll" v0.0 ts=2000/10/23 4:26 17k 2001/06/28 d:\cygwin\bin\cyghistory4.dll - os=4.0 img=1.0 sys=4.0 "cyghistory4.dll" v0.0 ts=2001/1/7 5:34 20k 2002/01/13 d:\cygwin\bin\cyghistory5.dll - os=4.0 img=1.0 sys=4.0 "cyghistory5.dll" v0.0 ts=2002/1/13 2:27 22k 2001/12/13 d:\cygwin\bin\cygintl-1.dll - os=4.0 img=1.0 sys=4.0 "cygintl-1.dll" v0.0 ts=2001/12/13 10:28 81k 2001/10/20 d:\cygwin\bin\cygitcl30.dll - os=4.0 img=1.0 sys=4.0 "cygitcl30.dll" v0.0 ts=2001/10/20 2:25 35k 2001/10/20 d:\cygwin\bin\cygitk30.dll - os=4.0 img=1.0 sys=4.0 "cygitk30.dll" v0.0 ts=2001/10/20 2:25 45k 2002/02/08 d:\cygwin\bin\cygjbig1.dll - os=4.0 img=1.0 sys=4.0 "cygjbig1.dll" v0.0 ts=2002/2/8 0:59 119k 2002/02/09 d:\cygwin\bin\cygjpeg6b.dll - os=4.0 img=1.0 sys=4.0 "cygjpeg6b.dll" v0.0 ts=2002/2/9 6:19 35k 2002/02/04 d:\cygwin\bin\cygltdl-3.dll - os=4.0 img=1.0 sys=4.0 "cygltdl-3.dll" v0.0 ts=2002/2/4 2:56 26k 2001/04/25 d:\cygwin\bin\cygmenu5.dll - os=4.0 img=1.0 sys=4.0 "cygmenu5.dll" v0.0 ts=2001/4/25 7:27 20k 2002/01/09 d:\cygwin\bin\cygmenu6.dll - os=4.0 img=1.0 sys=4.0 "cygmenu6.dll" v0.0 ts=2002/1/9 7:03 156k 2001/04/25 d:\cygwin\bin\cygncurses++5.dll - os=4.0 img=1.0 sys=4.0 "cygncurses++5.dll" v0.0 ts=2001/4/25 7:29 175k 2002/01/09 d:\cygwin\bin\cygncurses++6.dll - os=4.0 img=1.0 sys=4.0 "cygncurses++6.dll" v0.0 ts=2002/1/9 7:03 226k 2001/04/25 d:\cygwin\bin\cygncurses5.dll - os=4.0 img=1.0 sys=4.0 "cygncurses5.dll" v0.0 ts=2001/4/25 7:17 202k 2002/01/09 d:\cygwin\bin\cygncurses6.dll - os=4.0 img=1.0 sys=4.0 "cygncurses6.dll" v0.0 ts=2002/1/9 7:03 15k 2001/04/25 d:\cygwin\bin\cygpanel5.dll - os=4.0 img=1.0 sys=4.0 "cygpanel5.dll" v0.0 ts=2001/4/25 7:27 12k 2002/01/09 d:\cygwin\bin\cygpanel6.dll - os=4.0 img=1.0 sys=4.0 "cygpanel6.dll" v0.0 ts=2002/1/9 7:03 40k 2001/11/21 d:\cygwin\bin\cygpcre.dll - os=4.0 img=1.0 sys=4.0 "cygpcre.dll" v0.0 ts=2001/11/21 23:15 39k 2001/11/21 d:\cygwin\bin\cygpcreposix.dll - os=4.0 img=1.0 sys=4.0 "cygpcreposix.dll" v0.0 ts=2001/11/21 23:15 108k 2001/06/28 d:\cygwin\bin\cygreadline4.dll - os=4.0 img=1.0 sys=4.0 "cygreadline4.dll" v0.0 ts=2001/1/7 5:34 121k 2002/01/13 d:\cygwin\bin\cygreadline5.dll - os=4.0 img=1.0 sys=4.0 "cygreadline5.dll" v0.0 ts=2002/1/13 2:27 66k 2001/11/20 d:\cygwin\bin\cygregex.dll - os=4.0 img=1.0 sys=4.0 "cygregex.dll" v0.0 ts=2001/11/20 15:44 156k 2002/01/16 d:\cygwin\bin\cygssl.dll - os=4.0 img=1.0 sys=4.0 "cygssl.dll" v0.0 ts=2002/1/16 10:54 390k 2001/10/20 d:\cygwin\bin\cygtcl80.dll - os=4.0 img=1.0 sys=4.0 "cygtcl80.dll" v0.0 ts=2001/10/20 2:24 5k 2001/10/20 d:\cygwin\bin\cygtclpip80.dll - os=4.0 img=1.0 sys=4.0 10k 2001/10/20 d:\cygwin\bin\cygtclreg80.dll - os=4.0 img=1.0 sys=4.0 "cygtclreg80.dll" v0.0 ts=2001/10/20 2:24 253k 2002/02/10 d:\cygwin\bin\cygtiff3.dll - os=4.0 img=1.0 sys=4.0 "cygtiff3.dll" v0.0 ts=2002/2/10 9:34 623k 2001/10/20 d:\cygwin\bin\cygtk80.dll - os=4.0 img=1.0 sys=4.0 "cygtk80.dll" v0.0 ts=2001/10/20 2:25 612k 2002/01/16 d:\cygwin\bin\cygxml2-2.dll - os=4.0 img=1.0 sys=4.0 "cygxml2-2.dll" v0.0 ts=2002/1/16 5:24 41k 2001/07/04 d:\cygwin\bin\cygXpm-noX4.dll - os=4.0 img=1.0 sys=4.0 "cygXpm-noX4.dll" v0.0 ts=2001/7/4 3:21 45k 2001/07/04 d:\cygwin\bin\cygXpm-X4.dll - os=4.0 img=1.0 sys=4.0 "cygXpm-X4.dll" v0.0 ts=2000/11/20 3:45 202k 2002/01/16 d:\cygwin\bin\cygxslt-1.dll - os=4.0 img=1.0 sys=4.0 "cygxslt-1.dll" v0.0 ts=2002/1/16 9:52 22k 2002/01/16 d:\cygwin\bin\cygxsltbreakpoint-1.dll - os=4.0 img=1.0 sys=4.0 "cygxsltbreakpoint-1.dll" v0.0 ts=2002/1/16 10:05 50k 2002/01/20 d:\cygwin\bin\cygz.dll - os=4.0 img=1.0 sys=4.0 "cygz.dll" v0.0 ts=2002/1/20 20:41 751k 2002/01/21 d:\cygwin\bin\cygwin1.dll - os=4.0 img=1.0 sys=4.0 "cygwin1.dll" v0.0 ts=2002/1/21 18:48 Cygwin DLL version info: DLL version: 1.3.9 DLL epoch: 19 DLL bad signal mask: 19005 DLL old termios: 5 DLL malloc env: 28 API major: 0 API minor: 51 Shared data: 3 DLL identifier: cygwin1 Mount registry: 2 Cygnus registry name: Cygnus Solutions Cygwin registry name: Cygwin Program options name: Program Options Cygwin mount registry name: mounts v2 Cygdrive flags: cygdrive flags Cygdrive prefix: cygdrive prefix Cygdrive default prefix: Build date: Mon Jan 21 12:48:41 EST 2002 Shared id: cygwin1S3 Cygwin Package Information Last downloaded files to: d:\cygwin\lpd Last downloaded files from: ftp://ftp.ccp14.dl.ac.uk/ccp14/ftp-mirror/programming/cygwin/pub/cygwin Package Version ash 20020131-1 autoconf 2.52a-1 autoconf-devel 2.52-4 autoconf-stable 2.13-4 automake 1.5b-1 automake-devel 1.5-5 automake-stable 1.4p5-5 bash 2.05a-2 bc 1.06-1 binutils 20011002-1 bison 1.33-1 byacc 1.9-1 bzip2 1.0.1-6 clear 1.0 compface 1.4-5 cpio 2.4.2 cron 3.0.1-5 crypt 1.0-1 ctags 5.2-1 curl 7.9.3-1 cvs 1.11.0-1 cygrunsrv 0.94-2 cygutils 0.9.8-1 cygwin 1.3.9-1 dejagnu 20010117-1 diff 0.0 ed 0.2-1 expect 20010117-1 figlet 2.2-1 file 3.37-1 fileutils 4.1-1 findutils 4.1 flex 2.5.4-1 gawk 3.0.4-1 gcc 2.95.3-5 gdb 20010428-3 gdbm 1.8.0-3 gettext 0.10.40-1 ghostscript 6.51-1 gperf 0.0 grep 2.4.2-1 groff 1.17.2-1 gzip 1.3.2-1 indent 2.2.7-2 inetutils 1.3.2-17 irc 20010101-1 jbigkit 1.2-6 jpeg 6b-7 less 358-3 libintl 0.10.38-3 libintl1 0.10.40-1 libncurses5 5.2-1 libncurses6 5.2-8 libpng 1.0.12-1 libpng2 1.0.12-1 libreadline4 4.1-2 libreadline5 4.2a-1 libtool 20010531a-1 libtool-devel 20020202-1 libtool-stable 1.4.2-2 libxml2 2.4.13-1 libxslt 1.0.10-1 links 0.96-1 login 1.4-3 m4 0.0 make 3.79.1-5 man 1.5g-2 mingw-runtime 1.2-1 mktemp 1.4-1 mutt 1.2.5i-6 ncftp 3.0.2-2 ncurses 5.2-8 newlib-man 20001118-1 opengl 1.1.0-5 openssh 3.0.2p1-5 openssl 0.9.6c-3 openssl-devel 0.9.6c-2 patch 2.5-2 pcre 3.7-1 perl 5.6.1-2 popt 1.6.2-1 postgresql 7.1.3-2 python 2.2-1 rcs 5.7-2 readline 4.2a-1 regex 4.4-2 rsync 2.5.2-1 sed 3.02-1 sh-utils 2.0-2 sharutils 4.2.1-2 shutdown 1.2-2 squid 2.4-STABLE20010508 ssmtp 2.38.7-3 tar 1.13.19-1 tcltk 20001125-1 tcsh 6.11.00-3 termcap 20010825-1 terminfo 5.2-1 tetex-beta 20001218-1 texinfo 4.0-5 texmf 20000804-2 texmf-base 20000804-2 texmf-doc 20000804-2 texmf-extra 20000804-2 texmf-tiny 20000804-2 textutils 2.0.16-1 tiff 3.5.7-1 time 1.7-1 units 1.77-1 unzip 5.41-1 vim 6.0.93-1 w32api 1.2-1 wget 1.8-1 which 1.5-1 whois 4.5.17-1 xpm-nox 4.1.0-1 zip 2.3-1 zlib 1.1.3-7 Use -h to see help about each section
Attachment
pgsql-cygwin by date: