Re: ERROR: invalid page header in block 502758 of relation base/16388/16403

From: fous velkej <honza801(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ERROR: invalid page header in block 502758 of relation base/16388/16403
Date: 2009-09-16 14:35:38
Message-ID: 27cffc0909160735u5b8b3a65x9cb65d8d9a9bc751@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

ok, fault on my side

this is maybe better code
dd if=16403.3.orig of=16403.3 bs=8192 count=109542
dd if=/dev/zero bs=8192 count=1 >> 16403.3
dd if=16403.3.orig skip=109543 bs=8192 >> 16403.3

but now, it says
ERROR: index "day" contains unexpected zero page at block 502758
HINT: Please REINDEX it.

ok, so i did reindexing ending with following error
proxylog=# REINDEX TABLE user_record ;
ERROR: concurrent insert in progress

what should i do now?
i think it's not the problem of hw

thanks for help
fous

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-09-16 14:36:17 Re: strange bug with gist over box and circle
Previous Message Tom Lane 2009-09-16 14:01:13 Re: ERROR: invalid page header in block 502758 of relation base/16388/16403