背景:在虚拟机搭建主库和从库1,已经完成同步,先手动删了从1的一个库,又删了主的同一个库,此时从库会报错
Slave_IO_Running: Yes
Slave_SQL_Running: No
Last_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'ANONYMOUS' at master log mysql-bin.000013, end_log_pos 1154. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.
根据Last_Error提示,进入表performance_schema.replication_applier_status_by_worker查看
select * from performance_schema.replication_applier_status_by_worker;
发现具体问题如下:Error 'Can't drop database 'realy';
Worker 1 failed executing transaction 'ANONYMOUS' at master log mysql-bin.000013, end_log_pos 1154; Error 'Can't drop database 'realy'; datab