load加载报错

[TiDBer_OB4kHrS7]

导一个表也报同样的错误
** (mydumper:8992): CRITICAL **: Couldn’t acquire global lock, snapshots will not be consistent: FLUSH TABLES WITH READ LOCK is not supported. Please use @@tidb_snapshot
mydumper_tms.sh: line 4: 8992 Segmentation fault /usr/bin/mydumper -u $YOUR_USER -p $YOUR_PASSWD -P 4000 -h XXXXX -t 8 -l 7200 --kill-long-queries -B tms -T tms.delivery_bills_20201231 -o /data/tms/

[像风一样的男子]

写个脚本循环source 靠谱

[TiDBer_OB4kHrS7]

mysqldump: Couldn’t execute ‘FLUSH TABLES WITH READ LOCK’: FLUSH TABLES WITH READ LOCK is not supported. Please use @@tidb_snapshot (1105)

[TiDBer_OB4kHrS7]

嗯，用脚本在导了，看会不会继续报错了。

[路在何chu (Ti D Ber Ass Gn Qs R)]

这个mysql的命令，tidb不支持

[TiDBer_小阿飞]

看报错，写的是699行的列’channel_key’数据被删除了，truncated

[TiDBer_OB4kHrS7]

在用loader 导入的过程中，很多sql文件导入时，都报这种错误。

[TiDBer_OB4kHrS7]