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

backend closed the channel unexpectedly

From: David Wetzel <dave(at)turbocat(dot)de>
To: pgsql-hackers(at)postgreSQL(dot)org, pgsql-ports(at)postgreSQL(dot)org
Cc: gerald(at)lucky(dot)turbocat(dot)de
Subject: backend closed the channel unexpectedly
Date: 1999-05-12 00:37:16
Message-ID: 199905120037.CAA01218@cat.turbocat.de (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-ports
Hi,

I have found a bug that is very easy to reprouduce here:

The table is created with this code:

create table DIAGNOSE (ART varchar(1) NOT NULL, AUFENTHALTNR int NOT NULL,  
CREATION_DATE datetime, CREATION_USER varchar(30), DAUERDIAGNOSENR int NOT  
NULL, MODIFICATION_DATE datetime, MODIFICATION_USER varchar(30), NR int NOT  
NULL, OPNR int, TEXT varchar(250) NOT NULL, VERWEILDAUER int, ZEIT datetime);

CREATE UNIQUE INDEX DIAGNOSE_NR ON DIAGNOSE (NR);

Then create a file that contains 100 000 times this line and save it as  
/tmp/DBTEST.sql:

INSERT INTO  DIAGNOSE (CREATION_DATE, CREATION_USER, VERWEILDAUER, ART,  
TEXT, AUFENTHALTNR, NR, OPNR, DAUERDIAGNOSENR, MODIFICATION_USER,  
MODIFICATION_DATE, ZEIT)  VALUES  ('Fri May 07 21:10:52 1999 CEST', 'USER',  
NULL, 'X', 'Noch nicht eingegeben', 71108, 316707, NULL, 0, 'USER', 'Fri May  
07 21:10:52 1999 CEST', 'Fri May 07 21:10:52 1999 CEST');


Then do

psql -q -f /tmp/DBTEST.sql mydb

Wait.

The error messages are ok. But not the closing of the backend!

Is this bug known? Are there any patches out? I use postgresql-6.4.2 on NetBSD.

NOTE: I have only subscribed pgsql-ports(at)postgreSQL(dot)org

---
   _  _
 _(_)(_)_  David Wetzel, Turbocat's Development,
(_) __ (_) Buchhorster Strasse, D-16567 Muehlenbeck/Berlin, FRG,
  _/  \_   Fax +49 33056 82835 NeXTmail dave(at)turbocat(dot)de
 (______)  http://www.turbocat.de/
           DEVELOPMENT * CONSULTING * ADMINISTRATION

pgsql-ports by date

Next:From: rootDate: 1999-05-12 14:34:42
Subject: new user
Previous:From: Andrew MerrillDate: 1999-05-11 17:19:03
Subject: new SCO installation FAQ

pgsql-hackers by date

Next:From: Tatsuo IshiiDate: 1999-05-12 00:57:54
Subject: Re: [HACKERS] 6.5 TODO list
Previous:From: Chris BitmeadDate: 1999-05-12 00:12:26
Subject: Re: [HACKERS] Date/Time Flaw in pg_dump ?

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