"index contains unexpected zero page" problem

From: Yi Sun <yinan81(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: "index contains unexpected zero page" problem
Date: 2021-04-09 01:44:41
Message-ID: CABWY_HBQeWRXK5rMPQoCrHi70nRUpKVcq5f+nedFO-dx8f0NQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys,

We face "index contains unexpected zero page" problem in prd postgresql 11
environment

This url shows that need to backup database firstly, is it necessary?
https://cloudblue.freshdesk.com/support/solutions/articles/44001889599-error-index-tablename-contains-unexpected-zero-page

If "create index concurrently" create a new index and drop the old broken
index is a solution to avoid table lock please? Thanks

Best Regards
Dennis

Browse pgsql-general by date

  From Date Subject
Next Message Niels Jespersen 2021-04-09 07:24:54 where clauses including timstamptz and intervals
Previous Message Siddhartha2485 2021-04-09 01:43:58 Re: ERROR : invalid transaction termination : PostgreSQL v12