Re: ERROR: invalid page in block 1226710 of relation base/16750/27244

From: bricklen <bricklen(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: invalid page in block 1226710 of relation base/16750/27244
Date: 2015-10-21 19:55:08
Message-ID: CAGrpgQ84J6PUzhoKXiOENg5hEq+E3EJf6w7=GzzOi9KCWR8wEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 21, 2015 at 12:52 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> bricklen <bricklen(at)gmail(dot)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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Vanasco 2015-10-21 20:28:53 Re: temporary indexes?
Previous Message Tom Lane 2015-10-21 19:52:08 Re: ERROR: invalid page in block 1226710 of relation base/16750/27244