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
|
Список | 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 по дате отправления: