Re: select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619

Поиск
Список
Период
Сортировка
От Kim Applegate
Тема Re: select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619
Дата
Msg-id CAL7VFcJYBiVLjAiXqwdAWw9noeef2tM0bj-=w_2um6b6RacA6Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: select table indicate missing chunk number 0 for toast value96635 in pg_toast_2619  (David Rennalls <drennalls@gmail.com>)
Ответы Re: select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619  (David Rennalls <drennalls@gmail.com>)
Список pgsql-bugs
I have seen this issue on a slave although it was in version 9.2.  I ran
this

select 2619::regclass;
   regclass
--------------
 pg_statistic
(1 row)


I was able to fix my select issue by running analyze on the database




On Thu, Sep 26, 2013 at 11:47 AM, David Rennalls <drennalls@gmail.com>wrote:

> David Fetter <david <at> fetter.org> writes:
> >
> > Upgrade to 9.1.3 and let us know whether that fixes the problem.
>
> I've run into this issue as well on postgres 8.4.14. Aside from upgrading
> to a
> newer release is there any manual fixup that can be done ?
>
> Thanks,
>      David
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

В списке pgsql-bugs по дате отправления:

Предыдущее
От: David Rennalls
Дата:
Сообщение: Re: select table indicate missing chunk number 0 for toast value96635 in pg_toast_2619
Следующее
От: David Rennalls
Дата:
Сообщение: Re: select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619