GreatSQL社区

搜索

[已解决] Greatsql MGR集群其中一个节点一直UNREACHABLE无法恢复

342 8 2023-12-4 17:47
本帖最后由 running_db 于 2023-12-5 16:04 编辑

1、环境说明

OS:Rocky Linux release 8.8 5.4.259-1.el8.elrepo.x86_64
DB:GreatSQL-8.0.32-24-Linux-glibc2.28-x86_64


相关参数:

loose-group_replication_unreachable_majority_timeout = 30
loose-group_replication_member_expel_timeout = 5

  1. (Mon Dec  4 17:50:16 2023)[root@GreatSQL][(none)]>show variables like 'group_replication_unreachable_majority_timeout';
  2. +------------------------------------------------+-------+
  3. | Variable_name                                  | Value |
  4. +------------------------------------------------+-------+
  5. | group_replication_unreachable_majority_timeout | 30    |
  6. +------------------------------------------------+-------+
  7. 1 row in set (0.00 sec)

  8. (Mon Dec  4 17:50:29 2023)[root@GreatSQL][(none)]>show variables like 'group_replication_member_expel_timeout';
  9. +----------------------------------------+-------+
  10. | Variable_name                          | Value |
  11. +----------------------------------------+-------+
  12. | group_replication_member_expel_timeout | 5     |
  13. +----------------------------------------+-------+
复制代码


2、问题描述
192.168.6.188 PRIMARY
192.168.6.189 SECONDARY
192.168.6.190 SECONDARY
在批量导入数据过程中,发现三节点mgr中其中一个SECONDARY节点190处于UNREACHABLE状态,且,重启190数据库和重启操作系统,手动执行start group_replication都无法加入集群。

3、具体报错
PRIMARY:一直重复一下错误Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17016823274129381. Please stop the old node or wait for it to leave the group.'
  1. 2023-12-04T17:32:08.439396+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  2. 2023-12-04T17:32:08.439578+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  3. 2023-12-04T17:32:08.440629+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17016823274129381. Please stop the old node or wait for it to leave the group.'
  4. 2023-12-04T17:32:08.441617+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  5. 2023-12-04T17:32:08.539157+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:65 connected'
  6. 2023-12-04T17:32:08.539322+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:65'
  7. 2023-12-04T17:32:08.540069+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17016823274129381. Please stop the old node or wait for it to leave the group.'
  8. 2023-12-04T17:32:08.540974+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:65 in close_connection'
  9. 2023-12-04T17:32:08.638952+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  10. 2023-12-04T17:32:08.639208+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  11. 2023-12-04T17:32:08.640082+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17016823274129381. Please stop the old node or wait for it to leave the group.'
  12. 2023-12-04T17:32:08.641199+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
复制代码


190 SECONDARY
大量重复:
  1. 2023-12-04T17:44:16.818907+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] TCP_NODELAY already set'
  2. 2023-12-04T17:44:16.819005+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Sucessfully connected to peer 192.168.6.189:33081. Sending a request to be added to the group'
  3. 2023-12-04T17:44:16.819043+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Sending add_node request to a peer XCom node'
  4. 2023-12-04T17:44:16.844098+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] xcom_send_client_app_data sets CON_PROTO for fd:49'
  5. 2023-12-04T17:44:16.844845+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Sending a request to a remote XCom failed. Please check the remote node log for more details.'
  6. 2023-12-04T17:44:16.844930+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Failed to send add_node request to a peer XCom node.'
复制代码
其余日志:
  1. 2023-12-04T17:44:16.844930+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Failed to send add_node request to a peer XCom node.'
  2. 2023-12-04T17:44:16.845118+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 33081'
  3. 2023-12-04T17:44:16.846761+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 1701683056.846689 pid 992 xcom_id 7b487969 state xcom_fsm_start action x_fsm_terminate'
  4. 2023-12-04T17:44:16.846922+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 1701683056.846903 pid 992 xcom_id 7b487969 state xcom_fsm_start action x_fsm_exit'
  5. 2023-12-04T17:44:16.846977+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Exiting xcom thread'
  6. 2023-12-04T17:44:17.503680+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33081'
复制代码


当前状态:
  1. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  2. | CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST   | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
  3. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  4. | group_replication_applier | a55de711-812e-11ee-b3fc-5254005b7a28 | 192.168.6.190 |        3308 | UNREACHABLE  | SECONDARY   | 8.0.32         | XCom                       |
  5. | group_replication_applier | a5609358-812e-11ee-abe4-525400b01dcf | 192.168.6.188 |        3308 | ONLINE       | PRIMARY     | 8.0.32         | XCom                       |
  6. | group_replication_applier | a5623edf-812e-11ee-92a9-525400980c24 | 192.168.6.189 |        3308 | ONLINE       | SECONDARY   | 8.0.32         | XCom                       |
  7. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
复制代码

补充:
190节点于Dec  4 16:53:31发生oom,自动重启
/var/log/messeage
  1. Dec  4 16:53:31 greatsql03 kernel: Tasks state (memory values in pages):
  2. Dec  4 16:53:31 greatsql03 kernel: [  pid  ]   uid  tgid total_vm      rss pgtables_bytes swapents oom_score_adj name
  3. Dec  4 16:53:31 greatsql03 kernel: [    489]     0   489    26700     1196   258048        0             0 systemd-journal
  4. Dec  4 16:53:31 greatsql03 kernel: [    515]     0   515    24476      522   208896        0         -1000 systemd-udevd
  5. Dec  4 16:53:31 greatsql03 kernel: [    545]     0   545    14276      154   126976        0         -1000 auditd
  6. Dec  4 16:53:31 greatsql03 kernel: [    591]     0   591    31252      161   151552        0             0 irqbalance
  7. Dec  4 16:53:31 greatsql03 kernel: [    594]    81   594    14126      204   147456        0          -900 dbus-daemon
  8. Dec  4 16:53:31 greatsql03 kernel: [    595]     0   595   147629      605   393216        0             0 NetworkManager
  9. Dec  4 16:53:31 greatsql03 kernel: [    597]     0   597    20395      227   192512        0             0 systemd-logind
  10. Dec  4 16:53:31 greatsql03 kernel: [    601]   996   601    35018      177   180224        0             0 chronyd
  11. Dec  4 16:53:31 greatsql03 kernel: [    625]     0   625   173448     4113   438272        0             0 tuned
  12. Dec  4 16:53:31 greatsql03 kernel: [    627]     0   627    19162      226   188416        0         -1000 sshd
  13. Dec  4 16:53:31 greatsql03 kernel: [    631]     0   631    58906      213   102400        0             0 crond
  14. Dec  4 16:53:31 greatsql03 kernel: [    635]     0   635    54902       28    65536        0             0 agetty
  15. Dec  4 16:53:31 greatsql03 kernel: [    659]     0   659    64761     1084   233472        0             0 rsyslogd
  16. Dec  4 16:53:31 greatsql03 kernel: [    843]   998   843   436316     1265   348160        0             0 polkitd
  17. Dec  4 16:53:31 greatsql03 kernel: [   1030]   601  1030  1486663   930214 10153984        0             0 mysqld
  18. Dec  4 16:53:31 greatsql03 kernel: oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/greatsql.service,task=mysqld,pid=1030,uid=601
  19. Dec  4 16:53:31 greatsql03 kernel: Out of memory: Killed process 1030 (mysqld) total-vm:5946652kB, anon-rss:3720856kB, file-rss:0kB, shmem-rss:0kB, UID:601 pgtables:9916kB oom_score_adj:0
  20. Dec  4 16:53:31 greatsql03 systemd[1]: greatsql.service: Main process exited, code=killed, status=9/KILL
  21. Dec  4 16:53:31 greatsql03 systemd[1]: greatsql.service: Failed with result 'signal'.
  22. Dec  4 16:53:31 greatsql03 systemd[1]: greatsql.service: Service RestartSec=100ms expired, scheduling restart.
  23. Dec  4 16:53:31 greatsql03 systemd[1]: greatsql.service: Scheduled restart job, restart counter is at 1.
  24. Dec  4 16:53:31 greatsql03 systemd[1]: Stopped GreatSQL Server.
  25. Dec  4 16:53:31 greatsql03 systemd[1]: Starting GreatSQL Server...
  26. Dec  4 16:53:42 greatsql03 systemd[1]: Started GreatSQL Server.
  27. Dec  4 17:00:01 greatsql03 systemd[1]: Starting system activity accounting tool...
复制代码


188当时的日志:
  1. 2023-12-04T16:27:06.008289+08:00 285892 [Note] [MY-012485] [InnoDB] DDL log post ddl : begin for thread id : 285892
  2. 2023-12-04T16:27:06.008375+08:00 285892 [Note] [MY-012486] [InnoDB] DDL log post ddl : end for thread id : 285892
  3. 2023-12-04T16:29:42.099037+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:628458us, server id:188, thread_id:285908'
  4. 2023-12-04T16:32:08.618436+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:1228858us, server id:188, thread_id:285908'
  5. 2023-12-04T16:34:31.903747+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:924387us, server id:188, thread_id:285908'
  6. 2023-12-04T16:35:40.021236+08:00 285868 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`localhost`. The idle time since last command was too long.
  7. 2023-12-04T16:35:40.021484+08:00 285868 [Note] [MY-010914] [Server] Aborted connection 285868 to db: 'unconnected' user: 'root' host: 'localhost' (The client was disconnected by the server because of inactivity.).
  8. 2023-12-04T16:36:55.493502+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:1099862us, server id:188, thread_id:285908'
  9. 2023-12-04T16:39:18.889251+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:1026873us, server id:188, thread_id:285908'
  10. 2023-12-04T16:41:42.790207+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:1074727us, server id:188, thread_id:285908'
  11. 2023-12-04T16:44:03.741350+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:1402106us, server id:188, thread_id:285908'
  12. 2023-12-04T16:46:23.746283+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:1014195us, server id:188, thread_id:285908'
  13. 2023-12-04T16:48:46.386828+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:1056717us, server id:188, thread_id:285908'
  14. 2023-12-04T16:49:48.111022+08:00 285979 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`localhost`. The idle time since last command was too long.
  15. 2023-12-04T16:49:48.111302+08:00 285979 [Note] [MY-010914] [Server] Aborted connection 285979 to db: 'unconnected' user: 'root' host: 'localhost' (The client was disconnected by the server because of inactivity.).
  16. 2023-12-04T16:51:09.286181+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:1114375us, server id:188, thread_id:285908'
  17. 2023-12-04T16:53:30.862585+08:00 285908 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'MGR request time:1008435us, server id:188, thread_id:285908'
  18. 2023-12-04T16:53:31.651559+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Failure reading from fd=62 n=18446744073709551615 from 192.168.6.190:33081'
  19. 2023-12-04T16:53:31.651693+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  20. 2023-12-04T16:53:31.652006+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] fast_skip_allowed_for_kill is set here'
  21. 2023-12-04T16:53:31.652147+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:67 in close_connection'
  22. 2023-12-04T16:53:31.717465+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Sender task disconnected from 192.168.6.190:33081'
  23. 2023-12-04T16:53:31.717555+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connecting to 192.168.6.190:33081'
  24. 2023-12-04T16:53:31.717987+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  25. 2023-12-04T16:53:31.817881+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  26. 2023-12-04T16:53:31.928331+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  27. 2023-12-04T16:53:32.049835+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  28. 2023-12-04T16:53:32.183331+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  29. 2023-12-04T16:53:32.329817+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  30. 2023-12-04T16:53:32.490846+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  31. 2023-12-04T16:53:32.668289+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  32. 2023-12-04T16:53:32.802803+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] A configuration change was detected. Sending a Global View Message to all nodes. My node identifier is 0 and my address is 192.168.6.188:33081'
  33. 2023-12-04T16:53:32.802941+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] call send_my_view in detector'
  34. 2023-12-04T16:53:32.802982+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] send_my_view calls xcom_send'
  35. 2023-12-04T16:53:32.803009+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] notify is set true in check_local_node_set'
  36. 2023-12-04T16:53:32.803030+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] call deliver_view_msg in detector'
  37. 2023-12-04T16:53:32.803204+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] xcom_receive_local_view is called'
  38. 2023-12-04T16:53:32.803333+08:00 0 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'on_suspicions is activated'
  39. 2023-12-04T16:53:32.803453+08:00 0 [Warning] [MY-011493] [Repl] Plugin group_replication reported: 'Member with address 192.168.6.190:3308 has become unreachable.'
  40. 2023-12-04T16:53:32.803612+08:00 0 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'on_suspicions is called over'
  41. 2023-12-04T16:53:32.803652+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] xcom_receive_local_view return true'
  42. 2023-12-04T16:53:32.803710+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'Error: try to bind vip failed'
  43. 2023-12-04T16:53:32.805957+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] ::xcom_receive_global_view() is called'
  44. 2023-12-04T16:53:32.862833+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  45. 2023-12-04T16:53:33.077281+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  46. 2023-12-04T16:53:33.312944+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  47. 2023-12-04T16:53:33.572701+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  48. 2023-12-04T16:53:33.858344+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  49. 2023-12-04T16:53:34.172197+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  50. 2023-12-04T16:53:34.517920+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  51. 2023-12-04T16:53:34.898032+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
  52. 2023-12-04T16:53:35.316105+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection to 192.168.6.190:33081 failed'
