Updated on 2024-03-27 GMT+08:00

Case Overview

Table 1 Overview

Data Flow

Related Documents

Real-Time Migration from MongoDB to DDS

Full Migration Error: Prematurely reached end of stream

Full Migration Error: not authorized on *** to execute command {***}

Full Migration Error: GC overhead limit exceeded

Full Migration Error: 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."

Full Migration Error: Timed out after 60000 ms while waiting to connect

Full or Incremental Migration Error: Timed out after 60000 ms while waiting to connect

Full or Incremental Migration Error: Invalid BSON field name ***

Incremental Migration Error: Timed out after 60000 ms while waiting for a server that matches com.mongodb.client.internal

Incremental Migration Error: Command failed with error *** (***):***. The full response is {***}"

Real-Time Migration and Synchronization from MySQL to MySQL

Full Phase Error: Table *** doesn't exist

Full Phase Error: The background process is unavailable

Full Phase Error: 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.

Full Phase Error: Error writing file *** (errno: 28 - No space left on device)

Full Phase Error: The MySQL server is running with the --super-read-only option so it cannot execute this statement

Full Phase Error: The table *** is full

Full Phase Error: Unknown column *** in 'field list'

Full Phase Error: Lock wait timeout exceeded; try restarting transaction

Full Phase Error: Java heap space

Full Phase Error: Table *** already exists

Full Phase Error: temp table: *** not exist

Full Phase Error: failed to create new session

Full Phase Error: load table: *** failed

Full Phase Error: extract table structure failed!

Full Phase Error: read table=*** failed

Full Phase Error: CANNOT UPDATE USER WITH NULL PASSWORD

Full Phase Error: Access denied for user *** to database ***

Full Phase Error: The MySQL server is running with the --super-read-only option so it cannot execute this statement

Full Phase Error: Temporary file write failure.

Full Phase Error: 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

Full Phase Error: Unknown database ***

Full Phase Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Full Phase Error: retry structures failed events and Table *** doesn't exist

Full Phase Error: shard table=*** failed

Full Phase Error: error when split table shard occur!

Full Phase Error: Column name 'AUTO_PK_ROW_ID' is reserved.

Full Phase Error: transfer account failed, can not find password from src DB

Full Phase Error: Failed to add the foreign key constraint '***' to system tables

Full Phase Error: Too many keys specified; max 64 keys allowed

Full Phase Error: Unknown collation: 'utf8mb4_0900_ai_ci'

Full or Incremental Phase Error: Access denied for user ***

Full or Incremental Phase Error: binlog is not existed

Full or Incremental Phase Error: database log download failed

Full or Incremental Phase Error: Can not read response from server

Full or Incremental Phase Error: Communications link failure

Full or Incremental Phase Error: EOF Packet received, master disconnected

Full or Incremental Phase Error: Extract db create sql failed

Full or Incremental Phase Error: load database structure failed in source database

Full or Incremental Phase Error: load table: *** failed

Full or Incremental Phase Error: Reached end of input stream

Full or Incremental Phase Error: Read timed out

Full or Incremental Phase Error: The background process is unavailable

Full or Incremental Phase Error: Duplicate entry *** for key 'PRIMARY'

Full or Incremental Phase Error: cause by: Index: ***, Size: ***

Full or Incremental Phase Error: The offset and file name between src and parser is inconsistency

Full or Incremental Phase Error: core process is not healthy or crashed

Full or Incremental Phase Error: table info of table `***` from metadata miss

Full or Incremental Phase Error: binlog parse fail, data dictionary may be not complete!

Full or Incremental Phase Error: table *** record field size for insert/delete dml

Full or Incremental Phase Error: service *** failed, cause by: Unable to connect to DBMS: ***

Full or Incremental Phase Error: The binlog fetch connection may be interrupted

Full or Incremental Phase Error: Received error packet: errno - 1047, solstate - HY000 errmsg = Unknown command

Incremental Phase Error: not equals to target db column count

Incremental Phase Error: The MySQL server is running with the --super-read-only option

Incremental Phase Error: you need (at least one of) the SUPER privilege(s) for this operation

Incremental Phase Error: Can't DROP ***; check that column/key exists

Incremental Phase Error: Can't find file: *** (errno: 2 - No such file or directory)

Incremental Phase Error: Data truncation: Data too long for column

Incremental Phase Error: Failed to read file header from

Incremental Phase Error: Lock wait timeout exceeded

Incremental Phase Error: Must seek before attempting to read next event

Incremental Phase Error: Table *** already exists

Incremental Phase Error: Table *** doesn't exist

Incremental Phase Error: Table *** not found in database

Incremental Phase Error: source has more columns than target

Incremental Phase Error: Unknown storage engine

Incremental Phase Error: Unknown table

Incremental Phase Error: You have an error in your SQL syntax

Incremental Phase Error: not illegal for mariaDb gtid position

