ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.
复制代码
报错日志如下
2024-03-20T21:16:28.301465+08:00 0 [ERROR] [MY-011526] [Repl] Plugin group_replication reported: 'This member has more executed transactions than those present in the group. Local transactions: f4343bed-e68a-11ee-9d06-000c293b6e72:1-4 > Group transactions: 2b5c6540-e5d0-11ee-8376-000c29ec4ae4:1-8, aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-4'
2024-03-20T21:16:28.301534+08:00 0 [ERROR] [MY-011522] [Repl] Plugin group_replication reported: 'The member contains transactions not present in the group. The member will now exit the group.'
2024-03-20T21:16:28.301580+08:00 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to mgr01:3306, mgr02:3306 on view 17109245818795019:2.'
2024-03-20T21:16:31.371530+08:00 0 [System] [MY-011504] [Repl] Plugin group_replication reported: 'Group membership changed: This member has left the group.'
报错很明显了
Plugin group_replication reported: 'This member has more executed transactions than those present in the group. Local transactions: f4343bed-e68a-11ee-9d06-000c293b6e72:1-4 > Group transactions: 2b5c6540-e5d0-11ee-8376-000c29ec4ae4:1-8, aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-4'
此成员执行的事务比组中的事务多
在SECONDARY节点上使用 reset master 清空所有执行事务就好了
