MySQL Forums
Forum List  »  InnoDB

Re: DELETE from table does not delete rows
Posted by: Alexandru Badulescu
Date: April 24, 2019 08:05AM

Thank you for the answer James!
Managed to figure out what was happening: this was part of a big cron job, calculating some reports, making the inserts, moving older data to other tables and deleting these old records. The logs were indicating the same result as the slow-query log.
What was actually happening is that the dev had set autocommit=0 somewhere upper in the script. So this was running and remaining not committed until the connection dropped - time when it was actually rolling it back...

Options: ReplyQuote

Written By
Re: DELETE from table does not delete rows
April 24, 2019 08:05AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.