X-Spam-Check-By: sourceware.org Message-ID: <43D56D71.8050008@verysmall.org> Date: Tue, 24 Jan 2006 00:57:37 +0100 From: "pobox AT verysmall DOT org" User-Agent: Thunderbird 1.6a1 (Windows/20060119) MIME-Version: 1.0 To: cygwin AT cygwin DOT com Subject: PostgreSQL 8.1.2 crashes diring import - 8.0.4 does not Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-IsSubscribed: yes Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner AT cygwin DOT com Mail-Followup-To: cygwin AT cygwin DOT com Delivered-To: mailing list cygwin AT cygwin DOT com I am not sure if this is relevant for here, but as cygserver is involved, I thought it might be interesting. PostgreSQL 8.1.2 crashes during import (postmaster loses connection to cygserver, details below) and 8.0.4 does the same import without problem (all versions since 7.4, if I am not wrong, worked fine with the same database). Both 8.1.2 and 8.0.4 are compiled from source (./configure make make install). PostgreSQL 8.1.2 crashes again and again on the same place (somewhere around the end of the import, after heavy indexes). Clean cygwin install did not help. Increased configuration options (quoted below) of cygserver did not help. Database is 3-4 GB imported, with indexes. Does anyone have an idea what can it be? Thanks, Iv -- psql last messages: psql:db.sql:10372960: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. psql:db.sql:10372960: connection to server was lost -- postmaster last messages: 9 [main] postmaster 656 transport_layer_pipes::connect: lost connection to cygserver, error = 121 LOG: server process (PID 656) was terminated by signal 12 LOG: terminating any other active server processes LOG: all server processes terminated; reinitializing LOG: database system was interrupted at 2006-01-24 00:18:13 LOG: checkpoint record is at 1/5D901490 LOG: redo record is at 1/5D901490; undo record is at 0/0; shutdown FALSE LOG: next transaction ID: 2340; next OID: 31154176 LOG: next MultiXactId: 1; next MultiXactOffset: 0 LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 1/5D9014D8 LOG: record with zero length at 1/5D916268 LOG: redo done at 1/5D916218 LOG: database system is ready LOG: transaction ID wrap limit is 2147484146, limited by database "postgres" -- cygserver.conf # cygserver.conf, Copyright(C) 2003, 2005 Red Hat Inc. # # Contains configurable parameters for the cygserver. # # The format of this file is easy. Lines beginning with a hash `#' are # comments and ignored. Lines consisting of only whitespaces are ignored. # Any other line is a setting for cygserver. # A setting consists of a name/value pair, separated by whitespace. # Each line must only consist of one name/value pair. # Lines must not be longer than 1023 characters. # # Some settings can be overridden by a command line switch. If so, it's # mentioned below. # # Settings which are commented out will use the default values. These are # mentioned below, too. # kern.srv.cleanup_threads: No. of cygserver threads used for cleanup tasks. # Default: 2, Min: 1, Max: 16, command line option -c, --cleanup-threads #kern.srv.cleanup_threads 2 # kern.srv.request_threads: No. of cygserver threads used to serve # application requests. # Default: 10, Min: 1, Max: 310, command line option -r, --request-threads #kern.srv.request_threads 10 # kern.srv.process_cache_size: No. of concurrent processes which can be handled # by Cygserver concurrently. # Default: 62, Min: 1, Max: 310, command line option -p, --process-cache #kern.srv.process_cache_size 62 # kern.srv.msgqueues: Determines whether XSI Message Queue support should be # started, "yes" (or "true", "y", "t", "1") or "no" (or "false", "n", "f", "0"). # These values are valid for all binary type options. # Default is "yes". Command line option -q, --no-msgqueues #kern.srv.msgqueues yes # kern.srv.semaphores: Determines whether XSI Semaphore support should be # started. Default is "yes". Command line option -s, --no-semaphores #kern.srv.semaphores yes # kern.srv.sharedmem: Determines whether XSI Shared Memory support should be # started. Default is "yes". Command line option -m, --no-sharedmem #kern.srv.sharedmem yes # LOGGING # kern.log.syslog: Determines whether logging should go to the syslog, # Default is "yes", if stderr is no tty, "no" otherwise. # Command line option -y, --syslog or -Y, --no-syslog. #kern.log.syslog no # kern.log.stderr: Determines whether logging should go to stderr, # Default is "yes", if stderr is a tty, "no" otherwise. # Command line option -e, --stderr or -E, --no-stderr. #kern.log.stderr no # kern.log.level: Logging level. Valid values are 1 to 7 with a bigger # value emitting more logging output. Default level is 6. # Command line option -l, --log-level. #kern.log.level 6 # kern.log.debug: Determines whether debug output should be printed to stderr. # Default is "no". Command line option -d, --debug #kern.log.debug no # XSI message queue parameters. # # Each message is broken up and stored in segments that are msgssz bytes # long. For efficiency reasons, this should be a power of two. Also, # it doesn't make sense if it is less than 8 or greater than about 256. # kern.ipc.msgseg: Maximum no. of message queue segments hold concurrently. # Default: 2048, Min: 256, Max: 65535 #kern.ipc.msgseg 2048 # kern.ipc.msgssz: Size of segment in bytes. Must be a power of 2 value. # Default: 8, Min: 8, Max: 1024 #kern.ipc.msgssz 8 # kern.ipc.msgmnb: Maximum no. of bytes in a single message queue. # Default: 2048, Min: 1, Max: 65535 #kern.ipc.msgmnb 2048 # kern.ipc.msgmni: Maximum no. of message queue identifiers hold concurrently. # Default: 40, Min: 1, Max: 1024 #kern.ipc.msgmni 40 # kern.ipc.msgtql: Maximum no. of messages hold concurrently. # Default: 40, Min: 1, Max: 1024 #kern.ipc.msgtql 40 # XSI semaphore parameters # kern.ipc.semmni: Maximum no. of semaphore identifiers hold concurrently. # Default: 10, Min: 1, Max: 1024 kern.ipc.semmni 1024 # kern.ipc.semmns: Maximum no. of semaphores hold concurrently. # Default: 60, Min: 1, Max: 1024 kern.ipc.semmns 1024 # kern.ipc.semmnu: Total no. of undo structures hold by server. # Default: 30, Min: 1, Max: 1024 kern.ipc.semmnu 1024 # kern.ipc.semmsl: Maximum no. of semaphores per semaphore id. # Default: 60, Min: 1, Max: 1024 kern.ipc.semmsl 1024 # kern.ipc.semopm: Maximum no. of operations per semop call. # Default: 100, Min: 1, Max: 1024 kern.ipc.semopm 1024 # kern.ipc.semume: Maximum no. of undo entries per process. # Default: 10, Min: 1, Max: 1024 kern.ipc.semume 1024 # kern.ipc.semvmx: Maximum value of a semaphore. # Default: 32767, Min: 1, Max: 32767 #kern.ipc.semvmx 32767 # kern.ipc.semaem: Maximum value to adjust on process exit. # Default: 16384, Min: 1, Max: 32767 #kern.ipc.semaem 16384 # XSI shared memory parameters # kern.ipc.shmmaxpgs: Maximum pages available for XSI shared memory. # Changing shmmaxpgs immediately affects setting SHMMAX. The relation # between shmmaxpgs and SHMMAX is: SHMMAX = shmmaxpgs * getpagesize(). # Default: 8192, Min: 1, Max: 32767 kern.ipc.shmmaxpgs 32767 # kern.ipc.shmmni: Maximum number of shared memory segments, system wide. # Default: 192, Min: 1, Max: 32767 kern.ipc.shmmni 32767 # kern.ipc.shmseg: Maximum number of shared memory segments per process. # Default: 128, Min: 1, Max: 32767 kern.ipc.shmseg 32767 -- $ cygcheck -c Cygwin Package Information Package Version Status _update-info-dir 00348-1 OK alternatives 1.3.20a-2 OK ash 20040127-3 OK autoconf 2.59-2 OK autoconf2.1 2.13-1 OK autoconf2.5 2.59-2 OK automake1.9 1.9.6-1 OK base-files 3.6-1 OK base-passwd 2.2-1 OK bash 3.0-14 OK binutils 20050610-1 OK bison 20030307-1 OK bzip2 1.0.3-1 OK coreutils 5.93-2 OK crypt 1.1-1 OK cygrunsrv 1.12-1 OK cygutils 1.2.9-1 OK cygwin 1.5.19-4 OK cygwin-doc 1.4-3 OK diffutils 2.8.7-1 OK editrights 1.01-1 OK expat 1.95.8-1 OK file 4.16-1 OK findutils 4.2.27-1 OK flex 2.5.4a-3 OK fontconfig 2.2.2-1 OK freetype2 2.1.9-1 OK gawk 3.1.5-2 OK gcc 3.4.4-1 OK gcc-core 3.4.4-1 OK gcc-g++ 3.4.4-1 OK gcc-mingw-core 20050522-1 OK gcc-mingw-g++ 20050522-1 OK gcc-testsuite 3.4.4-1 OK gd 2.0.33-1 OK gdbm 1.8.3-7 OK gettext 0.14.5-1 OK ghostscript 8.15-2 OK ghostscript-base 8.15-2 OK grep 2.5.1a-2 OK groff 1.18.1-2 OK gzip 1.3.5-1 OK keychain 2.5.3.1-1 OK less 381-1 OK libapr0 0.9.7-1 OK libaprutil0 0.9.7-1 OK libbz2_1 1.0.3-1 OK libcharset1 1.9.2-2 OK libdb4.2 4.2.52-1 OK libdb4.3 4.3.28-1 OK libfontconfig1 2.2.2-1 OK libfreetype26 2.1.9-1 OK libgd2 2.0.33-1 OK libgdbm 1.8.0-5 OK libgdbm-devel 1.8.3-7 OK libgdbm3 1.8.3-3 OK libgdbm4 1.8.3-7 OK libiconv 1.9.2-2 OK libiconv2 1.9.2-2 OK libintl 0.10.38-3 OK libintl1 0.10.40-1 OK libintl2 0.12.1-3 OK libintl3 0.14.5-1 OK libjpeg62 6b-11 OK libltdl3 1.5.20-2 OK libncurses-devel 5.4-4 OK libncurses5 5.2-1 OK libncurses6 5.2-8 OK libncurses7 5.3-4 OK libncurses8 5.4-4 OK libneon24 0.24.7-2 OK libpcre0 6.3-1 OK libpng12 1.2.8-2 OK libpopt0 1.6.4-4 OK libreadline4 4.1-2 OK libreadline5 4.3-5 OK libreadline6 5.1-1 OK libtool1.5 1.5.20-2 OK libXft 2.1.6-1 OK libXft1 1.0.0-1 OK libXft2 2.1.6-1 OK libxml 1.8.17-2 OK libxml2 2.6.22-1 OK libxml2-devel 2.6.22-1 OK login 1.9-7 OK m4 1.4.4-1 OK make 3.80-1 OK man 1.5p-1 OK mingw-runtime 3.9-2 OK minires 1.00-1 OK mktemp 1.5-3 OK ncurses 5.4-4 OK openssh 4.2p1-1 OK openssl 0.9.8a-1 OK openssl097 0.9.7i-1 OK pcre 6.3-1 OK pcre-devel 6.3-1 OK pcre-doc 6.3-1 OK perl 5.8.7-5 OK readline 5.1-1 OK rsync 2.6.6-1 OK run 1.1.6-1 OK sed 4.1.4-1 OK subversion 1.2.3-1 OK tar 1.15.1-3 OK termcap 20050421-1 OK terminfo 5.4_20041009-1 OK texinfo 4.8-1 OK unzip 5.50-5 OK vim 6.4-4 OK w32api 3.6-1 OK which 1.7-1 OK whois 4.7.11-1 OK X-startup-scripts 1.0.11-1 OK xorg-x11-base 6.8.2.0-1 OK xorg-x11-bin 6.8.2.0-1 OK xorg-x11-bin-dlls 6.8.2.0-1 OK xorg-x11-bin-lndir 6.8.2.0-1 OK xorg-x11-etc 6.8.2.0-1 OK xorg-x11-fenc 6.8.1.0-2 OK xorg-x11-fnts 6.8.1.0-3 OK xorg-x11-libs-data 6.8.2.0-1 OK xorg-x11-xwin 6.8.2.0-4 OK xterm 202-1 OK zip 2.3-6 OK zlib 1.2.3-1 OK -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/