错误代码 [MY-010584] 和信息 [Repl] slave i/o for channel '': error connecting to master 表明在从库上尝试连接到主库时发生了 I/O 线程连接错误。 2. 分析可能的原因 网络连接问题:从库无法通过网络连接到主库。 防火墙或SELinux设置:可能阻止了从库与主库之间的通信。 权限问题:从库使用的用户没有...
[ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'replicationuser@10.104.76.188:3306' - retry-time: 60 retries: 40 message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection. Error_code: MY-002061 ...
新机器的错误日志: rce_bind=''.New state source_host='gxjtest20231130',source_port=3306,source_log_file='',source_log_pos=4,source_bind=''.2023-12-01T14:17:49.036551+08:00243[Warning][MY-010897][Repl]Storing MySQL user name or password informationinthe connection metadata repository is n...
MY-000001 2024-10-16T10:24:23.319598Z 64 [ERROR] [MY-010584] [Repl] Replica SQL for channel '': Worker 1 failed executing transaction 'ANONYMOUS' at source log binlog.000361, end_log _pos 401108027; Error 'Got error 125 - 'Transaction has been rolled back' during COMMIT' on query. ...
Test ended at 2021-02-19 19:12:38 line 2021-02-19T11:12:35.969408Z 11 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Error 'XAER_DUPID: The XID already exists' on query. Default database: 'test'. Query: 'XA START X'31',X'',1', Error_code: MY-001440 2021-02-19...
Status:ClosedImpact on me: None Category:MySQL Server: Group ReplicationSeverity:S2 (Serious) Version:8.0.18OS:Any Assigned to:CPU Architecture:Any Tags:xa group_replication [9 Jul 2020 0:56] phoenix Zhang Description:In group_replication cluster, the XA COMMIT command may failed when the node...
(10) ) CHARSET=utf8mb4 row_format=dynamic; doesn't execute success by the slave thread. the errlog is [ERROR] [MY-011825] [InnoDB] Cannot add field `col_197` in table `test`.`test1` because after adding it, the row size is 8126 which is greater than maximum allowed size (8126)...
2023-09-30T08:58:23.899753Z 24 [Warning] [MY-010584] [Repl] Replica I/O for channel '': Get source clock failed with error: , Error_code: MY-001159 Can you help to check. Thanks, Piseth Subject Views Written By Posted Replication Error ...
2024-12-03T21:48:34.088063Z 7 [ERROR] [MY-010584] [Repl] Replica SQL for channel '': Worker 1 failed executing transaction 'ANONYMOUS' at source log mysql-bin.000123, end_log_pos 515; Could not execute Write_rows event on table mydb.wp_options; Duplicate entry '_transient_jetpack_upda...
2019-06-06T20:09:11.652384Z 34 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl1_slave@127.0.0.1:3306' - retry-time: 60 retries: 66, Error_code: MY-002061 Please note my setup is on same server using mysqld_multi. ...