TIDB2.1.15通过binlog向tidb5.0.0迁移数据的时候遇到“2021/05/14 11:28:11 syncer.go:516: [info] [ddl][start]use `test_keystat`; create table test2(name varchar(11));[commit ts]424883679751569418”

为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:

【TiDB 版本】
源集群:tidb2.1.15
目标集群:tidb5.0.0
【问题描述】
已经部署好binlog全套启动也正常,但是数据未同步过去,查看drainer日志,发现如下报错:
2021/05/14 12:12:55 syncer.go:516: [info] [ddl][start]use test_keystat; create table test2(name varchar(11));[commit ts]424883679751569418
2021/05/14 12:12:55 sql.go:86: [error] [exec][sql]use test_keystat; create table test2(name varchar(11));[args][][error]Error 1046: No database selected
2021/05/14 12:12:58 sql.go:86: [error] [exec][sql]use test_keystat; create table test2(name varchar(11));[args][][error]Error 1046: No database selected
2021/05/14 12:13:01 sql.go:86: [error] [exec][sql]use test_keystat; create table test2(name varchar(11));[args][][error]Error 1046: No database selected
2021/05/14 12:13:04 sql.go:86: [error] [exec][sql]use test_keystat; create table test2(name varchar(11));[args][][error]Error 1046: No database selected
2021/05/14 12:13:07 sql.go:86: [error] [exec][sql]use test_keystat; create table test2(name varchar(11));[args][][error]Error 1046: No database selected
2021/05/14 12:13:07 syncer.go:360: [fatal] Error 1046: No database selected
github.com/pingcap/errors.AddStack
/home/jenkins/workspace/release_tidb_2.1/go/pkg/mod/github.com/pingcap/errors@v0.11.0/errors.go:174
github.com/pingcap/errors.Trace
/home/jenkins/workspace/release_tidb_2.1/go/pkg/mod/github.com/pingcap/errors@v0.11.0/juju_adaptor.go:12
github.com/pingcap/tidb-binlog/pkg/sql.ExecuteTxnWithHistogram
/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-binlog/pkg/sql/sql.go:91
github.com/pingcap/tidb-binlog/pkg/sql.ExecuteSQLsWithHistogram
/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-binlog/pkg/sql/sql.go:57
github.com/pingcap/tidb-binlog/drainer/executor.(*mysqlExecutor).Execute
/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-binlog/drainer/executor/mysql.go:33
github.com/pingcap/tidb-binlog/drainer.execute
/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-binlog/drainer/util.go:124
github.com/pingcap/tidb-binlog/drainer.(*Syncer).sync
/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-binlog/drainer/syncer.go:356
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1337

报错出现之后drainer也会自动挂掉,请问这个怎么排查问题,谢谢

若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。

配置的用户是root用户,在目标集群上test_keystat也是存在的

各路大神,:grinning:

可以先看下 tidb 5.0 日志有没有相关 sql 报错信息

