Re: invalid OID warning after disk failure

Поиск
Список
Период
Сортировка
От Gabriel Sánchez Martínez
Тема Re: invalid OID warning after disk failure
Дата
Msg-id BE067414-53F5-4BCA-A901-FF7B7570DB7F@gmail.com
обсуждение исходный текст
Ответ на Re: invalid OID warning after disk failure  (Raghu Ram <raghuchennuru@gmail.com>)
Ответы Re: invalid OID warning after disk failure  (Gabriel Sánchez Martínez<gabrielesanchez@gmail.com>)
Список pgsql-general
Дерево обсуждения


On Nov 17, 2014, at 3:28, Raghu Ram <raghuchennuru@gmail.com> wrote:

On Mon, Nov 17, 2014 at 10:20 AM, Gabriel Sánchez Martínez <gabrielesanchez@gmail.com> wrote:

The situation appears to be stable now, but upon running REINDEX and VACUUM on one of the databases, I get the following:

WARNING:  relation "pg_attrdef" TID 1/1: OID is invalid
WARNING:  relation "pg_attrdef" TID 1/2: OID is invalid
WARNING:  relation "pg_attrdef" TID 1/3: OID is invalid
...

Should I drop the database and restore it from a backup?  My most recent backup is from late September, so I would lose some data.  I also backed up what I could as soon as the disks started giving errors, but I don't know if I can trust that.

Should I drop the entire cluster?



are you receiving any kind of error messages,while taking database dump with "pg_dump" utility. 

I am getting these when running vacuum on the live database. Earlier I ran pg_dump. It was not working for the whole database due to I/O errors, so i did a series of more selective dumps, schema by schema and excluding the offending tables, so that I didn't get any errors or warnings. In the live database I dropped the few tables that were responsible for the pg_dump errors.


If you are not receiving any kind of error message,try to take a database dump and restore database dump file in another database server and perform all sanity checks. If all sanity checks are working fine,you can create a new cluster and restore all database dump's.

Thanks & Regards
Raghu Ram
 

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: [general] Encrypting/Decryption
Следующее
От: Brilliantov Kirill Vladimirovich
Дата:
Сообщение: Re: NEW in after insert trugger contained incorrect data