Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support pause/resume in full copy #370

Closed
Dinosauria opened this issue Nov 28, 2018 · 1 comment
Closed

Support pause/resume in full copy #370

Dinosauria opened this issue Nov 28, 2018 · 1 comment

Comments

@Dinosauria
Copy link
Member

Description

In full copy, Pause is supposed, While Resume seem to start copying again from the first row of src.

Steps to reproduce the issue:

  1. create a table sbtest1 with 10000000 recodes
  2. post a job for the table sbtest1
  3. when there are 5257040 recodes in dest, Pause the job, then job Paused, recodes in dest stop incresing.
  4. but when resume the job, there are still 5257040 recodes in dest in spite of dtle.log keep renew records from the first row of table sbtest1

Describe the results you received:

Describe the results you expected:

Output of ./dtle version:

Dtle 2.18.11.0 (git: 2.18.11.0 603ccda7c50526efe8a0ad1cf7316919abfdbdff)

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

  1. job config:
{
    "Name":"job7--8",
    "Failover":true,
    "Orders":[],
    "Type":"synchronous",
    "Tasks":[
        {
            "Type":"Src",
            "NodeId":"924c96fc-8b81-0372-1c21-1e144970036e",
            "Config":{
                "Gtid":"",
                "SkipCreateDbTable":false,
                "ExpandSyntaxSupport":false,
                "DropTableIfExists":false,
                "ReplChanBufferSize":"600",
                "ChunkSize":"2",
                "ApproveHeterogeneous":true,
                "ReplicateDoDb":[
                    {
                        "TableSchema":"sbtest",
                        "Tables":[]
                    }
                ],
                "ConnectionConfig":{
                    "Host":"172.17.7.1",
                    "Port":"3306",
                    "User":"test",
                    "Password":"test"
                }
            }
        },
        {
            "Type":"Dest",
            "NodeId":"924c96fc-8b81-0372-1c21-1e144970036e",
            "Config":{
                "Gtid":"",
                "SkipCreateDbTable":false,
                "DropTableIfExists":false,
                "ExpandSyntaxSupport":false,
                "ReplChanBufferSize":"600",
                "ApproveHeterogeneous":true,
                "ConnectionConfig":{
                    "Host":"172.17.8.1",
                    "Port":"3306",
                    "User":"test",
                    "Password":"test"
                }
            }
        }
    ]
}
@ghost
Copy link

ghost commented Jul 30, 2019

same as #365

@ghost ghost closed this as completed Jul 30, 2019
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant