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
