debugsqlMinor
Postgresql error: failed to re-find parent key in index
Viewed 0 times
postgresqlerrorparentfailedfindindexkey
Problem
I have a Django app with a postgresql 9.3 DB (hosted on Ubuntu VM), and very recently the VM ran out of disk space (resulting in
I cleared the space on the device and everything came back online.
But now, for a minority of my requests, I've started receiving a
Can someone explain the background of what this means, and a remedy for this problem? Thanks in advance!
no space left on device errors showing up in my logs). I cleared the space on the device and everything came back online.
But now, for a minority of my requests, I've started receiving a
django.db.utils:DatabaseError alert, with the description failed to re-find parent key in index "links_grouptraffic_time" for split pages 24582/24583. links_grouptraffic is one of my data models, and time is an attribute within that data model.Can someone explain the background of what this means, and a remedy for this problem? Thanks in advance!
Solution
Your database is likely corrupted, especially the indexes. You can rebuild all indexes and check all tables on a database by:
REINDEX SYSTEM; -- run once
REINDEX DATABASE ; -- run for each database
VACUUM (FULL VERBOSE ANALYZE); -- also run for each database after reindexingCode Snippets
REINDEX SYSTEM; -- run once
REINDEX DATABASE <your dbname>; -- run for each database
VACUUM (FULL VERBOSE ANALYZE); -- also run for each database after reindexingContext
StackExchange Database Administrators Q#135881, answer score: 8
Revisions (0)
No revisions yet.