Skip to content

Different 'character_set_server' values in src and dest,may cause different character set  #350

Closed
@Dinosauria

Description

@Dinosauria

Description

当源端和目标端character_set_server值不同时,当创建schema不指定character set 和collation,源端和目标端创建schema的默认字符集有差别,在此情况下当该库内不指明字符集 创建table时,会导致table继承schema的字符集,job创建之初时,log中有这一句不知为何没有生效

2018/11/08 13:24:46.097236 [INFO] [87651bc5-df8e-f2fe-dbf2-0afaa3c3e73a] mysql.extractor: Step 5: committing transaction 
2018/11/08 13:24:46.097462 [DEBUG] [87651bc5-df8e-f2fe-dbf2-0afaa3c3e73a] mysql.applier: Exec [SET collation_server = utf8mb4_general_ci, character_set_server = utf8mb4] 

image

Output of ./dtle version:

Dtle 9.9.9.9 (git: master c5126693689180c0950969432e4f939232f2dda8)

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

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

  1. job.json
{
    "Name":"task1",
    "Failover":false,
    "Orders":[],
    "Type":"synchronous",
    "Tasks":[
        {
            "Type":"Src",
            "NodeId":"53c0746e-beda-b193-ddbd-2744696b54a0",
            "Config":{
                "Gtid":"",
                "SkipCreateDbTable":false,
                "ExpandSyntaxSupport":false,
                "DropTableIfExists":false,
                "ReplChanBufferSize":"600",
                "ChunkSize":"2000",
                "ApproveHeterogeneous":true,
                "ReplicateDoDb":[],
                "ConnectionConfig":{
                    "Host":"172.17.5.1",
                    "Port":"1111",
                    "User":"test",
                    "Password":"test"
                }
            }
        },
        {
            "Type":"Dest",
            "NodeId":"53c0746e-beda-b193-ddbd-2744696b54a0",
            "Config":{
                "SkipCreateDbTable":false,
                "DropTableIfExists":false,
                "ExpandSyntaxSupport":false,
                "ReplChanBufferSize":"600",
                "ApproveHeterogeneous":true,
                "ConnectionConfig":{
                    "Host":"172.17.5.2",
                    "Port":"2222",
                    "User":"test",
                    "Password":"test"
                }
            }
        }
    ]
}
  1. dtle.log:dtle_log.txt

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