复制代码







全部回复(8)
KAiTO 2023-12-5 10:51:31
可能是因为192.168.6.190节点之前是组复制的成员,但是没有正常下线而离开了组。导致它的一些状态信息没有得到清理,还残留在其他成员节点上。
现在它重新加入组时,其他节点检测到它有一个旧的 incarnation 17016823274129381,所以拒绝让它加入。
试着清理一下组复制信息看看有没有效果
RESET SLAVE;
yejr 2023-12-5 11:05:33
在190异常退出后想重新加入,在primary节点上日志发现:Old incarnation found关键字,表示在原来的mgr里,190节点还没被驱逐出去。

试着这样做:
1. 暂停190节点反复重试加入mgr。
2. 观察188 primary节点上最新产生的日志,看看mgr状态是怎样的。
3. 提供188 primary节点上的事务状态。
show engine innodb status\G

4. 提供在188和189两个节点上看到的mgr状态。
参考这个方法提供数据:https://greatsql.cn/docs/8032/us ... 1%E7%9B%91%E6%8E%A7
running_db 2023-12-5 11:27:58
本帖最后由 running_db 于 2023-12-5 11:43 编辑
yejr 发表于 2023-12-5 11:05
在190异常退出后想重新加入,在primary节点上日志发现:Old incarnation found关键字,表示在原来的mgr里, ...

