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

From: fous velkej <honza801(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ERROR: invalid page header in block 502758 of relation base/16388/16403
Date: 2009-09-17 14:22:46
Message-ID: 27cffc0909170722r3333533crdca2a38efa86f84f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

there is a database running on xen dom U, but the node (dom0) went down,
we have a cluster, so the other node started the service and there is
nothing that shows any problem
unless i use SELECT on this database/table (this db contains only one table)
there is no backup of the database.
i can't see any solution and if you can't see any solution either, i'm
going to reinit the db
:)

fous

2009/9/17 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> fous velkej <honza801(at)gmail(dot)com> writes:
>> ok, so i did reindexing ending with following error
>> proxylog=# REINDEX TABLE user_record ;
>> ERROR:  concurrent insert in progress
>
> So that page header wasn't the only corrupted data in your database.
> Maybe you'd better take a step back and tell us some context about
> your problem.  I hope you've got recent backups, because if there's
> two different corrupted spots there are probably a lot more.
>
>                        regards, tom lane
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-09-17 14:38:01 Re: BUG #5062: 8.4.1 compile fails on debian can't find libdl
Previous Message philip wright 2009-09-17 14:14:43 BUG #5062: 8.4.1 compile fails on debian can't find libdl