Re: ERROR on database index

Frank Alberto Rodriguez Solana wrote:

> Hi Laurenz, thanks for you reply. I do REINDEX but then the same problem was trigger but with
pg_description_o_c_o_index,
 
> 
> [XX002] org.postgresql.util.PSQLException: ERROR: index "pg_description_o_c_o_index" contains unexpected zero page at
block
> 
> I reindex pg_description and I don't see more problems. The system file type is ext4 and is a cloud server.
> 
> But seeing logs I saw other problem in the same server but other database:
> ERROR:  invalid page in block 1478644 of relation pg_tblspc/117936/PG_10_201707211/117939/259612
> 
> that's makes me wonder if the problem is in the filesystem, but I have 3 cloud servers with the same
> specification and working charge, and each server have an incremental backup with barman.

At this point I would restore a backup, pg_dumpall and restore to a new server.

Data corruption can spread.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com