postmaster cygwin1.dll SIGSEGV problem, easy to duplicate. - Mailing list pgsql-cygwin

From Phil Walker
Subject postmaster cygwin1.dll SIGSEGV problem, easy to duplicate.
Date
Msg-id loom.20040422T232559-724@post.gmane.org
Whole thread Raw
List pgsql-cygwin
Has anyone seen the following problem?, it's a show-stopper ...

I can generate this fault with the following command line:

$ psql -f pgbug.sql

Here's a backtrace of the problem:

philwalk@walkerphilip:/usr/src/postgresql-7.4.1-3
$ gdb postgres.exe 3492
GNU gdb 2003-09-20-cvs (cygwin-special)
Copyright 2003 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "i686-pc-cygwin"...
Attaching to program `/usr/bin/postgres.exe', process 3492
[Switching to thread 3492.0xdc0]
(gdb) cont
Continuing.

Program received signal SIGSEGV, Segmentation fault.
[Switching to thread 3492.0x944]
0x6102b0bb in cygwin_internal () from /usr/bin/cygwin1.dll
(gdb) bt
#0  0x6102b0bb in cygwin_internal () from /usr/bin/cygwin1.dll
#1  0x610317f4 in cygwin_internal () from /usr/bin/cygwin1.dll
#2  0x6101e154 in dlfork () from /usr/bin/cygwin1.dll
#3  0x6101deb8 in dlfork () from /usr/bin/cygwin1.dll
#4  0x61094fd1 in getppid () from /usr/bin/cygwin1.dll

# -------------- end --------------

The following snippet of SQL is sufficient to generate this error every time:

BEGIN WORK;
SET CONSTRAINTS ALL DEFERRED;
CREATE TABLE OWL(SUN NUMERIC NOT NULL,SAY NUMERIC NOT NULL);
CREATE TABLE AGO(ADZ NUMERIC NOT NULL,IDE VARCHAR(1024) NOT NULL,ALT VARCHAR
(32) NOT NULL,AUK VARCHAR(32) NOT NULL,POX VARCHAR(32) NOT NULL,CONSTRAINT PAY
UNIQUE(ADZ,AUK));
CREATE TABLE PAN(NUB VARCHAR(10) NOT NULL,EGO VARCHAR(128) NOT NULL,MEW VARCHAR
(32) DEFAULT NULL,COP VARCHAR(32) DEFAULT NULL,CUR NUMERIC DEFAULT 0,FID VARCHAR
(16) DEFAULT NULL,APT NUMERIC DEFAULT 0,GYM NUMERIC DEFAULT 0,SOP VARCHAR(512)
DEFAULT NULL,RAN DATE DEFAULT CURRENT_DATE,LEG VARCHAR(16) DEFAULT NULL,BIG
NUMERIC DEFAULT 0,LUR VARCHAR(32),CONSTRAINT HIE PRIMARY KEY(NUB,EGO));
CREATE TABLE FEW(CAB NUMERIC NOT NULL,DEW VARCHAR(17),AID VARCHAR(32));
CREATE TABLE FEE(SHE NUMERIC,NUN NUMERIC DEFAULT 0,COL VARCHAR(64) NOT NULL,BAN
VARCHAR(256));
CREATE TABLE BEE(KIF VARCHAR(128),EYE VARCHAR(32),LOO VARCHAR(32),SLY VARCHAR
(32),BIN VARCHAR(64),CAW VARCHAR(32),HAM NUMERIC,CAY NUMERIC,GEL NUMERIC,EMS
NUMERIC);
CREATE TABLE DEY(CAB NUMERIC NOT NULL,RAG VARCHAR(32) NOT NULL);
CREATE TABLE GIB(CAB NUMERIC NOT NULL,CAT NUMERIC NOT NULL,POD NUMERIC NOT
NULL,RED NUMERIC NOT NULL);
CREATE TABLE NOG(CEP NUMERIC NOT NULL,HUG NUMERIC NOT NULL,POD NUMERIC NOT
NULL,AIR NUMERIC,RED NUMERIC NOT NULL,IVY NUMERIC,SOY NUMERIC NOT NULL,OVA
VARCHAR(16),DOT CHAR(1) DEFAULT 'N');
CREATE TABLE BAD(DEN VARCHAR(16),AHS VARCHAR(16),ADS VARCHAR(16),EFT VARCHAR
(17),BAT VARCHAR(32),ODS VARCHAR(240),LAR VARCHAR(16),PUT VARCHAR(16),CAD
VARCHAR(240),NUT VARCHAR(240),COY VARCHAR(240),ARK VARCHAR(240));
CREATE TABLE LEA(FIG VARCHAR(16),AHA VARCHAR(16));
CREATE TABLE NIT(CON VARCHAR(16),BIB VARCHAR(240),BUS VARCHAR(16),OWE
NUMERIC,BAT VARCHAR(32),SIC NUMERIC,HAM VARCHAR(240),CONSTRAINT LUX UNIQUE
(CON,BUS,BAT,HAM));
CREATE TABLE JAM(KIF VARCHAR(128) NOT NULL,HUM VARCHAR(80) NOT NULL,ORC VARCHAR
(80) NOT NULL,DAP OID,NIP OID,GAP DATE DEFAULT CURRENT_DATE,ARE DATE DEFAULT
CURRENT_DATE,HEP VARCHAR(10) DEFAULT NULL,SIB VARCHAR(128) DEFAULT NULL,LAG
NUMERIC DEFAULT 0,SEW VARCHAR(16) DEFAULT 'NEW',ORB NUMERIC DEFAULT 0,AWE
NUMERIC DEFAULT 0,HEN VARCHAR(32),LAY VARCHAR(10),KID VARCHAR(128),CONSTRAINT
OHM PRIMARY KEY(KIF),CONSTRAINT AWN UNIQUE(HUM,ORC));
CREATE TABLE ANT(DAW NUMERIC NOT NULL,APE VARCHAR(1024) NOT NULL,AUK VARCHAR
(32) NOT NULL,ADZ NUMERIC NOT NULL);
CREATE TABLE RUN(SAT VARCHAR(32),EAT VARCHAR(10),ALP VARCHAR(128),RHO
NUMERIC,ELK NUMERIC);
CREATE TABLE BUN(SAT VARCHAR(32),EAT VARCHAR(10),ALP VARCHAR(128),JUT NUMERIC);
CREATE TABLE NIL(SAT VARCHAR(32),EAT VARCHAR(10),ALP VARCHAR(128),OKA NUMERIC);
CREATE TABLE PUS(SOL VARCHAR(32),DUE VARCHAR(32),BOA VARCHAR(32),NIX VARCHAR
(32),TAD VARCHAR(32),MIR VARCHAR(16),DAW VARCHAR(32),EAT VARCHAR(10),ALP VARCHAR
(128),ODD NUMERIC,OKA NUMERIC,JAB NUMERIC);
CREATE TABLE REE(BOA VARCHAR(32),RAG VARCHAR(32),MIR VARCHAR(16),GYP VARCHAR
(16),DAW NUMERIC,EAT VARCHAR(10),ALP VARCHAR(128),ODD NUMERIC,MID VARCHAR
(16),LAC VARCHAR(16),BAR VARCHAR(16));
CREATE TABLE JOG(BOA VARCHAR(32),DUE VARCHAR(32),OLM VARCHAR(32),RAG VARCHAR
(32),COX VARCHAR(32),NIM NUMERIC,DAW VARCHAR(32),EAT VARCHAR(10),ALP VARCHAR
(128),DEE VARCHAR(32),ODD NUMERIC,JAG NUMERIC,OKA NUMERIC);
CREATE TABLE QUA(BOA VARCHAR(32),DUE VARCHAR(32),PRO VARCHAR(32),RAG VARCHAR
(32),MIR VARCHAR(16),ONE VARCHAR(16),EAT VARCHAR(10),ALP VARCHAR(128),DEE
VARCHAR(32),ODD NUMERIC,TAM NUMERIC);
CREATE TABLE HUE(BOA VARCHAR(32),DUE VARCHAR(32),PRO VARCHAR(32),RAG VARCHAR
(32),MIR VARCHAR(16),ONE VARCHAR(16),EAT VARCHAR(10),ALP VARCHAR(128),DEE
VARCHAR(32),ODD NUMERIC,TAM NUMERIC);
CREATE TABLE COR(BOA VARCHAR(32),DUE VARCHAR(32),OLM VARCHAR(32),RAG VARCHAR
(32),COX VARCHAR(32),NIM NUMERIC,DAW VARCHAR(32),EAT VARCHAR(10),ALP VARCHAR
(128),DEE VARCHAR(32),ODD NUMERIC,JAG NUMERIC,OKA NUMERIC);
CREATE TABLE KEG(BOA VARCHAR(32),DUE VARCHAR(32),PRO VARCHAR(32),RAG VARCHAR
(32),MIR VARCHAR(16),ONE VARCHAR(16),EAT VARCHAR(10),ALP VARCHAR(128),DEE
VARCHAR(32),ODD NUMERIC,TAM NUMERIC);
CREATE TABLE BUY(BOA VARCHAR(32),DUE VARCHAR(32),PRO VARCHAR(32),RAG VARCHAR
(32),MIR VARCHAR(16),ONE VARCHAR(16),EAT VARCHAR(10),ALP VARCHAR(128),DEE
VARCHAR(32),ODD NUMERIC,TAM NUMERIC);
CREATE TABLE CRY(OKA NUMERIC,NIX VARCHAR(32),FIX VARCHAR(40),EAT VARCHAR
(10),ALP VARCHAR(128),ODD NUMERIC,HUT VARCHAR(32),JOY NUMERIC,BOA VARCHAR
(32),OAT VARCHAR(32));
CREATE TABLE BET(OKA NUMERIC,NIX VARCHAR(32),ROC VARCHAR(32),TAD VARCHAR
(32),MIR VARCHAR(16),DUE VARCHAR(32),EAT VARCHAR(10),ALP VARCHAR(128),ODD
NUMERIC);
CREATE TABLE JAW(EMU NUMERIC,KIF NUMERIC,SUN NUMERIC,FOX VARCHAR(32),HEM VARCHAR
(32),SOD VARCHAR(32),BUR VARCHAR(64),KEA VARCHAR(16),ALB DATE);
CREATE TABLE CAM(EMU NUMERIC,KIF NUMERIC,HID VARCHAR(8),JUT NUMERIC,LOT
NUMERIC,PER VARCHAR(32),FAN NUMERIC,IRE VARCHAR(10) DEFAULT 'None',ALB DATE);
CREATE TABLE BOB(EMU NUMERIC,KIF NUMERIC,FRY VARCHAR(80),OBI VARCHAR(32),SAG
NUMERIC,ALB DATE);
CREATE TABLE AIS(SIT VARCHAR(32),EAT VARCHAR(10),ALP VARCHAR(128),ELK
NUMERIC,RHO NUMERIC);
CREATE TABLE HER(SIT VARCHAR(32),EAT VARCHAR(10),ALP VARCHAR(128),OKA
NUMERIC,COW VARCHAR(16));
CREATE TABLE PEN(BOA VARCHAR(32) NOT NULL,EAT VARCHAR(10) NOT NULL,ALP VARCHAR
(128) NOT NULL,RAG VARCHAR(32),ODD NUMERIC,CONSTRAINT EAR PRIMARY KEY
(BOA,EAT,ALP));
CREATE TABLE DIE(BOA VARCHAR(32),EAT VARCHAR(10),ALP VARCHAR(128),RAG VARCHAR
(32),ODD NUMERIC);



pgsql-cygwin by date:

Previous
From: Christopher Faylor
Date:
Subject: Re: INITDB-error - end-of-copy marker error
Next
From: Maya
Date:
Subject: Error after typing "psql"