This is the mail archive of the
cygwin
mailing list for the Cygwin project.
PostgreSQL 8.1.2 crashes diring import - 8.0.4 does not
- From: "pobox at verysmall dot org" <pobox at verysmall dot org>
- To: cygwin at cygwin dot com
- Date: Tue, 24 Jan 2006 00:57:37 +0100
- Subject: PostgreSQL 8.1.2 crashes diring import - 8.0.4 does not
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/