[MariaDB developers] Re: [PATCH] MDEV-34481 optimize away waiting for owned by prepared xa non-unique index record

Andrei Elkin <andrei.elkin@mariadb.com> writes:

...

Also, are you aware that when you skip a record like this, you may be skipping the very record that needs to be changed?

Yet luckily this is covered by the BASE (of the patch) logics. After(needless) scan the rest of duplicate key record set the third group of events would have to retry, to success. (This is optimizable, but I

You need to make sure that --slave_exec_mode=IDEMPOTENT is not used. Otherwise you can get silent data corruption. - Kristian.