zhyass/mysql-operator

[bug] mysql container report error

zhyass opened this issue · 0 comments

2021-05-11T10:14:59.657588-00:00 512 [ERROR] Slave SQL for channel '': Worker 1 failed executing transaction '45d3f8cf-b241-11eb-9ad4-ea61a2cf431b:7' at master log mysql-bin.000002, end_log_pos 2977447; Error 'Operation CREATE USER failed for 'qc_usr'@'%'' on query. Default database: 'qingcloud'. Query: 'CREATE USER 'qc_usr'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*266AEA1A17F66EAE711FF68D9A32F90BC588C668'', Error_code: 1396
2021-05-11T10:14:59.658276-00:00 511 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000002' position 2977001.
2021-05-11T10:15:01.657519-00:00 520 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'mysql-bin.000002' at position 2977001, relay log '/var/lib/mysql/mysql-relay-bin.000002' position: 2977214
2021-05-11T10:15:01.663451-00:00 521 [ERROR] Slave SQL for channel '': Worker 1 failed executing transaction '45d3f8cf-b241-11eb-9ad4-ea61a2cf431b:7' at master log mysql-bin.000002, end_log_pos 2977447; Error 'Operation CREATE USER failed for 'qc_usr'@'%'' on query. Default database: 'qingcloud'. Query: 'CREATE USER 'qc_usr'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*266AEA1A17F66EAE711FF68D9A32F90BC588C668'', Error_code: 1396
2021-05-11T10:15:01.664077-00:00 520 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000002' position 2977001.
2021-05-11T10:15:03.655800-00:00 530 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'mysql-bin.000002' at position 2977001, relay log '/var/lib/mysql/mysql-relay-bin.000002' position: 2977214