server process was terminated by signal 11 (easy to duplicate)

From: "Walker, Philip M" <phil(dot)walker(at)hp(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: server process was terminated by signal 11 (easy to duplicate)
Date: 2004-04-13 17:06:04
Message-ID: C9AAAF1DB2411546B68C720B0D0630CB202127@ataexc01.americas.cpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Cygwin Postgres 7.4

I have a sql file that crashes all server process when issued via the
command line:

$ psql -f pgbug.sql

The problem does not occur in Linux, but has been duplicated on the
following systems:

Laptop(Mobile CPU 1.8 Ghz Pentium 4, 768 MB Dram) running XP
Professional Service Pack 1

Intel Xeon 1.6Ghz, 5.8 GB Dram (8 Processors) running Windows 2000
5.00.2195 Service pack 4

I've also rolled back one minor revision level, same thing. Also built
from sources, no change.

Here's the logfile:

Unfortunately, the SQL file required to duplicate the problem is
54Kbytes, so I can't attach it here.
Will send copies if requested ...

Thanx in advance, if someone recognizes this ...
Phil Walker

LOG: shmdt(0xeb0000) failed: Invalid argument
LOG: database system was shut down at 2004-04-13 07:23:15 MDT
LOG: checkpoint record is at 0/E26970
LOG: redo record is at 0/E26970; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 575; next OID: 49910
FATAL: the database system is starting up
LOG: database system is ready
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"adventitiousness" for table "acknowledgement"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"administratorships" for table "administratorship"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"blasphemousness" for table "boustrophedonic"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"circumambulating" for table "characterizations"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"circumambulation" for table "characterizations"
LOG: server process (PID 3336) was terminated by signal 11
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2004-04-13 07:23:33 MDT
LOG: checkpoint record is at 0/E26970
LOG: redo record is at 0/E26970; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 575; next OID: 49910
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 0/E269B0
LOG: invalid magic number 0000 in log file 0, segment 0, offset
15769600
LOG: redo done at 0/F09F48
LOG: database system is ready
LOG: received smart shutdown request
LOG: shutting down
LOG: database system is shut down

Browse pgsql-cygwin by date

  From Date Subject
Next Message Wayne Phillips 2004-04-13 19:42:22 shutting down ipc-daemon2?
Previous Message Jason Tishler 2004-04-13 12:04:34 Re: CVS HEAD