Re: 9.0.4 Data corruption issue

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 9.0.4 Data corruption issue
Дата
Msg-id 27386.1310831992@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 9.0.4 Data corruption issue  (Ken Caruso <ken@ipl31.net>)
Ответы Re: 9.0.4 Data corruption issue  (Ken Caruso <ken@ipl31.net>)
Список pgsql-admin
Ken Caruso <ken@ipl31.net> writes:
> Had a DB that had bloated due to lots of updates and insuffcient auto vacuum
> settings. Attempted the following in the following order:

> VACUUM VERBOSE full tablename;
> CLUSTER tablename;

> Did the full first to ensure that the cluster had enough space to run.
> The db had already been previously clustered to an index. At some point
> during the VACUUM I started seeing the following errors in the logs:

>  CONTEXT:  writing block 12125253 of relation base/2651908/652397108

>  WARNING:  could not write block 12125253 of base/2651908/652397108

>  DETAIL:  Multiple failures --- write error might be permanent.

Ummm .... what's the actual ERROR?

            regards, tom lane

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

Предыдущее
От: Ken Caruso
Дата:
Сообщение: Re: 9.0.4 Data corruption issue
Следующее
От: Ken Caruso
Дата:
Сообщение: Re: 9.0.4 Data corruption issue