Unexpected VACUUM FULL failure

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Unexpected VACUUM FULL failure
Дата
Msg-id 10095.1186619320@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: Unexpected VACUUM FULL failure
Список pgsql-hackers
This is a bit disturbing:

*** ./expected/vacuum.out    Sat Jul 20 00:58:14 2002
--- ./results/vacuum.out    Wed Aug  8 20:16:45 2007
***************
*** 50,55 ****
--- 50,56 ----  DELETE FROM vactst WHERE i != 0; VACUUM FULL vactst;
+ ERROR:  HEAP_MOVED_OFF was expected DELETE FROM vactst; SELECT * FROM vactst;  i 

======================================================================

This is today's CVS HEAD, plus some startup/shutdown logic changes in
postmaster.c that hardly seem like they could be related.

I couldn't reproduce it in a few tries.  A reasonable guess is that
it's triggered by autovacuum deciding to vacuum the table sometime
before the VACUUM FULL starts.  Anyone want to try to reproduce it?
        regards, tom lane


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

Предыдущее
От: Gustavo Tonini
Дата:
Сообщение: Re: comunication protocol
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: GUC for default heap fillfactor