Re: BUG #7634: Missing files in global/ after a lot of CREATE DATABASE / DROP DATABASE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: thomas(dot)eckestad(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7634: Missing files in global/ after a lot of CREATE DATABASE / DROP DATABASE
Date: 2012-11-01 22:33:17
Message-ID: 9246.1351809197@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

thomas(dot)eckestad(at)gmail(dot)com writes:
> After a couple of days/weeks with frequent unit test activity DROP DATABASE
> eventually triggers errors on the following form:

> 2012-05-08 08:53:02.512 CEST> LOG: statement: DROP DATABASE IF EXISTS
> "HEAD_test_migrate_group_data_10010018668"
> 2012-05-08 08:53:02.512 CEST> ERROR: could not open file "global/12693": No
> such file or directory
> 2012-05-08 08:53:02.512 CEST> STATEMENT: DROP DATABASE IF EXISTS
> "HEAD_test_migrate_group_data_10010018668"

FWIW, I ran about 40000 cycles of CREATE/DROP DATABASE on 9.1 branch tip
without seeing anything odd. So it's fairly clear that there's
something you've not mentioned that's necessary to trigger this.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Eckestad 2012-11-02 09:58:24 Re: BUG #7634: Missing files in global/ after a lot of CREATE DATABASE / DROP DATABASE
Previous Message Marko Tiikkaja 2012-11-01 22:05:57 Re: BUG #7635: psql -1 and \connect