Purpose (problem description)
PgAdmin raises below error :
An error has occurred
Error: index <Index Name> contains unexpected zero page at block XXX.
HINT: Please REINDEX it
Applicable Platform
Platform or <Sub Platform Version> | 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
Reindex the index with below query using PGAdmin
REINDEX INDEX <INDEX NAME>
Here <INDEX NAME> is index for which error was coming.
- Then drop the corrupted schema.
So for such error, the solution is to reindex the index with above query.
Notes/comments
