Create table doesn't always respect atomicity of transactions.

From: Zalman Stern <zalman(at)netcom(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Create table doesn't always respect atomicity of transactions.
Date: 1999-06-22 05:21:48
Message-ID: 199906220521.WAA27197@netcom15.netcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Off and on, I've been seeing a situation where the following code:
begin;
create table foo (name text);
abort; leaves a file called "foo" in the database directory and
further attempts to create a relation called foo or to select anything from
it all fail. The database has been left in an inconsistent state.

I filed a bug report on this earlier today as it seemed dead on repeatable.
But then I recompiled with debug symbols to have a go at figuring out what
was up and the problem went away. So I recompiled with full optimization
again and the problem still doesn't occur now. I've been starting over each
time with a fresh database so if it was some property of the database
itself, then that state is lost. But this is not the first time I've seen
this. Has any one else seen such a thing? Its rather troublesome 'cause when
it does happen, the database is somewhat unuseable until I remove the file
in question and I hate going in and removing files that are supposed to be
under Postgres' control...

Glancing at the code, I'm wondering if it is possible for a database to get
stuck in "bootstrap mode." It looks like that would cause problems with
transactions not properly unlink'ing files. Though I haven't scoped out the
details of that...

-Z-

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message José Soares 1999-06-22 06:37:53 Re: [SQL] ODBC SQL question
Previous Message Hostmaster - Internet au Virtuel Inc. 1999-06-22 00:12:36 ODBC SQL question