1. stop group_replication;select sleep(1);start group_replication;操作了6次
2. 这6次中,188master日志如下,不管几次操作都是如下类似重复日志:
  1. 2023-12-05T11:22:22.771569+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  2. 2023-12-05T11:22:22.868889+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  3. 2023-12-05T11:22:22.869056+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  4. 2023-12-05T11:22:22.870079+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465417096765. Please stop the old node or wait for it to leave the group.'
  5. 2023-12-05T11:22:22.871105+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  6. 2023-12-05T11:22:22.968579+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  7. 2023-12-05T11:22:22.968725+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  8. 2023-12-05T11:22:22.969724+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465417096765. Please stop the old node or wait for it to leave the group.'
  9. 2023-12-05T11:22:22.970809+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  10. 2023-12-05T11:22:23.068229+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  11. 2023-12-05T11:22:23.068375+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  12. 2023-12-05T11:22:23.069379+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465417096765. Please stop the old node or wait for it to leave the group.'
  13. 2023-12-05T11:22:23.070655+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  14. 2023-12-05T11:22:23.167730+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  15. 2023-12-05T11:22:23.167877+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  16. 2023-12-05T11:22:23.168850+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465417096765. Please stop the old node or wait for it to leave the group.'
  17. 2023-12-05T11:22:23.169991+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  18. 2023-12-05T11:22:23.267696+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  19. 2023-12-05T11:22:23.267843+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  20. 2023-12-05T11:22:23.268747+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465417096765. Please stop the old node or wait for it to leave the group.'
  21. 2023-12-05T11:22:23.269624+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  22. 2023-12-05T11:22:23.367403+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  23. 2023-12-05T11:22:23.367580+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  24. 2023-12-05T11:22:23.368629+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465417096765. Please stop the old node or wait for it to leave the group.'
  25. 2023-12-05T11:22:23.369691+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  26. 2023-12-05T11:22:23.466530+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  27. 2023-12-05T11:22:23.466676+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  28. 2023-12-05T11:22:23.467677+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465417096765. Please stop the old node or wait for it to leave the group.'
  29. 2023-12-05T11:22:23.468775+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  30. 2023-12-05T11:22:23.566365+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  31. 2023-12-05T11:22:23.566532+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  32. 2023-12-05T11:22:23.567516+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465417096765. Please stop the old node or wait for it to leave the group.'
  33. 2023-12-05T11:22:23.568428+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  34. 2023-12-05T11:22:23.665596+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  35. 2023-12-05T11:22:23.665744+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  36. 2023-12-05T11:22:23.666590+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465417096765. Please stop the old node or wait for it to leave the group.'
  37. 2023-12-05T11:22:23.667606+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  38. 2023-12-05T11:22:30.338833+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  39. 2023-12-05T11:22:30.339096+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  40. 2023-12-05T11:22:30.339974+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465492827673. Please stop the old node or wait for it to leave the group.'
  41. 2023-12-05T11:22:30.340819+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  42. 2023-12-05T11:22:30.437804+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  43. 2023-12-05T11:22:30.437953+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  44. 2023-12-05T11:22:30.438884+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465492827673. Please stop the old node or wait for it to leave the group.'
  45. 2023-12-05T11:22:30.439826+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  46. 2023-12-05T11:22:30.537219+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  47. 2023-12-05T11:22:30.537375+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  48. 2023-12-05T11:22:30.538076+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465492827673. Please stop the old node or wait for it to leave the group.'
  49. 2023-12-05T11:22:30.538930+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  50. 2023-12-05T11:22:30.636592+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  51. 2023-12-05T11:22:30.636737+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  52. 2023-12-05T11:22:30.637592+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465492827673. Please stop the old node or wait for it to leave the group.'
  53. 2023-12-05T11:22:30.638393+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  54. 2023-12-05T11:22:30.735858+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  55. 2023-12-05T11:22:30.736034+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  56. 2023-12-05T11:22:30.737086+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465492827673. Please stop the old node or wait for it to leave the group.'
  57. 2023-12-05T11:22:30.738342+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  58. 2023-12-05T11:22:30.835882+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  59. 2023-12-05T11:22:30.836104+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  60. 2023-12-05T11:22:30.837235+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465492827673. Please stop the old node or wait for it to leave the group.'
  61. 2023-12-05T11:22:30.838368+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  62. 2023-12-05T11:22:30.935916+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  63. 2023-12-05T11:22:30.936067+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  64. 2023-12-05T11:22:30.937143+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465492827673. Please stop the old node or wait for it to leave the group.'
  65. 2023-12-05T11:22:30.938473+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  66. 2023-12-05T11:22:31.035307+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  67. 2023-12-05T11:22:31.035494+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  68. 2023-12-05T11:22:31.036528+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465492827673. Please stop the old node or wait for it to leave the group.'
  69. 2023-12-05T11:22:31.037624+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  70. 2023-12-05T11:22:31.135336+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  71. 2023-12-05T11:22:31.135537+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  72. 2023-12-05T11:22:31.136521+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465492827673. Please stop the old node or wait for it to leave the group.'
  73. 2023-12-05T11:22:31.137656+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  74. 2023-12-05T11:22:31.235049+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  75. 2023-12-05T11:22:31.235224+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  76. 2023-12-05T11:22:31.236470+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465492827673. Please stop the old node or wait for it to leave the group.'
  77. 2023-12-05T11:22:31.237586+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  78. 2023-12-05T11:22:37.906772+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  79. 2023-12-05T11:22:37.906980+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  80. 2023-12-05T11:22:37.908408+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465568264640. Please stop the old node or wait for it to leave the group.'
  81. 2023-12-05T11:22:37.909514+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  82. 2023-12-05T11:22:38.006803+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  83. 2023-12-05T11:22:38.006950+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  84. 2023-12-05T11:22:38.007983+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465568264640. Please stop the old node or wait for it to leave the group.'
  85. 2023-12-05T11:22:38.009093+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  86. 2023-12-05T11:22:38.106385+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  87. 2023-12-05T11:22:38.106566+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  88. 2023-12-05T11:22:38.107667+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465568264640. Please stop the old node or wait for it to leave the group.'
  89. 2023-12-05T11:22:38.108724+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  90. 2023-12-05T11:22:38.206078+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  91. 2023-12-05T11:22:38.206260+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  92. 2023-12-05T11:22:38.207309+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465568264640. Please stop the old node or wait for it to leave the group.'
  93. 2023-12-05T11:22:38.208697+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  94. 2023-12-05T11:22:38.305149+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  95. 2023-12-05T11:22:38.305313+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  96. 2023-12-05T11:22:38.306234+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465568264640. Please stop the old node or wait for it to leave the group.'
  97. 2023-12-05T11:22:38.307235+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  98. 2023-12-05T11:22:38.404683+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  99. 2023-12-05T11:22:38.404835+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  100. 2023-12-05T11:22:38.405731+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465568264640. Please stop the old node or wait for it to leave the group.'
  101. 2023-12-05T11:22:38.406858+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  102. 2023-12-05T11:22:38.504064+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  103. 2023-12-05T11:22:38.504276+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  104. 2023-12-05T11:22:38.505091+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465568264640. Please stop the old node or wait for it to leave the group.'
  105. 2023-12-05T11:22:38.506062+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  106. 2023-12-05T11:22:38.603796+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  107. 2023-12-05T11:22:38.603947+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  108. 2023-12-05T11:22:38.604973+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465568264640. Please stop the old node or wait for it to leave the group.'
  109. 2023-12-05T11:22:38.606180+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  110. 2023-12-05T11:22:38.702867+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  111. 2023-12-05T11:22:38.703012+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  112. 2023-12-05T11:22:38.703965+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465568264640. Please stop the old node or wait for it to leave the group.'
  113. 2023-12-05T11:22:38.704962+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  114. 2023-12-05T11:22:38.802072+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  115. 2023-12-05T11:22:38.802250+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  116. 2023-12-05T11:22:38.803346+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465568264640. Please stop the old node or wait for it to leave the group.'
  117. 2023-12-05T11:22:38.804235+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  118. 2023-12-05T11:22:45.677648+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  119. 2023-12-05T11:22:45.677841+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  120. 2023-12-05T11:22:45.678808+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465646129897. Please stop the old node or wait for it to leave the group.'
  121. 2023-12-05T11:22:45.679719+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  122. 2023-12-05T11:22:45.777390+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  123. 2023-12-05T11:22:45.777559+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  124. 2023-12-05T11:22:45.778481+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465646129897. Please stop the old node or wait for it to leave the group.'
  125. 2023-12-05T11:22:45.779489+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  126. 2023-12-05T11:22:45.876820+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  127. 2023-12-05T11:22:45.876998+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  128. 2023-12-05T11:22:45.877869+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465646129897. Please stop the old node or wait for it to leave the group.'
  129. 2023-12-05T11:22:45.878945+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  130. 2023-12-05T11:22:45.976231+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  131. 2023-12-05T11:22:45.976397+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  132. 2023-12-05T11:22:45.977414+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465646129897. Please stop the old node or wait for it to leave the group.'
  133. 2023-12-05T11:22:45.978573+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  134. 2023-12-05T11:22:46.075675+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  135. 2023-12-05T11:22:46.075836+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  136. 2023-12-05T11:22:46.076665+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465646129897. Please stop the old node or wait for it to leave the group.'
  137. 2023-12-05T11:22:46.077532+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  138. 2023-12-05T11:22:46.175147+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  139. 2023-12-05T11:22:46.175305+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  140. 2023-12-05T11:22:46.176339+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465646129897. Please stop the old node or wait for it to leave the group.'
  141. 2023-12-05T11:22:46.177579+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  142. 2023-12-05T11:22:46.274257+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  143. 2023-12-05T11:22:46.274416+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  144. 2023-12-05T11:22:46.275354+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465646129897. Please stop the old node or wait for it to leave the group.'
  145. 2023-12-05T11:22:46.276402+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  146. 2023-12-05T11:22:46.374422+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  147. 2023-12-05T11:22:46.374647+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  148. 2023-12-05T11:22:46.375634+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465646129897. Please stop the old node or wait for it to leave the group.'
  149. 2023-12-05T11:22:46.376672+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  150. 2023-12-05T11:22:46.479270+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  151. 2023-12-05T11:22:46.479497+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  152. 2023-12-05T11:22:46.480862+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465646129897. Please stop the old node or wait for it to leave the group.'
  153. 2023-12-05T11:22:46.481762+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  154. 2023-12-05T11:22:46.578432+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  155. 2023-12-05T11:22:46.578637+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  156. 2023-12-05T11:22:46.579584+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465646129897. Please stop the old node or wait for it to leave the group.'
  157. 2023-12-05T11:22:46.580479+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  158. 2023-12-05T11:22:53.258667+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  159. 2023-12-05T11:22:53.258841+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  160. 2023-12-05T11:22:53.259819+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465722004489. Please stop the old node or wait for it to leave the group.'
  161. 2023-12-05T11:22:53.260682+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  162. 2023-12-05T11:22:53.358251+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  163. 2023-12-05T11:22:53.358411+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  164. 2023-12-05T11:22:53.359371+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465722004489. Please stop the old node or wait for it to leave the group.'
  165. 2023-12-05T11:22:53.360528+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  166. 2023-12-05T11:22:53.457576+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  167. 2023-12-05T11:22:53.457730+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  168. 2023-12-05T11:22:53.458564+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465722004489. Please stop the old node or wait for it to leave the group.'
  169. 2023-12-05T11:22:53.459625+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  170. 2023-12-05T11:22:53.556739+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  171. 2023-12-05T11:22:53.556891+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  172. 2023-12-05T11:22:53.557993+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465722004489. Please stop the old node or wait for it to leave the group.'
  173. 2023-12-05T11:22:53.559276+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  174. 2023-12-05T11:22:53.656086+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  175. 2023-12-05T11:22:53.656275+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  176. 2023-12-05T11:22:53.657280+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465722004489. Please stop the old node or wait for it to leave the group.'
  177. 2023-12-05T11:22:53.658682+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  178. 2023-12-05T11:22:53.755652+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  179. 2023-12-05T11:22:53.755802+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  180. 2023-12-05T11:22:53.756645+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465722004489. Please stop the old node or wait for it to leave the group.'
  181. 2023-12-05T11:22:53.757774+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  182. 2023-12-05T11:22:53.855555+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  183. 2023-12-05T11:22:53.855703+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  184. 2023-12-05T11:22:53.856672+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465722004489. Please stop the old node or wait for it to leave the group.'
  185. 2023-12-05T11:22:53.857863+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  186. 2023-12-05T11:22:53.954803+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  187. 2023-12-05T11:22:53.954951+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  188. 2023-12-05T11:22:53.956024+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465722004489. Please stop the old node or wait for it to leave the group.'
  189. 2023-12-05T11:22:53.957187+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  190. 2023-12-05T11:22:54.058273+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  191. 2023-12-05T11:22:54.058460+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  192. 2023-12-05T11:22:54.059580+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465722004489. Please stop the old node or wait for it to leave the group.'
  193. 2023-12-05T11:22:54.060840+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  194. 2023-12-05T11:22:54.158841+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  195. 2023-12-05T11:22:54.159051+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  196. 2023-12-05T11:22:54.160225+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465722004489. Please stop the old node or wait for it to leave the group.'
  197. 2023-12-05T11:22:54.161378+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  198. 2023-12-05T11:23:13.476254+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  199. 2023-12-05T11:23:13.476543+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  200. 2023-12-05T11:23:13.477625+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465923127005. Please stop the old node or wait for it to leave the group.'
  201. 2023-12-05T11:23:13.478808+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  202. 2023-12-05T11:23:13.575307+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  203. 2023-12-05T11:23:13.575495+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  204. 2023-12-05T11:23:13.576278+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465923127005. Please stop the old node or wait for it to leave the group.'
  205. 2023-12-05T11:23:13.577100+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  206. 2023-12-05T11:23:13.674626+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  207. 2023-12-05T11:23:13.674760+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  208. 2023-12-05T11:23:13.675508+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465923127005. Please stop the old node or wait for it to leave the group.'
  209. 2023-12-05T11:23:13.676540+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  210. 2023-12-05T11:23:13.773966+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  211. 2023-12-05T11:23:13.774103+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  212. 2023-12-05T11:23:13.775235+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465923127005. Please stop the old node or wait for it to leave the group.'
  213. 2023-12-05T11:23:13.776343+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  214. 2023-12-05T11:23:13.873540+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  215. 2023-12-05T11:23:13.873718+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  216. 2023-12-05T11:23:13.874666+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465923127005. Please stop the old node or wait for it to leave the group.'
  217. 2023-12-05T11:23:13.875763+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  218. 2023-12-05T11:23:13.972787+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  219. 2023-12-05T11:23:13.972931+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  220. 2023-12-05T11:23:13.973739+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465923127005. Please stop the old node or wait for it to leave the group.'
  221. 2023-12-05T11:23:13.974681+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  222. 2023-12-05T11:23:14.072871+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  223. 2023-12-05T11:23:14.073025+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  224. 2023-12-05T11:23:14.074163+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465923127005. Please stop the old node or wait for it to leave the group.'
  225. 2023-12-05T11:23:14.075217+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  226. 2023-12-05T11:23:14.172165+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  227. 2023-12-05T11:23:14.172362+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  228. 2023-12-05T11:23:14.173258+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465923127005. Please stop the old node or wait for it to leave the group.'
  229. 2023-12-05T11:23:14.174365+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  230. 2023-12-05T11:23:14.271268+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  231. 2023-12-05T11:23:14.271412+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  232. 2023-12-05T11:23:14.272577+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465923127005. Please stop the old node or wait for it to leave the group.'
  233. 2023-12-05T11:23:14.273789+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  234. 2023-12-05T11:23:14.370784+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  235. 2023-12-05T11:23:14.370943+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  236. 2023-12-05T11:23:14.371995+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465923127005. Please stop the old node or wait for it to leave the group.'
  237. 2023-12-05T11:23:14.373158+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  238. 2023-12-05T11:23:20.943969+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  239. 2023-12-05T11:23:20.944245+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  240. 2023-12-05T11:23:20.945105+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465999651787. Please stop the old node or wait for it to leave the group.'
  241. 2023-12-05T11:23:20.945865+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  242. 2023-12-05T11:23:21.043787+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  243. 2023-12-05T11:23:21.043963+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  244. 2023-12-05T11:23:21.044757+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465999651787. Please stop the old node or wait for it to leave the group.'
  245. 2023-12-05T11:23:21.045775+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  246. 2023-12-05T11:23:21.143391+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  247. 2023-12-05T11:23:21.143594+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  248. 2023-12-05T11:23:21.144628+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465999651787. Please stop the old node or wait for it to leave the group.'
  249. 2023-12-05T11:23:21.145579+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  250. 2023-12-05T11:23:21.243570+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  251. 2023-12-05T11:23:21.243754+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  252. 2023-12-05T11:23:21.244760+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465999651787. Please stop the old node or wait for it to leave the group.'
  253. 2023-12-05T11:23:21.246017+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  254. 2023-12-05T11:23:21.342993+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  255. 2023-12-05T11:23:21.343212+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  256. 2023-12-05T11:23:21.344081+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465999651787. Please stop the old node or wait for it to leave the group.'
  257. 2023-12-05T11:23:21.345054+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  258. 2023-12-05T11:23:21.442231+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  259. 2023-12-05T11:23:21.442462+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  260. 2023-12-05T11:23:21.443370+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465999651787. Please stop the old node or wait for it to leave the group.'
  261. 2023-12-05T11:23:21.444398+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  262. 2023-12-05T11:23:21.541486+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  263. 2023-12-05T11:23:21.541641+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  264. 2023-12-05T11:23:21.542509+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465999651787. Please stop the old node or wait for it to leave the group.'
  265. 2023-12-05T11:23:21.543504+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  266. 2023-12-05T11:23:21.641056+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:48 connected'
  267. 2023-12-05T11:23:21.641232+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:48'
  268. 2023-12-05T11:23:21.642303+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465999651787. Please stop the old node or wait for it to leave the group.'
  269. 2023-12-05T11:23:21.643483+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:48 in close_connection'
  270. 2023-12-05T11:23:21.740341+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  271. 2023-12-05T11:23:21.740542+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  272. 2023-12-05T11:23:21.741547+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465999651787. Please stop the old node or wait for it to leave the group.'
  273. 2023-12-05T11:23:21.742603+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  274. 2023-12-05T11:23:21.839591+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:48 connected'
  275. 2023-12-05T11:23:21.839734+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:48'
  276. 2023-12-05T11:23:21.840638+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017465999651787. Please stop the old node or wait for it to leave the group.'
  277. 2023-12-05T11:23:21.841747+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:48 in close_connection'
  278. 2023-12-05T11:23:28.514003+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  279. 2023-12-05T11:23:28.514250+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  280. 2023-12-05T11:23:28.515228+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466074625778. Please stop the old node or wait for it to leave the group.'
  281. 2023-12-05T11:23:28.516276+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  282. 2023-12-05T11:23:28.613288+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  283. 2023-12-05T11:23:28.613482+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  284. 2023-12-05T11:23:28.614430+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466074625778. Please stop the old node or wait for it to leave the group.'
  285. 2023-12-05T11:23:28.615532+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  286. 2023-12-05T11:23:28.713284+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  287. 2023-12-05T11:23:28.713455+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  288. 2023-12-05T11:23:28.714357+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466074625778. Please stop the old node or wait for it to leave the group.'
  289. 2023-12-05T11:23:28.715625+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  290. 2023-12-05T11:23:28.813343+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  291. 2023-12-05T11:23:28.813522+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  292. 2023-12-05T11:23:28.814425+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466074625778. Please stop the old node or wait for it to leave the group.'
  293. 2023-12-05T11:23:28.815713+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  294. 2023-12-05T11:23:28.912809+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  295. 2023-12-05T11:23:28.912980+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  296. 2023-12-05T11:23:28.914160+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466074625778. Please stop the old node or wait for it to leave the group.'
  297. 2023-12-05T11:23:28.915373+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  298. 2023-12-05T11:23:29.012703+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  299. 2023-12-05T11:23:29.012849+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  300. 2023-12-05T11:23:29.013577+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466074625778. Please stop the old node or wait for it to leave the group.'
  301. 2023-12-05T11:23:29.014477+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  302. 2023-12-05T11:23:29.111824+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  303. 2023-12-05T11:23:29.112039+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  304. 2023-12-05T11:23:29.113227+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466074625778. Please stop the old node or wait for it to leave the group.'
  305. 2023-12-05T11:23:29.114532+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  306. 2023-12-05T11:23:29.210925+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  307. 2023-12-05T11:23:29.211179+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  308. 2023-12-05T11:23:29.212072+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466074625778. Please stop the old node or wait for it to leave the group.'
  309. 2023-12-05T11:23:29.213318+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  310. 2023-12-05T11:23:29.310294+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  311. 2023-12-05T11:23:29.310477+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  312. 2023-12-05T11:23:29.311615+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466074625778. Please stop the old node or wait for it to leave the group.'
  313. 2023-12-05T11:23:29.312547+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  314. 2023-12-05T11:23:29.410089+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:52 connected'
  315. 2023-12-05T11:23:29.410284+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:52'
  316. 2023-12-05T11:23:29.411230+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466074625778. Please stop the old node or wait for it to leave the group.'
  317. 2023-12-05T11:23:29.412250+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection'
  318. 2023-12-05T11:23:35.987001+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  319. 2023-12-05T11:23:35.987216+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  320. 2023-12-05T11:23:35.987966+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466150214388. Please stop the old node or wait for it to leave the group.'
  321. 2023-12-05T11:23:35.988985+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  322. 2023-12-05T11:23:36.086237+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  323. 2023-12-05T11:23:36.086415+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  324. 2023-12-05T11:23:36.087528+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466150214388. Please stop the old node or wait for it to leave the group.'
  325. 2023-12-05T11:23:36.088851+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  326. 2023-12-05T11:23:36.185607+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  327. 2023-12-05T11:23:36.185762+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  328. 2023-12-05T11:23:36.186696+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466150214388. Please stop the old node or wait for it to leave the group.'
  329. 2023-12-05T11:23:36.187663+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  330. 2023-12-05T11:23:36.285704+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  331. 2023-12-05T11:23:36.285856+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  332. 2023-12-05T11:23:36.286753+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466150214388. Please stop the old node or wait for it to leave the group.'
  333. 2023-12-05T11:23:36.287685+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  334. 2023-12-05T11:23:36.385167+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  335. 2023-12-05T11:23:36.385307+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  336. 2023-12-05T11:23:36.386283+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466150214388. Please stop the old node or wait for it to leave the group.'
  337. 2023-12-05T11:23:36.387321+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  338. 2023-12-05T11:23:36.484224+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  339. 2023-12-05T11:23:36.484399+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  340. 2023-12-05T11:23:36.485498+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466150214388. Please stop the old node or wait for it to leave the group.'
  341. 2023-12-05T11:23:36.486570+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  342. 2023-12-05T11:23:36.583618+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  343. 2023-12-05T11:23:36.583784+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  344. 2023-12-05T11:23:36.584850+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466150214388. Please stop the old node or wait for it to leave the group.'
  345. 2023-12-05T11:23:36.585762+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  346. 2023-12-05T11:23:36.683385+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  347. 2023-12-05T11:23:36.683549+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  348. 2023-12-05T11:23:36.684628+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466150214388. Please stop the old node or wait for it to leave the group.'
  349. 2023-12-05T11:23:36.685573+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  350. 2023-12-05T11:23:36.783497+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  351. 2023-12-05T11:23:36.783653+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  352. 2023-12-05T11:23:36.787678+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466150214388. Please stop the old node or wait for it to leave the group.'
  353. 2023-12-05T11:23:36.788749+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  354. 2023-12-05T11:23:36.883315+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  355. 2023-12-05T11:23:36.883493+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  356. 2023-12-05T11:23:36.884386+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466150214388. Please stop the old node or wait for it to leave the group.'
  357. 2023-12-05T11:23:36.885467+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  358. 2023-12-05T11:23:43.557848+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  359. 2023-12-05T11:23:43.558046+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  360. 2023-12-05T11:23:43.558857+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466225999935. Please stop the old node or wait for it to leave the group.'
  361. 2023-12-05T11:23:43.559793+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  362. 2023-12-05T11:23:43.657203+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  363. 2023-12-05T11:23:43.657337+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  364. 2023-12-05T11:23:43.658151+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466225999935. Please stop the old node or wait for it to leave the group.'
  365. 2023-12-05T11:23:43.659220+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  366. 2023-12-05T11:23:43.756248+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  367. 2023-12-05T11:23:43.756402+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  368. 2023-12-05T11:23:43.757345+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466225999935. Please stop the old node or wait for it to leave the group.'
  369. 2023-12-05T11:23:43.758518+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  370. 2023-12-05T11:23:43.855731+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  371. 2023-12-05T11:23:43.855887+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  372. 2023-12-05T11:23:43.856913+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466225999935. Please stop the old node or wait for it to leave the group.'
  373. 2023-12-05T11:23:43.858065+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  374. 2023-12-05T11:23:43.955423+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  375. 2023-12-05T11:23:43.955656+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  376. 2023-12-05T11:23:43.956577+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466225999935. Please stop the old node or wait for it to leave the group.'
  377. 2023-12-05T11:23:43.957523+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  378. 2023-12-05T11:23:44.058030+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  379. 2023-12-05T11:23:44.058246+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  380. 2023-12-05T11:23:44.059199+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466225999935. Please stop the old node or wait for it to leave the group.'
  381. 2023-12-05T11:23:44.060239+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  382. 2023-12-05T11:23:44.157766+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  383. 2023-12-05T11:23:44.157947+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  384. 2023-12-05T11:23:44.158743+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466225999935. Please stop the old node or wait for it to leave the group.'
  385. 2023-12-05T11:23:44.160055+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  386. 2023-12-05T11:23:44.256846+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  387. 2023-12-05T11:23:44.257001+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  388. 2023-12-05T11:23:44.257954+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466225999935. Please stop the old node or wait for it to leave the group.'
  389. 2023-12-05T11:23:44.258929+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  390. 2023-12-05T11:23:44.355986+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  391. 2023-12-05T11:23:44.356198+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  392. 2023-12-05T11:23:44.356948+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466225999935. Please stop the old node or wait for it to leave the group.'
  393. 2023-12-05T11:23:44.357827+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  394. 2023-12-05T11:23:44.455211+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  395. 2023-12-05T11:23:44.455387+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  396. 2023-12-05T11:23:44.456461+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466225999935. Please stop the old node or wait for it to leave the group.'
  397. 2023-12-05T11:23:44.457606+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  398. 2023-12-05T11:23:51.129890+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  399. 2023-12-05T11:23:51.130143+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  400. 2023-12-05T11:23:51.131053+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466300766585. Please stop the old node or wait for it to leave the group.'
  401. 2023-12-05T11:23:51.132232+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  402. 2023-12-05T11:23:51.229793+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  403. 2023-12-05T11:23:51.229979+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  404. 2023-12-05T11:23:51.231073+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466300766585. Please stop the old node or wait for it to leave the group.'
  405. 2023-12-05T11:23:51.232506+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  406. 2023-12-05T11:23:51.328968+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  407. 2023-12-05T11:23:51.329217+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  408. 2023-12-05T11:23:51.330170+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466300766585. Please stop the old node or wait for it to leave the group.'
  409. 2023-12-05T11:23:51.331255+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  410. 2023-12-05T11:23:51.428325+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  411. 2023-12-05T11:23:51.428517+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  412. 2023-12-05T11:23:51.429591+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466300766585. Please stop the old node or wait for it to leave the group.'
  413. 2023-12-05T11:23:51.430831+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  414. 2023-12-05T11:23:51.527822+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  415. 2023-12-05T11:23:51.527987+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  416. 2023-12-05T11:23:51.529013+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466300766585. Please stop the old node or wait for it to leave the group.'
  417. 2023-12-05T11:23:51.529961+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  418. 2023-12-05T11:23:51.627545+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  419. 2023-12-05T11:23:51.627714+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  420. 2023-12-05T11:23:51.628821+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466300766585. Please stop the old node or wait for it to leave the group.'
  421. 2023-12-05T11:23:51.629966+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  422. 2023-12-05T11:23:51.726832+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  423. 2023-12-05T11:23:51.726990+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  424. 2023-12-05T11:23:51.728146+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466300766585. Please stop the old node or wait for it to leave the group.'
  425. 2023-12-05T11:23:51.729265+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  426. 2023-12-05T11:23:51.826653+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  427. 2023-12-05T11:23:51.826832+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  428. 2023-12-05T11:23:51.827914+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466300766585. Please stop the old node or wait for it to leave the group.'
  429. 2023-12-05T11:23:51.829036+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  430. 2023-12-05T11:23:51.926295+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  431. 2023-12-05T11:23:51.926493+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  432. 2023-12-05T11:23:51.927544+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466300766585. Please stop the old node or wait for it to leave the group.'
  433. 2023-12-05T11:23:51.928720+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  434. 2023-12-05T11:23:52.025407+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  435. 2023-12-05T11:23:52.025631+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  436. 2023-12-05T11:23:52.026583+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466300766585. Please stop the old node or wait for it to leave the group.'
  437. 2023-12-05T11:23:52.027590+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  438. 2023-12-05T11:23:59.096492+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  439. 2023-12-05T11:23:59.096684+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  440. 2023-12-05T11:23:59.097894+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466376926735. Please stop the old node or wait for it to leave the group.'
  441. 2023-12-05T11:23:59.098950+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  442. 2023-12-05T11:23:59.195911+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  443. 2023-12-05T11:23:59.196044+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  444. 2023-12-05T11:23:59.196980+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466376926735. Please stop the old node or wait for it to leave the group.'
  445. 2023-12-05T11:23:59.198233+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  446. 2023-12-05T11:23:59.295642+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  447. 2023-12-05T11:23:59.295815+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  448. 2023-12-05T11:23:59.296636+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466376926735. Please stop the old node or wait for it to leave the group.'
  449. 2023-12-05T11:23:59.297751+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  450. 2023-12-05T11:23:59.395590+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  451. 2023-12-05T11:23:59.395772+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  452. 2023-12-05T11:23:59.396741+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466376926735. Please stop the old node or wait for it to leave the group.'
  453. 2023-12-05T11:23:59.397836+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  454. 2023-12-05T11:23:59.494968+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  455. 2023-12-05T11:23:59.495177+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  456. 2023-12-05T11:23:59.496024+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466376926735. Please stop the old node or wait for it to leave the group.'
  457. 2023-12-05T11:23:59.497066+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  458. 2023-12-05T11:23:59.594920+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  459. 2023-12-05T11:23:59.595067+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  460. 2023-12-05T11:23:59.596279+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466376926735. Please stop the old node or wait for it to leave the group.'
  461. 2023-12-05T11:23:59.597562+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  462. 2023-12-05T11:23:59.694772+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  463. 2023-12-05T11:23:59.694904+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  464. 2023-12-05T11:23:59.695801+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466376926735. Please stop the old node or wait for it to leave the group.'
  465. 2023-12-05T11:23:59.696749+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  466. 2023-12-05T11:23:59.793829+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  467. 2023-12-05T11:23:59.793964+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  468. 2023-12-05T11:23:59.794916+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466376926735. Please stop the old node or wait for it to leave the group.'
  469. 2023-12-05T11:23:59.795868+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  470. 2023-12-05T11:23:59.892993+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  471. 2023-12-05T11:23:59.893179+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  472. 2023-12-05T11:23:59.894144+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466376926735. Please stop the old node or wait for it to leave the group.'
  473. 2023-12-05T11:23:59.895083+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  474. 2023-12-05T11:23:59.992737+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  475. 2023-12-05T11:23:59.992917+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  476. 2023-12-05T11:23:59.993937+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466376926735. Please stop the old node or wait for it to leave the group.'
  477. 2023-12-05T11:23:59.994746+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  478. 2023-12-05T11:24:06.670031+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  479. 2023-12-05T11:24:06.670278+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  480. 2023-12-05T11:24:06.671044+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466457198100. Please stop the old node or wait for it to leave the group.'
  481. 2023-12-05T11:24:06.672191+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  482. 2023-12-05T11:24:06.769731+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  483. 2023-12-05T11:24:06.769905+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  484. 2023-12-05T11:24:06.770763+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466457198100. Please stop the old node or wait for it to leave the group.'
  485. 2023-12-05T11:24:06.771702+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  486. 2023-12-05T11:24:06.869599+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  487. 2023-12-05T11:24:06.869800+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  488. 2023-12-05T11:24:06.870859+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466457198100. Please stop the old node or wait for it to leave the group.'
  489. 2023-12-05T11:24:06.872009+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  490. 2023-12-05T11:24:06.969421+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  491. 2023-12-05T11:24:06.969595+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  492. 2023-12-05T11:24:06.970520+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466457198100. Please stop the old node or wait for it to leave the group.'
  493. 2023-12-05T11:24:06.971846+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  494. 2023-12-05T11:24:07.068623+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  495. 2023-12-05T11:24:07.068767+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  496. 2023-12-05T11:24:07.069692+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466457198100. Please stop the old node or wait for it to leave the group.'
  497. 2023-12-05T11:24:07.070646+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  498. 2023-12-05T11:24:07.167971+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  499. 2023-12-05T11:24:07.168162+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  500. 2023-12-05T11:24:07.169164+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466457198100. Please stop the old node or wait for it to leave the group.'
  501. 2023-12-05T11:24:07.170410+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  502. 2023-12-05T11:24:07.267635+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  503. 2023-12-05T11:24:07.267791+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  504. 2023-12-05T11:24:07.268778+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466457198100. Please stop the old node or wait for it to leave the group.'
  505. 2023-12-05T11:24:07.270100+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  506. 2023-12-05T11:24:07.367638+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  507. 2023-12-05T11:24:07.367792+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  508. 2023-12-05T11:24:07.368902+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466457198100. Please stop the old node or wait for it to leave the group.'
  509. 2023-12-05T11:24:07.369964+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
  510. 2023-12-05T11:24:07.467723+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:43 connected'
  511. 2023-12-05T11:24:07.467882+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:43'
  512. 2023-12-05T11:24:07.468775+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466457198100. Please stop the old node or wait for it to leave the group.'
  513. 2023-12-05T11:24:07.469730+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:43 in close_connection'
  514. 2023-12-05T11:24:07.567859+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:64 connected'
  515. 2023-12-05T11:24:07.568005+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:64'
  516. 2023-12-05T11:24:07.569068+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017466457198100. Please stop the old node or wait for it to leave the group.'
  517. 2023-12-05T11:24:07.570039+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:64 in close_connection'
