ERROR: No query specified 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. # 刷新日志 flush logs; # 查看主库状态 show master status; 1. 2. 3. 4. 5. 记住File和Position 切换从库 stop slave; CHANGE MASTER TO MASTER_LOG_FILE='记住的File',MASTER_LOG_POS=记住的Position; start slave 1....
LAST_ERROR_MESSAGE: Worker 2 failed executing transaction '6780264b-a74d-11ec-97c2-b8cef6724950:55483680' at master log master-bin.007730, end_log_pos 125232274; Error 'Truncated incorrect DOUBLE value: 'TB40001343'' on query. Default database: 'ods_garden'. Query: 'insert into is_dw.t0...
docker run -it -p3300:3306--name mysql-demo -e MYSQL_ROOT_PASSWORD=123456-d mysql:8.0.26 3、在root目录下创建mysql-master文件夹,在mysql-master文件夹下创建conf和data文件夹。 mkdir mysql-master mkdir -p~/mysql-master/conf ~/mysql-master/data 4、将mysql-demo容器内的/etc/mysql/my.cnf文件...