[MY-010584] [Repl] Slave SQL for channel ‘‘: Worker 1 failed executing transaction ‘8a6a904d-f

• 从库err日志报错：

2022-07-26T09:42:41.428914+08:00 18 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction '8a6a904d-f8df-11ec-8bc3-000c2927da2f:132' at master log jaspondb-binlog.000006, end_log_pos 45170; Error executing row event: 'Table 'jaspondb.jaspa12' doesn't exist', Error_code: MY-001146

• 测试版本

mysql> \s

 

--------------
mysql  Ver 8.0.19 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)

Connection id:          9
Current database:       jaspondb
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         8.0.19 MySQL Community Server - GPL
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8mb4
Conn.  characterset:    utf8mb4
UNIX socket:            /tmp/mysql.sock
Binary data as:         Hexadecimal
Uptime:                 39 min 18 sec

Threads: 9  Questions: 278  Slow queries: 0  Opens: 214  Flush tables: 4  Open tables: 77  Queries per second avg: 0.117
--------------

• 测试问题重现

(1) 当主库有数据时

mysql> show tables;
+--------------------+
| Tables_in_jaspondb |
+--------------------+
| a                  |
| b                  |
| jaspa12            |
+--------------------+

CREATE TABLE `jaspa12` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(60) DEFAULT NULL,
  `age` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=437849 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

mysql> select count(*) from jaspa12;
+----------+
| count(*) |
+----------+
|      378 |
+----------+

mysql> flush logs;

mysql> show master status;
+------------------------+----------+--------------+------------------+------