Re: Restart after power outage: createdb

[Jim Nasby <jim(at)nasby(dot)net>]

On Sep 26, 2006, at 7:06 AM, Jon Lapham wrote:
> While trying to reproduce power outage restart problem I reported  
> earlier, I have found something odd when pulling the plug on a VM  
> during a createdb operation.
>
> If I run...
> sleep 3; echo starting; createdb bar
> ...and power off the VM while the "createdb bar" is running.
>
> Upon restart, about 50% of the time I can reproduce the following  
> error message:
>
> [lapham(at)localhost ~]$ psql bar
> psql: FATAL:  database "bar" does not exist
> [lapham(at)localhost ~]$ createdb bar
> createdb: database creation failed: ERROR: could not create  
> directory "base/65536": File exists
> [lapham(at)localhost ~]$ createdb bar
> CREATE DATABASE
>
> So, running "createdb bar" a second time works.  This is probably  
> not a bug, but I thought I'd mention it anyway as it could  
> potentially cause problems for people running scripts.

Could this be a timing issue? IE: are you just issuing the first  
createdb bar too soon after the database has started?

I suspect this is a bug...
--
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)