【 使用环境 】生产环境
【 OB or 其他组件 】OB
【 使用版本 】4.1.0
【问题描述】我们计划从oceanbase中导出某个租户下某个数据库的表结构和数据,用mydumper执行导出报错,基于代理2883和直连2881导出都报错,报错详情:
[root@dbserver test]# mydumper -h 192.168.0.33 -P 2883 -u ‘edudiagnose@tt_edu’ -B edu_dw --no-data -o /home/test/schema2
** (mydumper:41270): WARNING **: Set session failed: /*!80003 SET SESSION information_schema_stats_expiry = 0 */
** (mydumper:41270): CRITICAL **: Error obtaining information from processlist
[root@dbserver test]# mydumper -h 192.168.0.33 -P 2881 -u ‘edudiagnose@tt_edu’ -B edu_dw --no-data -o /home/test/schema2
** (mydumper:41281): WARNING **: Set session failed: /*!80003 SET SESSION information_schema_stats_expiry = 0 */
** (mydumper:41281): WARNING **: Flush tables failed, we are continuing anyways: You have an error in your SQL syntax; c
heck the manual that corresponds to your OceanBase version for the right syntax to use near ‘FLUSH NO_WRITE_TO_BINLOG TA
BLES’ at line 1
** (mydumper:41281): CRITICAL **: Couldn’t acquire global lock, snapshots will not be consistent: You have an error in y
our SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘FLUSH TABL
ES WITH READ LOCK’ at line 1
** (mydumper:41281): WARNING **: Set session failed: /*!80003 SET SESSION information_schema_stats_expiry = 0 */
** (mydumper:41281): WARNING **: Set session failed: /*!80003 SET SESSION information_schema_stats_expiry = 0 */
** (mydumper:41281): WARNING **: Set session failed: /*!80003 SET SESSION information_schema_stats_expiry = 0 */
** (mydumper:41281): WARNING **: Set session failed: /*!80003 SET SESSION information_schema_stats_expiry = 0 */
所以请教下,oceanbase支持mydumper导出数据库吗(租户模式是mysql)?这个错误怎么解决呢,谢谢
【附件】