Error
Error Code:
XX002
PostgreSQL Error XX002: Corrupted Index Detected
Description
Error XX002 indicates an internal database consistency issue where one or more indexes have become corrupted. This critical error prevents PostgreSQL from reliably using the affected index, potentially leading to incorrect query results or database instability. It often points to underlying hardware, software, or system-level problems.
Error Message
index corrupted
Known Causes
4 known causesHardware Malfunction
Issues with disk drives, memory (RAM), or storage controllers can lead to data corruption, including database indexes.
Abrupt System Shutdown
Sudden power loss or improper server shutdown can leave database files, including indexes, in an inconsistent state.
File System Corruption
Problems at the operating system's file system level can introduce inconsistencies in the underlying database files that constitute indexes.
PostgreSQL Software Bug
Although rare, an underlying bug within PostgreSQL itself could, in specific circumstances, lead to index corruption.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service