Symptoms
It is impossible to perform some action in Control Panel, the attempts fail with a similar error:
"ODBC error #XX002: ERROR: index "TableName" contains unexpected zero page at block XXX; Error while executing the queryODBC error #XX002: ERROR: index "TableName" contains unexpected zero page at block XXX; Error while executing the query"
e.g. you cannot create a new account, it fails with:
"ODBC error #XX002: ERROR: index "TaskEID" contains unexpected zero page at block 334; Error while executing the queryODBC error #XX002: ERROR: index "TaskEID" contains unexpected zero page at block 334; Error while executing the query"
Cause
An indicated table index was corrupted (may be a result of a recent postgres or system failure, there was a lack of free space on the device, etc).
Resolution
- Backup the database (for backup consistency it is recommended to perform it with stopped service) of Operations Automation or Business Automation, depending on the table origin.
Reindex corrupted index:
pba=> REINDEX INDEX "TaskEID";