为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
【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也是存在的
qizheng
(qizheng)
4
可以先看下 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="use
test_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="use
test_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、同步账号是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
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
spc_monkey
(carry@pingcap.com)
18
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操作就直接丢了?那我同步就没什么意思了
库名肯定是有的呢 ,这个是数据导入之后我确认了就存在的