| From: | Jon Lapham <lapham(at)jandr(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Restart after power outage: createdb |
| Date: | 2006-09-26 11:06:21 |
| Message-ID: | 451909AD.4080503@jandr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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.
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham <lapham(at)jandr(dot)org> Rio de Janeiro, Brasil
Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harald Armin Massa | 2006-09-26 11:09:35 | Re: Restart after poweroutage |
| Previous Message | Florian Weimer | 2006-09-26 10:56:29 | Re: Deadlock when one process opens two separate connections? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-09-26 11:14:46 | Re: Block B-Tree concept |
| Previous Message | Heikki Linnakangas | 2006-09-26 10:31:08 | Re: Phantom Command ID |