Optimize fails due to duplicate rows error but no duplicates found
- Date: Tue, 13 Feb 2018 08:02:07 +0000
- From: Machiel Richards <machiel@xxxxxxxxxxxxxxxxxxxx>
- Subject: Optimize fails due to duplicate rows error but no duplicates found
Good day guys,
I am hoping this mail finds you well.
I am at a bit of a loss here...
We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed.
However, after running for over an hour , the optimize fails stating there is a duplicate entry in the table.
We have now spent 2 days using various methods but we are unable to find any duplicates in the primary key and also nothing on the unique key fields.
Any idea on why optimize would still be failing ?