Re: ERROR on database index
От | Laurenz Albe |
---|---|
Тема | Re: ERROR on database index |
Дата | |
Msg-id | 38eda5604f0e1c46b9970847061b97a98a4d2513.camel@cybertec.at обсуждение исходный текст |
Ответ на | ERROR on database index (Frank Alberto Rodriguez <franknigth@gmail.com>) |
Ответы |
Re: ERROR on database index
|
Список | pgsql-novice |
Frank Alberto Rodriguez wrote: > This morning the logs are showing me this error when I make a connection with > an specific database. > > [ > ERROR: index "pg_proc_proname_args_nsp_index" contains unexpected zero page > at block 16 at character 61 > ] > > I create a new database but I don't know where to find the origin of the > problem, or how to avoid this. Any idea would be helpful. Ths looks like data corruption. Could be a hardware problem or a PostgreSQL bug. Were there any crashes lately? Since this is an index, running REINDEX TABLE pg_proc; as superuser would fix the problem. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
В списке pgsql-novice по дате отправления: