PANIC during VACUUM

Поиск
Список
Период
Сортировка
От German Becker
Тема PANIC during VACUUM
Дата
Msg-id CALyjCLs0iswbroQtucQWeL+CcGGac0t8iq1yx1Sa8Xti=O3yeg@mail.gmail.com
обсуждение исходный текст
Ответы Re: PANIC during VACUUM
Список pgsql-admin
Hi,

I am testing version 9.1.9 before putting it in production. One of my tests involved deleting a the contents of a big table ( ~ 13 GB size) and then VACUUMing it. During VACUUM PANICS. Here is the message:

PANIC:  corrupted item pointer: offset = 8128, size = 80

I found the error a couple of times, allways during VACUUM after deleting the context of the same big table (after re-polpulating it of course).

The error message is always *exactly* the same i.e. the same offset and size.

When this happens the backend gets restarted and if I issue the same VACUUM command, I get the same error. 

I also tried triggering the backup server (hot-standby with streaming replication, and trying the VACUUM there (to see if it may be a hardware problem in the primary) and got the same issue.

What might be causing this? Should I reported as a bug? Thanks!

--
Germán

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

Предыдущее
От: "David F. Skoll"
Дата:
Сообщение: Re: archive falling behind
Следующее
От: Isabella Ghiurea
Дата:
Сообщение: Re: Postgresql Courses