更新时间：2024-11-29 GMT+08:00
MySQL->MySQL实时迁移和同步
- 全量阶段失败报错，关键词“Table *** doesn't exist”
- 全量阶段失败报错，关键词“The background process is unavailable”
- 全量阶段失败报错，关键词“Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server”
- 全量阶段失败报错，关键词“Error writing file *** (errno: 28 - No space left on device)”
- 全量阶段失败报错，关键词“The MySQL server is running with the --super-read-only option so it cannot execute this statement”
- 全量阶段失败报错，关键词“The table *** is full”
- 全量阶段失败报错，关键词“Unknown column *** in 'field list'”
- 全量阶段失败报错，关键词“Lock wait timeout exceeded; try restarting transaction”
- 全量阶段失败报错，关键词“Java heap space”
- 全量阶段失败报错，关键词“Table *** already exists”
- 全量阶段失败报错，关键词“temp table: *** not exist”
- 全量阶段失败报错，关键词“failed to create new session”
- 全量阶段失败报错，关键词“load table: *** failed”
- 全量阶段失败报错，关键词“extract table structure failed!”
- 全量阶段失败报错，关键词“read table=*** failed”
- 全量阶段失败报错，关键词“CANNOT UPDATE USER WITH NULL PASSWORD”
- 全量阶段失败报错，关键词“Access denied for user *** to database ***”
- 全量阶段失败报错，关键词“The MySQL server is running with the --super-read-only option so it cannot execute this statement”
- 全量阶段失败报错，关键词“Temporary file write failure.”
- 全量阶段失败报错，关键词“Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys”
- 全量阶段失败报错，关键词“Unknown database ***”
- 全量阶段失败报错，关键词“Access denied; you need (at least one of) the SUPER privilege(s) for this operation”
- 全量阶段失败报错，关键词“retry structures failed events”“Table *** doesn't exist”
- 全量阶段失败报错，关键词“ shard table=*** failed”
- 全量阶段失败报错，关键词“error when split table shard occur!”
- 全量阶段失败报错，关键词“Column name 'AUTO_PK_ROW_ID' is reserved.”
- 全量阶段失败报错，关键词“transfer account failed, can not find password from src DB”
- 全量阶段失败报错，关键词“Failed to add the foreign key constraint '***' to system tables”
- 全量阶段失败报错，关键词“Too many keys specified; max 64 keys allowed”
- 全量阶段失败报错，关键字“Unknown collation: 'utf8mb4_0900_ai_ci'”
- 全量阶段失败报错，关键字“exist some xa transactions for long times, may lack some data for this Job!.”
- 全量阶段失败报错，关键字“Invalid GIS data provided to function st_geometryfromtext'”
- 全量或增量阶段失败报错，关键词“Access denied for user ***”
- 全量或增量阶段失败报错，关键词“binlog is not existed”
- 全量或增量阶段失败报错，关键词“database log download failed”
- 全量或增量阶段失败报错，关键词“Can not read response from server”
- 全量或增量阶段失败报错，关键词“Communications link failure”
- 全量或增量阶段失败报错，关键词“EOF Packet received, master disconnected”
- 全量或增量阶段失败报错，关键词“Extract db create sql failed”
- 全量或增量阶段失败报错，关键词“load database structure failed in source database”
- 全量或增量阶段失败报错，关键词“load table: *** failed”
- 全量或增量阶段失败报错，关键词“Reached end of input stream”
- 全量或增量阶段失败报错，关键词“Read timed out”
- 全量或增量阶段失败报错，关键词“The background process is unavailable”
- 全量或增量阶段失败报错，关键词“Duplicate entry *** for key 'PRIMARY'”
- 全量或增量阶段失败报错，关键词“cause by: Index: ***, Size: ***”
- 全量或增量阶段失败报错，关键词“The offset and file name between src and parser is inconsistency”
- 全量或增量阶段失败报错，关键词“core process is not healthy or crashed”
- 全量或增量阶段失败报错，关键词“table info of table `***` from metadata miss”
- 全量或增量阶段失败报错，关键词“binlog parse fail, data dictionary may be not complete!”
- 全量或增量阶段失败报错，关键词“table *** record field size for insert/delete dml”
- 全量或增量阶段失败报错，关键词“service *** failed, cause by: Unable to connect to DBMS: ***”
- 全量或增量阶段失败报错, 关键词“The binlog fetch connection may be interrupted”
- 全量或增量阶段失败报错，关键词“Received error packet: errno - 1047, solstate - HY000 errmsg = Unknown command”
- 增量阶段失败报错，关键词“not equals to target db column count”
- 增量阶段失败报错，关键词“The MySQL server is running with the --super-read-only option”
- 增量阶段失败报错，关键词“you need (at least one of) the SUPER privilege(s) for this operation”
- 增量阶段失败报错，关键词“Can't DROP ***; check that column/key exists”
- 增量阶段失败报错，关键词“Can't find file: *** (errno: 2 - No such file or directory)”
- 增量阶段失败报错，关键词“Data truncation: Data too long for column”
- 增量阶段失败报错，关键词“Failed to read file header from”
- 增量阶段失败报错，关键词“Lock wait timeout exceeded”
- 增量阶段失败报错，关键词“Must seek before attempting to read next event”
- 增量阶段失败报错，关键词“Table *** already exists”
- 增量阶段失败报错，关键词“Table *** doesn't exist”
- 增量阶段失败报错，关键词“Table *** not found in database”
- 增量阶段失败报错，关键词“source has more columns than target”
- 增量阶段失败报错，关键词“Unknown storage engine”
- 增量阶段失败报错，关键词“Unknown table”
- 增量阶段失败报错，关键词“You have an error in your SQL syntax”
- 增量阶段失败报错，关键词“not illegal for mariaDb gtid position”
- 增量阶段失败报错，关键词“without PK execute failed”
- 增量阶段失败报错，关键词“Deadlock found when trying to get lock”
- 增量阶段失败报错，关键词“current serverUUID not equals to this session”
- 增量阶段失败报错，关键词“Slave has more GTIDs than the master has, using the master's SERVER_UUID.”
- 增量阶段失败报错，关键词“Operation not allowed when innodb_force_recovery > 0”
- 增量阶段失败报错，关键词“filter data in config condition filter error”
父主题： 失败案例
