RDBMS - PostgreSQL - Error - Index IndexName contains unexpected zero page at block XXX

Purpose (problem description)

PgAdmin raises below error :

An error has occurred
Error: index contains unexpected zero page at block XXX.
HINT: Please REINDEX it

Applicable Platform

Platform or Yes/No
CSS3✅
CSS2✅

Step by Step scenario

N/A

Action Plan

Some times while creating schema if the ServMan is closed abruptly due to some reason (say system restart), the schema is not created correctly.
Also with abnormal closing of ServMan, index gets corrupt and that is why it raises above error to REINDEX the index

  1. Reindex the index with below query using PGAdmin

REINDEX INDEX 


   Here <INDEX NAME> is index for which error was coming.
2. Then drop the corrupted schema.   
   So for such error, the solution is to reindex the index with above query.

**Notes/comments**