From: Nicola Mauri <nicola.mauri@saga.it>
To: pgsql-admin@postgresql.org
Subject: Crash with data corruption under Windows
Date: Fri, 20 Feb 2009 15:32:16 +0100
Message-ID: <499EBEF0.1010408@saga.it> (raw)
We run into the following issue with Windows 2003 and Postgres 8.2.6
while database was running:
FATAL: "pg_tblspc/16405/37638" is not a valid data directory
DETAIL: File "pg_tblspc/16405/37638/PG_VERSION" is missing.
ERROR: could not open relation 16405/37638/2661: No such file or
directory
ERROR: could not open relation 16405/37638/2659: No such file or
directory
ERROR: could not write block 4 of relation 16405/37638/37656:
Permission denied
CONTEXT: writing block 4 of relation 16405/37638/37656
...
WARNING: could not write block 4 of 16405/37638/37656
DETAIL: Multiple failures --- write error may be permanent.
This happened 4 times in the last few months! Usually after the crash
datafiles appear to be corrupted, but in some other cases they
completely disappear from the filesystem (tablespace directory is empty)
and we have to recreate the entire db from the last dump.
No suspicious activities have been detected on the server (unauthorized
accesses, anti-virus intervention) and information about disappeared
files cannot be found using an undelete utilities. Disk hardware is
healthy and no other part of the filesystem seems to be affected by such
strange deletions (several applications, including an oracle database,
are correctly running on the server).
Since the problem seems involving only directories containing
tablespaces (stored on local partition E:\) we are pointing our
attention to "Reparse Point" and "NTFS Junction" mechanism.
Could be there issues in those features?
Thanks in advance,
Nicola Mauri
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: nicola.mauri@saga.it
Subject: Re: Crash with data corruption under Windows
In-Reply-To: <499EBEF0.1010408@saga.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox