Re: could not write block

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(at)archonet(dot)com]
Sent: Wednesday, February 18, 2009 10:31 AM
To: Kopljan Michael
Cc: pgsql-general(at)postgresql(dot)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