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

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: ERROR: invalid page in block 1226710 of relation base/16750/27244
Дата
Msg-id CAGrpgQ84J6PUzhoKXiOENg5hEq+E3EJf6w7=GzzOi9KCWR8wEw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: invalid page in block 1226710 of relation base/16750/27244  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ERROR: invalid page in block 1226710 of relation base/16750/27244
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: invalid page in block 1226710 of relation base/16750/27244
Следующее
От: Jonathan Vanasco
Дата:
Сообщение: Re: temporary indexes?