MySQL Bugs: #84730: Feature: Troubleshoot Group Replication Transaction Rollbacks

Bug #84730	Feature: Troubleshoot Group Replication Transaction Rollbacks
Submitted:	31 Jan 2017 8:43	Modified:	3 Feb 2017 12:20
Reporter:	Kenny Gryp	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Group Replication	Severity:	S4 (Feature request)
Version:	5.7.17	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When there's a transaction rollback due to multi-master conflicting writes happening in Group Replication, you get an error like: 

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

How to repeat:
.

Suggested fix:
It would be good to have a way, either in errorlog or using PFS or ... to figure out why a specific transaction was rolled back and have some more information

This might be looking similar to what we get in SHOW ENGINE INNODB STATUS -> INNODB DEADLOCKS section.

Hi,

Thanks for your submission, I verified this as FeatureRequest

all best
Bogdan