2023-06-09T13:29:45.770338+08:00 7 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction '18e7656d-067e-11ee-8e87-000c291d503a:1' at master log log-bin.000003, end_log_pos 440; Error 'Operation CREATE USER failed for 'repl'@'%'' on query. Default database: ''. Query: 'CREATE USER 'repl'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*ECE5887B232CECE4D3D90FFFAF543AB884D12ABC'', Error_code: MY-001396
时间: 2023-12-22 17:04:05 浏览: 460
这是 MySQL 复制过程中出现的错误日志。其中,从服务器(Slave)在执行主服务器(Master)上的 SQL 语句时出现了错误。具体来说,这个错误是由于在执行一个 CREATE USER 的操作时失败了。在这个操作中,MySQL 尝试创建一个名为 repl 的用户,但是操作失败了。错误信息中提到了这个用户创建的语句:CREATE USER 'repl'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*ECE5887B232CECE4D3D90FFFAF543AB884D12ABC'。该语句的含义是创建一个用户名为 repl,可以从任何主机连接到 MySQL 服务器,并使用 mysql_native_password 认证方式,密码为 *ECE5887B232CECE4D3D90FFFAF543AB884D12ABC 的用户。错误码为 MY-001396。
相关问题
2023-06-09T13:20:36.814051+08:00 45 [Warning] [MY-010584] [Repl] Slave SQL for channel '': ... The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-transactional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see documentation for details). Error_code: MY-001756
这个错误信息也是关于MySQL复制的。它警告Slave SQL进程已停止,可能会导致数据不一致的状态,建议重启MySQL服务来恢复一致性。但是,如果使用非事务性存储来存储数据或信息表,或者执行DDL查询,则可能会导致问题。在这种情况下,需要检查数据以确保一致性(详见文档)。Error_code是MY-001756。
2023-06-09T13:13:18.331905+08:00 8 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction '18e7656d-067e-11ee-8e87-000c291d503a:1' at master log log-bin.000003, end_log_pos 440; Error 'Operation CREATE USER failed for 'repl'@'%'' on query. Default database: ''. Query: 'CREATE USER 'repl'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*ECE5887B232CECE4D3D90FFFAF543AB884D12ABC'', Error_code: MY-001396
这也是一个关于MySQL复制的错误信息。这个错误信息显示Slave SQL进程在执行一个CREATE USER语句时失败了。具体的错误信息是Operation CREATE USER failed for 'repl'@'%',Error_code是MY-001396。这个错误可能是由于权限不足或者语法错误导致的。需要检查错误日志和语法,确认是否有足够的权限执行这个语句。
阅读全文