Ad Widget

Collapse

Corrupted table?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sinloud
    Junior Member
    • Nov 2021
    • 2

    #1

    Corrupted table?

    Hi everybody

    Looks like i somehow corrupted history_uint table, i get this error when i try to do something with it
    ERROR: could not access status of transaction 650650
    DETAIL: Could not open file "pg_xact/0000": No such file or directory.

    Is there a way to fix this and if not, how safe it is to truncate this table?
  • vladimir_lv
    Senior Member
    • May 2022
    • 240

    #2
    Hi!
    Try to remove index and recreate it.
    Also, it may happen if you've got some serious filesystem-level or RAM problems.
    Ofc, you have to make a backup before doing anything on the database.

    Comment

    Working...