导入数据时tidb报错

为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
【 TiDB 使用环境】

【概述】:场景 + 问题概述
[2021/07/30 09:58:11.843 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:11.949 +00:00] [WARN] [session.go:549] [“can not retry txn”] [label=internal] [error=“[domain:8027]Information schema is out of date: schema failed to update in 1 lease, please make sure TiDB can connect to TiKV”] [IsBatchInsert=false] [IsPessimistic=true] [InRestrictedSQL=true] [tidb_retry_limit=10] [tidb_disable_txn_auto_retry=true]
[2021/07/30 09:58:11.949 +00:00] [WARN] [session.go:564] [“commit failed”] [“finished txn”=“Txn{state=invalid}”] [error=“[domain:8027]Information schema is out of date: schema failed to update in 1 lease, please make sure TiDB can connect to TiKV”]
[2021/07/30 09:58:11.950 +00:00] [WARN] [session.go:1429] [“run statement failed”] [schemaVersion=25] [error=“previous statement: update mysql.stats_meta set version = 426675820804440065, count = count + 11, modify_count = modify_count + 44 where table_id = 17: [domain:8027]Information schema is out of date: schema failed to update in 1 lease, please make sure TiDB can connect to TiKV”] [session=“{
"currDBName": "",
"id": 0,
"status": 2,
"strictMode": true,
"user": null
}”]
[2021/07/30 09:58:11.953 +00:00] [INFO] [2pc.go:917] [“2PC clean up done”] [txnStartTS=426675820804440065] [isPessimistic=true] [isOnePC=false]
[2021/07/30 09:58:12.065 +00:00] [WARN] [session.go:549] [“can not retry txn”] [label=internal] [error=“[domain:8027]Information schema is out of date: schema failed to update in 1 lease, please make sure TiDB can connect to TiKV”] [IsBatchInsert=false] [IsPessimistic=false] [InRestrictedSQL=true] [tidb_retry_limit=10] [tidb_disable_txn_auto_retry=true]
[2021/07/30 09:58:12.065 +00:00] [WARN] [session.go:564] [“commit failed”] [“finished txn”=“Txn{state=invalid}”] [error=“[domain:8027]Information schema is out of date: schema failed to update in 1 lease, please make sure TiDB can connect to TiKV”]
[2021/07/30 09:58:12.065 +00:00] [WARN] [session.go:1429] [“run statement failed”] [schemaVersion=25] [error=“[domain:8027]Information schema is out of date: schema failed to update in 1 lease, please make sure TiDB can connect to TiKV”] [session=“{
"currDBName": "",
"id": 0,
"status": 2,
"strictMode": true,
"user": null
}”]
[2021/07/30 09:58:12.065 +00:00] [WARN] [gc_worker.go:264] [“[gc worker] check leader”] [error=“[domain:8027]Information schema is out of date: schema failed to update in 1 lease, please make sure TiDB can connect to TiKV”]
[2021/07/30 09:58:12.070 +00:00] [INFO] [2pc.go:917] [“2PC clean up done”] [txnStartTS=426675820830654468] [isPessimistic=false] [isOnePC=false]
[2021/07/30 09:58:12.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:12.843 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:13.841 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:13.841 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:14.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:14.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:15.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:15.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:16.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:16.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:17.841 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:17.843 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:18.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:18.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:19.843 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:19.843 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:20.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:20.842 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:21.843 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 4, tp add index”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:21.843 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:21.879 +00:00] [ERROR] [domain.go:536] [“reload schema in loop failed”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]
[2021/07/30 09:58:22.841 +00:00] [WARN] [ddl_worker.go:179] [“[ddl] handle DDL job failed”] [worker=“worker 3, tp general”] [error=“newRegion’s range key is not encoded: , invalid marker byte, group bytes "Leo_item,"”]


【背景】:做过哪些操作

【现象】:业务和数据库现象

【问题】:当前遇到的问题

【业务影响】:

【TiDB 版本】:

【TiDB Operator 版本】:
1.13
【K8s 版本】:
1.22
【附件】:
日志
log-tidb0 (316.2 KB)
log-pd0 (128.3 KB)
log-tikv0 (517.9 KB)
log-tikv1 (511.9 KB)
log-tikv2 (597.7 KB)


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

1 个赞

看看这篇文章是否有帮助

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。