复制代码


3. 188执行show engine innodb status\G
  1. (Tue Dec  5 11:25:31 2023)[root@GreatSQL][(none)]>show engine innodb status\G
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 2023-12-05 11:25:33 139837876147968 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 7 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 146634 srv_active, 0 srv_shutdown, 1047831 srv_idle
  14. srv_master_thread log flush and writes: 0
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 81876
  19. OS WAIT ARRAY INFO: signal count 207328
  20. RW-shared spins 0, rounds 0, OS waits 0
  21. RW-excl spins 0, rounds 0, OS waits 0
  22. RW-sx spins 0, rounds 0, OS waits 0
  23. Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  24. ------------
  25. TRANSACTIONS
  26. ------------
  27. Trx id counter 41735491
  28. Purge done for trx's n:o < 41735490 undo n:o < 0 state: running but idle
  29. History list length 0
  30. LIST OF TRANSACTIONS FOR EACH SESSION:
  31. ---TRANSACTION 421318168155752, not started
  32. 0 lock struct(s), heap size 1128, 0 row lock(s)
  33. ---TRANSACTION 421318168156600, not started
  34. 0 lock struct(s), heap size 1128, 0 row lock(s)
  35. ---TRANSACTION 421318168159144, not started
  36. 0 lock struct(s), heap size 1128, 0 row lock(s)
  37. ---TRANSACTION 421318168163384, not started
  38. 0 lock struct(s), heap size 1128, 0 row lock(s)
  39. ---TRANSACTION 421318168162536, not started
  40. 0 lock struct(s), heap size 1128, 0 row lock(s)
  41. ---TRANSACTION 421318168161688, not started
  42. 0 lock struct(s), heap size 1128, 0 row lock(s)
  43. ---TRANSACTION 421318168160840, not started
  44. 0 lock struct(s), heap size 1128, 0 row lock(s)
  45. ---TRANSACTION 421318168159992, not started
  46. 0 lock struct(s), heap size 1128, 0 row lock(s)
  47. ---TRANSACTION 421318168157448, not started
  48. 0 lock struct(s), heap size 1128, 0 row lock(s)
  49. ---TRANSACTION 421318168154904, not started
  50. 0 lock struct(s), heap size 1128, 0 row lock(s)
  51. ---TRANSACTION 421318168154056, not started
  52. 0 lock struct(s), heap size 1128, 0 row lock(s)
  53. --------
  54. FILE I/O
  55. --------
  56. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  57. I/O thread 1 state: waiting for completed aio requests (log thread)
  58. I/O thread 2 state: waiting for completed aio requests (read thread)
  59. I/O thread 3 state: waiting for completed aio requests (read thread)
  60. I/O thread 4 state: waiting for completed aio requests (read thread)
  61. I/O thread 5 state: waiting for completed aio requests (read thread)
  62. I/O thread 6 state: waiting for completed aio requests (write thread)
  63. I/O thread 7 state: waiting for completed aio requests (write thread)
  64. I/O thread 8 state: waiting for completed aio requests (write thread)
  65. I/O thread 9 state: waiting for completed aio requests (write thread)
  66. I/O thread 10 state: waiting for completed aio requests (write thread)
  67. I/O thread 11 state: waiting for completed aio requests (write thread)
  68. I/O thread 12 state: waiting for completed aio requests (write thread)
  69. I/O thread 13 state: waiting for completed aio requests (write thread)
  70. I/O thread 14 state: waiting for completed aio requests (write thread)
  71. I/O thread 15 state: waiting for completed aio requests (write thread)
  72. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
  73. ibuf aio reads:, log i/o's:
  74. Pending flushes (fsync) log: 0; buffer pool: 18
  75. 2277 OS file reads, 2926538 OS file writes, 885733 OS fsyncs
  76. 0.00 reads/s, 0 avg bytes/read, 0.41 writes/s, 0.00 fsyncs/s
  77. -------------------------------------
  78. INSERT BUFFER AND ADAPTIVE HASH INDEX
  79. -------------------------------------
  80. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  81. merged operations:
  82. insert 0, delete mark 0, delete 0
  83. discarded operations:
  84. insert 0, delete mark 0, delete 0
  85. Hash table size 276707, node heap has 0 buffer(s)
  86. Hash table size 276707, node heap has 0 buffer(s)
  87. Hash table size 276707, node heap has 0 buffer(s)
  88. Hash table size 276707, node heap has 0 buffer(s)
  89. Hash table size 276707, node heap has 0 buffer(s)
  90. Hash table size 276707, node heap has 0 buffer(s)
  91. Hash table size 276707, node heap has 0 buffer(s)
  92. Hash table size 276707, node heap has 0 buffer(s)
  93. 0.00 hash searches/s, 3.00 non-hash searches/s
  94. ---
  95. LOG
  96. ---
  97. Log sequence number          25345870386
  98. Log buffer assigned up to    25345870386
  99. Log buffer completed up to   25345870386
  100. Log written up to            25345870386
  101. Log flushed up to            25345870386
  102. Added dirty pages up to      25345870386
  103. Pages flushed up to          25345870386
  104. Last checkpoint at           25345870386
  105. Log minimum file id is       119
  106. Log maximum file id is       125
  107. Modified age no less than    25345870386
  108. Checkpoint age               0
  109. Max checkpoint age           5422668288
  110. 2262305 log i/o's done, 0.00 log i/o's/second
  111. ----------------------
  112. BUFFER POOL AND MEMORY
  113. ----------------------
  114. Total large memory allocated 0
  115. Dictionary memory allocated 733538
  116. Buffer pool size   65528
  117. Buffer pool size, bytes 1073610752
  118. Free buffers       32000
  119. Database pages     33528
  120. Old database pages 12216
  121. Modified db pages  0
  122. Pending reads      0
  123. Pending writes: LRU 0, flush list 0, single page 0
  124. Pages made young 36127, not young 38986
  125. 0.54 youngs/s, 0.00 non-youngs/s
  126. Pages read 1536, created 229813, written 545499
  127. 0.00 reads/s, 0.27 creates/s, 0.41 writes/s
  128. Buffer pool hit rate 1000 / 1000, young-making rate 36 / 1000 not 0 / 1000
  129. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  130. LRU len: 33528, unzip_LRU len: 0
  131. I/O sum[168]:cur[0], unzip sum[0]:cur[0]
  132. ----------------------
  133. INDIVIDUAL BUFFER POOL INFO
  134. ----------------------
  135. ---BUFFER POOL 0
  136. Buffer pool size   8191
  137. Buffer pool size, bytes 134201344
  138. Free buffers       4000
  139. Database pages     4191
  140. Old database pages 1527
  141. Modified db pages  0
  142. Pending reads      0
  143. Pending writes: LRU 0, flush list 0, single page 0
  144. Pages made young 45, not young 129
  145. 0.00 youngs/s, 0.00 non-youngs/s
  146. Pages read 193, created 5618, written 7926
  147. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  148. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  149. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  150. LRU len: 4191, unzip_LRU len: 0
  151. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  152. ---BUFFER POOL 1
  153. Buffer pool size   8191
  154. Buffer pool size, bytes 134201344
  155. Free buffers       4000
  156. Database pages     4191
  157. Old database pages 1527
  158. Modified db pages  0
  159. Pending reads      0
  160. Pending writes: LRU 0, flush list 0, single page 0
  161. Pages made young 1019, not young 230
  162. 0.00 youngs/s, 0.00 non-youngs/s
  163. Pages read 165, created 6556, written 9143
  164. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  165. No buffer pool page gets since the last printout
  166. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  167. LRU len: 4191, unzip_LRU len: 0
  168. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  169. ---BUFFER POOL 2
  170. Buffer pool size   8191
  171. Buffer pool size, bytes 134201344
  172. Free buffers       4000
  173. Database pages     4191
  174. Old database pages 1527
  175. Modified db pages  0
  176. Pending reads      0
  177. Pending writes: LRU 0, flush list 0, single page 0
  178. Pages made young 113, not young 345
  179. 0.00 youngs/s, 0.00 non-youngs/s
  180. Pages read 196, created 6877, written 8871
  181. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  182. No buffer pool page gets since the last printout
  183. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  184. LRU len: 4191, unzip_LRU len: 0
  185. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  186. ---BUFFER POOL 3
  187. Buffer pool size   8191
  188. Buffer pool size, bytes 134201344
  189. Free buffers       4000
  190. Database pages     4191
  191. Old database pages 1527
  192. Modified db pages  0
  193. Pending reads      0
  194. Pending writes: LRU 0, flush list 0, single page 0
  195. Pages made young 7349, not young 14868
  196. 0.54 youngs/s, 0.00 non-youngs/s
  197. Pages read 289, created 52332, written 132747
  198. 0.00 reads/s, 0.27 creates/s, 0.41 writes/s
  199. Buffer pool hit rate 1000 / 1000, young-making rate 57 / 1000 not 0 / 1000
  200. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  201. LRU len: 4191, unzip_LRU len: 0
  202. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  203. ---BUFFER POOL 4
  204. Buffer pool size   8191
  205. Buffer pool size, bytes 134201344
  206. Free buffers       4000
  207. Database pages     4191
  208. Old database pages 1527
  209. Modified db pages  0
  210. Pending reads      0
  211. Pending writes: LRU 0, flush list 0, single page 0
  212. Pages made young 7683, not young 177
  213. 0.00 youngs/s, 0.00 non-youngs/s
  214. Pages read 93, created 52549, written 130217
  215. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  216. No buffer pool page gets since the last printout
  217. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  218. LRU len: 4191, unzip_LRU len: 0
  219. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  220. ---BUFFER POOL 5
  221. Buffer pool size   8191
  222. Buffer pool size, bytes 134201344
  223. Free buffers       4000
  224. Database pages     4191
  225. Old database pages 1527
  226. Modified db pages  0
  227. Pending reads      0
  228. Pending writes: LRU 0, flush list 0, single page 0
  229. Pages made young 9584, not young 1297
  230. 0.00 youngs/s, 0.00 non-youngs/s
  231. Pages read 27, created 48200, written 117488
  232. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  233. No buffer pool page gets since the last printout
  234. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  235. LRU len: 4191, unzip_LRU len: 0
  236. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  237. ---BUFFER POOL 6
  238. Buffer pool size   8191
  239. Buffer pool size, bytes 134201344
  240. Free buffers       4000
  241. Database pages     4191
  242. Old database pages 1527
  243. Modified db pages  0
  244. Pending reads      0
  245. Pending writes: LRU 0, flush list 0, single page 0
  246. Pages made young 10050, not young 7780
  247. 0.00 youngs/s, 0.00 non-youngs/s
  248. Pages read 139, created 52121, written 128902
  249. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  250. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  251. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  252. LRU len: 4191, unzip_LRU len: 0
  253. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  254. ---BUFFER POOL 7
  255. Buffer pool size   8191
  256. Buffer pool size, bytes 134201344
  257. Free buffers       4000
  258. Database pages     4191
  259. Old database pages 1527
  260. Modified db pages  0
  261. Pending reads      0
  262. Pending writes: LRU 0, flush list 0, single page 0
  263. Pages made young 284, not young 14160
  264. 0.00 youngs/s, 0.00 non-youngs/s
  265. Pages read 434, created 5560, written 10205
  266. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  267. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  268. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  269. LRU len: 4191, unzip_LRU len: 0
  270. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  271. --------------
  272. ROW OPERATIONS
  273. --------------
  274. 0 queries inside InnoDB, 0 queries in queue
  275. 0 read views open inside InnoDB
  276. 0 RW transactions active inside InnoDB
  277. Process ID=1062, Main thread ID=139841544886016 , state=sleeping
  278. Number of rows inserted 7347575, updated 115920, deleted 0, read 2372983
  279. 1.57 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1.57 reads/s
  280. Number of system rows inserted 9229, updated 2019, deleted 8977, read 116739649
  281. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 2.86 reads/s
  282. ----------------------------
  283. END OF INNODB MONITOR OUTPUT
  284. ============================

  285. 1 row in set (0.00 sec)

  286. (Tue Dec  5 11:25:33 2023)[root@GreatSQL][(none)]>
