DML statements written to audit logs but were not executed in the database

Hello Team,

Today we have identified a weird situation.. We observed that two of the DML's are written to the audit logs with retcode 0 but these statements did not change the database table rows. I even analysed the binary logs during the time statements were written to audit logs but could not find them in the binary logs. Meaning, somehow these statements are not written to redo logs and table page were not updated. We are using innodb_flush_log_at_trx_commit =1 and sync_binlog=1, also we are using autocommit.

I'm wondering how can a statement is written to audit logs with success code before committing in the database and writing to binary logs. I hope I can't reproduce this issue but I have the audit logs and binary logs saved during that time. I could not find any error messages in the error logs during that time. It would be great if someone could help us understand what went wrong as now we fear there might be some DML's which are silently being ignored (not written to database tables or redo logs).. Let me know if you need more information..