GreatSQL社区

搜索

[待回复] 【8.4.4-4】在主节点新建账号导致从节点复制失败

70 3 4 天前
  1. 2026-01-19T09:29:06.390396+08:00 581 [ERROR] [MY-010584] [Repl] Replica SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction 'bf235261-fd71-4f75-a73a-ff653c103ca1:1' at source log binlog.000001, end_log_pos 1134; Error 'Operation CREATE USER failed for 'user'@'%'' on query. Default database: ''. Query: 'CREATE USER 'user'@'%' IDENTIFIED WITH 'caching_sha2_password' AS '$A$00xxxxxxxxxxxxxx3TG.'', Error_code: MY-001396
  2. 2026-01-19T09:29:06.390574+08:00 416 [Note] [MY-011585] [Repl] Plugin group_replication reported: 'Terminating existing group replication donor connection and purging the corresponding logs.'
  3. 2026-01-19T09:29:06.407784+08:00 580 [ERROR] [MY-010586] [Repl] Error running query, replica SQL thread aborted. Fix the problem, and restart the replica SQL thread with "START REPLICA". We stopped at log 'binlog.000001' position 811
  4. 2026-01-19T09:29:06.408171+08:00 579 [Note] [MY-011026] [Repl] Replica I/O thread killed while reading event for channel 'group_replication_recovery'.
  5. 2026-01-19T09:29:06.408227+08:00 579 [Note] [MY-010570] [Repl] Replica I/O thread exiting for channel 'group_replication_recovery', read up to log 'binlog.000001', position 2591
  6. 2026-01-19T09:29:06.410726+08:00 416 [ERROR] [MY-011574] [Repl] Plugin group_replication reported: 'Maximum number of retries when trying to connect to a donor reached. Aborting group replication incremental recovery.'
复制代码


全部回复(3)
yejr 4 天前
请补充在主节点端的完整操作过程,并且确认其他从节点上没有已事先好相应账号
iamzhong 4 天前
yejr 发表于 2026-1-19 09:56
请补充在主节点端的完整操作过程,并且确认其他从节点上没有已事先好相应账号 ...

在三个节点都是正常加处MGR后,即member状态都是ONLINE后,才在主节点创建的账号,三个节点都有账号,如下(xxxx和yyyy替换了真实账号):
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| repl             | %         |
| yyyyy        | %         |
| xxxxx| 10.x.x.x |
| greatdb.sys      | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+

出问题是yyyy账号,权限是 grant all on *.* to yyyyy@'%';

xxxx账号则是正常的,权限是grant all on somedb.* to xxxx@'10.x.x.x';
yejr 4 天前
iamzhong 发表于 2026-1-19 10:05
在三个节点都是正常加处MGR后,即member状态都是ONLINE后,才在主节点创建的账号,三个节点都有账号,如 ...

请详细描述具体过程,这么笼统地说还是没办法定位原因或复现
iamzhong

3

主题

0

博客

17

贡献

新手上路

Rank: 1

积分
23

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2026-1-23 11:34 , Processed in 0.020425 second(s), 15 queries , Redis On.
快速回复 返回顶部 返回列表