Re: BUG #4948: getting error while vacuuming the database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4948: getting error while vacuuming the database
Дата
Msg-id 16570.1248789697@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #4948: getting error while vacuuming the database  ("fous" <honza801@gmail.com>)
Ответы Re: BUG #4948: getting error while vacuuming the database
Список pgsql-bugs
"fous" <honza801@gmail.com> writes:
> i'm getting this error while vacuuming the database.

> proxylog=# VACUUM ;
> ERROR:  failed to re-find parent key in index "user_day" for deletion
> target
> page 1441795

> does anoyne know, where the problem is?

Nope.

If you just want to fix it, reindexing that index should do the trick.

If you want us to look into what caused it and whether there's a fixable
bug there, we'll need a whole lot more information than the error
message.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4949: NOT IN is prohibitive slower than the rewrite for medium to large sets
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: issue:pgsql trigger with script file