Hi List, I have another error now here:

notice that only one backend is dying, all others are up and working.

Error - Message :

duplicate key violates unique constraint "ferber_rust_params_pkey"
FATAL:  block 0 of 1663/19335/476756 is still referenced (local 2)
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while


here is a sample script causing this server-crash (simple cut and paste)

BEGIN;

CREATE SEQUENCE dbridseq;

  CREATE TABLE ferber_rust_params
   (fbrp_id		SERIAL PRIMARY KEY,
    fbrp_pos		INTEGER,	  	
    fbrp_ferber		VARCHAR(20),
    fbrp_descr		VARCHAR(80) NOT NULL,
    fbrp_name		VARCHAR(10) NOT NULL,
    fbrp_default		FLOAT4,
    fbrp_formula		VARCHAR(100),
    dbrid		VARCHAR UNIQUE DEFAULT nextval('dbridseq')
   );


INSERT INTO ferber_rust_params (fbrp_id, fbrp_pos, fbrp_ferber, 
fbrp_descr, fbrp_name, fbrp_default, fbrp_formula, dbrid) VALUES (6, 4, 
'BSRUND', 'Vorschub aus Tabelle', 'vorschub', 360, 
'vorschub-(vorschub/100*40)', '337941');


SELECT * INTO TEMP TABLE ferber_rus_205102 FROM ferber_rust_params WHERE 
fbrp_ferber='BSRUND';
UPDATE ferber_rus_205102 SET fbrp_name='BSRUND1';
ALTER TABLE ferber_rus_205102 DROP COLUMN dbrid;
INSERT INTO ferber_rust_params SELECT * FROM ferber_rus_205102;

ROLLBACK;

PS : Running Windows XP Home.


Daniel
Tue, 07 Sep 2004 21:06:48 +0200
Daniel Schuchardt <daniel_schuchardt@web.de>
beta 2 crash with unique constraints
Daniel Schuchardt <daniel_schuchardt@web.de> writes:
> duplicate key violates unique constraint "ferber_rust_params_pkey"
> FATAL:  block 0 of 1663/19335/476756 is still referenced (local 2)
> server closed the connection unexpectedly

This is already fixed, but thanks for the report!

			regards, tom lane

Sat, 11 Sep 2004 11:58:39 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: beta 2 crash with unique constraints 