Re: 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