OS : Windows Server 2003
PostgreSQL : 8.2.4
Installed with Windows installer.
On server is installed NOD32 (2.7).
-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
Sent: Wednesday, February 18, 2009 10:31 AM
To: Kopljan Michael
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] could not write block
Kopljan Michael wrote:
> recently appears to me the following error :
*ALWAYS* with this sort of thing you need to supply the following
information:
1. Operating system
2. Version of PostgreSQL
3. How you installed it (compiled from source, windows installer, ubuntu
package etc).
Oh - and if you're getting *any* error the first thing you want to do is
check that your backups are working.
> could not write block 86 of relation 1663/121027/151994: Invalid
> argument
>
> What is that error and how to fix this?
Well, it means that the backend couldn't write to the indicated block
(86) in a particular file. The next three numbers should be oid or filenode
for the tablespace, database and table/index in question. Try looking for
121027 and 151994 in the following two queries.
SELECT oid,datname FROM pg_database WHERE oid = 121027; SELECT
oid,relfilenode,relname FROM pg_class WHERE oid=151994 OR relfilenode =
151994;
Now "Invalid argument" looks like an odd error to get - I could understand
something like "permission denied" or "block doesn't exist".
This leads me to suspect two things:
1. You are running on Windows
2. You have an anti-virus/security package running
If these aren't true, I'd guess you'd had a crash or power failure recently.
Once we know what table/index it is we can try clustering/reindexing it to
reproduce the error (remember to check your backups first!).
--
Richard Huxton
Archonet Ltd
__________ Information from ESET Smart Security, version of virus signature
database 3863 (20090218) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature
database 3863 (20090218) __________
The message was checked by ESET Smart Security.
http://www.eset.com