我按文档下载了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