My Oracle Support Banner

Operations Fail In Group Replication Setup With ERROR 3101: "Plugin instructed the server to rollback the current transaction" (Doc ID 2211042.1)

Last updated on AUGUST 19, 2020

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.


An environment contains three database nodes with Group Replication (GR) setup.

By trying to load the database with some operations from two different sessions of the same node, one reports error and operations are rolled back:

ERROR 3101 (HY000): Plugin instructed the server to rollback the current transaction.


Please note, that in general this error is an expected behavior of Group Replication plugin, when it finds conflicting transactions on different nodes, if Multi Primary mode is used. Application should be able to handle this type of errors based on application logic. The following sections can only applied in those cases, when this error is caused by multiple updates on the same node.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Permanent solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.