Started by user Jenkins Admin Obtained pipelines/pingcap/tiflow/latest/pull_syncdiff_integration_test.groovy from git https://github.com/PingCAP-QE/ci.git Loading library tipipeline@main Library tipipeline@main is cached. Copying from home. [Pipeline] Start of Pipeline [Pipeline] readJSON [Pipeline] readTrusted Obtained pipelines/pingcap/tiflow/latest/pod-pull_syncdiff_integration_test.yaml from git https://github.com/PingCAP-QE/ci.git [Pipeline] podTemplate [Pipeline] { [Pipeline] node Created Pod: kubernetes jenkins-tiflow/pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv Agent pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv is provisioned from template pingcap_tiflow_pull_syncdiff_integration_test_122-z639r-jlgjp --- apiVersion: "v1" kind: "Pod" metadata: annotations: buildUrl: "http://jenkins.apps.svc.cluster.local:8080/jenkins/job/pingcap/job/tiflow/job/pull_syncdiff_integration_test/122/" runUrl: "job/pingcap/job/tiflow/job/pull_syncdiff_integration_test/122/" labels: jenkins/jenkins-jenkins-agent: "true" jenkins/label-digest: "55cbaa49e6b7744d70a76f98394aa2d0a6f3a30c" jenkins/label: "pingcap_tiflow_pull_syncdiff_integration_test_122-z639r" name: "pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv" namespace: "jenkins-tiflow" spec: affinity: nodeAffinity: requiredDuringSchedulingIgnoredDuringExecution: nodeSelectorTerms: - matchExpressions: - key: "kubernetes.io/arch" operator: "In" values: - "amd64" containers: - env: - name: "GOPATH" value: "/go" image: "hub.pingcap.net/jenkins/centos7_golang-1.23:latest" name: "runner" resources: limits: memory: "8Gi" cpu: "4" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/network-multitool" name: "net-tool" resources: limits: memory: "128Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - args: - "--server-id=1" - "--log-bin" - "--binlog-format=ROW" env: - name: "MYSQL_ALLOW_EMPTY_PASSWORD" value: "1" image: "hub.pingcap.net/jenkins/mysql:5.7" name: "mysql" resources: limits: memory: "2Gi" cpu: "1" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - env: - name: "JENKINS_SECRET" value: "********" - name: "JENKINS_TUNNEL" value: "jenkins-agent.apps.svc.cluster.local:50000" - name: "JENKINS_AGENT_NAME" value: "pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv" - name: "JENKINS_NAME" value: "pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv" - name: "JENKINS_AGENT_WORKDIR" value: "/home/jenkins/agent" - name: "JENKINS_URL" value: "http://jenkins.apps.svc.cluster.local:8080/jenkins/" image: "jenkins/inbound-agent:3206.vb_15dcf73f6a_9-2" name: "jnlp" resources: requests: memory: "256Mi" cpu: "100m" volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false restartPolicy: "Never" securityContext: fsGroup: 1000 volumes: - emptyDir: medium: "" name: "workspace-volume" Running on pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv in /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test [Pipeline] { [Pipeline] stage [Pipeline] { (Declarative: Checkout SCM) [Pipeline] checkout The recommended git tool is: git No credentials specified Cloning the remote Git repository Using shallow clone with depth 1 Cloning repository https://github.com/PingCAP-QE/ci.git > git init /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test # timeout=10 Fetching upstream changes from https://github.com/PingCAP-QE/ci.git > git --version # timeout=10 > git --version # 'git version 2.39.2' > git fetch --tags --force --progress --depth=1 -- https://github.com/PingCAP-QE/ci.git +refs/heads/*:refs/remotes/origin/* # timeout=5 Avoid second fetch Checking out Revision b2a59508c11c86ba701c4af25fc536a9475b82c6 (origin/main) > git config remote.origin.url https://github.com/PingCAP-QE/ci.git # timeout=10 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10 > git rev-parse origin/main^{commit} # timeout=10 > git config core.sparsecheckout # timeout=10 > git checkout -f b2a59508c11c86ba701c4af25fc536a9475b82c6 # timeout=10 Commit message: "feat(prow-jobs/pingcap-qe/ci): add periodic job to crawl pull requests and issues (#3449)" First time build. Skipping changelog. [Pipeline] } [Pipeline] // stage [Pipeline] withEnv [Pipeline] { [Pipeline] container [Pipeline] { [Pipeline] withEnv [Pipeline] { [Pipeline] timeout Timeout set to expire in 40 min [Pipeline] { [Pipeline] stage [Pipeline] { (Debug info) [Pipeline] sh + printenv PROW_JOB_ID=74dcde62-bea8-4a9e-a56b-c9e0f6e7e7e0 JENKINS_NODE_COOKIE=a0350252-82b6-485a-af86-e6eee5fb73c9 BUILD_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tiflow/job/pull_syncdiff_integration_test/122/ GOLANG_VERSION=1.23.3 HOSTNAME=pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv HUDSON_SERVER_COOKIE=83ef27fe9acccc92 KUBERNETES_PORT=tcp://10.233.0.1:443 KUBERNETES_PORT_443_TCP_PORT=443 TERM=xterm STAGE_NAME=Debug info BUILD_TAG=jenkins-pingcap-tiflow-pull_syncdiff_integration_test-122 KUBERNETES_SERVICE_PORT=443 GIT_PREVIOUS_COMMIT=3e31ec89ba643faa364a78dbc7f062bb55f9c486 JOB_SPEC={"type":"presubmit","job":"pingcap/tiflow/pull_syncdiff_integration_test","buildid":"1908056220913111042","prowjobid":"74dcde62-bea8-4a9e-a56b-c9e0f6e7e7e0","refs":{"org":"pingcap","repo":"tiflow","repo_link":"https://github.com/pingcap/tiflow","base_ref":"master","base_sha":"4c631d5951854ac91765b729fe3849d8e8d5ed8a","base_link":"https://github.com/pingcap/tiflow/commit/4c631d5951854ac91765b729fe3849d8e8d5ed8a","pulls":[{"number":12118,"author":"dveeden","sha":"a306f48949e037965a7c1963f500f7e0abbfba51","title":"dm: upgrade go-mysql to v1.12.0","head_ref":"new_gomysql","link":"https://github.com/pingcap/tiflow/pull/12118","commit_link":"https://github.com/pingcap/tiflow/pull/12118/commits/a306f48949e037965a7c1963f500f7e0abbfba51","author_link":"https://github.com/dveeden"}]}} KUBERNETES_SERVICE_HOST=10.233.0.1 WORKSPACE=/home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test JOB_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tiflow/job/pull_syncdiff_integration_test/ RUN_CHANGES_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tiflow/job/pull_syncdiff_integration_test/122/display/redirect?page=changes RUN_ARTIFACTS_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tiflow/job/pull_syncdiff_integration_test/122/display/redirect?page=artifacts FILE_SERVER_URL=http://fileserver.pingcap.net JENKINS_HOME=/var/jenkins_home GIT_COMMIT=b2a59508c11c86ba701c4af25fc536a9475b82c6 PATH=/go/bin:/usr/local/go/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin RUN_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tiflow/job/pull_syncdiff_integration_test/122/display/redirect GOPROXY=http://goproxy.apps.svc,https://proxy.golang.org,direct _=/usr/bin/printenv POD_CONTAINER=runner PWD=/home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test HUDSON_URL=https://do.pingcap.net/jenkins/ JOB_NAME=pingcap/tiflow/pull_syncdiff_integration_test TZ=Asia/Shanghai BUILD_DISPLAY_NAME=#122 JENKINS_URL=https://do.pingcap.net/jenkins/ BUILD_ID=1908056220913111042 GOLANG_DOWNLOAD_SHA256=a0afb9744c00648bafb1b90b4aba5bdb86f424f02f9275399ce0c20b93a2c3a8 JOB_BASE_NAME=pull_syncdiff_integration_test GIT_PREVIOUS_SUCCESSFUL_COMMIT=3e31ec89ba643faa364a78dbc7f062bb55f9c486 RUN_TESTS_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tiflow/job/pull_syncdiff_integration_test/122/display/redirect?page=tests SHLVL=3 HOME=/home/jenkins POD_LABEL=pingcap_tiflow_pull_syncdiff_integration_test_122-z639r GOROOT=/usr/local/go GIT_BRANCH=origin/main KUBERNETES_PORT_443_TCP_PROTO=tcp CI=true KUBERNETES_SERVICE_PORT_HTTPS=443 WORKSPACE_TMP=/home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test@tmp EXECUTOR_NUMBER=0 JENKINS_SERVER_COOKIE=durable-31ddb3ecff489d43f13d11bed8c932dfc6474df027a9be4aa75bd8183413ee97 NODE_LABELS=pingcap_tiflow_pull_syncdiff_integration_test_122-z639r pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv GIT_URL=https://github.com/PingCAP-QE/ci.git HUDSON_HOME=/var/jenkins_home CLASSPATH= NODE_NAME=pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv GOPATH=/go JOB_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tiflow/job/pull_syncdiff_integration_test/display/redirect BUILD_NUMBER=122 KUBERNETES_PORT_443_TCP_ADDR=10.233.0.1 KUBERNETES_PORT_443_TCP=tcp://10.233.0.1:443 GOLANG_DOWNLOAD_URL=https://dl.google.com/go/go1.23.3.linux-amd64.tar.gz + echo ------------------------- ------------------------- + go env GO111MODULE='' GOARCH='amd64' GOBIN='' GOCACHE='/home/jenkins/.cache/go-build' GOENV='/home/jenkins/.config/go/env' GOEXE='' GOEXPERIMENT='' GOFLAGS='' GOHOSTARCH='amd64' GOHOSTOS='linux' GOINSECURE='' GOMODCACHE='/go/pkg/mod' GONOPROXY='' GONOSUMDB='' GOOS='linux' GOPATH='/go' GOPRIVATE='' GOPROXY='http://goproxy.apps.svc,https://proxy.golang.org,direct' GOROOT='/usr/local/go' GOSUMDB='sum.golang.org' GOTMPDIR='' GOTOOLCHAIN='auto' GOTOOLDIR='/usr/local/go/pkg/tool/linux_amd64' GOVCS='' GOVERSION='go1.23.3' GODEBUG='' GOTELEMETRY='local' GOTELEMETRYDIR='/home/jenkins/.config/go/telemetry' GCCGO='gccgo' GOAMD64='v1' AR='ar' CC='gcc' CXX='g++' CGO_ENABLED='1' GOMOD='/dev/null' GOWORK='' CGO_CFLAGS='-O2 -g' CGO_CPPFLAGS='' CGO_CXXFLAGS='-O2 -g' CGO_FFLAGS='-O2 -g' CGO_LDFLAGS='-O2 -g' PKG_CONFIG='pkg-config' GOGCCFLAGS='-fPIC -m64 -pthread -Wl,--no-gc-sections -fmessage-length=0 -fdebug-prefix-map=/tmp/go-build2922888782=/tmp/go-build -gno-record-gcc-switches' + echo ------------------------- ------------------------- + echo 'debug command: kubectl -n jenkins-tiflow exec -ti pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv bash' debug command: kubectl -n jenkins-tiflow exec -ti pingcap-tiflow-pull-syncdiff-integration-test-122-z639r-j-4q1wv bash [Pipeline] container [Pipeline] { [Pipeline] sh > git rev-list --no-walk 3e31ec89ba643faa364a78dbc7f062bb55f9c486 # timeout=10 + dig github.com ; <<>> DiG 9.18.16 <<>> github.com ;; global options: +cmd ;; Got answer: ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 21742 ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 2, AUTHORITY: 0, ADDITIONAL: 1 ;; OPT PSEUDOSECTION: ; EDNS: version: 0, flags:; udp: 1232 ; COOKIE: c5034f4e8b7a99e3 (echoed) ;; QUESTION SECTION: ;github.com. IN A ;; ANSWER SECTION: github.com. 27 IN A 20.27.177.113 github.com. 27 IN A 20.205.243.166 ;; Query time: 0 msec ;; SERVER: 169.254.25.10#53(169.254.25.10) (UDP) ;; WHEN: Fri Apr 04 07:17:33 UTC 2025 ;; MSG SIZE rcvd: 103 [Pipeline] script [Pipeline] { [Pipeline] } [Pipeline] // script [Pipeline] } [Pipeline] // container [Pipeline] } [Pipeline] // stage [Pipeline] stage [Pipeline] { (Checkout) [Pipeline] timeout Timeout set to expire in 10 min [Pipeline] { [Pipeline] dir Running in /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow [Pipeline] { [Pipeline] cache Cache restored successfully (git/pingcap/tiflow/rev-master) 192245760 bytes in 0.72 secs (266476927 bytes/sec) [Pipeline] { [Pipeline] script [Pipeline] { [Pipeline] retry [Pipeline] { [Pipeline] sh git version 2.36.6 Reinitialized existing Git repository in /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/.git/ .git HEAD is now at 4c631d595 kafka(ticdc): ddl sink close the underline sink if send ddl or checkpoint failed and refactor the kafka ddl sink (#12112) POST git-upload-pack (656 bytes) POST git-upload-pack (973 bytes) From https://github.com/pingcap/tiflow = [up to date] master -> origin/master * [new ref] refs/pull/12118/head -> origin/pr/12118/head HEAD is now at 4c631d595 kafka(ticdc): ddl sink close the underline sink if send ddl or checkpoint failed and refactor the kafka ddl sink (#12112) 🚧 Checkouting to base SHA:4c631d5951854ac91765b729fe3849d8e8d5ed8a... HEAD is now at 4c631d595 kafka(ticdc): ddl sink close the underline sink if send ddl or checkpoint failed and refactor the kafka ddl sink (#12112) βœ… Checked. πŸŽ‰ 🧾 HEAD info: 4c631d5951854ac91765b729fe3849d8e8d5ed8a 4c631d595 kafka(ticdc): ddl sink close the underline sink if send ddl or checkpoint failed and refactor the kafka ddl sink (#12112) 3cf60079e codec(ticdc): modify DDL type support about debezium protocol (#12113) 9ed3d76c5 consumer(ticdc): adjust consumer log level (#12092) 🚧 Pre-merge heads of pull requests to base SHA: 4c631d5951854ac91765b729fe3849d8e8d5ed8a ... Updating 4c631d595..a306f4894 Fast-forward go.mod | 5 ++--- go.sum | 8 ++------ 2 files changed, 4 insertions(+), 9 deletions(-) 🧾 Pre-merged result: a306f48949e037965a7c1963f500f7e0abbfba51 a306f4894 dm: upgrade go-mysql to v1.12.0 4c631d595 kafka(ticdc): ddl sink close the underline sink if send ddl or checkpoint failed and refactor the kafka ddl sink (#12112) 3cf60079e codec(ticdc): modify DDL type support about debezium protocol (#12113) βœ… Pre merged πŸŽ‰ πŸ“ update submodules ... βœ… update submodules done βœ… ~~~~~All done.~~~~~~ [Pipeline] } [Pipeline] // retry [Pipeline] } [Pipeline] // script [Pipeline] } Cache saved successfully (git/pingcap/tiflow/rev-4c631d5-a306f48) 192337920 bytes in 2.82 secs (68119056 bytes/sec) [Pipeline] // cache [Pipeline] } [Pipeline] // dir [Pipeline] } [Pipeline] // timeout [Pipeline] } [Pipeline] // stage [Pipeline] stage [Pipeline] { (Integration Test) [Pipeline] dir Running in /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow [Pipeline] { [Pipeline] script [Pipeline] { [Pipeline] echo computeBranchFromPR component: dumpling, prTargetBranch: master, prTitle: dm: upgrade go-mysql to v1.12.0, trunkBranch: master [Pipeline] sh + sha1= + [[ commit_master =~ ^commit_[0-9a-f]{40}$ ]] + refUrl=http://fileserver.pingcap.net/download/refs/pingcap/dumpling/master/sha1 + [[ false = \t\r\u\e ]] + echo 'πŸ” ref url: http://fileserver.pingcap.net/download/refs/pingcap/dumpling/master/sha1' πŸ” ref url: http://fileserver.pingcap.net/download/refs/pingcap/dumpling/master/sha1 ++ curl --fail http://fileserver.pingcap.net/download/refs/pingcap/dumpling/master/sha1 ++ head -1 % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 41 100 41 0 0 525 0 --:--:-- --:--:-- --:--:-- 525 + sha1=05b0b48d711a95ae330c08d07ec09543254cea6b + artifactUrl=http://fileserver.pingcap.net/download/builds/pingcap/dumpling/05b0b48d711a95ae330c08d07ec09543254cea6b/centos7/dumpling.tar.gz + echo 'β¬‡οΈπŸ“¦ artifact url: http://fileserver.pingcap.net/download/builds/pingcap/dumpling/05b0b48d711a95ae330c08d07ec09543254cea6b/centos7/dumpling.tar.gz' β¬‡οΈπŸ“¦ artifact url: http://fileserver.pingcap.net/download/builds/pingcap/dumpling/05b0b48d711a95ae330c08d07ec09543254cea6b/centos7/dumpling.tar.gz ++ basename http://fileserver.pingcap.net/download/builds/pingcap/dumpling/05b0b48d711a95ae330c08d07ec09543254cea6b/centos7/dumpling.tar.gz + saveFile=dumpling.tar.gz + wget -q --retry-connrefused --waitretry=1 --read-timeout=20 --timeout=15 -t 3 -c -O dumpling.tar.gz http://fileserver.pingcap.net/download/builds/pingcap/dumpling/05b0b48d711a95ae330c08d07ec09543254cea6b/centos7/dumpling.tar.gz + echo 'πŸ“‚ extract bin from dumpling.tar.gz ...' πŸ“‚ extract bin from dumpling.tar.gz ... + tar -xzf dumpling.tar.gz bin + rm dumpling.tar.gz + echo 'βœ… extracted bin from dumpling.tar.gz .' βœ… extracted bin from dumpling.tar.gz . [Pipeline] echo computeBranchFromPR component: tikv, prTargetBranch: master, prTitle: dm: upgrade go-mysql to v1.12.0, trunkBranch: master [Pipeline] sh + sha1= + [[ commit_master =~ ^commit_[0-9a-f]{40}$ ]] + refUrl=http://fileserver.pingcap.net/download/refs/pingcap/tikv/master/sha1 + [[ false = \t\r\u\e ]] + echo 'πŸ” ref url: http://fileserver.pingcap.net/download/refs/pingcap/tikv/master/sha1' πŸ” ref url: http://fileserver.pingcap.net/download/refs/pingcap/tikv/master/sha1 ++ curl --fail http://fileserver.pingcap.net/download/refs/pingcap/tikv/master/sha1 ++ head -1 % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 41 100 41 0 0 2125 0 --:--:-- --:--:-- --:--:-- 2157 + sha1=3eb3439fd88f0db9de06ef92e845e80b32c9b49a + artifactUrl=http://fileserver.pingcap.net/download/builds/pingcap/tikv/3eb3439fd88f0db9de06ef92e845e80b32c9b49a/centos7/tikv-server.tar.gz + echo 'β¬‡οΈπŸ“¦ artifact url: http://fileserver.pingcap.net/download/builds/pingcap/tikv/3eb3439fd88f0db9de06ef92e845e80b32c9b49a/centos7/tikv-server.tar.gz' β¬‡οΈπŸ“¦ artifact url: http://fileserver.pingcap.net/download/builds/pingcap/tikv/3eb3439fd88f0db9de06ef92e845e80b32c9b49a/centos7/tikv-server.tar.gz ++ basename http://fileserver.pingcap.net/download/builds/pingcap/tikv/3eb3439fd88f0db9de06ef92e845e80b32c9b49a/centos7/tikv-server.tar.gz + saveFile=tikv-server.tar.gz + wget -q --retry-connrefused --waitretry=1 --read-timeout=20 --timeout=15 -t 3 -c -O tikv-server.tar.gz http://fileserver.pingcap.net/download/builds/pingcap/tikv/3eb3439fd88f0db9de06ef92e845e80b32c9b49a/centos7/tikv-server.tar.gz + echo 'πŸ“‚ extract bin from tikv-server.tar.gz ...' πŸ“‚ extract bin from tikv-server.tar.gz ... + tar -xzf tikv-server.tar.gz bin + rm tikv-server.tar.gz + echo 'βœ… extracted bin from tikv-server.tar.gz .' βœ… extracted bin from tikv-server.tar.gz . [Pipeline] echo computeBranchFromPR component: pd, prTargetBranch: master, prTitle: dm: upgrade go-mysql to v1.12.0, trunkBranch: master [Pipeline] sh + sha1= + [[ commit_master =~ ^commit_[0-9a-f]{40}$ ]] + refUrl=http://fileserver.pingcap.net/download/refs/pingcap/pd/master/sha1 + [[ false = \t\r\u\e ]] + echo 'πŸ” ref url: http://fileserver.pingcap.net/download/refs/pingcap/pd/master/sha1' πŸ” ref url: http://fileserver.pingcap.net/download/refs/pingcap/pd/master/sha1 ++ curl --fail http://fileserver.pingcap.net/download/refs/pingcap/pd/master/sha1 ++ head -1 % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 41 100 41 0 0 1655 0 --:--:-- --:--:-- --:--:-- 1708 + sha1=9d6bbb8529d9d2acb9cf324a65e94ece465f6346 + artifactUrl=http://fileserver.pingcap.net/download/builds/pingcap/pd/9d6bbb8529d9d2acb9cf324a65e94ece465f6346/centos7/pd-server.tar.gz + echo 'β¬‡οΈπŸ“¦ artifact url: http://fileserver.pingcap.net/download/builds/pingcap/pd/9d6bbb8529d9d2acb9cf324a65e94ece465f6346/centos7/pd-server.tar.gz' β¬‡οΈπŸ“¦ artifact url: http://fileserver.pingcap.net/download/builds/pingcap/pd/9d6bbb8529d9d2acb9cf324a65e94ece465f6346/centos7/pd-server.tar.gz ++ basename http://fileserver.pingcap.net/download/builds/pingcap/pd/9d6bbb8529d9d2acb9cf324a65e94ece465f6346/centos7/pd-server.tar.gz + saveFile=pd-server.tar.gz + wget -q --retry-connrefused --waitretry=1 --read-timeout=20 --timeout=15 -t 3 -c -O pd-server.tar.gz http://fileserver.pingcap.net/download/builds/pingcap/pd/9d6bbb8529d9d2acb9cf324a65e94ece465f6346/centos7/pd-server.tar.gz + echo 'πŸ“‚ extract bin from pd-server.tar.gz ...' πŸ“‚ extract bin from pd-server.tar.gz ... + tar -xzf pd-server.tar.gz bin + rm pd-server.tar.gz + echo 'βœ… extracted bin from pd-server.tar.gz .' βœ… extracted bin from pd-server.tar.gz . [Pipeline] echo computeBranchFromPR component: tidb, prTargetBranch: master, prTitle: dm: upgrade go-mysql to v1.12.0, trunkBranch: master [Pipeline] sh + sha1= + [[ commit_master =~ ^commit_[0-9a-f]{40}$ ]] + refUrl=http://fileserver.pingcap.net/download/refs/pingcap/tidb/master/sha1 + [[ false = \t\r\u\e ]] + echo 'πŸ” ref url: http://fileserver.pingcap.net/download/refs/pingcap/tidb/master/sha1' πŸ” ref url: http://fileserver.pingcap.net/download/refs/pingcap/tidb/master/sha1 ++ curl --fail http://fileserver.pingcap.net/download/refs/pingcap/tidb/master/sha1 ++ head -1 % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 41 100 41 0 0 1297 0 --:--:-- --:--:-- --:--:-- 1322 + sha1=d9fb3a53376157be49b5a7941e6e689a33c81eb0 + artifactUrl=http://fileserver.pingcap.net/download/builds/pingcap/tidb/d9fb3a53376157be49b5a7941e6e689a33c81eb0/centos7/tidb-server.tar.gz + echo 'β¬‡οΈπŸ“¦ artifact url: http://fileserver.pingcap.net/download/builds/pingcap/tidb/d9fb3a53376157be49b5a7941e6e689a33c81eb0/centos7/tidb-server.tar.gz' β¬‡οΈπŸ“¦ artifact url: http://fileserver.pingcap.net/download/builds/pingcap/tidb/d9fb3a53376157be49b5a7941e6e689a33c81eb0/centos7/tidb-server.tar.gz ++ basename http://fileserver.pingcap.net/download/builds/pingcap/tidb/d9fb3a53376157be49b5a7941e6e689a33c81eb0/centos7/tidb-server.tar.gz + saveFile=tidb-server.tar.gz + wget -q --retry-connrefused --waitretry=1 --read-timeout=20 --timeout=15 -t 3 -c -O tidb-server.tar.gz http://fileserver.pingcap.net/download/builds/pingcap/tidb/d9fb3a53376157be49b5a7941e6e689a33c81eb0/centos7/tidb-server.tar.gz + echo 'πŸ“‚ extract bin from tidb-server.tar.gz ...' πŸ“‚ extract bin from tidb-server.tar.gz ... + tar -xzf tidb-server.tar.gz bin + rm tidb-server.tar.gz + echo 'βœ… extracted bin from tidb-server.tar.gz .' βœ… extracted bin from tidb-server.tar.gz . [Pipeline] } [Pipeline] // script [Pipeline] sh + wget --no-verbose --retry-connrefused --waitretry=1 -t 3 -O tidb-enterprise-tools.tar.gz http://fileserver.pingcap.net/download/ci-artifacts/tiflow/linux-amd64/v20220531/tidb-enterprise-tools.tar.gz 2025-04-04 15:19:08 URL:http://fileserver.pingcap.net/download/ci-artifacts/tiflow/linux-amd64/v20220531/tidb-enterprise-tools.tar.gz [152004949/152004949] -> "tidb-enterprise-tools.tar.gz" [1] + tar -xzf tidb-enterprise-tools.tar.gz + mv tidb-enterprise-tools/bin/loader bin/ + mv tidb-enterprise-tools/bin/importer bin/ + rm -r tidb-enterprise-tools [Pipeline] sh + which bin/tikv-server /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/bin/tikv-server + which bin/pd-server /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/bin/pd-server + which bin/tidb-server /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/bin/tidb-server + which bin/dumpling /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/bin/dumpling + which bin/importer /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/bin/importer + ls -alh ./bin/ total 2.8G drwxr-sr-x 2 jenkins jenkins 4.0K Apr 4 15:19 . drwxr-sr-x 19 jenkins jenkins 4.0K Apr 4 15:19 .. -rwxr-xr-x 1 jenkins jenkins 233M Apr 3 19:15 ddltest -rwxr-xr-x 1 jenkins jenkins 75M Mar 17 2022 dumpling -rwxr-xr-x 1 jenkins jenkins 67M May 31 2022 importer -rwxr-xr-x 1 jenkins jenkins 45M May 31 2022 loader -rwxr-xr-x 1 jenkins jenkins 41M Apr 3 15:30 pd-api-bench -rwxr-xr-x 1 jenkins jenkins 44M Apr 3 15:29 pd-ctl -rwxr-xr-x 1 jenkins jenkins 40M Apr 3 15:30 pd-heartbeat-bench -rwxr-xr-x 1 jenkins jenkins 35M Apr 3 15:29 pd-recover -rwxr-xr-x 1 jenkins jenkins 37M Apr 3 15:30 pd-region-bench -rwxr-xr-x 1 jenkins jenkins 115M Apr 3 15:29 pd-server -rwxr-xr-x 1 jenkins jenkins 37M Apr 3 15:30 pd-tso-bench -rwxr-xr-x 1 jenkins jenkins 15M Apr 3 15:30 pd-ut -rwxr-xr-x 1 jenkins jenkins 35M Apr 3 15:30 regions-dump -rwxr-xr-x 1 jenkins jenkins 35M Apr 3 15:30 stores-dump -rwxr-xr-x 1 jenkins jenkins 241M Apr 3 19:14 tidb-server -rwxr-xr-x 1 jenkins jenkins 241M Apr 3 19:11 tidb-server-check -rwxr-xr-x 1 jenkins jenkins 242M Apr 3 19:13 tidb-server-failpoint -rwxr-xr-x 1 jenkins jenkins 298M Apr 3 19:10 tidb-server-race -rwxr-xr-x 1 jenkins jenkins 212M Apr 2 11:56 tikv-ctl -rwxr-xr-x 1 jenkins jenkins 373M Apr 2 11:56 tikv-server -rwxr-xr-x 1 jenkins jenkins 376M Apr 2 11:57 tikv-server-failpoint -rwxr-xr-x 1 jenkins jenkins 2.3M Apr 3 15:30 xprog + chmod +x bin/ddltest bin/dumpling bin/importer bin/loader bin/pd-api-bench bin/pd-ctl bin/pd-heartbeat-bench bin/pd-recover bin/pd-region-bench bin/pd-server bin/pd-tso-bench bin/pd-ut bin/regions-dump bin/stores-dump bin/tidb-server bin/tidb-server-check bin/tidb-server-failpoint bin/tidb-server-race bin/tikv-ctl bin/tikv-server bin/tikv-server-failpoint bin/xprog + ./bin/dumpling --version Release version: v5.3.0-alpha-11-g05b0b48 Git commit hash: 05b0b48d711a95ae330c08d07ec09543254cea6b Git branch: master Build timestamp: 2022-03-17 08:15:23Z Go version: go version go1.18 linux/amd64 + ./bin/tikv-server -V TiKV Release Version: 9.0.0-beta.1 Edition: Community Git Commit Hash: 3eb3439fd88f0db9de06ef92e845e80b32c9b49a Git Commit Branch: master UTC Build Time: 2025-04-02 02:57:52 Rust Version: rustc 1.77.0-nightly (89e2160c4 2023-12-27) Enable Features: memory-engine pprof-fp jemalloc mem-profiling portable sse test-engine-kv-rocksdb test-engine-raft-raft-engine trace-async-tasks openssl-vendored Profile: dist_release + ./bin/pd-server -V Release Version: v9.0.0-beta.1.pre-91-g9d6bbb852 Edition: Community Git Commit Hash: 9d6bbb8529d9d2acb9cf324a65e94ece465f6346 Git Branch: master UTC Build Time: 2025-04-03 07:28:59 + ./bin/tidb-server -V Release Version: v9.0.0-beta.1.pre-511-gd9fb3a5337 Edition: Community Git Commit Hash: d9fb3a53376157be49b5a7941e6e689a33c81eb0 Git Branch: master UTC Build Time: 2025-04-03 11:14:01 GoVersion: go1.23.8 Race Enabled: false Check Table Before Drop: false Store: unistore [Pipeline] sh + for i in '{1..10}' mysqladmin ping -h0.0.0.0 -P 3306 -uroot --silent + '[' 0 -eq 0 ']' + break + export MYSQL_HOST=127.0.0.1 + MYSQL_HOST=127.0.0.1 + export MYSQL_PORT=3306 + MYSQL_PORT=3306 + make failpoint-enable go: downloading go1.23.4 (linux/amd64) cd tools/check && GO111MODULE=on go build -mod=mod -o ../bin/failpoint-ctl github.com/pingcap/failpoint/failpoint-ctl go: downloading github.com/pingcap/failpoint v0.0.0-20210316064728-7acb0f0a3dfd go: downloading github.com/sergi/go-diff v1.1.0 $(echo $(for p in $(go list ./... | grep -vE 'vendor|proto|tiflow/tests|integration|testing_utils|pb|pbmock|tiflow/bin'); do echo ${p#"github.com/pingcap/tiflow/"}|grep -v "github.com/pingcap/tiflow"; done) | xargs tools/bin/failpoint-ctl enable >/dev/null) go: downloading github.com/pingcap/failpoint v0.0.0-20240528011301-b51a646c7c86 go: downloading go.uber.org/zap v1.27.0 go: downloading github.com/google/uuid v1.6.0 go: downloading github.com/pingcap/errors v0.11.5-0.20240318064555-6bd07397691f go: downloading github.com/gin-gonic/gin v1.9.1 go: downloading github.com/golang/mock v1.6.0 go: downloading go.uber.org/atomic v1.11.0 go: downloading github.com/pingcap/log v1.1.1-0.20241212030209-7e3ff8601a2a go: downloading github.com/r3labs/diff v1.1.0 go: downloading github.com/pingcap/tidb v1.1.0-beta.0.20241223052309-3735ed55a394 go: downloading github.com/IBM/sarama v1.41.2 go: downloading github.com/go-sql-driver/mysql v1.7.1 go: downloading github.com/benbjohnson/clock v1.1.0 go: downloading go.etcd.io/etcd/client/v3 v3.5.12 go: downloading cloud.google.com/go/storage v1.39.1 go: downloading github.com/Azure/azure-sdk-for-go/sdk/azcore v1.16.0 go: downloading github.com/KimMachineGun/automemlimit v0.2.4 go: downloading github.com/json-iterator/go v1.1.12 go: downloading github.com/aws/aws-sdk-go v1.55.5 go: downloading github.com/cenkalti/backoff/v4 v4.2.1 go: downloading github.com/stretchr/testify v1.10.0 go: downloading github.com/pingcap/tidb/pkg/parser v0.0.0-20241223052309-3735ed55a394 go: downloading github.com/prometheus/client_golang v1.20.5 go: downloading golang.org/x/sync v0.10.0 go: downloading github.com/google/btree v1.1.2 go: downloading github.com/swaggo/gin-swagger v1.2.0 go: downloading github.com/cockroachdb/pebble v1.1.0 go: downloading github.com/swaggo/files v0.0.0-20210815190702-a29dd2bc99b2 go: downloading github.com/pingcap/tidb-dashboard v0.0.0-20240326110213-9768844ff5d7 go: downloading go.uber.org/multierr v1.11.0 go: downloading github.com/tikv/client-go/v2 v2.0.8-0.20241209094930-06d7f4b9233b go: downloading google.golang.org/grpc v1.64.0 go: downloading github.com/shirou/gopsutil/v3 v3.24.5 go: downloading github.com/goccy/go-json v0.10.2 go: downloading github.com/DATA-DOG/go-sqlmock v1.5.0 go: downloading github.com/imdario/mergo v0.3.16 go: downloading github.com/pingcap/kvproto v0.0.0-20241120022153-92b0414aeed8 go: downloading github.com/tinylib/msgp v1.1.6 go: downloading github.com/swaggo/swag v1.16.3 go: downloading github.com/coreos/go-semver v0.3.1 go: downloading github.com/tikv/pd/client v0.0.0-20241111073742-238d4d79ea31 go: downloading github.com/apache/pulsar-client-go v0.11.0 go: downloading github.com/aws/aws-sdk-go-v2 v1.19.1 go: downloading github.com/grpc-ecosystem/go-grpc-prometheus v1.2.0 go: downloading github.com/tikv/pd v1.1.0-beta.0.20240407022249-7179657d129b go: downloading go.etcd.io/etcd/client/pkg/v3 v3.5.12 go: downloading cloud.google.com/go v0.112.2 go: downloading github.com/xdg/scram v1.0.5 go: downloading golang.org/x/time v0.7.0 go: downloading go.etcd.io/etcd/server/v3 v3.5.12 go: downloading go.etcd.io/etcd/api/v3 v3.5.12 go: downloading github.com/uber-go/atomic v1.4.0 go: downloading github.com/modern-go/reflect2 v1.0.2 go: downloading github.com/phayes/freeport v0.0.0-20180830031419-95f893ade6f2 go: downloading github.com/gogo/protobuf v1.3.2 go: downloading gopkg.in/natefinch/lumberjack.v2 v2.2.1 go: downloading github.com/go-mysql-org/go-mysql v1.12.0 go: downloading github.com/pingcap/check v0.0.0-20211026125417-57bd13f7b5f0 go: downloading github.com/gavv/monotime v0.0.0-20190418164738-30dba4353424 go: downloading github.com/containerd/cgroups v1.0.4 go: downloading github.com/hashicorp/golang-lru v0.5.1 go: downloading github.com/rcrowley/go-metrics v0.0.0-20201227073835-cf1acfcdf475 go: downloading golang.org/x/oauth2 v0.24.0 go: downloading github.com/jcmturner/gokrb5/v8 v8.4.4 go: downloading github.com/segmentio/kafka-go v0.4.41-0.20230526171612-f057b1d369cd go: downloading github.com/klauspost/compress v1.17.9 go: downloading github.com/pierrec/lz4/v4 v4.1.18 go: downloading golang.org/x/net v0.33.0 go: downloading github.com/philhofer/fwd v1.1.1 go: downloading github.com/modern-go/concurrent v0.0.0-20180306012644-bacd9c7ef1dd go: downloading github.com/gin-contrib/sse v0.1.0 go: downloading github.com/mattn/go-isatty v0.0.20 go: downloading github.com/go-playground/validator/v10 v10.14.0 go: downloading github.com/pelletier/go-toml/v2 v2.0.8 go: downloading github.com/ugorji/go/codec v1.2.11 go: downloading google.golang.org/protobuf v1.35.2 go: downloading gopkg.in/yaml.v3 v3.0.1 go: downloading github.com/docker/go-units v0.5.0 go: downloading golang.org/x/sys v0.28.0 go: downloading go.etcd.io/etcd/pkg/v3 v3.5.12 go: downloading github.com/xdg/stringprep v1.0.3 go: downloading golang.org/x/crypto v0.31.0 go: downloading github.com/coreos/go-systemd/v22 v22.5.0 go: downloading github.com/prometheus/client_model v0.6.1 go: downloading github.com/prometheus/common v0.61.0 go: downloading github.com/beorn7/perks v1.0.1 go: downloading github.com/cespare/xxhash/v2 v2.3.0 go: downloading github.com/prometheus/procfs v0.15.1 go: downloading github.com/aws/smithy-go v1.13.5 go: downloading github.com/dustin/go-humanize v1.0.1 go: downloading github.com/pingcap/sysutil v1.0.1-0.20240311050922-ae81ee01f3a5 go: downloading github.com/robfig/cron v1.2.0 go: downloading github.com/pkg/errors v0.9.1 go: downloading github.com/opentracing/opentracing-go v1.2.0 go: downloading github.com/tiancaiamao/gp v0.0.0-20221230034425-4025bc8a4d4a go: downloading github.com/BurntSushi/toml v1.4.1-0.20240526193622-a339e1f7089c go: downloading github.com/spf13/cobra v1.8.1 go: downloading github.com/go-oauth2/oauth2/v4 v4.5.2 go: downloading github.com/golang-jwt/jwt v3.2.2+incompatible go: downloading github.com/confluentinc/confluent-kafka-go/v2 v2.3.0 go: downloading github.com/PingCAP-QE/go-sqlsmith v0.0.0-20241224111350-ad2e4f976c7c go: downloading gopkg.in/yaml.v2 v2.4.0 go: downloading github.com/davecgh/go-spew v1.1.2-0.20180830191138-d8f796af33cc go: downloading github.com/eapache/go-resiliency v1.4.0 go: downloading github.com/eapache/go-xerial-snappy v0.0.0-20230731223053-c322873962e3 go: downloading github.com/eapache/queue v1.1.0 go: downloading github.com/hashicorp/go-multierror v1.1.1 go: downloading github.com/jcmturner/gofork v1.7.6 go: downloading github.com/chzyer/readline v1.5.1 go: downloading github.com/golang/protobuf v1.5.4 go: downloading github.com/google/shlex v0.0.0-20191202100458-e7afc7fbc510 go: downloading github.com/spf13/pflag v1.0.5 go: downloading github.com/deepmap/oapi-codegen v1.9.0 go: downloading github.com/gogo/gateway v1.1.0 go: downloading github.com/grpc-ecosystem/grpc-gateway v1.16.0 go: downloading github.com/getkin/kin-openapi v0.80.0 go: downloading google.golang.org/genproto/googleapis/api v0.0.0-20240401170217-c3f982113cda go: downloading cloud.google.com/go/compute/metadata v0.3.0 go: downloading cloud.google.com/go/iam v1.1.7 go: downloading google.golang.org/genproto v0.0.0-20240401170217-c3f982113cda go: downloading golang.org/x/text v0.21.0 go: downloading github.com/googleapis/gax-go/v2 v2.12.3 go: downloading google.golang.org/api v0.170.0 go: downloading github.com/pierrec/lz4 v2.6.1+incompatible go: downloading github.com/Azure/azure-sdk-for-go/sdk/storage/azblob v1.0.0 go: downloading golang.org/x/exp v0.0.0-20240909161429-701f63a606c0 go: downloading github.com/syndtr/goleveldb v1.0.1-0.20210305035536-64b5b1c73954 go: downloading github.com/KyleBanks/depth v1.2.1 go: downloading github.com/go-openapi/spec v0.21.0 go: downloading github.com/shopspring/decimal v1.3.0 go: downloading github.com/soheilhy/cmux v0.1.5 go: downloading github.com/grpc-ecosystem/grpc-gateway/v2 v2.19.1 go: downloading go.uber.org/dig v1.13.0 go: downloading golang.org/x/tools v0.28.0 go: downloading gorm.io/gorm v1.25.11 go: downloading github.com/mattn/go-shellwords v1.0.12 go: downloading go.uber.org/ratelimit v0.2.0 go: downloading github.com/VividCortex/mysqlerr v1.0.0 go: downloading github.com/glebarez/go-sqlite v1.21.2 go: downloading github.com/go-ozzo/ozzo-validation/v4 v4.3.0 go: downloading github.com/glebarez/sqlite v1.7.0 go: downloading gorm.io/driver/mysql v1.5.7 go: downloading google.golang.org/genproto/googleapis/rpc v0.0.0-20240515191416-fc5f0ca64291 go: downloading golang.org/x/term v0.27.0 go: downloading github.com/fatih/color v1.18.0 go: downloading github.com/edwingeng/deque v0.0.0-20191220032131-8596380dee17 go: downloading github.com/pmezard/go-difflib v1.0.1-0.20181226105442-5d4384ee4fb2 go: downloading github.com/stretchr/objx v0.5.2 go: downloading go.uber.org/goleak v1.3.0 go: downloading github.com/aws/aws-sdk-go-v2/config v1.18.30 go: downloading github.com/aws/aws-sdk-go-v2/credentials v1.13.29 go: downloading github.com/aws/aws-sdk-go-v2/service/glue v1.58.1 go: downloading github.com/jarcoal/httpmock v1.2.0 go: downloading github.com/linkedin/goavro/v2 v2.11.1 go: downloading github.com/mailru/easyjson v0.7.7 go: downloading github.com/olekukonko/tablewriter v0.0.5 go: downloading github.com/bradleyjkemp/grpc-tools v0.2.5 go: downloading github.com/integralist/go-findroot v0.0.0-20160518114804-ac90681525dc go: downloading github.com/jmoiron/sqlx v1.3.3 go: downloading upper.io/db.v3 v3.7.1+incompatible go: downloading github.com/bits-and-blooms/bitset v1.14.3 go: downloading github.com/sirupsen/logrus v1.9.3 go: downloading github.com/joomcode/errorx v1.0.1 go: downloading github.com/godbus/dbus/v5 v5.0.4 go: downloading github.com/opencontainers/runtime-spec v1.0.2 go: downloading github.com/cilium/ebpf v0.4.0 go: downloading filippo.io/edwards25519 v1.1.0 go: downloading github.com/Masterminds/semver v1.5.0 go: downloading github.com/jcmturner/dnsutils/v2 v2.0.0 go: downloading github.com/hashicorp/go-uuid v1.0.3 go: downloading github.com/AthenZ/athenz v1.10.39 go: downloading github.com/tmc/grpc-websocket-proxy v0.0.0-20220101234140-673ab2c3ae75 go: downloading go.etcd.io/bbolt v1.3.9 go: downloading go.opentelemetry.io/contrib/instrumentation/google.golang.org/grpc/otelgrpc v0.49.0 go: downloading go.opentelemetry.io/otel v1.24.0 go: downloading go.opentelemetry.io/otel/exporters/otlp/otlptrace/otlptracegrpc v1.22.0 go: downloading go.opentelemetry.io/otel/sdk v1.24.0 go: downloading sigs.k8s.io/yaml v1.4.0 go: downloading github.com/cakturk/go-netstat v0.0.0-20200220111822-e5b49efee7a5 go: downloading github.com/xdg-go/scram v1.1.2 go: downloading github.com/Azure/azure-sdk-for-go/sdk/internal v1.10.0 go: downloading github.com/gabriel-vasile/mimetype v1.4.2 go: downloading github.com/go-playground/universal-translator v0.18.1 go: downloading github.com/leodido/go-urn v1.2.4 go: downloading github.com/munnerz/goautoneg v0.0.0-20191010083416-a7dc8b61c822 go: downloading github.com/cockroachdb/errors v1.11.1 go: downloading github.com/cockroachdb/redact v1.1.5 go: downloading github.com/cockroachdb/tokenbucket v0.0.0-20230807174530-cc333fc44b06 go: downloading github.com/cznic/mathutil v0.0.0-20181122101859-297441e03548 go: downloading github.com/twmb/murmur3 v1.1.6 go: downloading github.com/grpc-ecosystem/go-grpc-middleware v1.4.0 go: downloading github.com/dgryski/go-farm v0.0.0-20240924180020-3414d57e47da go: downloading github.com/cloudfoundry/gosigar v1.3.6 go: downloading github.com/tidwall/buntdb v1.3.0 go: downloading github.com/golang/snappy v0.0.4 go: downloading github.com/hashicorp/errwrap v1.0.0 go: downloading go.opentelemetry.io/otel/exporters/otlp/otlptrace v1.22.0 go: downloading github.com/go-openapi/jsonpointer v0.21.0 go: downloading github.com/ghodss/yaml v1.0.0 go: downloading go.opencensus.io v0.23.1-0.20220331163232-052120675fac go: downloading go.opentelemetry.io/otel/trace v1.24.0 go: downloading github.com/godbus/dbus v0.0.0-20190726142602-4481cbc300e2 go: downloading github.com/coocood/freecache v1.2.1 go: downloading github.com/pingcap/tipb v0.0.0-20241105053214-f91fdb81a69e go: downloading github.com/gorilla/mux v1.8.1 go: downloading github.com/ngaut/pools v0.0.0-20180318154953-b7bc8c42aac7 go: downloading github.com/uber/jaeger-client-go v2.30.0+incompatible go: downloading github.com/otiai10/copy v1.2.0 go: downloading github.com/ngaut/log v0.0.0-20210830112240-0124ec040aeb go: downloading github.com/opentracing/basictracer-go v1.1.0 go: downloading github.com/Azure/azure-sdk-for-go/sdk/azidentity v1.7.0 go: downloading github.com/blacktear23/go-proxyprotocol v1.0.6 go: downloading github.com/pingcap/fn v1.0.0 go: downloading github.com/aliyun/alibaba-cloud-sdk-go v1.61.1581 go: downloading github.com/joho/sqltocsv v0.0.0-20210428211105-a6d6801d59df go: downloading github.com/jedib0t/go-pretty/v6 v6.2.2 go: downloading github.com/tidwall/btree v1.7.0 go: downloading github.com/carlmjohnson/flagext v0.21.0 go: downloading github.com/spkg/bom v1.0.0 go: downloading github.com/xitongsys/parquet-go v1.6.3-0.20240520233950-75e935fc3e17 go: downloading github.com/qri-io/jsonschema v0.2.1 go: downloading github.com/DataDog/zstd v1.5.5 go: downloading github.com/shurcooL/httpgzip v0.0.0-20190720172056-320755c1c1b0 go: downloading github.com/spaolacci/murmur3 v1.1.0 go: downloading github.com/sourcegraph/appdash v0.0.0-20190731080439-ebfcffb1b5c0 go: downloading golang.org/x/mod v0.22.0 go: downloading github.com/go-resty/resty/v2 v2.11.0 go: downloading github.com/ks3sdklib/aws-sdk-go v1.2.9 go: downloading github.com/tiancaiamao/appdash v0.0.0-20181126055449-889f96f722a2 go: downloading github.com/sourcegraph/appdash-data v0.0.0-20151005221446-73f23eafcf67 go: downloading github.com/pingcap/goleveldb v0.0.0-20191226122134-f82aafb29989 go: downloading github.com/jcmturner/aescts/v2 v2.0.0 go: downloading github.com/mattn/go-colorable v0.1.13 go: downloading github.com/99designs/keyring v1.2.1 go: downloading go.etcd.io/etcd/raft/v3 v3.5.12 go: downloading github.com/jcmturner/rpc/v2 v2.0.3 go: downloading github.com/jonboulle/clockwork v0.4.0 go: downloading github.com/xiang90/probing v0.0.0-20221125231312-a49e3df8f510 go: downloading github.com/mattn/go-runewidth v0.0.16 go: downloading github.com/andres-erbsen/clock v0.0.0-20160526145045-9e14626cd129 go: downloading modernc.org/libc v1.37.1 go: downloading modernc.org/sqlite v1.27.0 go: downloading github.com/gorilla/websocket v1.5.1 go: downloading github.com/tklauser/go-sysconf v0.3.12 go: downloading go.opentelemetry.io/otel/metric v1.24.0 go: downloading github.com/improbable-eng/grpc-web v0.12.0 go: downloading github.com/xdg-go/pbkdf2 v1.0.0 go: downloading github.com/xdg-go/stringprep v1.0.4 go: downloading github.com/aws/aws-sdk-go-v2/feature/ec2/imds v1.13.6 go: downloading github.com/aws/aws-sdk-go-v2/internal/ini v1.3.37 go: downloading github.com/aws/aws-sdk-go-v2/service/ssooidc v1.14.14 go: downloading github.com/aws/aws-sdk-go-v2/service/sso v1.12.14 go: downloading github.com/aws/aws-sdk-go-v2/service/sts v1.20.1 go: downloading github.com/tidwall/gjson v1.14.3 go: downloading github.com/tidwall/grect v0.1.4 go: downloading github.com/tidwall/match v1.1.1 go: downloading github.com/tidwall/rtred v0.1.2 go: downloading github.com/go-playground/locales v0.14.1 go: downloading github.com/influxdata/tdigest v0.0.1 go: downloading github.com/go-openapi/swag v0.23.0 go: downloading github.com/danjacques/gofslock v0.0.0-20240212154529-d899e02bfe22 go: downloading github.com/asaskevich/govalidator v0.0.0-20230301143203-a9d515a09cc2 go: downloading go.uber.org/mock v0.4.0 go: downloading github.com/lestrrat-go/jwx/v2 v2.0.21 go: downloading github.com/vbauerster/mpb/v7 v7.5.3 go: downloading github.com/cheggaaa/pb/v3 v3.0.8 go: downloading github.com/jellydator/ttlcache/v3 v3.0.1 go: downloading github.com/dolthub/swiss v0.2.1 go: downloading github.com/ngaut/sync2 v0.0.0-20141008032647-7a24ed77b2ef go: downloading github.com/remyoudompheng/bigfft v0.0.0-20230129092748-24d4a6f8daec go: downloading github.com/dgraph-io/ristretto v0.1.1 go: downloading github.com/jinzhu/now v1.1.5 go: downloading github.com/yangkeao/ldap/v3 v3.4.5-0.20230421065457-369a3bab1117 go: downloading github.com/jfcg/sorty/v2 v2.1.0 go: downloading github.com/AzureAD/microsoft-authentication-library-for-go v1.2.2 go: downloading github.com/google/pprof v0.0.0-20241001023024-f4c0cfd0cf1d go: downloading github.com/go-openapi/jsonreference v0.21.0 go: downloading github.com/golang-jwt/jwt/v4 v4.5.1 go: downloading github.com/apache/thrift v0.16.0 go: downloading go.etcd.io/etcd/client/v2 v2.305.12 go: downloading github.com/golang/groupcache v0.0.0-20210331224755-41bb18bfe9da go: downloading github.com/jinzhu/inflection v1.0.0 go: downloading github.com/rivo/uniseg v0.4.7 go: downloading github.com/cockroachdb/logtags v0.0.0-20230118201751-21c54148d20b go: downloading github.com/getsentry/sentry-go v0.27.0 go: downloading github.com/dvsekhvalnov/jose2go v1.5.0 go: downloading github.com/gsterjov/go-libsecret v0.0.0-20161001094733-a6f4afe4910c go: downloading github.com/mtibben/percent v0.2.1 go: downloading github.com/aws/aws-sdk-go-v2/internal/configsources v1.1.36 go: downloading github.com/qri-io/jsonpointer v0.1.1 go: downloading github.com/pingcap/badger v1.5.1-0.20241015064302-38533b6cbf8d go: downloading github.com/robfig/cron/v3 v3.0.1 go: downloading github.com/wangjohn/quickselect v0.0.0-20161129230411-ed8402a42d5f go: downloading github.com/aws/aws-sdk-go-v2/service/internal/presigned-url v1.9.30 go: downloading github.com/uber/jaeger-lib v2.4.1+incompatible go: downloading k8s.io/api v0.29.11 go: downloading github.com/emirpasic/gods v1.18.1 go: downloading github.com/tidwall/pretty v1.2.0 go: downloading github.com/tklauser/numcpus v0.6.1 go: downloading github.com/dolthub/maphash v0.1.0 go: downloading github.com/apache/arrow/go/v12 v12.0.1 go: downloading github.com/goccy/go-reflect v1.2.0 go: downloading github.com/VividCortex/ewma v1.2.0 go: downloading github.com/kr/pretty v0.3.1 go: downloading github.com/jfcg/sixb v1.3.8 go: downloading github.com/acarl005/stripansi v0.0.0-20180116102854-5a71ef0e047d go: downloading github.com/aws/aws-sdk-go-v2/internal/endpoints/v2 v2.4.30 go: downloading github.com/Azure/go-ntlmssp v0.0.0-20221128193559-754e69321358 go: downloading github.com/go-asn1-ber/asn1-ber v1.5.4 go: downloading github.com/tidwall/tinyqueue v0.1.1 go: downloading github.com/josharian/intern v1.0.0 go: downloading go.opentelemetry.io/proto/otlp v1.1.0 go: downloading cloud.google.com/go/kms v1.15.8 go: downloading github.com/go-logr/logr v1.4.1 go: downloading github.com/go-logr/stdr v1.2.2 go: downloading github.com/desertbit/timer v0.0.0-20180107155436-c41aec40b27f go: downloading github.com/rs/cors v1.7.0 go: downloading github.com/kr/text v0.2.0 go: downloading github.com/rogpeppe/go-internal v1.13.1 go: downloading github.com/golang/glog v1.2.0 go: downloading github.com/kylelemons/godebug v1.1.0 go: downloading github.com/pkg/browser v0.0.0-20240102092130-5ac0b6a4141c go: downloading github.com/golang-jwt/jwt/v5 v5.2.1 go: downloading github.com/lestrrat-go/option v1.0.1 go: downloading github.com/lestrrat-go/blackmagic v1.0.2 go: downloading github.com/lestrrat-go/iter v1.0.2 go: downloading github.com/lestrrat-go/httprc v1.0.5 go: downloading github.com/lestrrat-go/httpcc v1.0.1 go: downloading github.com/klauspost/cpuid v1.3.1 go: downloading github.com/coocood/rtutil v0.0.0-20190304133409-c84515f646f2 go: downloading github.com/coocood/bbloom v0.0.0-20190830030839-58deb6228d64 go: downloading github.com/ncw/directio v1.0.5 go: downloading golang.org/x/xerrors v0.0.0-20231012003039-104605ab7028 go: downloading github.com/google/flatbuffers v2.0.8+incompatible go: downloading github.com/zeebo/xxh3 v1.0.2 go: downloading github.com/andybalholm/brotli v1.0.5 go: downloading github.com/klauspost/cpuid/v2 v2.2.4 go: downloading k8s.io/apimachinery v0.29.11 go: downloading k8s.io/klog/v2 v2.120.1 go: downloading github.com/google/gofuzz v1.2.0 go: downloading sigs.k8s.io/structured-merge-diff/v4 v4.4.1 go: downloading gopkg.in/inf.v0 v0.9.1 go: downloading sigs.k8s.io/json v0.0.0-20221116044647-bc3834ca7abd go: downloading k8s.io/utils v0.0.0-20230726121419-3b25d923346b go: downloading modernc.org/memory v1.7.2 go: downloading modernc.org/mathutil v1.6.0 go: downloading github.com/ardielle/ardielle-go v1.5.2 go: downloading github.com/jmespath/go-jmespath v0.4.0 go: downloading go.opentelemetry.io/contrib/instrumentation/net/http/otelhttp v0.49.0 go: downloading github.com/googleapis/enterprise-certificate-proxy v0.3.2 go: downloading github.com/google/s2a-go v0.1.7 go: downloading github.com/felixge/httpsnoop v1.0.4 + make sync-diff-inspector CGO_ENABLED=0 GO111MODULE=on go build -trimpath -ldflags '-X "github.com/pingcap/tiflow/pkg/version.ReleaseVersion=v9.0.0-beta.1-10-ga306f4894-dirty" -X "github.com/pingcap/tiflow/pkg/version.BuildTS=2025-04-04 07:19:41" -X "github.com/pingcap/tiflow/pkg/version.GitHash=a306f48949e037965a7c1963f500f7e0abbfba51" -X "github.com/pingcap/tiflow/pkg/version.GitBranch=HEAD" -X "github.com/pingcap/tidb/pkg/parser/mysql.TiDBReleaseVersion=v9.0.0-beta.1-10-ga306f4894-dirty"' -o bin/sync_diff_inspector ./sync_diff_inspector + make failpoint-disable $(echo $(for p in $(go list ./... | grep -vE 'vendor|proto|tiflow/tests|integration|testing_utils|pb|pbmock|tiflow/bin'); do echo ${p#"github.com/pingcap/tiflow/"}|grep -v "github.com/pingcap/tiflow"; done) | xargs tools/bin/failpoint-ctl disable >/dev/null) + cd sync_diff_inspector + ln -sf ../bin . + ./tests/run.sh tikv-server: no process found pd-server: no process found tidb-server: no process found Starting PD... Starting TiKV... Starting TiDB... Verifying TiDB is started... tidb is not alive, will try again tidb is alive Starting Upstream TiDB... Verifying Upstream TiDB is started... tidb is not alive, will try again tidb is alive ******************************************* Running test ./importer/run.sh... ******************************************* mysql is alive [importer]total 10 cases, cost 0 seconds, tps -1, start 2025-04-04 15:22:31.360470656 +0800 CST m=+0.055803951, now 2025-04-04 15:22:31.361746539 +0800 CST m=+0.057079832 [importer]total 10 cases, cost 0 seconds, tps -1, start 2025-04-04 15:22:31.3975977 +0800 CST m=+0.024138599, now 2025-04-04 15:22:31.398567916 +0800 CST m=+0.025108815 [importer]total 10 cases, cost 0 seconds, tps -1, start 2025-04-04 15:22:31.433177031 +0800 CST m=+0.024292483, now 2025-04-04 15:22:31.434481344 +0800 CST m=+0.025596797 [importer]total 10 cases, cost 0 seconds, tps -1, start 2025-04-04 15:22:31.466163484 +0800 CST m=+0.021675556, now 2025-04-04 15:22:31.467016732 +0800 CST m=+0.022528805 ******************************************* Running test ./sync_diff_inspector/run.sh... ******************************************* ++ dirname ./sync_diff_inspector/run.sh + cd ./sync_diff_inspector + check_db_status 127.0.0.1 3306 mysql . mysql is alive + BASE_DIR=/tmp/sync_diff_inspector_test/sync_diff_inspector + OUT_DIR=/tmp/sync_diff_inspector_test/sync_diff_inspector/output + mkdir -p /tmp/sync_diff_inspector_test/sync_diff_inspector/output + echo 'use importer to generate test data' use importer to generate test data + mysql -uroot -h 127.0.0.1 -P 4000 -e 'create database if not exists diff_test' + importer -t 'create table diff_test.test(a int, aa int, b varchar(10), c float, d datetime, primary key(a), key(aa));' -c 10 -n 10000 -P 4000 -h 127.0.0.1 -D diff_test -b 1000 [importer]total 10000 cases, cost 1 seconds, tps 10000, start 2025-04-04 15:22:31.559442143 +0800 CST m=+0.040427914, now 2025-04-04 15:22:32.799173397 +0800 CST m=+1.280159166 + mysql -uroot -h 127.0.0.1 -P 4000 -e 'alter table diff_test.test change column a `table` int' + echo 'dump data and then load to tidb and mysql' dump data and then load to tidb and mysql + dumpling --host 127.0.0.1 --port 4000 --user root -o /tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff -B diff_test -T diff_test.test Release version: v5.3.0-alpha-11-g05b0b48 Git commit hash: 05b0b48d711a95ae330c08d07ec09543254cea6b Git branch: master Build timestamp: 2022-03-17 08:15:23Z Go version: go version go1.18 linux/amd64 [2025/04/04 15:22:32.912 +08:00] [INFO] [versions.go:55] ["Welcome to dumpling"] ["Release Version"=v5.3.0-alpha-11-g05b0b48] ["Git Commit Hash"=05b0b48d711a95ae330c08d07ec09543254cea6b] ["Git Branch"=master] ["Build timestamp"="2022-03-17 08:15:23"] ["Go Version"="go version go1.18 linux/amd64"] [2025/04/04 15:22:32.914 +08:00] [INFO] [config.go:609] ["detect server type"] [type=TiDB] [2025/04/04 15:22:32.914 +08:00] [INFO] [config.go:628] ["detect server version"] [version=9.0.0-beta.1.pre-511-gd9fb3a5337] [2025/04/04 15:22:32.920 +08:00] [INFO] [client.go:215] ["[pd] create pd client with endpoints"] [pd-address="[127.0.0.1:2379]"] [2025/04/04 15:22:32.921 +08:00] [INFO] [base_client.go:364] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2379] [old-leader=] [2025/04/04 15:22:32.921 +08:00] [INFO] [base_client.go:127] ["[pd] init cluster id"] [cluster-id=7489354995974521043] [2025/04/04 15:22:32.921 +08:00] [INFO] [client.go:239] ["[pd] create tso dispatcher"] [dc-location=global] [2025/04/04 15:22:32.922 +08:00] [INFO] [dump.go:1151] ["generate dumpling gc safePoint id"] [id=dumpling_1743751352922131662] [2025/04/04 15:22:32.923 +08:00] [INFO] [dump.go:93] ["begin to run Dump"] [conf="{\"s3\":{\"endpoint\":\"\",\"region\":\"\",\"storage-class\":\"\",\"sse\":\"\",\"sse-kms-key-id\":\"\",\"acl\":\"\",\"access-key\":\"\",\"secret-access-key\":\"\",\"provider\":\"\",\"force-path-style\":true,\"use-accelerate-endpoint\":false},\"gcs\":{\"endpoint\":\"\",\"storage-class\":\"\",\"predefined-acl\":\"\",\"credentials-file\":\"\"},\"AllowCleartextPasswords\":false,\"SortByPk\":true,\"NoViews\":true,\"NoHeader\":false,\"NoSchemas\":false,\"NoData\":false,\"CompleteInsert\":false,\"TransactionalConsistency\":true,\"EscapeBackslash\":true,\"DumpEmptyDatabase\":true,\"PosAfterConnect\":false,\"CompressType\":0,\"Host\":\"127.0.0.1\",\"Port\":4000,\"Threads\":4,\"User\":\"root\",\"Security\":{\"CAPath\":\"\",\"CertPath\":\"\",\"KeyPath\":\"\"},\"LogLevel\":\"info\",\"LogFile\":\"\",\"LogFormat\":\"text\",\"OutputDirPath\":\"/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff\",\"StatusAddr\":\":8281\",\"Snapshot\":\"457113954650423302\",\"Consistency\":\"snapshot\",\"CsvNullValue\":\"\\\\N\",\"SQL\":\"\",\"CsvSeparator\":\",\",\"CsvDelimiter\":\"\\\"\",\"Databases\":[\"diff_test\"],\"Where\":\"\",\"FileType\":\"sql\",\"ServerInfo\":{\"HasTiKV\":true,\"ServerType\":3,\"ServerVersion\":\"9.0.0-beta.1.pre-511-gd9fb3a5337\"},\"Rows\":0,\"ReadTimeout\":900000000000,\"TiDBMemQuotaQuery\":0,\"FileSize\":0,\"StatementSize\":1000000,\"SessionParams\":{\"tidb_snapshot\":\"457113954650423302\"},\"Tables\":null}"] [2025/04/04 15:22:32.975 +08:00] [INFO] [collector.go:228] ["backup success summary"] [total-ranges=3] [ranges-succeed=3] [ranges-failed=0] [total-take=37.697486ms] [total-rows=10000] [total-kv-size=604kB] [average-speed=16.02MB/s] [2025/04/04 15:22:32.975 +08:00] [INFO] [main.go:81] ["dump data successfully, dumpling will exit now"] + loader -h 127.0.0.1 -P 4001 -u root -d /tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff 2025/04/04 15:22:33 printer.go:52: [info] Welcome to loader 2025/04/04 15:22:33 printer.go:53: [info] Release Version: v1.0.0-79-gf505ab3 2025/04/04 15:22:33 printer.go:54: [info] Git Commit Hash: f505ab3ce55cd9cbb29e2346317164055a1b1c15 2025/04/04 15:22:33 printer.go:55: [info] Git Branch: master 2025/04/04 15:22:33 printer.go:56: [info] UTC Build Time: 2021-07-28 03:42:32 2025/04/04 15:22:33 printer.go:57: [info] Go Version: go version go1.13 linux/amd64 2025/04/04 15:22:33 main.go:51: [info] config: {"log-level":"info","log-file":"","status-addr":":8272","pool-size":16,"dir":"/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff","db":{"host":"127.0.0.1","user":"root","port":4001,"sql-mode":"@DownstreamDefault","max-allowed-packet":67108864},"checkpoint-schema":"tidb_loader","config-file":"","route-rules":null,"do-table":null,"do-db":null,"ignore-table":null,"ignore-db":null,"rm-checkpoint":false} 2025/04/04 15:22:33 loader.go:532: [info] [loader] prepare takes 0.000111 seconds 2025/04/04 15:22:33 checkpoint.go:207: [info] calc checkpoint finished. finished tables (map[]) 2025/04/04 15:22:33 loader.go:715: [info] [loader][run db schema]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test-schema-create.sql[start] 2025/04/04 15:22:33 loader.go:720: [info] [loader][run db schema]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test-schema-create.sql[finished] 2025/04/04 15:22:33 loader.go:736: [info] [loader][run table schema]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test.test-schema.sql[start] 2025/04/04 15:22:33 loader.go:741: [info] [loader][run table schema]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test.test-schema.sql[finished] 2025/04/04 15:22:33 loader.go:773: [info] [loader] create tables takes 0.020270 seconds 2025/04/04 15:22:33 loader.go:788: [info] [loader] all data files have been dispatched, waiting for them finished  2025/04/04 15:22:33 loader.go:158: [info] [loader][restore table data sql]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test.test.000000000.sql[start] 2025/04/04 15:22:33 loader.go:216: [info] data file /tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test.test.000000000.sql scanned finished. 2025/04/04 15:22:33 loader.go:165: [info] [loader][restore table data sql]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test.test.000000000.sql[finished] 2025/04/04 15:22:33 loader.go:791: [info] [loader] all data files has been finished, takes 0.273589 seconds 2025/04/04 15:22:33 status.go:32: [info] [loader] finished_bytes = 603954, total_bytes = GetAllRestoringFiles603954, progress = 100.00 % 2025/04/04 15:22:33 main.go:88: [info] loader stopped and exits  + mysql -h 127.0.0.1 -P 3306 -u root -e 'create database if not exists tidb_loader' + loader -h 127.0.0.1 -P 3306 -u root -d /tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff 2025/04/04 15:22:33 printer.go:52: [info] Welcome to loader 2025/04/04 15:22:33 printer.go:53: [info] Release Version: v1.0.0-79-gf505ab3 2025/04/04 15:22:33 printer.go:54: [info] Git Commit Hash: f505ab3ce55cd9cbb29e2346317164055a1b1c15 2025/04/04 15:22:33 printer.go:55: [info] Git Branch: master 2025/04/04 15:22:33 printer.go:56: [info] UTC Build Time: 2021-07-28 03:42:32 2025/04/04 15:22:33 printer.go:57: [info] Go Version: go version go1.13 linux/amd64 2025/04/04 15:22:33 main.go:51: [info] config: {"log-level":"info","log-file":"","status-addr":":8272","pool-size":16,"dir":"/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff","db":{"host":"127.0.0.1","user":"root","port":3306,"sql-mode":"@DownstreamDefault","max-allowed-packet":67108864},"checkpoint-schema":"tidb_loader","config-file":"","route-rules":null,"do-table":null,"do-db":null,"ignore-table":null,"ignore-db":null,"rm-checkpoint":false} 2025/04/04 15:22:33 loader.go:532: [info] [loader] prepare takes 0.000098 seconds 2025/04/04 15:22:33 checkpoint.go:207: [info] calc checkpoint finished. finished tables (map[]) 2025/04/04 15:22:33 loader.go:715: [info] [loader][run db schema]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test-schema-create.sql[start] 2025/04/04 15:22:33 loader.go:720: [info] [loader][run db schema]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test-schema-create.sql[finished] 2025/04/04 15:22:33 loader.go:736: [info] [loader][run table schema]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test.test-schema.sql[start] 2025/04/04 15:22:33 loader.go:741: [info] [loader][run table schema]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test.test-schema.sql[finished] 2025/04/04 15:22:33 loader.go:773: [info] [loader] create tables takes 0.004945 seconds 2025/04/04 15:22:33 loader.go:788: [info] [loader] all data files have been dispatched, waiting for them finished  2025/04/04 15:22:33 loader.go:158: [info] [loader][restore table data sql]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test.test.000000000.sql[start] 2025/04/04 15:22:33 loader.go:216: [info] data file /tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test.test.000000000.sql scanned finished. 2025/04/04 15:22:33 loader.go:165: [info] [loader][restore table data sql]/tmp/sync_diff_inspector_test/sync_diff_inspector/dump_diff/diff_test.test.000000000.sql[finished] 2025/04/04 15:22:33 loader.go:791: [info] [loader] all data files has been finished, takes 0.093885 seconds 2025/04/04 15:22:33 status.go:32: [info] [loader] finished_bytes = 603954, total_bytes = GetAllRestoringFiles603954, progress = 100.00 % 2025/04/04 15:22:33 main.go:88: [info] loader stopped and exits  + mysql -h 127.0.0.1 -P 3306 -u root -e 'select * from diff_test.test limit 10;' table aa b c d 0 1419776618 MQHOSygk -487978000 2025-10-14 00:25:17 1 -1450444538 yQ7D39x 1455490000 2025-06-25 17:20:28 2 89923793 i01DI7ru3e -1091340000 2025-11-04 16:28:12 3 -683496931 kmPhOj 1996750000 2025-09-06 13:45:06 4 1376192461 VAHJIM -486142000 2025-01-20 14:51:01 5 398209485 1N -1853740000 2025-08-01 09:45:08 6 -658080513 F6 965807000 2025-04-10 03:34:29 7 -1320295525 u 1512750000 2025-02-18 01:35:32 8 1727278371 rENT -1925820000 2025-07-24 12:41:11 9 180231004 oc2 897792000 2025-11-13 05:29:34 + echo 'use sync_diff_inspector to compare data' use sync_diff_inspector to compare data + sync_diff_inspector --config=./config_base_tidb.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + echo 'analyze table, and will use tidb'\''s statistical information to split chunks' analyze table, and will use tidb's statistical information to split chunks + check_contains 'split range by random' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/diff.output /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + mysql -uroot -h 127.0.0.1 -P 4000 -e 'analyze table diff_test.test' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'explain select * from diff_test.test where aa > 1' id estRows task access object operator info TableReader_7 5021.18 root data:Selection_6 └─Selection_6 5021.18 cop[tikv] gt(diff_test.test.aa, 1) └─TableFullScan_5 10000.00 cop[tikv] table:test keep order:false, stats:partial[table:allEvicted] + mysql -uroot -h 127.0.0.1 -P 4000 -e 'explain select * from diff_test.test where `table` > 1' id estRows task access object operator info TableReader_6 9999.00 root data:TableRangeScan_5 └─TableRangeScan_5 9999.00 cop[tikv] table:test range:(1,+inf], keep order:false + mysql -uroot -h 127.0.0.1 -P 4000 -e 'show stats_buckets' Db_name Table_name Partition_name Column_name Is_index Bucket_id Count Repeats Lower_Bound Upper_Bound Ndv diff_test test table 0 0 40 1 0 39 0 diff_test test table 0 1 80 1 40 79 0 diff_test test table 0 2 120 1 80 119 0 diff_test test table 0 3 160 1 120 159 0 diff_test test table 0 4 200 1 160 199 0 diff_test test table 0 5 240 1 200 239 0 diff_test test table 0 6 280 1 240 279 0 diff_test test table 0 7 320 1 280 319 0 diff_test test table 0 8 360 1 320 359 0 diff_test test table 0 9 400 1 360 399 0 diff_test test table 0 10 440 1 400 439 0 diff_test test table 0 11 480 1 440 479 0 diff_test test table 0 12 520 1 480 519 0 diff_test test table 0 13 560 1 520 559 0 diff_test test table 0 14 600 1 560 599 0 diff_test test table 0 15 640 1 600 639 0 diff_test test table 0 16 680 1 640 679 0 diff_test test table 0 17 720 1 680 719 0 diff_test test table 0 18 760 1 720 759 0 diff_test test table 0 19 800 1 760 799 0 diff_test test table 0 20 840 1 800 839 0 diff_test test table 0 21 880 1 840 879 0 diff_test test table 0 22 920 1 880 919 0 diff_test test table 0 23 960 1 920 959 0 diff_test test table 0 24 1000 1 960 999 0 diff_test test table 0 25 1040 1 1000 1039 0 diff_test test table 0 26 1080 1 1040 1079 0 diff_test test table 0 27 1120 1 1080 1119 0 diff_test test table 0 28 1160 1 1120 1159 0 diff_test test table 0 29 1200 1 1160 1199 0 diff_test test table 0 30 1240 1 1200 1239 0 diff_test test table 0 31 1280 1 1240 1279 0 diff_test test table 0 32 1320 1 1280 1319 0 diff_test test table 0 33 1360 1 1320 1359 0 diff_test test table 0 34 1400 1 1360 1399 0 diff_test test table 0 35 1440 1 1400 1439 0 diff_test test table 0 36 1480 1 1440 1479 0 diff_test test table 0 37 1520 1 1480 1519 0 diff_test test table 0 38 1560 1 1520 1559 0 diff_test test table 0 39 1600 1 1560 1599 0 diff_test test table 0 40 1640 1 1600 1639 0 diff_test test table 0 41 1680 1 1640 1679 0 diff_test test table 0 42 1720 1 1680 1719 0 diff_test test table 0 43 1760 1 1720 1759 0 diff_test test table 0 44 1800 1 1760 1799 0 diff_test test table 0 45 1840 1 1800 1839 0 diff_test test table 0 46 1880 1 1840 1879 0 diff_test test table 0 47 1920 1 1880 1919 0 diff_test test table 0 48 1960 1 1920 1959 0 diff_test test table 0 49 2000 1 1960 1999 0 diff_test test table 0 50 2040 1 2000 2039 0 diff_test test table 0 51 2080 1 2040 2079 0 diff_test test table 0 52 2120 1 2080 2119 0 diff_test test table 0 53 2160 1 2120 2159 0 diff_test test table 0 54 2200 1 2160 2199 0 diff_test test table 0 55 2240 1 2200 2239 0 diff_test test table 0 56 2280 1 2240 2279 0 diff_test test table 0 57 2320 1 2280 2319 0 diff_test test table 0 58 2360 1 2320 2359 0 diff_test test table 0 59 2400 1 2360 2399 0 diff_test test table 0 60 2440 1 2400 2439 0 diff_test test table 0 61 2480 1 2440 2479 0 diff_test test table 0 62 2520 1 2480 2519 0 diff_test test table 0 63 2560 1 2520 2559 0 diff_test test table 0 64 2600 1 2560 2599 0 diff_test test table 0 65 2640 1 2600 2639 0 diff_test test table 0 66 2680 1 2640 2679 0 diff_test test table 0 67 2720 1 2680 2719 0 diff_test test table 0 68 2760 1 2720 2759 0 diff_test test table 0 69 2800 1 2760 2799 0 diff_test test table 0 70 2840 1 2800 2839 0 diff_test test table 0 71 2880 1 2840 2879 0 diff_test test table 0 72 2920 1 2880 2919 0 diff_test test table 0 73 2960 1 2920 2959 0 diff_test test table 0 74 3000 1 2960 2999 0 diff_test test table 0 75 3040 1 3000 3039 0 diff_test test table 0 76 3080 1 3040 3079 0 diff_test test table 0 77 3120 1 3080 3119 0 diff_test test table 0 78 3160 1 3120 3159 0 diff_test test table 0 79 3200 1 3160 3199 0 diff_test test table 0 80 3240 1 3200 3239 0 diff_test test table 0 81 3280 1 3240 3279 0 diff_test test table 0 82 3320 1 3280 3319 0 diff_test test table 0 83 3360 1 3320 3359 0 diff_test test table 0 84 3400 1 3360 3399 0 diff_test test table 0 85 3440 1 3400 3439 0 diff_test test table 0 86 3480 1 3440 3479 0 diff_test test table 0 87 3520 1 3480 3519 0 diff_test test table 0 88 3560 1 3520 3559 0 diff_test test table 0 89 3600 1 3560 3599 0 diff_test test table 0 90 3640 1 3600 3639 0 diff_test test table 0 91 3680 1 3640 3679 0 diff_test test table 0 92 3720 1 3680 3719 0 diff_test test table 0 93 3760 1 3720 3759 0 diff_test test table 0 94 3800 1 3760 3799 0 diff_test test table 0 95 3840 1 3800 3839 0 diff_test test table 0 96 3880 1 3840 3879 0 diff_test test table 0 97 3920 1 3880 3919 0 diff_test test table 0 98 3960 1 3920 3959 0 diff_test test table 0 99 4000 1 3960 3999 0 diff_test test table 0 100 4040 1 4000 4039 0 diff_test test table 0 101 4080 1 4040 4079 0 diff_test test table 0 102 4120 1 4080 4119 0 diff_test test table 0 103 4160 1 4120 4159 0 diff_test test table 0 104 4200 1 4160 4199 0 diff_test test table 0 105 4240 1 4200 4239 0 diff_test test table 0 106 4280 1 4240 4279 0 diff_test test table 0 107 4320 1 4280 4319 0 diff_test test table 0 108 4360 1 4320 4359 0 diff_test test table 0 109 4400 1 4360 4399 0 diff_test test table 0 110 4440 1 4400 4439 0 diff_test test table 0 111 4480 1 4440 4479 0 diff_test test table 0 112 4520 1 4480 4519 0 diff_test test table 0 113 4560 1 4520 4559 0 diff_test test table 0 114 4600 1 4560 4599 0 diff_test test table 0 115 4640 1 4600 4639 0 diff_test test table 0 116 4680 1 4640 4679 0 diff_test test table 0 117 4720 1 4680 4719 0 diff_test test table 0 118 4760 1 4720 4759 0 diff_test test table 0 119 4800 1 4760 4799 0 diff_test test table 0 120 4840 1 4800 4839 0 diff_test test table 0 121 4880 1 4840 4879 0 diff_test test table 0 122 4920 1 4880 4919 0 diff_test test table 0 123 4960 1 4920 4959 0 diff_test test table 0 124 5000 1 4960 4999 0 diff_test test table 0 125 5040 1 5000 5039 0 diff_test test table 0 126 5080 1 5040 5079 0 diff_test test table 0 127 5120 1 5080 5119 0 diff_test test table 0 128 5160 1 5120 5159 0 diff_test test table 0 129 5200 1 5160 5199 0 diff_test test table 0 130 5240 1 5200 5239 0 diff_test test table 0 131 5280 1 5240 5279 0 diff_test test table 0 132 5320 1 5280 5319 0 diff_test test table 0 133 5360 1 5320 5359 0 diff_test test table 0 134 5400 1 5360 5399 0 diff_test test table 0 135 5440 1 5400 5439 0 diff_test test table 0 136 5480 1 5440 5479 0 diff_test test table 0 137 5520 1 5480 5519 0 diff_test test table 0 138 5560 1 5520 5559 0 diff_test test table 0 139 5600 1 5560 5599 0 diff_test test table 0 140 5640 1 5600 5639 0 diff_test test table 0 141 5680 1 5640 5679 0 diff_test test table 0 142 5720 1 5680 5719 0 diff_test test table 0 143 5760 1 5720 5759 0 diff_test test table 0 144 5800 1 5760 5799 0 diff_test test table 0 145 5840 1 5800 5839 0 diff_test test table 0 146 5880 1 5840 5879 0 diff_test test table 0 147 5920 1 5880 5919 0 diff_test test table 0 148 5960 1 5920 5959 0 diff_test test table 0 149 6000 1 5960 5999 0 diff_test test table 0 150 6040 1 6000 6039 0 diff_test test table 0 151 6080 1 6040 6079 0 diff_test test table 0 152 6120 1 6080 6119 0 diff_test test table 0 153 6160 1 6120 6159 0 diff_test test table 0 154 6200 1 6160 6199 0 diff_test test table 0 155 6240 1 6200 6239 0 diff_test test table 0 156 6280 1 6240 6279 0 diff_test test table 0 157 6320 1 6280 6319 0 diff_test test table 0 158 6360 1 6320 6359 0 diff_test test table 0 159 6400 1 6360 6399 0 diff_test test table 0 160 6440 1 6400 6439 0 diff_test test table 0 161 6480 1 6440 6479 0 diff_test test table 0 162 6520 1 6480 6519 0 diff_test test table 0 163 6560 1 6520 6559 0 diff_test test table 0 164 6600 1 6560 6599 0 diff_test test table 0 165 6640 1 6600 6639 0 diff_test test table 0 166 6680 1 6640 6679 0 diff_test test table 0 167 6720 1 6680 6719 0 diff_test test table 0 168 6760 1 6720 6759 0 diff_test test table 0 169 6800 1 6760 6799 0 diff_test test table 0 170 6840 1 6800 6839 0 diff_test test table 0 171 6880 1 6840 6879 0 diff_test test table 0 172 6920 1 6880 6919 0 diff_test test table 0 173 6960 1 6920 6959 0 diff_test test table 0 174 7000 1 6960 6999 0 diff_test test table 0 175 7040 1 7000 7039 0 diff_test test table 0 176 7080 1 7040 7079 0 diff_test test table 0 177 7120 1 7080 7119 0 diff_test test table 0 178 7160 1 7120 7159 0 diff_test test table 0 179 7200 1 7160 7199 0 diff_test test table 0 180 7240 1 7200 7239 0 diff_test test table 0 181 7280 1 7240 7279 0 diff_test test table 0 182 7320 1 7280 7319 0 diff_test test table 0 183 7360 1 7320 7359 0 diff_test test table 0 184 7400 1 7360 7399 0 diff_test test table 0 185 7440 1 7400 7439 0 diff_test test table 0 186 7480 1 7440 7479 0 diff_test test table 0 187 7520 1 7480 7519 0 diff_test test table 0 188 7560 1 7520 7559 0 diff_test test table 0 189 7600 1 7560 7599 0 diff_test test table 0 190 7640 1 7600 7639 0 diff_test test table 0 191 7680 1 7640 7679 0 diff_test test table 0 192 7720 1 7680 7719 0 diff_test test table 0 193 7760 1 7720 7759 0 diff_test test table 0 194 7800 1 7760 7799 0 diff_test test table 0 195 7840 1 7800 7839 0 diff_test test table 0 196 7880 1 7840 7879 0 diff_test test table 0 197 7920 1 7880 7919 0 diff_test test table 0 198 7960 1 7920 7959 0 diff_test test table 0 199 8000 1 7960 7999 0 diff_test test table 0 200 8040 1 8000 8039 0 diff_test test table 0 201 8080 1 8040 8079 0 diff_test test table 0 202 8120 1 8080 8119 0 diff_test test table 0 203 8160 1 8120 8159 0 diff_test test table 0 204 8200 1 8160 8199 0 diff_test test table 0 205 8240 1 8200 8239 0 diff_test test table 0 206 8280 1 8240 8279 0 diff_test test table 0 207 8320 1 8280 8319 0 diff_test test table 0 208 8360 1 8320 8359 0 diff_test test table 0 209 8400 1 8360 8399 0 diff_test test table 0 210 8440 1 8400 8439 0 diff_test test table 0 211 8480 1 8440 8479 0 diff_test test table 0 212 8520 1 8480 8519 0 diff_test test table 0 213 8560 1 8520 8559 0 diff_test test table 0 214 8600 1 8560 8599 0 diff_test test table 0 215 8640 1 8600 8639 0 diff_test test table 0 216 8680 1 8640 8679 0 diff_test test table 0 217 8720 1 8680 8719 0 diff_test test table 0 218 8760 1 8720 8759 0 diff_test test table 0 219 8800 1 8760 8799 0 diff_test test table 0 220 8840 1 8800 8839 0 diff_test test table 0 221 8880 1 8840 8879 0 diff_test test table 0 222 8920 1 8880 8919 0 diff_test test table 0 223 8960 1 8920 8959 0 diff_test test table 0 224 9000 1 8960 8999 0 diff_test test table 0 225 9040 1 9000 9039 0 diff_test test table 0 226 9080 1 9040 9079 0 diff_test test table 0 227 9120 1 9080 9119 0 diff_test test table 0 228 9160 1 9120 9159 0 diff_test test table 0 229 9200 1 9160 9199 0 diff_test test table 0 230 9240 1 9200 9239 0 diff_test test table 0 231 9280 1 9240 9279 0 diff_test test table 0 232 9320 1 9280 9319 0 diff_test test table 0 233 9360 1 9320 9359 0 diff_test test table 0 234 9400 1 9360 9399 0 diff_test test table 0 235 9440 1 9400 9439 0 diff_test test table 0 236 9480 1 9440 9479 0 diff_test test table 0 237 9520 1 9480 9519 0 diff_test test table 0 238 9560 1 9520 9559 0 diff_test test table 0 239 9600 1 9560 9599 0 diff_test test table 0 240 9640 1 9600 9639 0 diff_test test table 0 241 9680 1 9640 9679 0 diff_test test table 0 242 9720 1 9680 9719 0 diff_test test table 0 243 9760 1 9720 9759 0 diff_test test table 0 244 9800 1 9760 9799 0 diff_test test table 0 245 9840 1 9800 9839 0 diff_test test table 0 246 9880 1 9840 9879 0 diff_test test table 0 247 9920 1 9880 9919 0 diff_test test table 0 248 9960 1 9920 9959 0 diff_test test table 0 249 10000 1 9960 9999 0 diff_test test aa 0 0 40 1 -2147334946 -2130828599 0 diff_test test aa 0 1 80 1 -2128575805 -2114374744 0 diff_test test aa 0 2 120 1 -2114183094 -2098566411 0 diff_test test aa 0 3 160 1 -2098301170 -2075696367 0 diff_test test aa 0 4 200 1 -2075213103 -2063312509 0 diff_test test aa 0 5 240 1 -2063066903 -2046893603 0 diff_test test aa 0 6 280 1 -2046739026 -2034343887 0 diff_test test aa 0 7 320 1 -2034289271 -2014843088 0 diff_test test aa 0 8 360 1 -2014490597 -1998369135 0 diff_test test aa 0 9 400 1 -1997384893 -1983458853 0 diff_test test aa 0 10 440 1 -1983445557 -1968356425 0 diff_test test aa 0 11 480 1 -1968330727 -1955158992 0 diff_test test aa 0 12 520 1 -1954395497 -1936533468 0 diff_test test aa 0 13 560 1 -1936506669 -1914883690 0 diff_test test aa 0 14 600 1 -1914873359 -1899761971 0 diff_test test aa 0 15 640 1 -1899555042 -1878414295 0 diff_test test aa 0 16 680 1 -1878175204 -1863313630 0 diff_test test aa 0 17 720 1 -1863286655 -1845637985 0 diff_test test aa 0 18 760 1 -1845378911 -1826615118 0 diff_test test aa 0 19 800 1 -1826265647 -1811765441 0 diff_test test aa 0 20 840 1 -1811669167 -1791207132 0 diff_test test aa 0 21 880 1 -1791060797 -1771228470 0 diff_test test aa 0 22 920 1 -1771021617 -1752902096 0 diff_test test aa 0 23 960 1 -1752739259 -1739729334 0 diff_test test aa 0 24 1000 1 -1739456506 -1724014206 0 diff_test test aa 0 25 1040 1 -1723980295 -1709899210 0 diff_test test aa 0 26 1080 1 -1708509614 -1694584315 0 diff_test test aa 0 27 1120 1 -1694453393 -1674829305 0 diff_test test aa 0 28 1160 1 -1674695301 -1659474492 0 diff_test test aa 0 29 1200 1 -1659407136 -1642586704 0 diff_test test aa 0 30 1240 1 -1641908791 -1626807742 0 diff_test test aa 0 31 1280 1 -1626108401 -1610425754 0 diff_test test aa 0 32 1320 1 -1610376253 -1591973433 0 diff_test test aa 0 33 1360 1 -1591892991 -1576520135 0 diff_test test aa 0 34 1400 1 -1576264982 -1561650466 0 diff_test test aa 0 35 1440 1 -1561196780 -1543350078 0 diff_test test aa 0 36 1480 1 -1543077056 -1521858447 0 diff_test test aa 0 37 1520 1 -1520644356 -1501409721 0 diff_test test aa 0 38 1560 1 -1500405482 -1481388694 0 diff_test test aa 0 39 1600 1 -1481185620 -1459114161 0 diff_test test aa 0 40 1640 1 -1458771638 -1440092399 0 diff_test test aa 0 41 1680 1 -1439963603 -1423152394 0 diff_test test aa 0 42 1720 1 -1423024074 -1407501161 0 diff_test test aa 0 43 1760 1 -1406470639 -1388557256 0 diff_test test aa 0 44 1800 1 -1388177209 -1375321411 0 diff_test test aa 0 45 1840 1 -1375050277 -1363748201 0 diff_test test aa 0 46 1880 1 -1363320206 -1345281763 0 diff_test test aa 0 47 1920 1 -1344877231 -1328149572 0 diff_test test aa 0 48 1960 1 -1327897243 -1314294554 0 diff_test test aa 0 49 2000 1 -1313924924 -1295953735 0 diff_test test aa 0 50 2040 1 -1294099536 -1271914959 0 diff_test test aa 0 51 2080 1 -1271901769 -1254396961 0 diff_test test aa 0 52 2120 1 -1254139095 -1237137377 0 diff_test test aa 0 53 2160 1 -1236419297 -1220289004 0 diff_test test aa 0 54 2200 1 -1219974634 -1200548969 0 diff_test test aa 0 55 2240 1 -1199663860 -1183546114 0 diff_test test aa 0 56 2280 1 -1182375484 -1164007572 0 diff_test test aa 0 57 2320 1 -1163394000 -1147233278 0 diff_test test aa 0 58 2360 1 -1147078689 -1130499974 0 diff_test test aa 0 59 2400 1 -1130458985 -1116413914 0 diff_test test aa 0 60 2440 1 -1115874147 -1099438049 0 diff_test test aa 0 61 2480 1 -1099029848 -1081138947 0 diff_test test aa 0 62 2520 1 -1080911116 -1066545384 0 diff_test test aa 0 63 2560 1 -1066467172 -1052315528 0 diff_test test aa 0 64 2600 1 -1051960570 -1025486996 0 diff_test test aa 0 65 2640 1 -1025441319 -1008952615 0 diff_test test aa 0 66 2680 1 -1008140838 -994117470 0 diff_test test aa 0 67 2720 1 -993751925 -974369712 0 diff_test test aa 0 68 2760 1 -974020794 -957822024 0 diff_test test aa 0 69 2800 1 -957664316 -944094209 0 diff_test test aa 0 70 2840 1 -943495201 -927650822 0 diff_test test aa 0 71 2880 1 -927280052 -909421445 0 diff_test test aa 0 72 2920 1 -909322442 -890878015 0 diff_test test aa 0 73 2960 1 -890760706 -876066109 0 diff_test test aa 0 74 3000 1 -875639503 -861927167 0 diff_test test aa 0 75 3040 1 -861855722 -844458781 0 diff_test test aa 0 76 3080 1 -843492540 -829638141 0 diff_test test aa 0 77 3120 1 -829449645 -812754095 0 diff_test test aa 0 78 3160 1 -812488711 -792953971 0 diff_test test aa 0 79 3200 1 -792791900 -776594561 0 diff_test test aa 0 80 3240 1 -776150906 -757738156 0 diff_test test aa 0 81 3280 1 -757727311 -738301899 0 diff_test test aa 0 82 3320 1 -737986180 -723828223 0 diff_test test aa 0 83 3360 1 -722666781 -703566598 0 diff_test test aa 0 84 3400 1 -703538363 -689453433 0 diff_test test aa 0 85 3440 1 -688969778 -674012120 0 diff_test test aa 0 86 3480 1 -673857341 -659010828 0 diff_test test aa 0 87 3520 1 -658986208 -641600839 0 diff_test test aa 0 88 3560 1 -640968798 -621999948 0 diff_test test aa 0 89 3600 1 -621533564 -606381979 0 diff_test test aa 0 90 3640 1 -605910060 -587016207 0 diff_test test aa 0 91 3680 1 -586969398 -574869516 0 diff_test test aa 0 92 3720 1 -574764467 -550850080 0 diff_test test aa 0 93 3760 1 -550739891 -530650374 0 diff_test test aa 0 94 3800 1 -530418886 -514589912 0 diff_test test aa 0 95 3840 1 -514356741 -498266807 0 diff_test test aa 0 96 3880 1 -497483528 -480066301 0 diff_test test aa 0 97 3920 1 -479659343 -462672985 0 diff_test test aa 0 98 3960 1 -462583589 -445798925 0 diff_test test aa 0 99 4000 1 -444379592 -429656822 0 diff_test test aa 0 100 4040 1 -429566296 -414436349 0 diff_test test aa 0 101 4080 1 -414188846 -395753243 0 diff_test test aa 0 102 4120 1 -394739010 -375911153 0 diff_test test aa 0 103 4160 1 -375847418 -351087821 0 diff_test test aa 0 104 4200 1 -350954330 -336032189 0 diff_test test aa 0 105 4240 1 -335986701 -320030431 0 diff_test test aa 0 106 4280 1 -319973095 -301694957 0 diff_test test aa 0 107 4320 1 -301170081 -282142210 0 diff_test test aa 0 108 4360 1 -281510143 -264180445 0 diff_test test aa 0 109 4400 1 -262401336 -245774189 0 diff_test test aa 0 110 4440 1 -245765661 -229856738 0 diff_test test aa 0 111 4480 1 -229286684 -216088493 0 diff_test test aa 0 112 4520 1 -215229426 -197493005 0 diff_test test aa 0 113 4560 1 -197169773 -183149030 0 diff_test test aa 0 114 4600 1 -183114372 -163554241 0 diff_test test aa 0 115 4640 1 -163550917 -145768189 0 diff_test test aa 0 116 4680 1 -145162295 -126581271 0 diff_test test aa 0 117 4720 1 -126217299 -106614292 0 diff_test test aa 0 118 4760 1 -105630175 -88255525 0 diff_test test aa 0 119 4800 1 -87996461 -75474727 0 diff_test test aa 0 120 4840 1 -75388200 -60926832 0 diff_test test aa 0 121 4880 1 -60320014 -42544182 0 diff_test test aa 0 122 4920 1 -42437718 -24053506 0 diff_test test aa 0 123 4960 1 -22412609 -7803974 0 diff_test test aa 0 124 5000 1 -7635463 8189115 0 diff_test test aa 0 125 5040 1 8433131 23416958 0 diff_test test aa 0 126 5080 1 23860788 44309821 0 diff_test test aa 0 127 5120 1 44455188 59958145 0 diff_test test aa 0 128 5160 1 59973613 74938862 0 diff_test test aa 0 129 5200 1 75670581 93449447 0 diff_test test aa 0 130 5240 1 93537079 110449829 0 diff_test test aa 0 131 5280 1 111251967 128836017 0 diff_test test aa 0 132 5320 1 129933894 147932038 0 diff_test test aa 0 133 5360 1 147932783 162191304 0 diff_test test aa 0 134 5400 1 162632602 179700766 0 diff_test test aa 0 135 5440 1 180231004 197785546 0 diff_test test aa 0 136 5480 1 198002067 212955773 0 diff_test test aa 0 137 5520 1 213418719 232933466 0 diff_test test aa 0 138 5560 1 233086632 256602611 0 diff_test test aa 0 139 5600 1 256861806 272696902 0 diff_test test aa 0 140 5640 1 272908842 288108922 0 diff_test test aa 0 141 5680 1 288429741 305926482 0 diff_test test aa 0 142 5720 1 306273261 320247705 0 diff_test test aa 0 143 5760 1 320331946 335446229 0 diff_test test aa 0 144 5800 1 336093103 352973743 0 diff_test test aa 0 145 5840 1 353413317 370311659 0 diff_test test aa 0 146 5880 1 370400042 388390652 0 diff_test test aa 0 147 5920 1 388496106 402737846 0 diff_test test aa 0 148 5960 1 403665840 420247882 0 diff_test test aa 0 149 6000 1 420357707 433747475 0 diff_test test aa 0 150 6040 1 433905320 452191215 0 diff_test test aa 0 151 6080 1 452419946 469533154 0 diff_test test aa 0 152 6120 1 470587632 487599000 0 diff_test test aa 0 153 6160 1 487928082 509322973 0 diff_test test aa 0 154 6200 1 509505432 524664055 0 diff_test test aa 0 155 6240 1 525051576 542168690 0 diff_test test aa 0 156 6280 1 542754866 558778124 0 diff_test test aa 0 157 6320 1 559242867 575055607 0 diff_test test aa 0 158 6360 1 575483933 589717010 0 diff_test test aa 0 159 6400 1 590002801 612785772 0 diff_test test aa 0 160 6440 1 612867639 638949001 0 diff_test test aa 0 161 6480 1 639250894 656865082 0 diff_test test aa 0 162 6520 1 657149205 672107678 0 diff_test test aa 0 163 6560 1 672255668 691299492 0 diff_test test aa 0 164 6600 1 691671606 706395158 0 diff_test test aa 0 165 6640 1 707954912 720646930 0 diff_test test aa 0 166 6680 1 721267685 742971526 0 diff_test test aa 0 167 6720 1 744363380 761344755 0 diff_test test aa 0 168 6760 1 761535742 778154617 0 diff_test test aa 0 169 6800 1 778935275 795371926 0 diff_test test aa 0 170 6840 1 795705476 812699245 0 diff_test test aa 0 171 6880 1 812778420 828081353 0 diff_test test aa 0 172 6920 1 828130803 843647077 0 diff_test test aa 0 173 6960 1 844302425 864299198 0 diff_test test aa 0 174 7000 1 864596435 880564827 0 diff_test test aa 0 175 7040 1 881329524 896904527 0 diff_test test aa 0 176 7080 1 897724164 911714542 0 diff_test test aa 0 177 7120 1 912128931 929980022 0 diff_test test aa 0 178 7160 1 930639062 949871522 0 diff_test test aa 0 179 7200 1 950462793 968450896 0 diff_test test aa 0 180 7240 1 968712370 984283029 0 diff_test test aa 0 181 7280 1 984625348 1001571989 0 diff_test test aa 0 182 7320 1 1001828465 1019596550 0 diff_test test aa 0 183 7360 1 1020371304 1033211423 0 diff_test test aa 0 184 7400 1 1033931079 1050794595 0 diff_test test aa 0 185 7440 1 1051116945 1069465350 0 diff_test test aa 0 186 7480 1 1069779396 1082915340 0 diff_test test aa 0 187 7520 1 1083037893 1099990683 0 diff_test test aa 0 188 7560 1 1101927619 1113435934 0 diff_test test aa 0 189 7600 1 1113481880 1131020171 0 diff_test test aa 0 190 7640 1 1131251867 1149621352 0 diff_test test aa 0 191 7680 1 1150198403 1163772722 0 diff_test test aa 0 192 7720 1 1164217391 1183855777 0 diff_test test aa 0 193 7760 1 1184469597 1198332848 0 diff_test test aa 0 194 7800 1 1198623643 1213360112 0 diff_test test aa 0 195 7840 1 1214834255 1231776333 0 diff_test test aa 0 196 7880 1 1231871775 1243638052 0 diff_test test aa 0 197 7920 1 1244234001 1260742761 0 diff_test test aa 0 198 7960 1 1260794702 1282342949 0 diff_test test aa 0 199 8000 1 1282889134 1297635670 0 diff_test test aa 0 200 8040 1 1297730654 1316707880 0 diff_test test aa 0 201 8080 1 1316770670 1332460952 0 diff_test test aa 0 202 8120 1 1333385048 1348516293 0 diff_test test aa 0 203 8160 1 1348648696 1365688180 0 diff_test test aa 0 204 8200 1 1366222386 1386087724 0 diff_test test aa 0 205 8240 1 1386665106 1403025795 0 diff_test test aa 0 206 8280 1 1403380936 1422626567 0 diff_test test aa 0 207 8320 1 1423187316 1443005081 0 diff_test test aa 0 208 8360 1 1443092968 1459534029 0 diff_test test aa 0 209 8400 1 1459601125 1471853246 0 diff_test test aa 0 210 8440 1 1471863804 1488388522 0 diff_test test aa 0 211 8480 1 1488865495 1504695550 0 diff_test test aa 0 212 8520 1 1505309134 1522032642 0 diff_test test aa 0 213 8560 1 1522186427 1534648357 0 diff_test test aa 0 214 8600 1 1534853910 1549122083 0 diff_test test aa 0 215 8640 1 1549780484 1568943533 0 diff_test test aa 0 216 8680 1 1569676409 1587948078 0 diff_test test aa 0 217 8720 1 1588310095 1607510615 0 diff_test test aa 0 218 8760 1 1607615108 1620574513 0 diff_test test aa 0 219 8800 1 1621859146 1637330594 0 diff_test test aa 0 220 8840 1 1637508721 1656830413 0 diff_test test aa 0 221 8880 1 1656942301 1674020297 0 diff_test test aa 0 222 8920 1 1674250604 1694816094 0 diff_test test aa 0 223 8960 1 1695651236 1714494536 0 diff_test test aa 0 224 9000 1 1714499226 1727788038 0 diff_test test aa 0 225 9040 1 1727895556 1744288583 0 diff_test test aa 0 226 9080 1 1744769846 1757437509 0 diff_test test aa 0 227 9120 1 1758502754 1774596836 0 diff_test test aa 0 228 9160 1 1774679353 1793803584 0 diff_test test aa 0 229 9200 1 1794144379 1811996978 0 diff_test test aa 0 230 9240 1 1812018654 1830000719 0 diff_test test aa 0 231 9280 1 1830039885 1845692812 0 diff_test test aa 0 232 9320 1 1845976479 1865391845 0 diff_test test aa 0 233 9360 1 1865603058 1881846704 0 diff_test test aa 0 234 9400 1 1882281637 1896758750 0 diff_test test aa 0 235 9440 1 1897555337 1913896814 0 diff_test test aa 0 236 9480 1 1914493903 1927887180 0 diff_test test aa 0 237 9520 1 1928979031 1946270774 0 diff_test test aa 0 238 9560 1 1946580509 1963968244 0 diff_test test aa 0 239 9600 1 1965072954 1982673067 0 diff_test test aa 0 240 9640 1 1982680404 2001840051 0 diff_test test aa 0 241 9680 1 2001861811 2014740220 0 diff_test test aa 0 242 9720 1 2016032285 2034821030 0 diff_test test aa 0 243 9760 1 2035217666 2048639186 0 diff_test test aa 0 244 9800 1 2048848948 2062459389 0 diff_test test aa 0 245 9840 1 2062968201 2079654955 0 diff_test test aa 0 246 9880 1 2079895677 2097792073 0 diff_test test aa 0 247 9920 1 2098411220 2118519785 0 diff_test test aa 0 248 9960 1 2119020737 2133324029 0 diff_test test aa 0 249 10000 1 2133406017 2147121894 0 diff_test test aa 1 0 40 1 -2147334946 -2130828599 0 diff_test test aa 1 1 80 1 -2128575805 -2114374744 0 diff_test test aa 1 2 120 1 -2114183094 -2098566411 0 diff_test test aa 1 3 160 1 -2098301170 -2075696367 0 diff_test test aa 1 4 200 1 -2075213103 -2063312509 0 diff_test test aa 1 5 240 1 -2063066903 -2046893603 0 diff_test test aa 1 6 280 1 -2046739026 -2034343887 0 diff_test test aa 1 7 320 1 -2034289271 -2014843088 0 diff_test test aa 1 8 360 1 -2014490597 -1998369135 0 diff_test test aa 1 9 400 1 -1997384893 -1983458853 0 diff_test test aa 1 10 440 1 -1983445557 -1968356425 0 diff_test test aa 1 11 480 1 -1968330727 -1955158992 0 diff_test test aa 1 12 520 1 -1954395497 -1936533468 0 diff_test test aa 1 13 560 1 -1936506669 -1914883690 0 diff_test test aa 1 14 600 1 -1914873359 -1899761971 0 diff_test test aa 1 15 640 1 -1899555042 -1878414295 0 diff_test test aa 1 16 680 1 -1878175204 -1863313630 0 diff_test test aa 1 17 720 1 -1863286655 -1845637985 0 diff_test test aa 1 18 760 1 -1845378911 -1826615118 0 diff_test test aa 1 19 800 1 -1826265647 -1811765441 0 diff_test test aa 1 20 840 1 -1811669167 -1791207132 0 diff_test test aa 1 21 880 1 -1791060797 -1771228470 0 diff_test test aa 1 22 920 1 -1771021617 -1752902096 0 diff_test test aa 1 23 960 1 -1752739259 -1739729334 0 diff_test test aa 1 24 1000 1 -1739456506 -1724014206 0 diff_test test aa 1 25 1040 1 -1723980295 -1709899210 0 diff_test test aa 1 26 1080 1 -1708509614 -1694584315 0 diff_test test aa 1 27 1120 1 -1694453393 -1674829305 0 diff_test test aa 1 28 1160 1 -1674695301 -1659474492 0 diff_test test aa 1 29 1200 1 -1659407136 -1642586704 0 diff_test test aa 1 30 1240 1 -1641908791 -1626807742 0 diff_test test aa 1 31 1280 1 -1626108401 -1610425754 0 diff_test test aa 1 32 1320 1 -1610376253 -1591973433 0 diff_test test aa 1 33 1360 1 -1591892991 -1576520135 0 diff_test test aa 1 34 1400 1 -1576264982 -1561650466 0 diff_test test aa 1 35 1440 1 -1561196780 -1543350078 0 diff_test test aa 1 36 1480 1 -1543077056 -1521858447 0 diff_test test aa 1 37 1520 1 -1520644356 -1501409721 0 diff_test test aa 1 38 1560 1 -1500405482 -1481388694 0 diff_test test aa 1 39 1600 1 -1481185620 -1459114161 0 diff_test test aa 1 40 1640 1 -1458771638 -1440092399 0 diff_test test aa 1 41 1680 1 -1439963603 -1423152394 0 diff_test test aa 1 42 1720 1 -1423024074 -1407501161 0 diff_test test aa 1 43 1760 1 -1406470639 -1388557256 0 diff_test test aa 1 44 1800 1 -1388177209 -1375321411 0 diff_test test aa 1 45 1840 1 -1375050277 -1363748201 0 diff_test test aa 1 46 1880 1 -1363320206 -1345281763 0 diff_test test aa 1 47 1920 1 -1344877231 -1328149572 0 diff_test test aa 1 48 1960 1 -1327897243 -1314294554 0 diff_test test aa 1 49 2000 1 -1313924924 -1295953735 0 diff_test test aa 1 50 2040 1 -1294099536 -1271914959 0 diff_test test aa 1 51 2080 1 -1271901769 -1254396961 0 diff_test test aa 1 52 2120 1 -1254139095 -1237137377 0 diff_test test aa 1 53 2160 1 -1236419297 -1220289004 0 diff_test test aa 1 54 2200 1 -1219974634 -1200548969 0 diff_test test aa 1 55 2240 1 -1199663860 -1183546114 0 diff_test test aa 1 56 2280 1 -1182375484 -1164007572 0 diff_test test aa 1 57 2320 1 -1163394000 -1147233278 0 diff_test test aa 1 58 2360 1 -1147078689 -1130499974 0 diff_test test aa 1 59 2400 1 -1130458985 -1116413914 0 diff_test test aa 1 60 2440 1 -1115874147 -1099438049 0 diff_test test aa 1 61 2480 1 -1099029848 -1081138947 0 diff_test test aa 1 62 2520 1 -1080911116 -1066545384 0 diff_test test aa 1 63 2560 1 -1066467172 -1052315528 0 diff_test test aa 1 64 2600 1 -1051960570 -1025486996 0 diff_test test aa 1 65 2640 1 -1025441319 -1008952615 0 diff_test test aa 1 66 2680 1 -1008140838 -994117470 0 diff_test test aa 1 67 2720 1 -993751925 -974369712 0 diff_test test aa 1 68 2760 1 -974020794 -957822024 0 diff_test test aa 1 69 2800 1 -957664316 -944094209 0 diff_test test aa 1 70 2840 1 -943495201 -927650822 0 diff_test test aa 1 71 2880 1 -927280052 -909421445 0 diff_test test aa 1 72 2920 1 -909322442 -890878015 0 diff_test test aa 1 73 2960 1 -890760706 -876066109 0 diff_test test aa 1 74 3000 1 -875639503 -861927167 0 diff_test test aa 1 75 3040 1 -861855722 -844458781 0 diff_test test aa 1 76 3080 1 -843492540 -829638141 0 diff_test test aa 1 77 3120 1 -829449645 -812754095 0 diff_test test aa 1 78 3160 1 -812488711 -792953971 0 diff_test test aa 1 79 3200 1 -792791900 -776594561 0 diff_test test aa 1 80 3240 1 -776150906 -757738156 0 diff_test test aa 1 81 3280 1 -757727311 -738301899 0 diff_test test aa 1 82 3320 1 -737986180 -723828223 0 diff_test test aa 1 83 3360 1 -722666781 -703566598 0 diff_test test aa 1 84 3400 1 -703538363 -689453433 0 diff_test test aa 1 85 3440 1 -688969778 -674012120 0 diff_test test aa 1 86 3480 1 -673857341 -659010828 0 diff_test test aa 1 87 3520 1 -658986208 -641600839 0 diff_test test aa 1 88 3560 1 -640968798 -621999948 0 diff_test test aa 1 89 3600 1 -621533564 -606381979 0 diff_test test aa 1 90 3640 1 -605910060 -587016207 0 diff_test test aa 1 91 3680 1 -586969398 -574869516 0 diff_test test aa 1 92 3720 1 -574764467 -550850080 0 diff_test test aa 1 93 3760 1 -550739891 -530650374 0 diff_test test aa 1 94 3800 1 -530418886 -514589912 0 diff_test test aa 1 95 3840 1 -514356741 -498266807 0 diff_test test aa 1 96 3880 1 -497483528 -480066301 0 diff_test test aa 1 97 3920 1 -479659343 -462672985 0 diff_test test aa 1 98 3960 1 -462583589 -445798925 0 diff_test test aa 1 99 4000 1 -444379592 -429656822 0 diff_test test aa 1 100 4040 1 -429566296 -414436349 0 diff_test test aa 1 101 4080 1 -414188846 -395753243 0 diff_test test aa 1 102 4120 1 -394739010 -375911153 0 diff_test test aa 1 103 4160 1 -375847418 -351087821 0 diff_test test aa 1 104 4200 1 -350954330 -336032189 0 diff_test test aa 1 105 4240 1 -335986701 -320030431 0 diff_test test aa 1 106 4280 1 -319973095 -301694957 0 diff_test test aa 1 107 4320 1 -301170081 -282142210 0 diff_test test aa 1 108 4360 1 -281510143 -264180445 0 diff_test test aa 1 109 4400 1 -262401336 -245774189 0 diff_test test aa 1 110 4440 1 -245765661 -229856738 0 diff_test test aa 1 111 4480 1 -229286684 -216088493 0 diff_test test aa 1 112 4520 1 -215229426 -197493005 0 diff_test test aa 1 113 4560 1 -197169773 -183149030 0 diff_test test aa 1 114 4600 1 -183114372 -163554241 0 diff_test test aa 1 115 4640 1 -163550917 -145768189 0 diff_test test aa 1 116 4680 1 -145162295 -126581271 0 diff_test test aa 1 117 4720 1 -126217299 -106614292 0 diff_test test aa 1 118 4760 1 -105630175 -88255525 0 diff_test test aa 1 119 4800 1 -87996461 -75474727 0 diff_test test aa 1 120 4840 1 -75388200 -60926832 0 diff_test test aa 1 121 4880 1 -60320014 -42544182 0 diff_test test aa 1 122 4920 1 -42437718 -24053506 0 diff_test test aa 1 123 4960 1 -22412609 -7803974 0 diff_test test aa 1 124 5000 1 -7635463 8189115 0 diff_test test aa 1 125 5040 1 8433131 23416958 0 diff_test test aa 1 126 5080 1 23860788 44309821 0 diff_test test aa 1 127 5120 1 44455188 59958145 0 diff_test test aa 1 128 5160 1 59973613 74938862 0 diff_test test aa 1 129 5200 1 75670581 93449447 0 diff_test test aa 1 130 5240 1 93537079 110449829 0 diff_test test aa 1 131 5280 1 111251967 128836017 0 diff_test test aa 1 132 5320 1 129933894 147932038 0 diff_test test aa 1 133 5360 1 147932783 162191304 0 diff_test test aa 1 134 5400 1 162632602 179700766 0 diff_test test aa 1 135 5440 1 180231004 197785546 0 diff_test test aa 1 136 5480 1 198002067 212955773 0 diff_test test aa 1 137 5520 1 213418719 232933466 0 diff_test test aa 1 138 5560 1 233086632 256602611 0 diff_test test aa 1 139 5600 1 256861806 272696902 0 diff_test test aa 1 140 5640 1 272908842 288108922 0 diff_test test aa 1 141 5680 1 288429741 305926482 0 diff_test test aa 1 142 5720 1 306273261 320247705 0 diff_test test aa 1 143 5760 1 320331946 335446229 0 diff_test test aa 1 144 5800 1 336093103 352973743 0 diff_test test aa 1 145 5840 1 353413317 370311659 0 diff_test test aa 1 146 5880 1 370400042 388390652 0 diff_test test aa 1 147 5920 1 388496106 402737846 0 diff_test test aa 1 148 5960 1 403665840 420247882 0 diff_test test aa 1 149 6000 1 420357707 433747475 0 diff_test test aa 1 150 6040 1 433905320 452191215 0 diff_test test aa 1 151 6080 1 452419946 469533154 0 diff_test test aa 1 152 6120 1 470587632 487599000 0 diff_test test aa 1 153 6160 1 487928082 509322973 0 diff_test test aa 1 154 6200 1 509505432 524664055 0 diff_test test aa 1 155 6240 1 525051576 542168690 0 diff_test test aa 1 156 6280 1 542754866 558778124 0 diff_test test aa 1 157 6320 1 559242867 575055607 0 diff_test test aa 1 158 6360 1 575483933 589717010 0 diff_test test aa 1 159 6400 1 590002801 612785772 0 diff_test test aa 1 160 6440 1 612867639 638949001 0 diff_test test aa 1 161 6480 1 639250894 656865082 0 diff_test test aa 1 162 6520 1 657149205 672107678 0 diff_test test aa 1 163 6560 1 672255668 691299492 0 diff_test test aa 1 164 6600 1 691671606 706395158 0 diff_test test aa 1 165 6640 1 707954912 720646930 0 diff_test test aa 1 166 6680 1 721267685 742971526 0 diff_test test aa 1 167 6720 1 744363380 761344755 0 diff_test test aa 1 168 6760 1 761535742 778154617 0 diff_test test aa 1 169 6800 1 778935275 795371926 0 diff_test test aa 1 170 6840 1 795705476 812699245 0 diff_test test aa 1 171 6880 1 812778420 828081353 0 diff_test test aa 1 172 6920 1 828130803 843647077 0 diff_test test aa 1 173 6960 1 844302425 864299198 0 diff_test test aa 1 174 7000 1 864596435 880564827 0 diff_test test aa 1 175 7040 1 881329524 896904527 0 diff_test test aa 1 176 7080 1 897724164 911714542 0 diff_test test aa 1 177 7120 1 912128931 929980022 0 diff_test test aa 1 178 7160 1 930639062 949871522 0 diff_test test aa 1 179 7200 1 950462793 968450896 0 diff_test test aa 1 180 7240 1 968712370 984283029 0 diff_test test aa 1 181 7280 1 984625348 1001571989 0 diff_test test aa 1 182 7320 1 1001828465 1019596550 0 diff_test test aa 1 183 7360 1 1020371304 1033211423 0 diff_test test aa 1 184 7400 1 1033931079 1050794595 0 diff_test test aa 1 185 7440 1 1051116945 1069465350 0 diff_test test aa 1 186 7480 1 1069779396 1082915340 0 diff_test test aa 1 187 7520 1 1083037893 1099990683 0 diff_test test aa 1 188 7560 1 1101927619 1113435934 0 diff_test test aa 1 189 7600 1 1113481880 1131020171 0 diff_test test aa 1 190 7640 1 1131251867 1149621352 0 diff_test test aa 1 191 7680 1 1150198403 1163772722 0 diff_test test aa 1 192 7720 1 1164217391 1183855777 0 diff_test test aa 1 193 7760 1 1184469597 1198332848 0 diff_test test aa 1 194 7800 1 1198623643 1213360112 0 diff_test test aa 1 195 7840 1 1214834255 1231776333 0 diff_test test aa 1 196 7880 1 1231871775 1243638052 0 diff_test test aa 1 197 7920 1 1244234001 1260742761 0 diff_test test aa 1 198 7960 1 1260794702 1282342949 0 diff_test test aa 1 199 8000 1 1282889134 1297635670 0 diff_test test aa 1 200 8040 1 1297730654 1316707880 0 diff_test test aa 1 201 8080 1 1316770670 1332460952 0 diff_test test aa 1 202 8120 1 1333385048 1348516293 0 diff_test test aa 1 203 8160 1 1348648696 1365688180 0 diff_test test aa 1 204 8200 1 1366222386 1386087724 0 diff_test test aa 1 205 8240 1 1386665106 1403025795 0 diff_test test aa 1 206 8280 1 1403380936 1422626567 0 diff_test test aa 1 207 8320 1 1423187316 1443005081 0 diff_test test aa 1 208 8360 1 1443092968 1459534029 0 diff_test test aa 1 209 8400 1 1459601125 1471853246 0 diff_test test aa 1 210 8440 1 1471863804 1488388522 0 diff_test test aa 1 211 8480 1 1488865495 1504695550 0 diff_test test aa 1 212 8520 1 1505309134 1522032642 0 diff_test test aa 1 213 8560 1 1522186427 1534648357 0 diff_test test aa 1 214 8600 1 1534853910 1549122083 0 diff_test test aa 1 215 8640 1 1549780484 1568943533 0 diff_test test aa 1 216 8680 1 1569676409 1587948078 0 diff_test test aa 1 217 8720 1 1588310095 1607510615 0 diff_test test aa 1 218 8760 1 1607615108 1620574513 0 diff_test test aa 1 219 8800 1 1621859146 1637330594 0 diff_test test aa 1 220 8840 1 1637508721 1656830413 0 diff_test test aa 1 221 8880 1 1656942301 1674020297 0 diff_test test aa 1 222 8920 1 1674250604 1694816094 0 diff_test test aa 1 223 8960 1 1695651236 1714494536 0 diff_test test aa 1 224 9000 1 1714499226 1727788038 0 diff_test test aa 1 225 9040 1 1727895556 1744288583 0 diff_test test aa 1 226 9080 1 1744769846 1757437509 0 diff_test test aa 1 227 9120 1 1758502754 1774596836 0 diff_test test aa 1 228 9160 1 1774679353 1793803584 0 diff_test test aa 1 229 9200 1 1794144379 1811996978 0 diff_test test aa 1 230 9240 1 1812018654 1830000719 0 diff_test test aa 1 231 9280 1 1830039885 1845692812 0 diff_test test aa 1 232 9320 1 1845976479 1865391845 0 diff_test test aa 1 233 9360 1 1865603058 1881846704 0 diff_test test aa 1 234 9400 1 1882281637 1896758750 0 diff_test test aa 1 235 9440 1 1897555337 1913896814 0 diff_test test aa 1 236 9480 1 1914493903 1927887180 0 diff_test test aa 1 237 9520 1 1928979031 1946270774 0 diff_test test aa 1 238 9560 1 1946580509 1963968244 0 diff_test test aa 1 239 9600 1 1965072954 1982673067 0 diff_test test aa 1 240 9640 1 1982680404 2001840051 0 diff_test test aa 1 241 9680 1 2001861811 2014740220 0 diff_test test aa 1 242 9720 1 2016032285 2034821030 0 diff_test test aa 1 243 9760 1 2035217666 2048639186 0 diff_test test aa 1 244 9800 1 2048848948 2062459389 0 diff_test test aa 1 245 9840 1 2062968201 2079654955 0 diff_test test aa 1 246 9880 1 2079895677 2097792073 0 diff_test test aa 1 247 9920 1 2098411220 2118519785 0 diff_test test aa 1 248 9960 1 2119020737 2133324029 0 diff_test test aa 1 249 10000 1 2133406017 2147121894 0 + sync_diff_inspector --config=./config_base_tidb.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + check_not_contains 'split range by random' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/diff.output /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + echo 'test '\''exclude-tables'\'' config' test 'exclude-tables' config + mysql -uroot -h 127.0.0.1 -P 4000 -e 'create table if not exists diff_test.should_not_compare (id int)' + sync_diff_inspector --config=./config_base_tidb.toml + check_not_contains '[table=should_not_compare]' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/diff.log /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + sed 's/"127.0.0.1"#MYSQL_HOST/"127.0.0.1"/g' ./config_base_mysql.toml + sed s/3306#MYSQL_PORT/3306/g + sync_diff_inspector --config=./config_base_mysql_.toml A total of 1 tables need to be compared Comparing the table structure of `diff_test`.`test` ... equivalent Comparing the table data of `diff_test`.`test` ... _____________________________________________________________________________ Progress [>------------------------------------------------------------] 0% 0/0 Comparing the table data of `diff_test`.`test` ... equivalent _____________________________________________________________________________ Progress [============================================================>] 100% 0/0 Progress [============================================================>] 100% 0/0 A total of 1 table have been compared and all are equal. You can view the comparison details through '/tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log' + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + for script in './*/run.sh' +++ dirname ./checkpoint/run.sh ++ basename ./checkpoint + test_name=checkpoint + echo --------------------------------------- --------------------------------------- + echo 'Running test ./checkpoint/run.sh...' Running test ./checkpoint/run.sh... + echo --------------------------------------- --------------------------------------- + sh ./checkpoint/run.sh ++ dirname ./checkpoint/run.sh + cd ./checkpoint + OUT_DIR=/tmp/sync_diff_inspector_test/sync_diff_inspector/output + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output + mkdir -p /tmp/sync_diff_inspector_test/sync_diff_inspector/output + sed 's/"127.0.0.1"#MYSQL_HOST/"127.0.0.1"/g' ./config_base.toml + sed s/3306#MYSQL_PORT/3306/g + echo '================test bucket checkpoint=================' ================test bucket checkpoint================= + echo '---------1. chunk is in the last of the bucket---------' ---------1. chunk is in the last of the bucket--------- + export 'GO_FAILPOINTS=github.com/pingcap/tiflow/sync_diff_inspector/splitter/check-one-bucket=return();github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return();github.com/pingcap/tiflow/sync_diff_inspector/diff/wait-for-checkpoint=return()' + GO_FAILPOINTS='github.com/pingcap/tiflow/sync_diff_inspector/splitter/check-one-bucket=return();github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return();github.com/pingcap/tiflow/sync_diff_inspector/diff/wait-for-checkpoint=return()' + sync_diff_inspector --config=./config.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log ++ grep print-chunk-info /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log ++ awk -F upperBounds= '{print $2}' ++ sed 's/[]["]//g' ++ sort -n ++ awk 'END {print}' + last_chunk_info='39 indexCode=0:0-0:3:4' + echo '39 indexCode=0:0-0:3:4' 39 indexCode=0:0-0:3:4 ++ echo 39 indexCode=0:0-0:3:4 ++ awk -F ' ' '{print $1}' + last_chunk_bound=39 + echo 39 39 ++ echo 39 indexCode=0:0-0:3:4 ++ awk -F = '{print $2}' + last_chunk_index=0:0-0:3:4 + echo 0:0-0:3:4 0:0-0:3:4 + OLD_IFS=' ' + IFS=: + last_chunk_index_array=($last_chunk_index) + IFS=' ' + for s in '${last_chunk_index_array[@]}' + echo 0 0 + for s in '${last_chunk_index_array[@]}' + echo 0-0 0-0 + for s in '${last_chunk_index_array[@]}' + echo 3 3 + for s in '${last_chunk_index_array[@]}' + echo 4 4 + [[ 4 -eq 4 ]] ++ echo 0-0 ++ awk -F - '{print $2}' + bucket_index_right=1 + echo 1 1 + rm -f /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + export 'GO_FAILPOINTS=github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return()' + GO_FAILPOINTS='github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return()' + sync_diff_inspector --config=./config.toml ++ grep print-chunk-info /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log ++ awk -F lowerBounds= '{print $2}' ++ sed 's/[]["]//g' ++ sort -n ++ awk NR==1 + first_chunk_info='39 upperBounds=50 indexCode=0:1-1:0:4' + echo 39 upperBounds=50 indexCode=0:1-1:0:4 + awk -F = '{print $1}' + cat /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_bound 39 upperBounds + echo 39 upperBounds=50 indexCode=0:1-1:0:4 + awk -F = '{print $3}' + cat /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_index 0:1-1:0:4 + check_contains 39 /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_bound + check_contains_regex .:1-.:0:. /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_index + echo '--------2. chunk is in the middle of the bucket--------' --------2. chunk is in the middle of the bucket-------- + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output + mkdir -p /tmp/sync_diff_inspector_test/sync_diff_inspector/output + export 'GO_FAILPOINTS=github.com/pingcap/tiflow/sync_diff_inspector/splitter/check-one-bucket=return();github.com/pingcap/tiflow/sync_diff_inspector/splitter/ignore-last-n-chunk-in-bucket=return(1);github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return();github.com/pingcap/tiflow/sync_diff_inspector/diff/wait-for-checkpoint=return()' + GO_FAILPOINTS='github.com/pingcap/tiflow/sync_diff_inspector/splitter/check-one-bucket=return();github.com/pingcap/tiflow/sync_diff_inspector/splitter/ignore-last-n-chunk-in-bucket=return(1);github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return();github.com/pingcap/tiflow/sync_diff_inspector/diff/wait-for-checkpoint=return()' + sync_diff_inspector --config=./config.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log ++ grep print-chunk-info /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log ++ awk -F upperBounds= '{print $2}' ++ sed 's/[]["]//g' ++ sort -n ++ awk 'END {print}' + last_chunk_info='26 indexCode=0:0-0:2:4' + echo '26 indexCode=0:0-0:2:4' 26 indexCode=0:0-0:2:4 ++ echo 26 indexCode=0:0-0:2:4 ++ awk -F ' ' '{print $1}' + last_chunk_bound=26 + echo 26 26 ++ echo 26 indexCode=0:0-0:2:4 ++ awk -F = '{print $2}' + last_chunk_index=0:0-0:2:4 + echo 0:0-0:2:4 0:0-0:2:4 + OLD_IFS=' ' + IFS=: + last_chunk_index_array=($last_chunk_index) + IFS=' ' + for s in '${last_chunk_index_array[@]}' + echo 0 0 + for s in '${last_chunk_index_array[@]}' + echo 0-0 0-0 + for s in '${last_chunk_index_array[@]}' + echo 2 2 + for s in '${last_chunk_index_array[@]}' + echo 4 4 + [[ 4 -eq 4 ]] ++ echo 0-0 ++ awk -F - '{print $1}' + bucket_index_left=0 ++ echo 0-0 ++ awk -F - '{print $2}' + bucket_index_right=0 + echo 0-0 0-0 + rm -f /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + export 'GO_FAILPOINTS=github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return()' + GO_FAILPOINTS='github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return()' + sync_diff_inspector --config=./config.toml ++ grep print-chunk-info /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log ++ awk -F lowerBounds= '{print $2}' ++ sed 's/[]["]//g' ++ sort -n ++ awk NR==1 + first_chunk_info='26 upperBounds=39 indexCode=0:0-0:3:4' + echo 26 upperBounds=39 indexCode=0:0-0:3:4 + awk -F = '{print $1}' + cat /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_bound 26 upperBounds + echo 26 upperBounds=39 indexCode=0:0-0:3:4 + awk -F = '{print $3}' + cat /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_index 0:0-0:3:4 + check_contains 26 /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_bound + check_contains_regex .:0-0:3:4 /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_index + sed 's/"127.0.0.1"#MYSQL_HOST/"127.0.0.1"/g' ./config_base_rand.toml + sed s/3306#MYSQL_PORT/3306/g + echo '================test random checkpoint=================' ================test random checkpoint================= + echo '--------------1. chunk is in the middle----------------' --------------1. chunk is in the middle---------------- + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output + mkdir -p /tmp/sync_diff_inspector_test/sync_diff_inspector/output + export 'GO_FAILPOINTS=github.com/pingcap/tiflow/sync_diff_inspector/splitter/ignore-last-n-chunk-in-bucket=return(1);github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return();github.com/pingcap/tiflow/sync_diff_inspector/diff/wait-for-checkpoint=return()' + GO_FAILPOINTS='github.com/pingcap/tiflow/sync_diff_inspector/splitter/ignore-last-n-chunk-in-bucket=return(1);github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return();github.com/pingcap/tiflow/sync_diff_inspector/diff/wait-for-checkpoint=return()' + sync_diff_inspector --config=./config.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log ++ grep print-chunk-info /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log ++ awk -F upperBounds= '{print $2}' ++ sed 's/[]["]//g' ++ sort -n ++ awk 'END {print}' + last_chunk_info='9359 indexCode=0:0-0:18:20' + echo '9359 indexCode=0:0-0:18:20' 9359 indexCode=0:0-0:18:20 ++ echo 9359 indexCode=0:0-0:18:20 ++ awk -F ' ' '{print $1}' + last_chunk_bound=9359 + echo 9359 9359 ++ echo 9359 indexCode=0:0-0:18:20 ++ awk -F = '{print $2}' + last_chunk_index=0:0-0:18:20 + echo 0:0-0:18:20 0:0-0:18:20 + OLD_IFS=' ' + IFS=: + last_chunk_index_array=($last_chunk_index) + IFS=' ' + for s in '${last_chunk_index_array[@]}' + echo 0 0 + for s in '${last_chunk_index_array[@]}' + echo 0-0 0-0 + for s in '${last_chunk_index_array[@]}' + echo 18 18 + for s in '${last_chunk_index_array[@]}' + echo 20 20 + [[ 20 -eq 20 ]] + rm -f /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + export 'GO_FAILPOINTS=github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return()' + GO_FAILPOINTS='github.com/pingcap/tiflow/sync_diff_inspector/splitter/print-chunk-info=return()' + sync_diff_inspector --config=./config.toml ++ grep print-chunk-info /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log ++ awk -F lowerBounds= '{print $2}' ++ sed 's/[]["]//g' ++ sort -n ++ awk NR==1 + first_chunk_info='9359 upperBounds= indexCode=0:0-0:19:20' + echo 9359 upperBounds= indexCode=0:0-0:19:20 + awk -F = '{print $1}' + cat /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_bound 9359 upperBounds + echo 9359 upperBounds= indexCode=0:0-0:19:20 + awk -F = '{print $3}' + cat /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_index 0:0-0:19:20 + check_contains 9359 /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_bound + check_contains_regex .:0-0:19:20 /tmp/sync_diff_inspector_test/sync_diff_inspector/output/first_chunk_index + sed 's/"127.0.0.1"#MYSQL_HOST/"127.0.0.1"/g' ./config_base_continous.toml + sed s/3306#MYSQL_PORT/3306/g + echo '================test checkpoint continous=================' ================test checkpoint continous================= + mysql -uroot -h 127.0.0.1 -P 4000 -e 'create table IF NOT EXISTS diff_test.ttt(a int, aa int, primary key(a), key(aa));' + mysql -uroot -h 127.0.0.1 -P 3306 -e 'create table IF NOT EXISTS diff_test.ttt(a int, b int, primary key(a), key(b));' + export 'GO_FAILPOINTS=github.com/pingcap/tiflow/sync_diff_inspector/diff/wait-for-checkpoint=return()' + GO_FAILPOINTS='github.com/pingcap/tiflow/sync_diff_inspector/diff/wait-for-checkpoint=return()' + sync_diff_inspector --config=./config.toml + true + grep 'save checkpoint' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + awk 'END {print}' + check_not_contains 'has-upper\":true' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint_info + export GO_FAILPOINTS= + GO_FAILPOINTS= + for script in './*/run.sh' +++ dirname ./expression/run.sh ++ basename ./expression + test_name=expression + echo --------------------------------------- --------------------------------------- + echo 'Running test ./expression/run.sh...' Running test ./expression/run.sh... + echo --------------------------------------- --------------------------------------- + sh ./expression/run.sh ++ dirname ./expression/run.sh + cd ./expression + OUT_DIR=/tmp/sync_diff_inspector_test/sync_diff_inspector/output + FIX_DIR=/tmp/sync_diff_inspector_test/sync_diff_inspector/fixsql + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/fixsql + mkdir -p /tmp/sync_diff_inspector_test/sync_diff_inspector/output + mkdir -p /tmp/sync_diff_inspector_test/sync_diff_inspector/fixsql + for port in 4000 4001 + mysql -uroot -h 127.0.0.1 -P 4000 -e 'create database if not exists expression_test;' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'create table expression_test.diff(`a``;sad` int, id int);' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'alter table expression_test.diff add index i1((`a``;sad` + 1 + `a``;sad`));' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'insert into expression_test.diff values (1,1),(2,2),(3,3);' + for port in 4000 4001 + mysql -uroot -h 127.0.0.1 -P 4001 -e 'create database if not exists expression_test;' + mysql -uroot -h 127.0.0.1 -P 4001 -e 'create table expression_test.diff(`a``;sad` int, id int);' + mysql -uroot -h 127.0.0.1 -P 4001 -e 'alter table expression_test.diff add index i1((`a``;sad` + 1 + `a``;sad`));' + mysql -uroot -h 127.0.0.1 -P 4001 -e 'insert into expression_test.diff values (1,1),(2,2),(3,3);' + echo 'check result should be pass' check result should be pass + sync_diff_inspector --config=./config.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/expression_diff.output /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + for script in './*/run.sh' +++ dirname ./json/run.sh ++ basename ./json + test_name=json + echo --------------------------------------- --------------------------------------- + echo 'Running test ./json/run.sh...' Running test ./json/run.sh... + echo --------------------------------------- --------------------------------------- + sh ./json/run.sh 10c10 < export-fix-sql = true --- > export-fix-sql = false compare json tables, check result should be pass compare json tables without fixsql, check result should be pass update data to make it different, and data should not be equal update data to make it different, and downstream json data is NULL + for script in './*/run.sh' +++ dirname ./shard/run.sh ++ basename ./shard + test_name=shard + echo --------------------------------------- --------------------------------------- + echo 'Running test ./shard/run.sh...' Running test ./shard/run.sh... + echo --------------------------------------- --------------------------------------- + sh ./shard/run.sh generate data to sharding tables compare sharding tables with one table in downstream, check result should be pass update data in one shard table, and data should not be equal check the router for shard test router 1: normal rule test router 2: only schema rule test router 3: other rule test router 4: no rule test router 5: regex rule shard test passed + for script in './*/run.sh' +++ dirname ./snapshot/run.sh ++ basename ./snapshot + test_name=snapshot + echo --------------------------------------- --------------------------------------- + echo 'Running test ./snapshot/run.sh...' Running test ./snapshot/run.sh... + echo --------------------------------------- --------------------------------------- + sh ./snapshot/run.sh get ts 457113955987619843 delete one data, diff should not passed use snapshot compare data, test sql mode by the way, will auto discover ANSI_QUOTES thus pass Variable_name Value sql_mode ANSI_QUOTES Table Create Table test CREATE TABLE "test" (\n "table" int NOT NULL,\n "aa" int DEFAULT NULL,\n "b" varchar(10) DEFAULT NULL,\n "c" float DEFAULT NULL,\n "d" datetime DEFAULT NULL,\n PRIMARY KEY ("table") /*T![clustered_index] CLUSTERED */,\n KEY "aa" ("aa")\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin use snapshot compare data, data should be equal A total of 1 tables need to be compared Comparing the table structure of `diff_test`.`test` ... equivalent Comparing the table data of `diff_test`.`test` ... _____________________________________________________________________________ Progress [>------------------------------------------------------------] 0% 0/0 Comparing the table data of `diff_test`.`test` ... equivalent _____________________________________________________________________________ Progress [============================================================>] 100% 0/0 Progress [============================================================>] 100% 0/0 A total of 1 table have been compared and all are equal. You can view the comparison details through '/tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log' execute fix.sql and use base config, and then compare data, data should be equal snapshot test passed + for script in './*/run.sh' +++ dirname ./table_config/run.sh ++ basename ./table_config + test_name=table_config + echo --------------------------------------- --------------------------------------- + echo 'Running test ./table_config/run.sh...' Running test ./table_config/run.sh... + echo --------------------------------------- --------------------------------------- + sh ./table_config/run.sh update data in column b (WHERE `table` >= 10 AND `table` <= 200), data should not be equal ignore check column b, check result should be pass set range a < 10 OR a > 200, check result should be pass execute fix.sql and use base config, and then compare data, data should be equal table_config test passed + for script in './*/run.sh' +++ dirname ./table_skip/run.sh ++ basename ./table_skip + test_name=table_skip + echo --------------------------------------- --------------------------------------- + echo 'Running test ./table_skip/run.sh...' Running test ./table_skip/run.sh... + echo --------------------------------------- --------------------------------------- + sh ./table_skip/run.sh ++ dirname ./table_skip/run.sh + cd ./table_skip + OUT_DIR=/tmp/sync_diff_inspector_test/sync_diff_inspector/output + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output + mkdir -p /tmp/sync_diff_inspector_test/sync_diff_inspector/output + mysql -uroot -h 127.0.0.1 -P 3306 + mysql -uroot -h 127.0.0.1 -P 4000 + sed 's/"127.0.0.1"#MYSQL_HOST/"127.0.0.1"/g' ./config_base.toml + sed s/3306#MYSQL_PORT/3306/g + echo 'compare tables, check result should be pass' compare tables, check result should be pass + sync_diff_inspector --config=./config.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + echo 'make some tables exist only upstream or downstream' make some tables exist only upstream or downstream + mysql -uroot -h 127.0.0.1 -P 3306 -e 'create table skip_test.t2 (a int, b int, primary key(a));' + mysql -uroot -h 127.0.0.1 -P 3306 -e 'insert into skip_test.t2 values (3,3);' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'create table skip_test.t3 (a int, b int, primary key(a));' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'insert into skip_test.t3 values (1,1);' + sync_diff_inspector --config=./config.toml + check_contains 'check pass' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + check_contains 'Comparing the table data of `skip_test`.`t2` ...skipped' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + check_contains 'Comparing the table data of `skip_test`.`t3` ...skipped' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + check_contains 'The data of `skip_test`.`t2` does not exist in downstream database' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + check_contains 'The data of `skip_test`.`t3` does not exist in upstream database' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + check_contains '| TABLE | RESULT | STRUCTURE EQUALITY | DATA DIFF ROWS | UPCOUNT | DOWNCOUNT |' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt + check_contains '| `skip_test`.`t2` | skipped | false | +1/-0 | 1 | 0 |' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt + check_contains '| `skip_test`.`t3` | skipped | false | +0/-1 | 0 | 1 |' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + echo 'make some table data not equal' make some table data not equal + mysql -uroot -h 127.0.0.1 -P 4000 -e 'insert into skip_test.t1 values (4,4);' + sync_diff_inspector --config=./config.toml + true + check_contains 'check failed' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + check_contains '| `skip_test`.`t1` | succeed | true | +0/-1 | 1 | 2 |' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + echo 'make some table structure not equal' make some table structure not equal + mysql -uroot -h 127.0.0.1 -P 3306 -e 'create table skip_test.t4 (a int, b int, c int,primary key(a));' + mysql -uroot -h 127.0.0.1 -P 3306 -e 'insert into skip_test.t4 values (1,1,1);' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'create table skip_test.t4 (a int, b int, primary key(a));' + sync_diff_inspector --config=./config.toml + true + check_contains 'check failed' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + check_contains '| `skip_test`.`t4` | succeed | false | +0/-0 | 0 | 0 |' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt + check_contains 'A total of 5 tables have been compared, 1 tables finished, 2 tables failed, 2 tables skipped' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + cat /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt Summary Source Database host = "127.0.0.1" port = 3306 user = "root" Target Databases host = "127.0.0.1" port = 4000 user = "root" Comparison Result The table structure and data in following tables are equivalent +------------------+---------+-----------+ | TABLE | UPCOUNT | DOWNCOUNT | +------------------+---------+-----------+ | `skip_test`.`t0` | 1 | 1 | +------------------+---------+-----------+ The following tables contains inconsistent data +------------------+---------+--------------------+----------------+---------+-----------+ | TABLE | RESULT | STRUCTURE EQUALITY | DATA DIFF ROWS | UPCOUNT | DOWNCOUNT | +------------------+---------+--------------------+----------------+---------+-----------+ | `skip_test`.`t2` | skipped | false | +1/-0 | 1 | 0 | | `skip_test`.`t4` | succeed | false | +0/-0 | 0 | 0 | | `skip_test`.`t3` | skipped | false | +0/-1 | 0 | 1 | | `skip_test`.`t1` | succeed | true | +0/-1 | 1 | 2 | +------------------+---------+--------------------+----------------+---------+-----------+ Time Cost: 26.526161ms Average Speed: 0.000000MB/s + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + echo 'test router case' test router case + sync_diff_inspector --config=./config_router.toml + check_contains 'check pass' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + check_contains '| `skip_test`.`t5` | skipped | false | +3/-0 | 3 | 0 |' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt + check_contains 'The data of `skip_test`.`t5` does not exist in downstream database' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + check_contains 'A total of 1 tables have been compared, 0 tables finished, 0 tables failed, 1 tables skipped' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb0 /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log /tmp/sync_diff_inspector_test/sync_diff_inspector/output/table_skip_diff.output + echo 'table_skip test passed' table_skip test passed + for script in './*/run.sh' +++ dirname ./time_zone/run.sh ++ basename ./time_zone + test_name=time_zone + echo --------------------------------------- --------------------------------------- + echo 'Running test ./time_zone/run.sh...' Running test ./time_zone/run.sh... + echo --------------------------------------- --------------------------------------- + sh ./time_zone/run.sh ++ dirname ./time_zone/run.sh + cd ./time_zone + OUT_DIR=/tmp/sync_diff_inspector_test/sync_diff_inspector/output + FIX_DIR=/tmp/sync_diff_inspector_test/sync_diff_inspector/fixsql + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/fixsql + mkdir -p /tmp/sync_diff_inspector_test/sync_diff_inspector/output + mkdir -p /tmp/sync_diff_inspector_test/sync_diff_inspector/fixsql + mysql -uroot -h 127.0.0.1 -P 4000 -e 'SET @@GLOBAL.SQL_MODE='\''ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'\'';' + sleep 3 + for port in 4000 4001 + mysql -uroot -h 127.0.0.1 -P 4000 -e 'create database if not exists tz_test' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'create table tz_test.diff(id int, dt datetime, ts timestamp);' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'insert into tz_test.diff values (1, '\''2020-05-17 09:12:13'\'', '\''2020-05-17 09:12:13'\'');' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'set @@session.time_zone = "-07:00"; insert into tz_test.diff values (2, '\''2020-05-17 09:12:13'\'', '\''2020-05-17 09:12:13'\'');' + for port in 4000 4001 + mysql -uroot -h 127.0.0.1 -P 4001 -e 'create database if not exists tz_test' + mysql -uroot -h 127.0.0.1 -P 4001 -e 'create table tz_test.diff(id int, dt datetime, ts timestamp);' + mysql -uroot -h 127.0.0.1 -P 4001 -e 'insert into tz_test.diff values (1, '\''2020-05-17 09:12:13'\'', '\''2020-05-17 09:12:13'\'');' + mysql -uroot -h 127.0.0.1 -P 4001 -e 'set @@session.time_zone = "-07:00"; insert into tz_test.diff values (2, '\''2020-05-17 09:12:13'\'', '\''2020-05-17 09:12:13'\'');' + echo 'check with the same time_zone, check result should be pass' check with the same time_zone, check result should be pass + sync_diff_inspector --config=./config.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log /tmp/sync_diff_inspector_test/sync_diff_inspector/output/time_zone_diff.output + mysql -uroot -h 127.0.0.1 -P 4000 -e 'SET @@global.time_zone = '\''+08:00'\''' + mysql -uroot -h 127.0.0.1 -P 4001 -e 'SET @@global.time_zone = '\''+00:00'\''' + sleep 5 + echo 'check with different time_zone, check result should be pass again' check with different time_zone, check result should be pass again + sync_diff_inspector --config=./config.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log /tmp/sync_diff_inspector_test/sync_diff_inspector/output/time_zone_diff.output + echo 'set different rows, check result should be failed' set different rows, check result should be failed + mysql -uroot -h 127.0.0.1 -P 4001 -e 'SET @@session.time_zone = '\''-06:00'\''; insert into tz_test.diff values (4, '\''2020-05-17 09:12:13'\'', '\''2020-05-17 09:12:13'\'');' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'SET @@session.time_zone = '\''-05:00'\''; insert into tz_test.diff values (3, '\''2020-05-17 10:12:13'\'', '\''2020-05-17 10:12:13'\'');' + sync_diff_inspector --config=./config.toml + true + check_contains 'check failed' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + mv /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb/ /tmp/sync_diff_inspector_test/sync_diff_inspector/fixsql/ + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log /tmp/sync_diff_inspector_test/sync_diff_inspector/output/time_zone_diff.output + echo 'fix the rows, check result should be pass' fix the rows, check result should be pass + cat /tmp/sync_diff_inspector_test/sync_diff_inspector/fixsql/fix-on-tidb/tz_test:diff:0:0-0:0.sql + mysql -uroot -h127.0.0.1 -P 4000 + sync_diff_inspector --config=./config.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output/checkpoint /tmp/sync_diff_inspector_test/sync_diff_inspector/output/fix-on-tidb /tmp/sync_diff_inspector_test/sync_diff_inspector/output/summary.txt /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log /tmp/sync_diff_inspector_test/sync_diff_inspector/output/time_zone_diff.output + mysql -uroot -h 127.0.0.1 -P 4000 -e 'SET @@session.time_zone = '\''-06:00'\''; select ts from tz_test.diff where id = 4 or id = 3;' + check_contains '2020-05-17 09:12:13' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/tmp_sql_timezone + check_not_contains '2020-05-17 10:12:13' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/tmp_sql_timezone + mysql -uroot -h 127.0.0.1 -P 4000 -e 'SET @@global.time_zone = '\''SYSTEM'\''' + mysql -uroot -h 127.0.0.1 -P 4001 -e 'SET @@global.time_zone = '\''SYSTEM'\''' + for script in './*/run.sh' +++ dirname ./tls/run.sh ++ basename ./tls + test_name=tls + echo --------------------------------------- --------------------------------------- + echo 'Running test ./tls/run.sh...' Running test ./tls/run.sh... + echo --------------------------------------- --------------------------------------- + sh ./tls/run.sh ++ dirname ./tls/run.sh + cd ./tls ++ cd ../../conf ++ pwd + CONF_PATH=/home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/sync_diff_inspector/tests/conf + CA_PATH=/home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/sync_diff_inspector/tests/conf/root.crt + CERT_PATH=/home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/sync_diff_inspector/tests/conf/client.crt + KEY_PATH=/home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/sync_diff_inspector/tests/conf/client.key + OUT_DIR=/tmp/sync_diff_inspector_test/sync_diff_inspector/output + rm -rf /tmp/sync_diff_inspector_test/sync_diff_inspector/output + mkdir -p /tmp/sync_diff_inspector_test/sync_diff_inspector/output + mysql -uroot -h 127.0.0.1 -P 4000 -e 'create user '\''root_tls'\''@'\''%'\'' identified by '\'''\'' require X509;' + mysql -uroot -h 127.0.0.1 -P 4000 -e 'grant all privileges on *.* to '\''root_tls'\''@'\''%'\'';' + mysql -uroot_tls -h 127.0.0.1 -P 4000 --ssl-ca /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/sync_diff_inspector/tests/conf/root.crt --ssl-cert /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/sync_diff_inspector/tests/conf/client.crt --ssl-key /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/sync_diff_inspector/tests/conf/client.key -e 'SHOW STATUS LIKE "%Ssl%";' Variable_name Value Ssl_cipher ECDHE-RSA-AES128-GCM-SHA256 Ssl_cipher_list RC4-SHA:DES-CBC3-SHA:AES128-SHA:AES256-SHA:AES128-SHA256:AES128-GCM-SHA256:AES256-GCM-SHA384:ECDHE-ECDSA-RC4-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-RC4-SHA:ECDHE-RSA-DES-CBC3-SHA:ECDHE-RSA-AES128-SHA:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-CHACHA20-POLY1305:TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256: Ssl_server_not_after Feb 6 15:50:25 2051 UTC Ssl_server_not_before Sep 21 15:50:25 2023 UTC Ssl_verify_mode 5 Ssl_version TLSv1.2 + echo 'use sync_diff_inspector to compare data' use sync_diff_inspector to compare data ++ echo /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/sync_diff_inspector/tests/conf/root.crt ++ sed 's/\//\\\//g' + CA_PATH_REG='\/home\/jenkins\/agent\/workspace\/pingcap\/tiflow\/pull_syncdiff_integration_test\/tiflow\/sync_diff_inspector\/tests\/conf\/root.crt' ++ echo /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/sync_diff_inspector/tests/conf/client.crt ++ sed 's/\//\\\//g' + CERT_PATH_REG='\/home\/jenkins\/agent\/workspace\/pingcap\/tiflow\/pull_syncdiff_integration_test\/tiflow\/sync_diff_inspector\/tests\/conf\/client.crt' ++ echo /home/jenkins/agent/workspace/pingcap/tiflow/pull_syncdiff_integration_test/tiflow/sync_diff_inspector/tests/conf/client.key ++ sed 's/\//\\\//g' + KEY_PATH_REG='\/home\/jenkins\/agent\/workspace\/pingcap\/tiflow\/pull_syncdiff_integration_test\/tiflow\/sync_diff_inspector\/tests\/conf\/client.key' + sed 's/"ca-path"#CAPATH/"\/home\/jenkins\/agent\/workspace\/pingcap\/tiflow\/pull_syncdiff_integration_test\/tiflow\/sync_diff_inspector\/tests\/conf\/root.crt"/g' config.toml + sed 's/"cert-path"#CERTPATH/"\/home\/jenkins\/agent\/workspace\/pingcap\/tiflow\/pull_syncdiff_integration_test\/tiflow\/sync_diff_inspector\/tests\/conf\/client.crt"/g' + sed 's/"key-path"#KEYPATH/"\/home\/jenkins\/agent\/workspace\/pingcap\/tiflow\/pull_syncdiff_integration_test\/tiflow\/sync_diff_inspector\/tests\/conf\/client.key"/g' + sync_diff_inspector --config=./config_.toml + check_contains 'check pass!!!' /tmp/sync_diff_inspector_test/sync_diff_inspector/output/sync_diff.log \033[0;36m<<< Run all test success >>>\033[0m [Pipeline] } [Pipeline] // dir [Pipeline] } [Pipeline] // stage [Pipeline] } [Pipeline] // timeout [Pipeline] } [Pipeline] // withEnv [Pipeline] } [Pipeline] // container [Pipeline] } [Pipeline] // withEnv [Pipeline] } [Pipeline] // node [Pipeline] } [Pipeline] // podTemplate [Pipeline] End of Pipeline Finished: SUCCESS