Incremental Phase Error: without PK execute failed

Incremental Phase Error: Deadlock found when trying to get lock

Incremental Phase Error: current serverUUID not equals to this session

Incremental Phase Error: Slave has more GTIDs than the master has, using the master's SERVER_UUID.

Incremental Phase Error: Operation not allowed when innodb_force_recovery > 0

Incremental Phase Error: filter data in config condition filter error

Real-Time Migration and Synchronization from MySQL to GaussDB(for MySQL)

Full or Incremental Phase Error: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation

Real-Time Synchronization from MySQL to GaussDB(DWS)

Full Synchronization Error: Table *** not found in database

Full Synchronization Error: column 'database_table' of relation *** does not exist

Full Synchronization Error: value too long for type character varying

Full Synchronization Error: int1 has not implemented

Full Synchronization Error: column name 'tid' conflicts with a system column name

Full Synchronization Error: date/time field value out of range

Full or Incremental Synchronization Error: service LOGMANAGER failed

Full or Incremental Synchronization Error: service CAPTURER failed

Full or Incremental Synchronization Error: ERROR: pooler

Full or Incremental Phase Error: service *** failed, cause by: Unable to connect to DBMS: ***

Full or Incremental Phase Error: The binlog fetch connection may be interrupted

Incremental Synchronization Error: dn_***: column *** contains null values

Incremental Synchronization Error: source has more columns than target

Incremental Synchronization Errors: Connection to *.*.*.98:8000 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections

Incremental Synchronization Error: Table *** not found in target database

Incremental Synchronization Error: in a read-only transaction

Incremental Synchronization Error: relation *** does not exist

Incremental Synchronization Error: *** doesn't in the target table

Incremental Synchronization Error: syntax error at or near

Incremental Synchronization Error: schema *** does not exist

Incremental Synchronization Error: Check whether dws supports the DDL

Incremental Synchronization Error: PL/pgSQL function *** line *** at SQL statement

Real-Time Synchronization from MySQL to CSS/ES

Incremental Synchronization Error: write table *** failed: null

Real-Time Synchronization from PostgreSQL to PostgreSQL

Full Synchronization Error: function *** does not exist

Full Synchronization Error: relation *** does not exist

Full Synchronization Error: GC overhead limit exceeded

Full Synchronization Error: Java heap space

Full Synchronization Error: column *** of relation *** does not exist

Full Synchronization Error: column *** does not exist

Full Synchronization Error: type 'hstore' does not exist

Full Synchronization Error: type 'geometry' does not exist

Full Synchronization Error: Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections

Full Synchronization Error: invalid locale name

Full Synchronization Error: password must not equal user name

Full Synchronization Error: permission denied for schema ***

Full or Incremental Phase Error: service *** failed, cause by: Unable to connect to DBMS: ***

Full or Incremental Phase Error: Initialize logical replication stream failed, the source database may have a long transaction

Full or Incremental Phase Error: memory required is *** MB, maintenance_work_mem is *** MB

Full or Incremental Phase Error: temporary file size exceeds temp_file_limit

Incremental Synchronization Error: Table *** not found in target database

Incremental Synchronization Error: remaining connection slots are reserved

Incremental Synchronization Error: PL/pgSQL function *** line *** at SQL statement

Real-Time Synchronization with Oracle Serving as the Source

Full Synchronization Error: has date/datetime: *** which is outside of dest allowed range

Full or Incremental Phase Error: Got minus one from a read call

Incremental Synchronization Error: Source supplemental log level is PK/UI. Missing column data at delete+insert on ***"

Incremental Synchronization Error: timeout when get next file log, maybe has been deleted, please check it.

Incremental Synchronization Error: Failed to construct kafka producer.

Incremental Synchronization Error: Topic *** not present in metadata after 300000 ms

Real-Time DR with MySQL Serving as the Source

DR Error: A dml without pk write target db fail

Backup Migration

Backup Migration Failed Because Backup Files Cannot Be Found

Backup Migration Failed Because a Backup Database Cannot Be Found in the Backup Files

Backup Migration Failed Because the Database with the Same Name Already Exists

Backup Migration Failed Because an Incremental Backup File Is Used

Backup Migration Failed Because an Log Backup File Is Used

Backup Migration Failed Because the Backup File Verification Failed

Backup Migration Failed Because of Insufficient Space

Backup Migration Failed Because Database Names Are Not Specified

Backup Migration Failed Because a Full Backup File Is Used

Backup Migration Failed Because the LSNs of Incremental Backup Files Are Inconsecutive

Backup Migration Failed Because the Number of Databases to Be Restored Exceeds the Destination Database Threshold

Traffic Replay

Parsing Failed, and a Message Is Displayed Indicating That the OBS Connection Failed

Data-Level Comparison

Data-Level Comparison Error: service SDV failed! cause by: the size of records in one shard[ *** ] of target database, exceeds the max size 200000