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