MySQL Forums
Forum List  »  Replication

Plugin instructed the server to rollback the current transaction.
Posted by: Icaro Orte
Date: June 03, 2020 08:43AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Plugin instructed the server to rollback the current transaction.
429
June 03, 2020 08:43AM


Sorry, only registered users may post in this forum.

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.