【 TiDB 使用环境】生产环境
【 TiDB 版本】V5.3.3
【复现路径】利用mydumper导出tidb数据库下面的一个库
【遇到的问题:问题现象及影响】
利用mydumper导出tidb数据库下面的一个库,报错提示如下:
cat mydumper_oms_online.sh
#!/bin/sh
YOUR_USER=XXXXXX
YOUR_PASSWD=XXXXXX
/usr/bin/mydumper -u $YOUR_USER -p $YOUR_PASSWD -P 4000 -h 10.8.123.5 -l 7200 --kill-long-queries --lock-all-tables -B oms_online --max-rows 10000 -z -o /data/oms_online/
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件:截图/日志/监控】
cat mydumper_oms_online.log
** (mydumper:25456): WARNING **: Killed a query that was running for 505284s
** (mydumper:25456): WARNING **: Killed a query that was running for 500434s
** (mydumper:25456): WARNING **: No table found to lock
** (mydumper:25456): CRITICAL **: Error showing tables on: /data/oms_online/ - Could not execute query: No database selected
** (mydumper:25456): CRITICAL **: Error dumping create database (/data/oms_online/): Unknown database ‘/data/oms_online/’
– metadata.partial.0 0
– metadata 228
Started dump at: 2023-11-03 10:46:23
[master]
Channel_Name = ‘’ # It can be use to setup replication FOR CHANNEL
File = tidb-binlog
Position = 445377303943577629
Executed_Gtid_Set =
Finished dump at: 2023-11-03 10:46:23
** (mydumper:25456): CRITICAL **: Backup directory not removed: export-20231103-104622