Re: Optimize fails due to duplicate rows error but no duplicates found

2018-02-13 Thread Machiel Richards
ok, so we have managed to get an id out of the errors etc... however when we look in the table that id does not even exist at all. no idea what is going on here though. From: shawn l.green Sent: 13 February 2018 09:51:33 PM To: mysql@lists.mysql.com Subject: R

Re: Optimize fails due to duplicate rows error but no duplicates found

2018-02-13 Thread Machiel Richards
Thank you for the response. There are no partitioning involved at all... I will try the suggestion though and see if we get anything... Regards From: shawn l.green Sent: 13 February 2018 09:51:33 PM To: mysql@lists.mysql.com Subject: Re: Optimize fails

Re: Optimize fails due to duplicate rows error but no duplicates found

2018-02-13 Thread shawn l.green
Hello Machiel, On 2/13/2018 3:02 AM, Machiel Richards wrote: 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. Ho

Optimize fails due to duplicate rows error but no duplicates found

2018-02-13 Thread Machiel Richards
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 t