复制代码



4、mgr状态
188执行
  1. (Tue Dec  5 11:25:33 2023)[root@GreatSQL][(none)]>select * from performance_schema.replication_group_members;SELECT * FROM performance_schema.replication_group_member_stats\G;show master status\G;SELECT MEMBER_ID AS id, COUNT_TRANSACTIONS_IN_QUEUE AS trx_tobe_certified, COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE AS relaylog_tobe_applied, COUNT_TRANSACTIONS_CHECKED AS trx_chkd, COUNT_TRANSACTIONS_REMOTE_APPLIED AS trx_done, COUNT_TRANSACTIONS_LOCAL_PROPOSED AS proposed FROM performance_schema.replication_group_member_stats;SELECT RECEIVED_TRANSACTION_SET FROM performance_schema.replication_connection_status WHERE  channel_name = 'group_replication_applier' UNION ALL SELECT variable_value FROM performance_schema.global_variables WHERE  variable_name = 'gtid_executed'\G;select now();SELECT MEMBER_ID,COUNT_TRANSACTIONS_ROWS_VALIDATING FROM performance_schema.replication_group_member_stats;
  2. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  3. | CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST   | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
  4. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  5. | group_replication_applier | a55de711-812e-11ee-b3fc-5254005b7a28 | 192.168.6.190 |        3308 | UNREACHABLE  | SECONDARY   | 8.0.32         | XCom                       |
  6. | group_replication_applier | a5609358-812e-11ee-abe4-525400b01dcf | 192.168.6.188 |        3308 | ONLINE       | PRIMARY     | 8.0.32         | XCom                       |
  7. | group_replication_applier | a5623edf-812e-11ee-92a9-525400980c24 | 192.168.6.189 |        3308 | ONLINE       | SECONDARY   | 8.0.32         | XCom                       |
  8. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  9. 3 rows in set (0.00 sec)

  10. *************************** 1. row ***************************
  11.                               CHANNEL_NAME: group_replication_applier
  12.                                    VIEW_ID: 17005521402960008:4
  13.                                  MEMBER_ID: a55de711-812e-11ee-b3fc-5254005b7a28
  14.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  15.                 COUNT_TRANSACTIONS_CHECKED: 115994
  16.                   COUNT_CONFLICTS_DETECTED: 0
  17.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  18.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  19. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  20.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19543900
  21. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  22.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 116005
  23.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
  24.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  25. *************************** 2. row ***************************
  26.                               CHANNEL_NAME: group_replication_applier
  27.                                    VIEW_ID: 17005521402960008:4
  28.                                  MEMBER_ID: a5609358-812e-11ee-abe4-525400b01dcf
  29.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  30.                 COUNT_TRANSACTIONS_CHECKED: 116195
  31.                   COUNT_CONFLICTS_DETECTED: 0
  32.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  33.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  34. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  35.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
  36. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  37.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 4
  38.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 116195
  39.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  40. *************************** 3. row ***************************
  41.                               CHANNEL_NAME: group_replication_applier
  42.                                    VIEW_ID: 17005521402960008:4
  43.                                  MEMBER_ID: a5623edf-812e-11ee-92a9-525400980c24
  44.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  45.                 COUNT_TRANSACTIONS_CHECKED: 269
  46.                   COUNT_CONFLICTS_DETECTED: 0
  47.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  48.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  49. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  50.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
  51. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  52.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 269
  53.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
  54.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  55. 3 rows in set (0.00 sec)

  56. ERROR:
  57. No query specified

  58. *************************** 1. row ***************************
  59.              File: binlog.000692
  60.          Position: 246047058
  61.      Binlog_Do_DB:
  62. Binlog_Ignore_DB:
  63. Executed_Gtid_Set: a5609358-812e-11ee-abe4-525400b01dcf:1,
  64. f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
  65. 1 row in set (0.00 sec)

  66. ERROR:
  67. No query specified

  68. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  69. | id                                   | trx_tobe_certified | relaylog_tobe_applied | trx_chkd | trx_done | proposed |
  70. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  71. | a55de711-812e-11ee-b3fc-5254005b7a28 |                  0 |                     0 |   115994 |   116005 |        0 |
  72. | a5609358-812e-11ee-abe4-525400b01dcf |                  0 |                     0 |   116195 |        4 |   116195 |
  73. | a5623edf-812e-11ee-92a9-525400980c24 |                  0 |                     0 |      269 |      269 |        0 |
  74. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  75. 3 rows in set (0.00 sec)

  76. *************************** 1. row ***************************
  77. RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
  78. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  79. *************************** 2. row ***************************
  80. RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
  81. f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
  82. 2 rows in set (0.00 sec)

  83. ERROR:
  84. No query specified

  85. +---------------------+
  86. | now()               |
  87. +---------------------+
  88. | 2023-12-05 11:27:05 |
  89. +---------------------+
  90. 1 row in set (0.00 sec)

  91. +--------------------------------------+------------------------------------+
  92. | MEMBER_ID                            | COUNT_TRANSACTIONS_ROWS_VALIDATING |
  93. +--------------------------------------+------------------------------------+
  94. | a55de711-812e-11ee-b3fc-5254005b7a28 |                                  0 |
  95. | a5609358-812e-11ee-abe4-525400b01dcf |                                  0 |
  96. | a5623edf-812e-11ee-92a9-525400980c24 |                                  0 |
  97. +--------------------------------------+------------------------------------+
  98. 3 rows in set (0.00 sec)

  99. (Tue Dec  5 11:27:05 2023)[root@GreatSQL][(none)]>
