We have seen a weird situation where the DML's are written to the audit logs with retcode 0(meaning success) but were not executed inside the database. I have analysed the binary logs generated during that time and the count of statements from binary logs is less than the count of statements from audit logs... These are batch inserts into a simple innodb table without any foreign key references etc.. In audit logs we got 3131 batch insert statements where as in binary logs we got just 2323.
We are using MariaDB community server 10.4.12 version on Debian 10 with sync_binlog=1 and innodb_flush_log_at_trx_commit=1.
Does anyone faced similar situation? Looking for some insights on this issue..
I checked the configuration settings of database and could not find anything which is against the ACID properties of the database.
Thank you Jaya