MySQL Forums
Forum List  »  InnoDB clusters

InnoDB cluster can not update certification while replication
Posted by: long tran
Date: June 17, 2021 04:35AM

Hi guys,

Mysql innoDB cluster suddenly get this error:


2021-06-17T02:36:19.594959Z 2722 [ERROR] [MY-011553] [Repl] Plugin group_replication reported: 'Unable to update certification result on server side, thread_id: 69284944'
2021-06-17T02:36:19.595116Z 2722 [ERROR] [MY-011445] [Repl] Plugin group_replication reported: 'Error at event handling! Got error: 1.'
2021-06-17T02:36:19.595278Z 2722 [ERROR] [MY-011452] [Repl] Plugin group_replication reported: 'Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.'
2021-06-17T02:36:19.597366Z 69093448 [ERROR] [MY-011601] [Repl] Plugin group_replication reported: 'Transaction cannot be executed while Group Replication is on ERROR state. Check for errors and restart the plugin'
2021-06-17T02:36:19.597427Z 69093448 [ERROR] [MY-010207] [Repl] Run function 'before_commit' in plugin 'group_replication' failed
2021-06-17T02:36:19.599301Z 69284940 [ERROR] [MY-011601] [Repl] Plugin group_replication reported: 'Transaction cannot be executed while Group Replication is on ERROR state. Check for errors and restart the plugin'
2021-06-17T02:36:19.599350Z 69284940 [ERROR] [MY-010207] [Repl] Run function 'before_commit' in plugin 'group_replication' failed
2021-06-17T02:36:19.601075Z 69242210 [ERROR] [MY-011601] [Repl] Plugin group_replication reported: 'Transaction cannot be executed while Group Replication is on ERROR state. Check for errors and restart the plugin'
2021-06-17T02:36:19.601121Z 69242210 [ERROR] [MY-010207] [Repl] Run function 'before_commit' in plugin 'group_replication' failed
2021-06-17T02:36:19.601414Z 2722 [Warning] [MY-011630] [Repl] Plugin group_replication reported: 'Due to a plugin error, some transactions were unable to be certified and will now rollback.'
2021-06-17T02:36:19.601546Z 2722 [ERROR] [MY-011631] [Repl] Plugin group_replication reported: 'Error when trying to unblock non certified or consistent transactions. Check for consistency errors when restarting the service'
2021-06-17T02:36:19.601554Z 69284944 [ERROR] [MY-011615] [Repl] Plugin group_replication reported: 'Error while waiting for conflict detection procedure to finish on session 69284944'
2021-06-17T02:36:19.601655Z 69284944 [ERROR] [MY-010207] [Repl] Run function 'before_commit' in plugin 'group_replication' failed
2021-06-17T02:36:19.601653Z 2722 [ERROR] [MY-011712] [Repl] Plugin group_replication reported: 'The server was automatically set into read only mode after an error was detected.'
02:36:19 UTC - mysqld got signal 11 ;


After that the replication stopped.

Can you help me explain why it happens?

Thank you all!

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB cluster can not update certification while replication
149
June 17, 2021 04:35AM


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.