复制代码
补充188执行的mysqlsh检测结果:
  1. MySQL  192.168.6.188:3308 ssl  Py > c=dba.get_cluster()
  2. MySQL  192.168.6.188:3308 ssl  Py > c.status()
  3. {
  4.     "clusterName": "test_mgr01",
  5.     "defaultReplicaSet": {
  6.         "name": "default",
  7.         "primary": "192.168.6.188:3308",
  8.         "ssl": "REQUIRED",
  9.         "status": "OK_NO_TOLERANCE",
  10.         "statusText": "Cluster is NOT tolerant to any failures. 1 member is not active.",
  11.         "topology": {
  12.             "192.168.6.188:3308": {
  13.                 "address": "192.168.6.188:3308",
  14.                 "memberRole": "PRIMARY",
  15.                 "mode": "R/W",
  16.                 "readReplicas": {},
  17.                 "replicationLag": null,
  18.                 "role": "HA",
  19.                 "status": "ONLINE",
  20.                 "version": "8.0.32"
  21.             },
  22.             "192.168.6.189:3308": {
  23.                 "address": "192.168.6.189:3308",
  24.                 "memberRole": "SECONDARY",
  25.                 "mode": "R/O",
  26.                 "readReplicas": {},
  27.                 "replicationLag": null,
  28.                 "role": "HA",
  29.                 "status": "ONLINE",
  30.                 "version": "8.0.32"
  31.             },
  32.             "192.168.6.190:3308": {
  33.                 "address": "192.168.6.190:3308",
  34.                 "instanceErrors": [
  35.                     "NOTE: group_replication is stopped."
  36.                 ],
  37.                 "memberRole": "SECONDARY",
  38.                 "memberState": "OFFLINE",
  39.                 "mode": "R/O",
  40.                 "readReplicas": {},
  41.                 "role": "HA",
  42.                 "status": "UNREACHABLE",
  43.                 "version": "8.0.32"
  44.             }
  45.         },
  46.         "topologyMode": "Single-Primary"
  47.     },
  48.     "groupInformationSourceMember": "192.168.6.188:3308"
  49. }
  50. MySQL  192.168.6.188:3308 ssl  Py >
复制代码


189执行
  1. (Tue Dec  5 10:30:34 2023)[root@GreatSQL][tpcc10]>select * from performance_schema.replication_group_members;SELECT * FROM performance_schema.replication_group_member_stats\G;show master status\G;SELECT MEMBER_ID AS id, COUNT_TRANSACTIONS_IN_QUEUE AS trx_tobe_certified, COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE AS relaylog_tobe_applied, COUNT_TRANSACTIONS_CHECKED AS trx_chkd, COUNT_TRANSACTIONS_REMOTE_APPLIED AS trx_done, COUNT_TRANSACTIONS_LOCAL_PROPOSED AS proposed FROM performance_schema.replication_group_member_stats;SELECT RECEIVED_TRANSACTION_SET FROM performance_schema.replication_connection_status WHERE  channel_name = 'group_replication_applier' UNION ALL SELECT variable_value FROM performance_schema.global_variables WHERE  variable_name = 'gtid_executed'\G;select now();SELECT MEMBER_ID,COUNT_TRANSACTIONS_ROWS_VALIDATING FROM performance_schema.replication_group_member_stats;
  2. ERROR 4031 (HY000): The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior.
  3. No connection. Trying to reconnect...
  4. Connection id:    38
  5. Current database: tpcc10

  6. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  7. | CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST   | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
  8. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  9. | group_replication_applier | a55de711-812e-11ee-b3fc-5254005b7a28 | 192.168.6.190 |        3308 | UNREACHABLE  | SECONDARY   | 8.0.32         | XCom                       |
  10. | group_replication_applier | a5609358-812e-11ee-abe4-525400b01dcf | 192.168.6.188 |        3308 | ONLINE       | PRIMARY     | 8.0.32         | XCom                       |
  11. | group_replication_applier | a5623edf-812e-11ee-92a9-525400980c24 | 192.168.6.189 |        3308 | ONLINE       | SECONDARY   | 8.0.32         | XCom                       |
  12. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  13. 3 rows in set (0.00 sec)

  14. *************************** 1. row ***************************
  15.                               CHANNEL_NAME: group_replication_applier
  16.                                    VIEW_ID: 17005521402960008:4
  17.                                  MEMBER_ID: a55de711-812e-11ee-b3fc-5254005b7a28
  18.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  19.                 COUNT_TRANSACTIONS_CHECKED: 115994
  20.                   COUNT_CONFLICTS_DETECTED: 0
  21.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  22.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  23. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  24.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19543900
  25. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  26.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 116005
  27.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
  28.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  29. *************************** 2. row ***************************
  30.                               CHANNEL_NAME: group_replication_applier
  31.                                    VIEW_ID: 17005521402960008:4
  32.                                  MEMBER_ID: a5609358-812e-11ee-abe4-525400b01dcf
  33.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  34.                 COUNT_TRANSACTIONS_CHECKED: 116195
  35.                   COUNT_CONFLICTS_DETECTED: 0
  36.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  37.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  38. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  39.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
  40. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  41.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 4
  42.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 116195
  43.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  44. *************************** 3. row ***************************
  45.                               CHANNEL_NAME: group_replication_applier
  46.                                    VIEW_ID: 17005521402960008:4
  47.                                  MEMBER_ID: a5623edf-812e-11ee-92a9-525400980c24
  48.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  49.                 COUNT_TRANSACTIONS_CHECKED: 269
  50.                   COUNT_CONFLICTS_DETECTED: 0
  51.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  52.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  53. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  54.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
  55. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  56.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 269
  57.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
  58.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  59. 3 rows in set (0.00 sec)

  60. ERROR:
  61. No query specified

  62. *************************** 1. row ***************************
  63.              File: binlog.000026
  64.          Position: 151728036
  65.      Binlog_Do_DB:
  66. Binlog_Ignore_DB:
  67. Executed_Gtid_Set: a5609358-812e-11ee-abe4-525400b01dcf:1,
  68. f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
  69. 1 row in set (0.01 sec)

  70. ERROR:
  71. No query specified

  72. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  73. | id                                   | trx_tobe_certified | relaylog_tobe_applied | trx_chkd | trx_done | proposed |
  74. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  75. | a55de711-812e-11ee-b3fc-5254005b7a28 |                  0 |                     0 |   115994 |   116005 |        0 |
  76. | a5609358-812e-11ee-abe4-525400b01dcf |                  0 |                     0 |   116195 |        4 |   116195 |
  77. | a5623edf-812e-11ee-92a9-525400980c24 |                  0 |                     0 |      269 |      269 |        0 |
  78. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  79. 3 rows in set (0.00 sec)

  80. *************************** 1. row ***************************
  81. RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
  82. f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
  83. *************************** 2. row ***************************
  84. RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
  85. f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
  86. 2 rows in set (0.01 sec)

  87. ERROR:
  88. No query specified

  89. +---------------------+
  90. | now()               |
  91. +---------------------+
  92. | 2023-12-05 11:27:45 |
  93. +---------------------+
  94. 1 row in set (0.00 sec)

  95. +--------------------------------------+------------------------------------+
  96. | MEMBER_ID                            | COUNT_TRANSACTIONS_ROWS_VALIDATING |
  97. +--------------------------------------+------------------------------------+
  98. | a55de711-812e-11ee-b3fc-5254005b7a28 |                                  0 |
  99. | a5609358-812e-11ee-abe4-525400b01dcf |                                  0 |
  100. | a5623edf-812e-11ee-92a9-525400980c24 |                                  0 |
  101. +--------------------------------------+------------------------------------+
  102. 3 rows in set (0.00 sec)

  103. (Tue Dec  5 11:27:45 2023)[root@GreatSQL][tpcc10]>
复制代码

yejr 2023-12-5 12:51:52
running_db 发表于 2023-12-5 11:27
1. stop group_replication;select sleep(1);start group_replication;操作了6次
2. 这6次中,188master日 ...

注意我说的是“1. 暂停190节点反复重试加入mgr。”,也就是停止尝试加入mgr这个动作,不是让你反复重试加入mgr。
running_db 2023-12-5 13:51:20
yejr 发表于 2023-12-5 12:51
注意我说的是“1. 暂停190节点反复重试加入mgr。”,也就是停止尝试加入mgr这个动作,不是让你反复重试加 ...

1. 停止后,master日志没有任何变化,依旧是上次拒绝190加入的日志。到是189有新日志,两条。

188:
  1. [root@greatsql01 log]# tail -f error.log
  2. 2023-12-05T12:11:47.695006+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017495059959455. Please stop the old node or wait for it to leave the group.'
  3. 2023-12-05T12:11:47.696147+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:63 in close_connection'
  4. 2023-12-05T12:11:47.793762+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
  5. 2023-12-05T12:11:47.793916+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
  6. 2023-12-05T12:11:47.794826+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017495059959455. Please stop the old node or wait for it to leave the group.'
  7. 2023-12-05T12:11:47.796004+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
  8. 2023-12-05T12:11:47.893200+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:63 connected'
  9. 2023-12-05T12:11:47.893350+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:63'
  10. 2023-12-05T12:11:47.894470+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017495059959455. Please stop the old node or wait for it to leave the group.'
  11. 2023-12-05T12:11:47.895709+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:63 in close_connection'
复制代码



189:
  1. [root@greatsql02 ~]# tail -f /data/greatsql/8.0.32/log/error.log
  2. 2023-12-05T12:11:47.799393+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:42 connected'
  3. 2023-12-05T12:11:47.799614+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:42'
  4. 2023-12-05T12:11:47.800686+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017495059959455. Please stop the old node or wait for it to leave the group.'
  5. 2023-12-05T12:11:47.801667+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:42 in close_connection'
  6. 2023-12-05T12:11:47.899419+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:45 connected'
  7. 2023-12-05T12:11:47.899694+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:45'
  8. 2023-12-05T12:11:47.900776+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017495059959455. Please stop the old node or wait for it to leave the group.'
  9. 2023-12-05T12:11:47.901968+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:45 in close_connection'
  10. 2023-12-05T13:44:41.027189+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:35 connected'
  11. 2023-12-05T13:44:41.027717+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:35 in close_connection'
复制代码



