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

postmaster cygwin1.dll SIGSEGV problem, easy to duplicate.

From: Phil Walker <phil(dot)walker(at)hp(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: postmaster cygwin1.dll SIGSEGV problem, easy to duplicate.
Date: 2004-04-22 21:34:11
Message-ID: loom.20040422T232559-724@post.gmane.org (view raw or flat)
Thread:
Lists: 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(at)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);




Responses

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2004-04-23 13:11:07
Subject: Re: INITDB-error - end-of-copy marker error
Previous:From: Christopher FaylorDate: 2004-04-22 17:05:13
Subject: Re: INITDB-error - end-of-copy marker error

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