transaction block: server closed the connection unexpectedly

From: "Koju Iijima" <koju(at)fast(dot)fujitsu(dot)com(dot)au>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: transaction block: server closed the connection unexpectedly
Date: 2004-09-06 06:41:32
Message-ID: 015601c493dc$8cf71df0$b44bac89@maheshs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi

While testing 8.0's transaction mechanism, I encountered this error:
(I can reproduce this error with the latest cvs codes)

========================================================================
Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

template1=# BEGIN;
BEGIN
template1=# CREATE TABLE FOO ( a int unique);
NOTICE: CREATE TABLE / UNIQUE will create implicit index "foo_a_key" for
table
"foo"
CREATE TABLE
template1=# INSERT INTO FOO VALUES ( 0 );
INSERT 17232 1
template1=# INSERT INTO FOO VALUES ( 0 );
ERROR: duplicate key violates unique constraint "foo_a_key"
FATAL: block 1 of 1663/1/17230 is still referenced (private 1, global 1)
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
template1=#
========================================================================

This error cann't be reproduced If the CREATE TABLE is called outside the
transaction block.

Regards

koju

----------------------------------------------------------------------------
---
Koju Iijima

Software Engineer
Fujitsu Australia Software Technology
Address: 14 Rodborough Road, Frenchs Forest NSW 2086
Tel: +61 2 9452 9076
Fax: +61 2 9975 2899
Email: koju(at)fast(dot)fujitsu(dot)com(dot)au
Web site: www.fastware.com
----------------------------------------------------------------------------
---

This is an email from Fujitsu Australia Software Technology Pty Ltd, ABN 27 003 693 481. It is confidential to the ordinary user of the email address to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you.

If you do not wish to receive commercial email messages from Fujitsu Australia Software Technology Pty Ltd, please email unsubscribe(at)fast(dot)fujitsu(dot)com(dot)au

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-09-06 13:05:57 BUG #1239: Stale postmaster.pid prevents server start
Previous Message Tom Lane 2004-09-06 02:04:39 Re: Permissions problem with sequences