Re: ERROR: invalid page in block 1226710 of relation base/16750/27244 - Mailing list pgsql-general

From bricklen
Subject Re: ERROR: invalid page in block 1226710 of relation base/16750/27244
Date
Msg-id CAGrpgQ84J6PUzhoKXiOENg5hEq+E3EJf6w7=GzzOi9KCWR8wEw@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: invalid page in block 1226710 of relation base/16750/27244  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ERROR: invalid page in block 1226710 of relation base/16750/27244  (bricklen <bricklen@gmail.com>)
List pgsql-general

On Wed, Oct 21, 2015 at 12:52 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
bricklen <bricklen@gmail.com> writes:
> Yes, it is definitely a table. There was originally an index on that table
> which threw the original error (about sibling mismatch). I dropped the
> index and attempted to recreate it, which failed. Further investigation led
> to discovery of corruption in the table.

Hm.  There's still something weird about this though.  Maybe there is no
data at all between pages 1226710 and 690651?  Might be worth doing some
poking around with contrib/pageinspect/.


Ah, good idea.

Thanks again!


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: invalid page in block 1226710 of relation base/16750/27244
Next
From: Jonathan Vanasco
Date:
Subject: Re: temporary indexes?