Search Postgresql Archives

Re: What should I do with this: invalid page header in block ... ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Gianni Mariani <gianni@xxxxxxxxxx> writes:
> I suspect the error below is bad. - Running 8.0.1 on linux FC3 on AMD 64.

> septicide=# delete from sp_log where sp_log_time < (now() - interval '7 
> days')::abstime;
> DELETE 215822
> septicide=# vacuum full analyze;
> ERROR:  invalid page header in block 5991 of relation "sp_log_idx2"

It is bad ... but if that is just an index, as one would guess from the
name, then a REINDEX should fix it.

After that you might want to think about running some disk and memory
diagnostics.  If the same thing happens to one of your tables it won't
be so easy to repair :-(

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux