Skip to content

incremental replication:Dtle and DBZ output are somewhat different #331

Open
@leixia2018

Description

@leixia2018

Description

Steps to reproduce the issue:
1.Creat database and table

create database data_type_test;
use data_type_test;
create table...
  1. Create job
{
    "Region": "global",
    "Name": "dtle1",
    "Type": "synchronous",
    "Tasks": [
        {
            "Type": "Src",
            "NodeName": "dtle",
            "Driver": "MySQL",
            "Config": {
                "Gtid": "",
                "ApproveHeterogeneous": true,
                "ExpandSyntaxSupport": false,
                "ReplChanBufferSize": 600,
                "MsgBytesLimit": 20480,
                "ChunkSize": 2000,
                "DropTableIfExists": true,
                "ReplicateDoDb": [
                    {
                        "TableSchema": "data_type_test",
                        "Tables": []
                    }
                ],
                "ConnectionConfig": {                  
                    "Host":"172.100.9.3",
                    "Port": 3306,
                    "User": "test1",
                    "Password": "test1_pwd"
                }
            }
        }, {
            "Type": "Dest",
            "NodeName": "dtle",
            "Driver": "Kafka",
            "Config": {
                "Topic": "dtle1",
                "Brokers": ["172.100.9.2:9092"],
                "Converter": "json"
            }           
        }
    ]
}
  1. Create dbz job
  2. Insert sql

Describe the results you received:

Describe the results you expected:

Output of ./dtle version:

Udup 9.9.9.9 (git: master a608d0c9ae1f4fef9a2a22d6b7485661d1694506)

Additional information you deem important (e.g. issue happens only occasionally):

Additional details (log, config, job config etc):

binlog-diff.zip

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions