From: | "Walker, Philip M (Utility Data Center)" <phil(dot)walker(at)hp(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | SIGSEGV is reproducible in cygwin, but not elsewhere; where do I report this bug? |
Date: | 2004-04-23 12:59:13 |
Message-ID: | C9AAAF1DB2411546B68C720B0D0630CB202154@ataexc01.americas.cpqcorp.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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);
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Tishler | 2004-04-23 13:11:07 | Re: INITDB-error - end-of-copy marker error |
Previous Message | Hans Forbrich | 2004-04-23 12:13:04 | Re: How configure Oracle 9i not case sensitive... |