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:

Previous
From: 오피스프라자
Date:
Subject: 라벨S/W 무료!!(새우편번호 자동입력) [홍보]
Next
From:
Date:
Subject: help