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:
[EMAIL PROTECTED] ~]$ psql bar
psql: FATAL: database "bar" does not exist
[EMAIL PROTECTED] ~]$ createdb bar
createdb: database creation failed: ERROR: could not create
directory "base/65536": File exists
[EMAIL PROTECTED] ~]$ 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 [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
