Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-cygwin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group