执行obdumper异常

我按文档下载了obdumper,执行如下命令:

./obdumper -h 127.0.0.1 -P 2883 -u root -p abc123 --sys-password rootPWD123 -t obmysql -D test --csv --table data_pool -f outputs

报异常如下:

2022-01-06 15:12:47 [INFO] Parsed args:

[–host] 127.0.0.1

[–port] 2883

[–user] root

[–tenant] obmysql

[–password] ******

[–database] test

[–sys-user] root

[–sys-password] ******

[–csv] true

[–file-path] outputs

[–table] [data_pool]

2022-01-06 15:12:48 [INFO] Load jdbc driver class: “org.mariadb.jdbc.Driver” finished

2022-01-06 15:12:48 [INFO] The manifest file: “/data/oceanbase-ce/ob-loader-dumper/bin/outputs/data/MANIFEST.bin” has been saved

2022-01-06 15:12:48 [ERROR] create connection SQLException, url: jdbc:mysql://127.0.0.1:2883/oceanbase?useUnicode=true&characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&useSSL=false, errorCode 1193, state HY000 java.sql.SQLTransientConnectionException: Could not connect to address=(host=127.0.0.1)(port=2883)(type=master) : Unknown system variable ‘session_track_schema’

at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.Driver.connect(Driver.java:89) ~[mariadb-java-client-2.7.4.jar:?]

at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657) ~[druid-1.2.8.jar:1.2.8]

at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[druid-1.2.8.jar:1.2.8]

at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838) [druid-1.2.8.jar:1.2.8]

Caused by: java.sql.SQLException: Unknown system variable ‘session_track_schema’

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1694) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1556) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1519) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.additionalData(AbstractConnectProtocol.java:1121) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.postConnectionQueries(AbstractConnectProtocol.java:892) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:597) ~[mariadb-java-client-2.7.4.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389) ~[mariadb-java-client-2.7.4.jar:?]

… 6 more

2022-01-06 15:12:48 [ERROR] Dump failed! Error: Query schema: “test” metadata failed. Error: Unknown system variable ‘session_track_schema’

2022-01-06 15:12:48 [INFO] System exit 1

产品手册中有对适用版本的说明:

自导数工具 V3.0.0 版本起,导数工具支持 OceanBase 社区版。

社区版导数工具(OBLOADER & OBDUMPER)需搭配社区版 OceanBase V3.1.2 及以上版本使用。


https://open.oceanbase.com/docs/obloader-obdumper/obloader-obdumper/V3.0.0/product-introduction

1 个赞