MySQL Forums
Forum List  »  InnoDB clusters

"Plugin instructed the server to rollback the current transaction."
Posted by: Zachary Skalin
Date: August 02, 2018 11:43AM

Hello,

I have a 3 Node setup,

2 Internal and one AWS EC2 instance.

I randomly get this error when running an update query.

"Plugin instructed the server to rollback the current transaction."

This is all I see in the logs

2018-08-02T16:00:27.495026Z 13 [Warning] [MY-010956] [Server] Invalid replication timestamps: original commit timestamp is more recent than the immediate commit timestamp. This may be an issue if delayed replication is active. Make sure that servers have their clocks set to the correct time. No further message will be emitted until after timestamps become valid again

2018-08-02T16:00:27.603044Z 13 [Warning] [MY-010957] [Server] The replication timestamps have returned to normal values.



Is this because one of the nodes is outside the network and causing a delay in replication?

Options: ReplyQuote


Subject
Views
Written By
Posted
"Plugin instructed the server to rollback the current transaction."
22
August 02, 2018 11: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.