Re: ERROR on database index

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