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 JULY 11, 2017

Applies to:

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

Symptoms

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.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms