Received: from netcom15.netcom.com (zalman@netcom15.netcom.com [192.100.81.128]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA29092 for ; Tue, 22 Jun 1999 01:21:52 -0400 (EDT) (envelope-from zalman@netcom.com) Received: (from zalman@localhost) by netcom15.netcom.com (8.8.5-r-beta/8.8.5/(NETCOM v1.02)) id WAA27197 for pgsql-sql@postgreSQL.org; Mon, 21 Jun 1999 22:21:49 -0700 (PDT) From: Zalman Stern Message-Id: <199906220521.WAA27197@netcom15.netcom.com> Subject: Create table doesn't always respect atomicity of transactions. To: pgsql-sql@postgreSQL.org Date: Mon, 21 Jun 1999 22:21:48 -0700 (PDT) X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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-