2. 188执行show engine innodb status\G

  1. (Tue Dec  5 13:48:52 2023)[root@GreatSQL][(none)]>show engine innodb status\G
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 2023-12-05 13:48:53 139837876680448 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 7 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 147638 srv_active, 0 srv_shutdown, 1055424 srv_idle
  14. srv_master_thread log flush and writes: 0
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 81940
  19. OS WAIT ARRAY INFO: signal count 207394
  20. RW-shared spins 0, rounds 0, OS waits 0
  21. RW-excl spins 0, rounds 0, OS waits 0
  22. RW-sx spins 0, rounds 0, OS waits 0
  23. Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  24. ------------
  25. TRANSACTIONS
  26. ------------
  27. Trx id counter 41735491
  28. Purge done for trx's n:o < 41735490 undo n:o < 0 state: running but idle
  29. History list length 0
  30. LIST OF TRANSACTIONS FOR EACH SESSION:
  31. ---TRANSACTION 421318168159144, not started
  32. 0 lock struct(s), heap size 1128, 0 row lock(s)
  33. ---TRANSACTION 421318168155752, not started
  34. 0 lock struct(s), heap size 1128, 0 row lock(s)
  35. ---TRANSACTION 421318168158296, not started
  36. 0 lock struct(s), heap size 1128, 0 row lock(s)
  37. ---TRANSACTION 421318168156600, not started
  38. 0 lock struct(s), heap size 1128, 0 row lock(s)
  39. ---TRANSACTION 421318168163384, not started
  40. 0 lock struct(s), heap size 1128, 0 row lock(s)
  41. ---TRANSACTION 421318168162536, not started
  42. 0 lock struct(s), heap size 1128, 0 row lock(s)
  43. ---TRANSACTION 421318168161688, not started
  44. 0 lock struct(s), heap size 1128, 0 row lock(s)
  45. ---TRANSACTION 421318168160840, not started
  46. 0 lock struct(s), heap size 1128, 0 row lock(s)
  47. ---TRANSACTION 421318168159992, not started
  48. 0 lock struct(s), heap size 1128, 0 row lock(s)
  49. ---TRANSACTION 421318168157448, not started
  50. 0 lock struct(s), heap size 1128, 0 row lock(s)
  51. ---TRANSACTION 421318168154904, not started
  52. 0 lock struct(s), heap size 1128, 0 row lock(s)
  53. ---TRANSACTION 421318168154056, not started
  54. 0 lock struct(s), heap size 1128, 0 row lock(s)
  55. --------
  56. FILE I/O
  57. --------
  58. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  59. I/O thread 1 state: waiting for completed aio requests (log thread)
  60. I/O thread 2 state: waiting for completed aio requests (read thread)
  61. I/O thread 3 state: waiting for completed aio requests (read thread)
  62. I/O thread 4 state: waiting for completed aio requests (read thread)
  63. I/O thread 5 state: waiting for completed aio requests (read thread)
  64. I/O thread 6 state: waiting for completed aio requests (write thread)
  65. I/O thread 7 state: waiting for completed aio requests (write thread)
  66. I/O thread 8 state: waiting for completed aio requests (write thread)
  67. I/O thread 9 state: waiting for completed aio requests (write thread)
  68. I/O thread 10 state: waiting for completed aio requests (write thread)
  69. I/O thread 11 state: waiting for completed aio requests (write thread)
  70. I/O thread 12 state: waiting for completed aio requests (write thread)
  71. I/O thread 13 state: waiting for completed aio requests (write thread)
  72. I/O thread 14 state: waiting for completed aio requests (write thread)
  73. I/O thread 15 state: waiting for completed aio requests (write thread)
  74. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
  75. ibuf aio reads:, log i/o's:
  76. Pending flushes (fsync) log: 0; buffer pool: 18
  77. 2300 OS file reads, 2930377 OS file writes, 886147 OS fsyncs
  78. 0.00 reads/s, 0 avg bytes/read, 1.11 writes/s, 0.14 fsyncs/s
  79. -------------------------------------
  80. INSERT BUFFER AND ADAPTIVE HASH INDEX
  81. -------------------------------------
  82. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  83. merged operations:
  84. insert 0, delete mark 0, delete 0
  85. discarded operations:
  86. insert 0, delete mark 0, delete 0
  87. Hash table size 276707, node heap has 0 buffer(s)
  88. Hash table size 276707, node heap has 0 buffer(s)
  89. Hash table size 276707, node heap has 0 buffer(s)
  90. Hash table size 276707, node heap has 0 buffer(s)
  91. Hash table size 276707, node heap has 0 buffer(s)
  92. Hash table size 276707, node heap has 0 buffer(s)
  93. Hash table size 276707, node heap has 0 buffer(s)
  94. Hash table size 276707, node heap has 0 buffer(s)
  95. 0.00 hash searches/s, 782.75 non-hash searches/s
  96. ---
  97. LOG
  98. ---
  99. Log sequence number          25345870386
  100. Log buffer assigned up to    25345870386
  101. Log buffer completed up to   25345870386
  102. Log written up to            25345870386
  103. Log flushed up to            25345870386
  104. Added dirty pages up to      25345870386
  105. Pages flushed up to          25345870386
  106. Last checkpoint at           25345870386
  107. Log minimum file id is       119
  108. Log maximum file id is       125
  109. Modified age no less than    25345870386
  110. Checkpoint age               0
  111. Max checkpoint age           5422668288
  112. 2262305 log i/o's done, 0.00 log i/o's/second
  113. ----------------------
  114. BUFFER POOL AND MEMORY
  115. ----------------------
  116. Total large memory allocated 0
  117. Dictionary memory allocated 733538
  118. Buffer pool size   65528
  119. Buffer pool size, bytes 1073610752
  120. Free buffers       32000
  121. Database pages     33528
  122. Old database pages 12216
  123. Modified db pages  0
  124. Pending reads      0
  125. Pending writes: LRU 0, flush list 0, single page 0
  126. Pages made young 40135, not young 39298
  127. 1.11 youngs/s, 0.00 non-youngs/s
  128. Pages read 1559, created 231057, written 548924
  129. 0.00 reads/s, 0.42 creates/s, 0.97 writes/s
  130. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  131. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  132. LRU len: 33528, unzip_LRU len: 0
  133. I/O sum[168]:cur[0], unzip sum[0]:cur[0]
  134. ----------------------
  135. INDIVIDUAL BUFFER POOL INFO
  136. ----------------------
  137. ---BUFFER POOL 0
  138. Buffer pool size   8191
  139. Buffer pool size, bytes 134201344
  140. Free buffers       4000
  141. Database pages     4191
  142. Old database pages 1527
  143. Modified db pages  0
  144. Pending reads      0
  145. Pending writes: LRU 0, flush list 0, single page 0
  146. Pages made young 45, not young 143
  147. 0.00 youngs/s, 0.00 non-youngs/s
  148. Pages read 198, created 5618, written 7926
  149. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  150. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  151. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  152. LRU len: 4191, unzip_LRU len: 0
  153. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  154. ---BUFFER POOL 1
  155. Buffer pool size   8191
  156. Buffer pool size, bytes 134201344
  157. Free buffers       4000
  158. Database pages     4191
  159. Old database pages 1527
  160. Modified db pages  0
  161. Pending reads      0
  162. Pending writes: LRU 0, flush list 0, single page 0
  163. Pages made young 1019, not young 230
  164. 0.00 youngs/s, 0.00 non-youngs/s
  165. Pages read 165, created 6556, written 9143
  166. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  167. No buffer pool page gets since the last printout
  168. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  169. LRU len: 4191, unzip_LRU len: 0
  170. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  171. ---BUFFER POOL 2
  172. Buffer pool size   8191
  173. Buffer pool size, bytes 134201344
  174. Free buffers       4000
  175. Database pages     4191
  176. Old database pages 1527
  177. Modified db pages  0
  178. Pending reads      0
  179. Pending writes: LRU 0, flush list 0, single page 0
  180. Pages made young 113, not young 345
  181. 0.00 youngs/s, 0.00 non-youngs/s
  182. Pages read 196, created 6877, written 8871
  183. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  184. No buffer pool page gets since the last printout
  185. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  186. LRU len: 4191, unzip_LRU len: 0
  187. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  188. ---BUFFER POOL 3
  189. Buffer pool size   8191
  190. Buffer pool size, bytes 134201344
  191. Free buffers       4000
  192. Database pages     4191
  193. Old database pages 1527
  194. Modified db pages  0
  195. Pending reads      0
  196. Pending writes: LRU 0, flush list 0, single page 0
  197. Pages made young 8586, not young 14895
  198. 1.11 youngs/s, 0.00 non-youngs/s
  199. Pages read 289, created 52707, written 133801
  200. 0.00 reads/s, 0.28 creates/s, 0.83 writes/s
  201. Buffer pool hit rate 1000 / 1000, young-making rate 8 / 1000 not 0 / 1000
  202. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  203. LRU len: 4191, unzip_LRU len: 0
  204. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  205. ---BUFFER POOL 4
  206. Buffer pool size   8191
  207. Buffer pool size, bytes 134201344
  208. Free buffers       4000
  209. Database pages     4191
  210. Old database pages 1527
  211. Modified db pages  0
  212. Pending reads      0
  213. Pending writes: LRU 0, flush list 0, single page 0
  214. Pages made young 8031, not young 177
  215. 0.00 youngs/s, 0.00 non-youngs/s
  216. Pages read 93, created 52642, written 130509
  217. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  218. No buffer pool page gets since the last printout
  219. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  220. LRU len: 4191, unzip_LRU len: 0
  221. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  222. ---BUFFER POOL 5
  223. Buffer pool size   8191
  224. Buffer pool size, bytes 134201344
  225. Free buffers       4000
  226. Database pages     4191
  227. Old database pages 1527
  228. Modified db pages  0
  229. Pending reads      0
  230. Pending writes: LRU 0, flush list 0, single page 0
  231. Pages made young 11017, not young 1351
  232. 0.00 youngs/s, 0.00 non-youngs/s
  233. Pages read 27, created 48644, written 118717
  234. 0.00 reads/s, 0.14 creates/s, 0.14 writes/s
  235. No buffer pool page gets since the last printout
  236. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  237. LRU len: 4191, unzip_LRU len: 0
  238. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  239. ---BUFFER POOL 6
  240. Buffer pool size   8191
  241. Buffer pool size, bytes 134201344
  242. Free buffers       4000
  243. Database pages     4191
  244. Old database pages 1527
  245. Modified db pages  0
  246. Pending reads      0
  247. Pending writes: LRU 0, flush list 0, single page 0
  248. Pages made young 11038, not young 7859
  249. 0.00 youngs/s, 0.00 non-youngs/s
  250. Pages read 143, created 52453, written 129752
  251. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  252. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  253. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  254. LRU len: 4191, unzip_LRU len: 0
  255. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  256. ---BUFFER POOL 7
  257. Buffer pool size   8191
  258. Buffer pool size, bytes 134201344
  259. Free buffers       4000
  260. Database pages     4191
  261. Old database pages 1527
  262. Modified db pages  0
  263. Pending reads      0
  264. Pending writes: LRU 0, flush list 0, single page 0
  265. Pages made young 286, not young 14298
  266. 0.00 youngs/s, 0.00 non-youngs/s
  267. Pages read 448, created 5560, written 10205
  268. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  269. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  270. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  271. LRU len: 4191, unzip_LRU len: 0
  272. I/O sum[21]:cur[0], unzip sum[0]:cur[0]
  273. --------------
  274. ROW OPERATIONS
  275. --------------
  276. 0 queries inside InnoDB, 0 queries in queue
  277. 0 read views open inside InnoDB
  278. 0 RW transactions active inside InnoDB
  279. Process ID=1062, Main thread ID=139841544886016 , state=sleeping
  280. Number of rows inserted 7363728, updated 115920, deleted 0, read 2389239
  281. 8.86 inserts/s, 0.00 updates/s, 0.00 deletes/s, 8.86 reads/s
  282. Number of system rows inserted 9229, updated 2019, deleted 8977, read 117606390
  283. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 828.31 reads/s
  284. ----------------------------
  285. END OF INNODB MONITOR OUTPUT
  286. ============================

  287. 1 row in set (0.00 sec)

  288. (Tue Dec  5 13:48:53 2023)[root@GreatSQL][(none)]>
复制代码



3. mgr状态检测

