Re: DELETE from table does not delete rows
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...
Subject
Views
Written By
Posted
819
April 23, 2019 11:23AM
501
April 24, 2019 02:07AM
Re: DELETE from table does not delete rows
577
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.