Plugin instructed the server to rollback the current transaction.

[Icaro Orte]

Hi all and hope you are well

I have a system with 3 mysql group replication (multi-master) nodes, in which there are servers with scripts that execute actions, and sometimes they coincide at exactly the same moment, this happening:

update scripts set start = now(), status = 1 where id = ?
Plugin instructed the server to rollback the current transaction.

At other times it happens:

update scripts set start = now(), status = 1 where id = ?
Error on observer while running replication hook 'before_commit'.


It is a very simple table, without FK.

Sometimes the error is also reproduced in some other tables when using inserts or updates

How could I deal with this so that it doesn't happen?

Thanks, best regards