案例总览

表1 案例总览
链路	相关文档
MongoDB->DDS实时迁移	全量迁移失败报错，关键词“Prematurely reached end of stream”
	全量迁移失败报错，关键词“not authorized on * to execute command {*}”
	全量迁移失败报错，关键词“GC overhead limit exceeded”
	全量迁移失败报错，关键词“The background process is unavailable. Maybe it has been killed manually or by the operating system. Please restart the task if possible or wait for restarting by itself within 5 minutes.”
	全量迁移失败报错，关键词“Timed out after 60000 ms while waiting to connect”
	全量或增量迁移失败报错，关键词“Timed out after 60000 ms while waiting to connect”
	全量或增量迁移失败报错，关键词“Invalid BSON field name ***”
	增量迁移失败报错，关键词“Timed out after 60000 ms while waiting for a server that matches com.mongodb.client.internal”
	增量迁移失败报错，关键词“Command failed with error * ():. The full response is {*}”
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'”
	全量阶段失败报错，关键字“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”
MySQL->GaussDB(for MySQL)实时迁移和同步	全量或增量阶段失败报错，关键词“Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation”
MySQL->CSS/ES实时同步	增量同步失败报错，关键词“write table *** failed: null”
PostgreSQL->PostgreSQL实时同步	任务启动失败报错，关键词“Initialize logical replication stream failed, the source database may have a long transaction: ****.”
	全量同步失败报错，关键词“function *** does not exist”
	全量同步失败报错，关键词“relation *** does not exist”
	全量同步失败报错，关键词“GC overhead limit exceeded”
	全量同步失败报错，关键词“Java heap space”
	全量同步失败报错，关键词“column * of relation * does not exist”
	全量同步失败报错，关键词“column *** does not exist”
	全量同步失败报错，关键词“type 'hstore' does not exist”
	全量同步失败报错，关键词“type 'geometry' does not exist”
	全量同步失败报错，关键词“Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections”
	全量同步失败报错，关键词“invalid locale name”
	全量同步失败报错，关键词“password must not equal user name”
	全量同步失败报错，关键词“permission denied for schema ***”
	全量或增量阶段失败报错，关键词“service * failed, cause by: Unable to connect to DBMS: *”
	全量或增量阶段失败报错，关键词“Initialize logical replication stream failed, the source database may have a long transaction”
	全量或增量阶段失败报错，关键词“memory required is * MB, maintenance_work_mem is * MB”
	全量或增量阶段失败报错，关键词“temporary file size exceeds temp_file_limit”
	增量同步失败报错，关键词“Table *** not found in target database”
	增量同步失败报错，关键词“remaining connection slots are reserved”
	增量同步失败报错，关键词“PL/pgSQL function * line * at SQL statement”
	增量同步失败报错，关键词“The replication slot does not exist and the task is not started for the first time.”
Oracle为源实时同步	全量同步失败报错，关键词“has date/datetime: *** which is outside of dest allowed range”
	全量或增量阶段失败报错，关键词“Got minus one from a read call”
	增量同步失败报错，关键词“Source supplemental log level is PK/UI. Missing column data at delete+insert on ***”
	增量同步失败报错，关键词“timeout when get next file log, maybe has been deleted, please check it.”
	增量同步失败报错，关键词“Failed to construct kafka producer. ”
	增量同步失败报错，关键词“Topic *** not present in metadata after 300000 ms”
GaussDB为源实时同步	任务启动失败报错，关键词“Initialize logical replication stream failed, the source database may have a long transaction: ****.”
GaussDB为源实时同步	增量同步失败报错，关键词“The replication slot does not exist and the task is not started for the first time.”
MySQL为源实时灾备	灾备阶段失败报错，关键词“A dml without pk write target db fail”
备份迁移	备份迁移失败，无法找到备份文件
	备份迁移失败，提示备份的源数据库不在备份文件列表中
	备份迁移失败，提示同名数据库已经存在
	备份迁移失败，提示使用的是增量备份文件
	备份迁移失败，提示使用的是日志备份文件
	备份迁移失败，提示备份校验文件失败
	备份迁移失败，提示空间不足
	备份迁移失败，提示请指定具体的库名
	备份迁移失败，提示使用的是全量备份文件
	备份迁移失败，提示增量bak文件LSN不连续
	备份迁移失败，提示恢复库的数量超过目标库阈值
录制回放	解析失败，提示OBS连接失败
数据对比	对比任务报错，关键词“失败报错：service SDV failed! cause by: the size of records in one shard[ *** ] of target database, exceeds the max size 200000”

父主题： 失败案例

上一篇：失败案例

下一篇：MongoDB->DDS实时迁移

意见反馈

文档内容是否对您有帮助？

有帮助没帮助

提供反馈

提交成功！非常感谢您的反馈，我们会继续努力做到更好！

系统繁忙，请稍后重试

在使用文档中是否遇到以下问题

内容与产品页面不一致

内容不易理解

缺失示例代码

步骤不可操作

搜不到想要的内容

缺少最佳实践

意见反馈（选填）

0/500

请至少选择一项反馈信息并填写问题反馈

字符长度不能超过500

直接提交取消