[2021/05/14 12:12:26.142 +08:00] [INFO] [session.go:2761] [“CRUCIAL OPERATION”] [conn=66077] [schemaVersion=59] [cur_db=] [sql=“create schema if not exists tidb_binlog”] [user=root@xxxxxxxx]
[2021/05/14 12:12:26.142 +08:00] [INFO] [session.go:2761] [“CRUCIAL OPERATION”] [conn=66077] [schemaVersion=59] [cur_db=] [sql=“create table if not exists tidb_binlog.checkpoint(clusterID bigint unsigned primary key, checkPoint MEDIUMTEXT)”] [user=root
@xxxxxxxx]
[2021/05/14 12:12:27.181 +08:00] [INFO] [conn.go:812] [“command dispatched failed”] [conn=66079] [connInfo=“id:66079, addr:xxxxxxxxxxxx:18906 status:11, collation:utf8_general_ci, user:root”] [command=Query] [status=“inTxn:1, autocommit:1”] [sql=“use t est_keystat; create table test2(name varchar(11));”] [txn_mode=PESSIMISTIC] [err="[planner:1046]No database selected\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/e
rrors@v0.11.5-0.20201126102027-b0a155152ca3/errors.go:174\ngithub.com/pingcap/errors.Trace\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20201126102027-b0a155152ca3/juju_adaptor.go:15
ngithub.com/pingcap/tidb/planner/core.(*preprocessor).handleTableName\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:1116\ngithub.com/pingcap/tidb/planner/core.(*preprocessor
).Leave\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:355\ngithub.com/pingcap/parser/ast.(*TableName).Accept\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-a
md/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20210325072920-0d17053a8a69/ast/dml.go:403\ngithub.com/pingcap/parser/ast.(*CreateTableStmt).Accept\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/parser@v
0.0.0-20210325072920-0d17053a8a69/ast/ddl.go:1036\ngithub.com/pingcap/tidb/planner/core.Preprocess\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:89\ github.com/pingcap/tidb/
server.(*clientConn).prefetchPointPlanKeys\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1555\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\ \t/home/jenkins/agent/workspace/
optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1482\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go
:1030\ngithub.com/pingcap/tidb/server.(*clientConn).Run\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:795\ngithub.com/pingcap/tidb/server.(*Server).onConn\ \t/home/jenkins/agent/workspa
ce/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:477\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357"]
[2021/05/14 12:12:30.182 +08:00] [INFO] [conn.go:812] [“command dispatched failed”] [conn=66079] [connInfo=“id:66079, addr:xxxxxx:18906 status:11, collation:utf8_general_ci, user:root”] [command=Query] [status=“inTxn:1, autocommit:1”] [sql=“use t est_keystat; create table test2(name varchar(11));”] [txn_mode=PESSIMISTIC] [err="[planner:1046]No database selected\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/e
rrors@v0.11.5-0.20201126102027-b0a155152ca3/errors.go:174\ngithub.com/pingcap/errors.Trace\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20201126102027-b0a155152ca3/juju_adaptor.go:15
ngithub.com/pingcap/tidb/planner/core.(*preprocessor).handleTableName\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:1116\ngithub.com/pingcap/tidb/planner/core.(*preprocessor
).Leave\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:355\ngithub.com/pingcap/parser/ast.(*TableName).Accept\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-a
md/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20210325072920-0d17053a8a69/ast/dml.go:403\ngithub.com/pingcap/parser/ast.(*CreateTableStmt).Accept\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/parser@v
0.0.0-20210325072920-0d17053a8a69/ast/ddl.go:1036\ngithub.com/pingcap/tidb/planner/core.Preprocess\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:89\ github.com/pingcap/tidb/
server.(*clientConn).prefetchPointPlanKeys\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1555\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\ \t/home/jenkins/agent/workspace/
optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1482\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go
:1030\ngithub.com/pingcap/tidb/server.(*clientConn).Run\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:795\ngithub.com/pingcap/tidb/server.(*Server).onConn\ \t/home/jenkins/agent/workspa
ce/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:477\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357"]

No database selected. 在tidb.log中也是这个提示,但是binlog传过来的sql确实是 sql=“use t est_keystat ; create table test2(name varchar(11));”,大神这个咋查呢

手动在 2.1.15 的集群上执行 use t est_keystat ; create table test2(name varchar(11)); 可以执行么
手动在 5.0.0 的集群上执行 use t est_keystat ; create table test2(name varchar(11)); 可以执行么

可以的, use test_keystat ; create table test2(name varchar(11));是我在mydumper数据的时候在2.1.15上跑的

报错之后,我单独在5.0.0上执行 use test_keystat ; create table test2(name varchar(11));也没有问题,可以执行成功


这个 test t 与 e 之间为什么是有空格的?

这个是我屏幕显示的时候换行了,所有粘贴上去的时候变成这样了;正常的报错如下,drainer挂掉之后会自动重启,然后每次的报错都是一样的,我就重新取了一个时间段的如下:

----drainer.log
2021/05/15 22:21:14 sql.go:86: [error] [exec][sql]use test_keystat; create table test2(name varchar(11));[args][][error]Error 1046: No database selected
2021/05/15 22:21:17 sql.go:86: [error] [exec][sql]use test_keystat; create table test2(name varchar(11));[args][][error]Error 1046: No database selected
2021/05/15 22:21:20 sql.go:86: [error] [exec][sql]use test_keystat; create table test2(name varchar(11));[args][][error]Error 1046: No database selected
2021/05/15 22:21:23 sql.go:86: [error] [exec][sql]use test_keystat; create table test2(name varchar(11));[args][][error]Error 1046: No database selected
2021/05/15 22:21:26 sql.go:86: [error] [exec][sql]use test_keystat; create table test2(name varchar(11));[args][][error]Error 1046: No database selected
2021/05/15 22:21:26 syncer.go:360: [fatal] Error 1046: No database selected
github.com/pingcap/errors.AddStack
rrors@v0.11.0/errors.go:174pace/release_tidb_2.1/go/pkg/mod/github.com/pingcap/e–More–
github.com/pingcap/errors.Trace
/home/jenkins/workspace/release_tidb_2.1/go/pkg/mod/github.com/pingcap/errors@v0.11.0/juju_adaptor.go:12
github.com/pingcap/tidb-binlog/pkg/sql.ExecuteTxnWithHistogram
/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-binlog/pkg/sql/sql.go:91
github.com/pingcap/tidb-binlog/pkg/sql.ExecuteSQLsWithHistogram
/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-binlog/pkg/sql/sql.go:57
github.com/pingcap/tidb-binlog/drainer/executor.(*mysqlExecutor).Execute
/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-binlog/drainer/executor/mysql.go:33
github.com/pingcap/tidb-binlog/drainer.execute
/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-binlog/drainer/util.go:124
github.com/pingcap/tidb-binlog/drainer.(*Syncer).sync
/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-binlog/drainer/syncer.go:356
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1337

—tidb.log

[2021/05/15 21:21:54.140 +08:00] [INFO] [session.go:2761] [“CRUCIAL OPERATION”] [conn=68697] [schemaVersion=63] [cur_db=] [sql=“create schema if not exists tidb_binlog”] [user=root@xxxxxxxxxxxx]
[2021/05/15 21:21:54.141 +08:00] [INFO] [session.go:2761] [“CRUCIAL OPERATION”] [conn=68697] [schemaVersion=63] [cur_db=] [sql=“create table if not exists tidb_binlog.checkpoint(clusterID bigint unsigned primary key, checkPoint MEDIUMTEXT)”] [user=root@xxxxxxxxxxxx]
[2021/05/15 21:21:55.179 +08:00] [INFO] [conn.go:812] [“command dispatched failed”] [conn=68699] [connInfo=“id:68699, addr:xxxxxxxxxxxx:26614 status:11, collation:utf8_general_ci, user:root”] [command=Query] [status=“inTxn:1, autocommit:1”] [sql=“use tmod/github.com/pingcap/errors@v0.11.5-0.20201126102027-b0a155152ca3/errors.go:174\ github.com/pingcap/errors.Trace\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20201126102027-b0a155152ca3/juju_adaptor.go:15\ github.com/pingcap/tidb/planner/core.(*preprocessor).handleTableName\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:1116\ github.com/pingcap/tidb/planner/core.(*preprocessor).Leave\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:355\ github.com/pingcap/parser/ast.(*TableName).Accept\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20210325072920-0d17053a8a69/ast/dml.go:403\ github.com/pingcap/parser/ast.(*CreateTableStmt).Accept\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20210325072920-0d17053a8a69/ast/ddl.go:1036\ github.com/pingcap/tidb/planner/core.Preprocess\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:89\ github.com/pingcap/tidb/server.(*clientConn).prefetchPointPlanKeys\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1555\ github.com/pingcap/tidb/server.(*clientConn).handleQuery\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1482\ github.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pinRun\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:795\ github.com/pingcap/tidb/server.(*Server).onConn\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:477\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357"] [2021/05/15 21:21:58.181 +08:00] [INFO] [conn.go:812] ["command dispatched failed"] [conn=68699] [connInfo="id:68699, addr:xxxxxxxxxxxx:26614 status:11, collation:utf8_general_ci, user:root"] [command=Query] [status="inTxn:1, autocommit:1"] [sql="usetest_keystat; create table test2(name varchar(11));"] [txn_mode=PESSIMISTIC] [err="[planner:1046]No database selected\ github.com/pingcap/errors.AddStack\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20201126102027-b0a155152ca3/errors.go:174\ github.com/pingcap/errors.Trace\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20201126102027-b0a155152ca3/juju_adaptor.go:15\ github.com/pingcap/tidb/planner/core.(*preprocessor).handleTableName\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:1116\ github.com/pingcap/tidb/planner/core.(*preprocessor).Leave\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:355\ github.com/pingcap/parser/ast.(*TableName).Accept\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-aoptimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20210325072920-0d17053a8a69/ast/ddl.go:1036\ github.com/pingcap/tidb/planner/core.Preprocess\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:89\ github.com/pingcap/tidb/server.(*clientConn).prefetchPointPlanKeys\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1555\ github.com/pingcap/tidb/server.(*clientConn).handleQuery\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1482\ github.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1030\ github.com/pingcap/tidb/server.(*clientConn).Run\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:795\ github.com/pingcap/tidb/server.(*Server).onConn\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:477\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357"] [2021/05/15 21:22:01.183 +08:00] [INFO] [conn.go:812] ["command dispatched failed"] [conn=68699] [connInfo="id:68699, addr:xxxxxxxxxxxx:26614 status:11, collation:utf8_general_ci, user:root"] [command=Query] [status="inTxn:1, autocommit:1"] [sql="usetest_keystat`; create table test2(name varchar(11));”] [txn_mode=PESSIMISTIC] [err="[planner:1046]No database selected\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/e4\ github.com/pingcap/errors.Trace\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20201126102027-b0a155152ca3/juju_adaptor.go:15\ github.com/pingcap/tidb/planner/core.(*preprocessor).handleTableName\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:1116\ngithub.com/pingcap/tidb/planner/core.(*preprocessor).Leave\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:355\ngithub.com/pingcap/parser/ast.(*TableName).Accept\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20210325072920-0d17053a8a69/ast/dml.go:403\ngithub.com/pingcap/parser/ast.(*CreateTableStmt).Accept\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20210325072920-0d17053a8a69/ast/ddl.go:1036\ngithub.com/pingcap/tidb/planner/core.Preprocess\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/planner/core/preprocess.go:89\ github.com/pingcap/tidb/server.(*clientConn).prefetchPointPlanKeys\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1555\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1482\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1030\ngithub.com/pingcap/tidb/server.(*clientConn).Run\thub.com/pingcap/tidb/server/conn.go:795\ github.com/pingcap/tidb/server.(*Server).onConn\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:477\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357"]

这个粘贴上去之后一些字符就看不见了 我截图一下

  1. 同步账户的权限是怎么样的?
  2. drainer 的同步配置是怎么样的?

1、同步账号是root
2、配置都是默认的,如下:
[tidb@tidb-grass-tidb-sg-nc-10-71-26-17 conf]$ cat drainer.toml |grep -v “#”
detect-interval = 10
[syncer]
ignore-schemas = “INFORMATION_SCHEMA,PERFORMANCE_SCHEMA,mysql”
txn-batch = 20
worker-count = 16
disable-dispatch = false
safe-mode = false

db-type = “tidb”
[syncer.to]
host = “XXXXXX”
user = “root”
password = “”
port = 4000

  1. 请问 binlog 版本是什么?
  2. 能否上传报错范围的完整的 binlog 日志 和 tidb 日志,多谢。

binlog是2.1.15版本

drainer.log (5.1 MB) tidb.log (5.6 MB) pump.log.20210515 (3.6 MB)

pump和drainer和源数据库版本一致都是tidb2.1.15
目标tidb数据库是tidb5.0.5

1、这个报错看起来就是 use 语句没有执行成功或者没有解析成功,只执行了后面的 create 语句,才报的错
2、建议咱们下游 确认一下,日志提到的 库名字 在下游 有没有
3、建议咱们可以先跳过这个错误,先解决这个问题为主

刚刚我手工在目标5.0.0的数据库上将需要的表create了,然后重启了drainer,这会没有报错了,但是在导入导出数据这段时间我手工插入2.1.15的几条数据完全没有同步到5.0.5上,而且连日志也没有任何显示;

在driainer正常跑的情况下,再执行dml操作就没有问题

所以现在的问题是:从2.1.15中导出的数据到导入5.0.0这段时间差不多有两天的时间,这段时间的dml操作就直接丢了?那我同步就没什么意思了:sweat_smile:

库名肯定是有的呢 ,这个是数据导入之后我确认了就存在的