| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Frank Alberto Rodriguez <franknigth(at)gmail(dot)com>, pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: ERROR on database index |
| Date: | 2019-03-28 13:00:59 |
| Message-ID: | 38eda5604f0e1c46b9970847061b97a98a4d2513.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JORGE MALDONADO | 2019-03-28 13:30:13 | Re: How to correctly include double quotes in an insert statement |
| Previous Message | Danny Severns | 2019-03-28 11:04:26 | RE: How to correctly include double quotes in an insert statement |