188:
  1. (Tue Dec  5 13:49:31 2023)[root@GreatSQL][(none)]>select * from performance_schema.replication_group_members;SELECT * FROM performance_schema.replication_group_member_stats\G;show master status\G;SELECT MEMBER_ID AS id, COUNT_TRANSACTIONS_IN_QUEUE AS trx_tobe_certified, COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE AS relaylog_tobe_applied, COUNT_TRANSACTIONS_CHECKED AS trx_chkd, COUNT_TRANSACTIONS_REMOTE_APPLIED AS trx_done, COUNT_TRANSACTIONS_LOCAL_PROPOSED AS proposed FROM performance_schema.replication_group_member_stats;SELECT RECEIVED_TRANSACTION_SET FROM performance_schema.replication_connection_status WHERE  channel_name = 'group_replication_applier' UNION ALL SELECT variable_value FROM performance_schema.global_variables WHERE  variable_name = 'gtid_executed'\G;select now();SELECT MEMBER_ID,COUNT_TRANSACTIONS_ROWS_VALIDATING FROM performance_schema.replication_group_member_stats;
  2. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  3. | CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST   | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
  4. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  5. | group_replication_applier | a55de711-812e-11ee-b3fc-5254005b7a28 | 192.168.6.190 |        3308 | UNREACHABLE  | SECONDARY   | 8.0.32         | XCom                       |
  6. | group_replication_applier | a5609358-812e-11ee-abe4-525400b01dcf | 192.168.6.188 |        3308 | ONLINE       | PRIMARY     | 8.0.32         | XCom                       |
  7. | group_replication_applier | a5623edf-812e-11ee-92a9-525400980c24 | 192.168.6.189 |        3308 | ONLINE       | SECONDARY   | 8.0.32         | XCom                       |
  8. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  9. 3 rows in set (0.00 sec)

  10. *************************** 1. row ***************************
  11.                               CHANNEL_NAME: group_replication_applier
  12.                                    VIEW_ID: 17005521402960008:4
  13.                                  MEMBER_ID: a55de711-812e-11ee-b3fc-5254005b7a28
  14.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  15.                 COUNT_TRANSACTIONS_CHECKED: 115994
  16.                   COUNT_CONFLICTS_DETECTED: 0
  17.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  18.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  19. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  20.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19543900
  21. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  22.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 116005
  23.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
  24.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  25. *************************** 2. row ***************************
  26.                               CHANNEL_NAME: group_replication_applier
  27.                                    VIEW_ID: 17005521402960008:4
  28.                                  MEMBER_ID: a5609358-812e-11ee-abe4-525400b01dcf
  29.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  30.                 COUNT_TRANSACTIONS_CHECKED: 116195
  31.                   COUNT_CONFLICTS_DETECTED: 0
  32.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  33.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  34. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  35.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
  36. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  37.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 4
  38.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 116195
  39.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  40. *************************** 3. row ***************************
  41.                               CHANNEL_NAME: group_replication_applier
  42.                                    VIEW_ID: 17005521402960008:4
  43.                                  MEMBER_ID: a5623edf-812e-11ee-92a9-525400980c24
  44.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  45.                 COUNT_TRANSACTIONS_CHECKED: 269
  46.                   COUNT_CONFLICTS_DETECTED: 0
  47.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  48.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  49. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  50.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
  51. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  52.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 269
  53.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
  54.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  55. 3 rows in set (0.00 sec)

  56. ERROR:
  57. No query specified

  58. *************************** 1. row ***************************
  59.              File: binlog.000692
  60.          Position: 246047058
  61.      Binlog_Do_DB:
  62. Binlog_Ignore_DB:
  63. Executed_Gtid_Set: a5609358-812e-11ee-abe4-525400b01dcf:1,
  64. f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
  65. 1 row in set (0.00 sec)

  66. ERROR:
  67. No query specified

  68. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  69. | id                                   | trx_tobe_certified | relaylog_tobe_applied | trx_chkd | trx_done | proposed |
  70. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  71. | a55de711-812e-11ee-b3fc-5254005b7a28 |                  0 |                     0 |   115994 |   116005 |        0 |
  72. | a5609358-812e-11ee-abe4-525400b01dcf |                  0 |                     0 |   116195 |        4 |   116195 |
  73. | a5623edf-812e-11ee-92a9-525400980c24 |                  0 |                     0 |      269 |      269 |        0 |
  74. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  75. 3 rows in set (0.00 sec)

  76. *************************** 1. row ***************************
  77. RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
  78. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  79. *************************** 2. row ***************************
  80. RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
  81. f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
  82. 2 rows in set (0.01 sec)

  83. ERROR:
  84. No query specified

  85. +---------------------+
  86. | now()               |
  87. +---------------------+
  88. | 2023-12-05 13:49:32 |
  89. +---------------------+
  90. 1 row in set (0.00 sec)

  91. +--------------------------------------+------------------------------------+
  92. | MEMBER_ID                            | COUNT_TRANSACTIONS_ROWS_VALIDATING |
  93. +--------------------------------------+------------------------------------+
  94. | a55de711-812e-11ee-b3fc-5254005b7a28 |                                  0 |
  95. | a5609358-812e-11ee-abe4-525400b01dcf |                                  0 |
  96. | a5623edf-812e-11ee-92a9-525400980c24 |                                  0 |
  97. +--------------------------------------+------------------------------------+
  98. 3 rows in set (0.00 sec)

  99. (Tue Dec  5 13:49:32 2023)[root@GreatSQL][(none)]>
复制代码


188使用mysqlsh检测:

  1. MySQL  192.168.6.188:3308 ssl  Py > c=dba.get_cluster()
  2. MySQL  192.168.6.188:3308 ssl  Py > c.status()
  3. {
  4.     "clusterName": "test_mgr01",
  5.     "defaultReplicaSet": {
  6.         "name": "default",
  7.         "primary": "192.168.6.188:3308",
  8.         "ssl": "REQUIRED",
  9.         "status": "OK_NO_TOLERANCE",
  10.         "statusText": "Cluster is NOT tolerant to any failures. 1 member is not active.",
  11.         "topology": {
  12.             "192.168.6.188:3308": {
  13.                 "address": "192.168.6.188:3308",
  14.                 "memberRole": "PRIMARY",
  15.                 "mode": "R/W",
  16.                 "readReplicas": {},
  17.                 "replicationLag": null,
  18.                 "role": "HA",
  19.                 "status": "ONLINE",
  20.                 "version": "8.0.32"
  21.             },
  22.             "192.168.6.189:3308": {
  23.                 "address": "192.168.6.189:3308",
  24.                 "memberRole": "SECONDARY",
  25.                 "mode": "R/O",
  26.                 "readReplicas": {},
  27.                 "replicationLag": null,
  28.                 "role": "HA",
  29.                 "status": "ONLINE",
  30.                 "version": "8.0.32"
  31.             },
  32.             "192.168.6.190:3308": {
  33.                 "address": "192.168.6.190:3308",
  34.                 "memberRole": "SECONDARY",
  35.                 "memberState": "(MISSING)",
  36.                 "mode": "n/a",
  37.                 "readReplicas": {},
  38.                 "role": "HA",
  39.                 "shellConnectError": "MySQL Error 2003 (HY000): Can't connect to MySQL server on '192.168.6.190:3308' (111)",
  40.                 "status": "UNREACHABLE",
  41.                 "version": "8.0.32"
  42.             }
  43.         },
  44.         "topologyMode": "Single-Primary"
  45.     },
  46.     "groupInformationSourceMember": "192.168.6.188:3308"
  47. }
  48. MySQL  192.168.6.188:3308 ssl  Py >
复制代码



189:
  1. (Tue Dec  5 13:51:08 2023)[root@GreatSQL][tpcc10]>select * from performance_schema.replication_group_members;SELECT * FROM performance_schema.replication_group_member_stats\G;show master status\G;SELECT MEMBER_ID AS id, COUNT_TRANSACTIONS_IN_QUEUE AS trx_tobe_certified, COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE AS relaylog_tobe_applied, COUNT_TRANSACTIONS_CHECKED AS trx_chkd, COUNT_TRANSACTIONS_REMOTE_APPLIED AS trx_done, COUNT_TRANSACTIONS_LOCAL_PROPOSED AS proposed FROM performance_schema.replication_group_member_stats;SELECT RECEIVED_TRANSACTION_SET FROM performance_schema.replication_connection_status WHERE  channel_name = 'group_replication_applier' UNION ALL SELECT variable_value FROM performance_schema.global_variables WHERE  variable_name = 'gtid_executed'\G;select now();SELECT MEMBER_ID,COUNT_TRANSACTIONS_ROWS_VALIDATING FROM performance_schema.replication_group_member_stats;
  2. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  3. | CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST   | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
  4. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  5. | group_replication_applier | a55de711-812e-11ee-b3fc-5254005b7a28 | 192.168.6.190 |        3308 | UNREACHABLE  | SECONDARY   | 8.0.32         | XCom                       |
  6. | group_replication_applier | a5609358-812e-11ee-abe4-525400b01dcf | 192.168.6.188 |        3308 | ONLINE       | PRIMARY     | 8.0.32         | XCom                       |
  7. | group_replication_applier | a5623edf-812e-11ee-92a9-525400980c24 | 192.168.6.189 |        3308 | ONLINE       | SECONDARY   | 8.0.32         | XCom                       |
  8. +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
  9. 3 rows in set (0.00 sec)

  10. *************************** 1. row ***************************
  11.                               CHANNEL_NAME: group_replication_applier
  12.                                    VIEW_ID: 17005521402960008:4
  13.                                  MEMBER_ID: a55de711-812e-11ee-b3fc-5254005b7a28
  14.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  15.                 COUNT_TRANSACTIONS_CHECKED: 115994
  16.                   COUNT_CONFLICTS_DETECTED: 0
  17.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  18.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  19. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  20.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19543900
  21. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  22.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 116005
  23.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
  24.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  25. *************************** 2. row ***************************
  26.                               CHANNEL_NAME: group_replication_applier
  27.                                    VIEW_ID: 17005521402960008:4
  28.                                  MEMBER_ID: a5609358-812e-11ee-abe4-525400b01dcf
  29.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  30.                 COUNT_TRANSACTIONS_CHECKED: 116195
  31.                   COUNT_CONFLICTS_DETECTED: 0
  32.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  33.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  34. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  35.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
  36. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  37.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 4
  38.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 116195
  39.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  40. *************************** 3. row ***************************
  41.                               CHANNEL_NAME: group_replication_applier
  42.                                    VIEW_ID: 17005521402960008:4
  43.                                  MEMBER_ID: a5623edf-812e-11ee-92a9-525400980c24
  44.                COUNT_TRANSACTIONS_IN_QUEUE: 0
  45.                 COUNT_TRANSACTIONS_CHECKED: 269
  46.                   COUNT_CONFLICTS_DETECTED: 0
  47.         COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
  48.         TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
  49. f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
  50.             LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
  51. COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
  52.          COUNT_TRANSACTIONS_REMOTE_APPLIED: 269
  53.          COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
  54.          COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
  55. 3 rows in set (0.00 sec)

  56. ERROR:
  57. No query specified

  58. *************************** 1. row ***************************
  59.              File: binlog.000026
  60.          Position: 151728036
  61.      Binlog_Do_DB:
  62. Binlog_Ignore_DB:
  63. Executed_Gtid_Set: a5609358-812e-11ee-abe4-525400b01dcf:1,
  64. f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
  65. 1 row in set (0.00 sec)

  66. ERROR:
  67. No query specified

  68. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  69. | id                                   | trx_tobe_certified | relaylog_tobe_applied | trx_chkd | trx_done | proposed |
  70. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  71. | a55de711-812e-11ee-b3fc-5254005b7a28 |                  0 |                     0 |   115994 |   116005 |        0 |
  72. | a5609358-812e-11ee-abe4-525400b01dcf |                  0 |                     0 |   116195 |        4 |   116195 |
  73. | a5623edf-812e-11ee-92a9-525400980c24 |                  0 |                     0 |      269 |      269 |        0 |
  74. +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
  75. 3 rows in set (0.00 sec)

  76. *************************** 1. row ***************************
  77. RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
  78. f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
  79. *************************** 2. row ***************************
  80. RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
  81. f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
  82. 2 rows in set (0.01 sec)

  83. ERROR:
  84. No query specified

  85. +---------------------+
  86. | now()               |
  87. +---------------------+
  88. | 2023-12-05 13:51:08 |
  89. +---------------------+
  90. 1 row in set (0.00 sec)

  91. +--------------------------------------+------------------------------------+
  92. | MEMBER_ID                            | COUNT_TRANSACTIONS_ROWS_VALIDATING |
  93. +--------------------------------------+------------------------------------+
  94. | a55de711-812e-11ee-b3fc-5254005b7a28 |                                  0 |
  95. | a5609358-812e-11ee-abe4-525400b01dcf |                                  0 |
  96. | a5623edf-812e-11ee-92a9-525400980c24 |                                  0 |
  97. +--------------------------------------+------------------------------------+
  98. 3 rows in set (0.00 sec)

  99. (Tue Dec  5 13:51:08 2023)[root@GreatSQL][tpcc10]>
复制代码

yejr 2023-12-5 16:30:20
running_db 发表于 2023-12-5 13:51
1. 停止后,master日志没有任何变化,依旧是上次拒绝190加入的日志。到是189有新日志,两条。

188:

经查,是因为190节点被OOM kill了,在这之前有大事务尚未结束,并且设置了 group_replication_unreachable_majority_timeout = 30(默认值为0),导致在MGR中,190节点还没被驱逐出去前,该实例已重新拉起并尝试再次加入MGR,所以存在旧视图冲突告警。

建议:
1. 故障节点再次加入MGR前,要先判断该节点已被正常驱逐出MGR。
2. 调整group_replication_unreachable_majority_timeout = 0(相应的my.cnf模板也已调整 https://gitee.com/GreatSQL/Great ... -greatsql-8.0.32-24)。
3. 采用MySQL Shell工具来管理MGR,也利用Shell负责处理将故障节点重新加回MGR的工作。
4. 尽量不要在MGR中执行大事务,遇到大事务要拆分成多个小事务执行。
running_db 2023-12-7 09:29:29
yejr 发表于 2023-12-5 16:30
经查,是因为190节点被OOM kill了,在这之前有大事务尚未结束,并且设置了 group_replication_unreachabl ...

叶老师,请问当前状态如何恢复到正常呢,不能设置这个参数group_replication_force_members 。用mysqlsh的remove_instance?顺便问下,这个remove_instance底层调用的mysql本身那边什么操作,函数?sql?
yejr 2023-12-7 12:00:10
running_db 发表于 2023-12-7 09:29
叶老师,请问当前状态如何恢复到正常呢,不能设置这个参数group_replication_force_members 。用mysqlsh ...

问题1:
可以试试几个方法(任选一种):
1. 停掉189这个secondary节点。
2. 在188、189间做一次切换primary节点。
3. 用remove_instance()方法踢掉一个节点后再加入。

问题2:
mysql shell创建连接时,加上启用log参数,详见:https://greatsql.cn/docs/8032/us ... 4%E7%AA%8D%E9%97%A8
running_db

8

主题

0

博客

39

贡献

注册会员

Rank: 2

积分
64

助人为乐(铜)

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2024-3-3 00:57 , Processed in 0.026083 second(s), 21 queries , Redis On.
快速回复 返回顶部 返回列表