首页 > 数据库 >mysql在开启group_replication后,报错ERROR 3092,This member has more executed transactions than those presen

mysql在开启group_replication后,报错ERROR 3092,This member has more executed transactions than those presen

时间:2023-08-13 16:31:55浏览次数:41  
标签:executed group Plugin 08 member replication 报错 13T07 master

问题描述:mysql在开启group_replication后,报错ERROR 3092,This member has more executed transactions than those present in the group,如下所示:
数据库:MySQL 8.0.27
系统:rhel 7.3
1、异常重现
Slave01[(none)]> start group_replication;
ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.

告警日志:
2023-08-13T07:49:14.174588Z 38 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2023-08-13T07:49:14.176201Z 39 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.'
2023-08-13T07:49:14.179622Z 41 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2023-08-13T07:49:22.544316Z 0 [ERROR] [MY-011526] [Repl] Plugin group_replication reported: 'This member has more executed transactions than those present in the group. Local transactions: 9e1ab21c-3986-11ee-ad9a-0050562d243d:1 > Group transactions: bbbbbbbb-bbbb-cccc-dddd-eeeeeeeeeeee:1-3'
2023-08-13T07:49:22.544390Z 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.'
2023-08-13T07:49:22.544431Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to MySQL-827MGR-Master:3306, MySQL-827MGR-Slave01:3306 on view 16919056084451773:6.'
2023-08-13T07:49:25.624647Z 0 [System] [MY-011504] [Repl] Plugin group_replication reported: 'Group membership changed: This member has left the group.'
2023-08-13T07:49:25.626312Z 39 [System] [MY-011566] [Repl] Plugin group_replication reported: 'Setting super_read_only=OFF.'

2、异常原因
该节点在有操作之前创建了用户.

3、解决方案
因为是初始化安装,可采用reset master清空executed_gtid_set方式解决.
Slave01[(none)]> reset master;
Query OK, 0 rows affected (0.02 sec)

Slave01[(none)]> start group_replication;
Query OK, 0 rows affected (4.78 sec)

Slave01[(none)]> select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+----------------------+-------------+--------------+-------------+----------------+----------------------------+
| CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST          | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
+---------------------------+--------------------------------------+----------------------+-------------+--------------+-------------+----------------+----------------------------+
| group_replication_applier | 9259a41b-3985-11ee-a5e4-000c299ea627 | MySQL-827MGR-Master  |        3306 | ONLINE       | PRIMARY     | 8.0.27         | XCom                       |
| group_replication_applier | 9e1ab21c-3986-11ee-ad9a-0050562d243d | MySQL-827MGR-Slave01 |        3306 | ONLINE       | SECONDARY   | 8.0.27         | XCom                       |
+---------------------------+--------------------------------------+----------------------+-------------+--------------+-------------+----------------+----------------------------+
2 rows in set (0.00 sec)

说明:如上所示,从节点slave01成功开启mgr.

标签:executed,group,Plugin,08,member,replication,报错,13T07,master
From: https://blog.51cto.com/u_12991611/7068041

相关文章

  • mysql在安装group_replication插件时,报错"version libcrypto.so.10 not defined in fi
    问题描述:mysql在安装group_replication插件时,报错"versionlibcrypto.so.10notdefinedinfilelibcrypto.so",如下所示:数据库:mysql8.0.27系统:rhel7.364位1、异常重现mysql>installplugingroup_replicationsoname'group_replication.so';ERROR1126(HY000):......
  • python创建代理报错[WinError 10061] 由于目标计算机积极拒绝,无法连接。
    [WinError10061]由于目标计算机积极拒绝,无法连接最近在学习《python3:网络爬虫开发实战》时遇到了一个问题,在创建代理的例子中,运行代码后报了以下的错误:修改计算机代理设置或者防火墙都无法解决,最后注释了proxy_handler的http的键值,运行成功,所以猜测可能不支持存在多个代理信......
  • 码云git clone报错Incorrect username or password ( access token )
    使用码云将仓库clone到本地,报错信息如下:D:\\123\>gitclonehttps://gitee.com/ycyzharry/helloworld.gitCloninginto'helloworld'...remote:Incorrectusernameorpassword(accesstoken)fatal:Authenticationfailedfor'https://gitee.com/ycyzharry/h......
  • 当打开百度,定位输入报错怎么解决driver.find_element_by_id('kw').send_keys("seleniu
    报错如下: 解决方案,改变编写方式,引入fromselenium.webdriver.common.byimportBy  源码:例子说明: 打开百度,输入selenium进行搜索。fromseleniumimportwebdriverfromtimeimportsleepfromselenium.webdriver.common.byimportBydriver=webdriver.Chrome()d......
  • 1、编译 glibc 过程中报错 ../configure --prefix=/opt/glibc-2.27       2、首
    64位安装包,查看系统位数,安装对应的mysqlLinux系统安装MySQL时,将MySQL-5.6.17-1.el6.x86_64.rpm-bundle.tar包打开,有7个rpm文件,如下:MySQL-client-5.6.17-1.el6.x86_64.rpmMySQL-devel-5.6.17-1.el6.x86_64.rpmMySQL-embedded-5.6.17-1.el6.x86_64.rpmMySQL-server-5.6.17-1.el6.......
  • 关闭ESlint/路径起别名/配置前端代理/引入模块报错
    怎么关闭ESlint语法检查(不建议)vue-cli创建的项目,在vue.config.js​文件里面//vue.config.jsconst{defineConfig}=require('@vue/cli-service');module.exports=defineConfig({lintOnSave:false,})vite创建的项目,在vite.config.js​文件里面import......
  • 如何解决 yum update 报错
    yumupdate的时候遇到报错[root@shawnyan~]#yumupdateerror:rpmdb:BDB0113Thread/process2043/140494753589056failed:BDB1507ThreaddiedinBerkeleyDBlibraryerror:db5error(-30973)fromdbenv->failchk:BDB0087DB_RUNRECOVERY:Fatalerror,rundataba......
  • 报错RuntimeError: Working outside of request context的解决办法
    在程序编写过程中,我写了一个装饰器defauth(func):definner(*args,**kwargs):ifsession.get('username'):res=func(*args,**kwargs)#真正的执行视图函数,在执行视图函数之前判断是否登录returnreselse:#重......
  • 恭喜又一白鲸开源成员成为 Apache SeaTunnel PMC Member
    个人简介王海林白鲸开源研发工程师GitHubID:hailin0做过性能监控、数据开发平台等,目前聚焦在数据集成同步及其周边生态的研发问:作为白鲸开源的一员,您为社区做出过哪些贡献?具体方案(代码类)和贡献事迹有哪些?最开始参与到社区,主要是贡献一些连接器插件以及修复bug,随着对项目加......
  • 恭喜又一白鲸开源成员成为 Apache SeaTunnel PMC Member
    个人简介王海林白鲸开源研发工程师GitHubID:hailin0做过性能监控、数据开发平台等,目前聚焦在数据集成同步及其周边生态的研发问:作为白鲸开源的一员,您为社区做出过哪些贡献?具体方案(代码类)和贡献事迹有哪些?最开始参与到社区,主要是贡献一些连接器插件以及修复bug,随着对项目......