Your indexes in MySQL or Postgresql have become corrupted, and as a result, your backups now contain these corrupted indexes. This is a serious issue, and the only way to fix it is to recreate the indexes while ensuring that any duplicates are removed. I had to do this a couple of weeks ago, and it was a frustrating and time-consuming process. It is frustrating that those responsible did not verify the backups properly.

Reply to this note

Please Login to reply.

Discussion

If you think the organization needs a heads-up as to how messed up that situation is, provide a report showing a cost comparison of their mistake vs a proper SOP. You might see mountains move.