【 使用环境 】测试环境
【 OB or 其他组件 】 ob obdumper
【 使用版本 】
obdumper Version: 4.2.5-RELEASE,
ob OceanBase_CE 4.1.0.0
【问题描述】
使用下面命令导出所有表和数据
obdumper -u root -p iforgot -h 127.0.0.1 -P 2881 -t tenant_homed --sys-user root@sys --sys-password root --all --ddl --sql -f ./t1
root库从哪里来的,提示的很奇怪
无论–sys-user是写root还是root@sys 都有报错如下:
[root@dbserver01(49.196) baksql]# obdumper -u root -p iforgot -h 127.0.0.1 -P 2881 -t tenant_homed --sys-user root@sys --sys-password root --all --ddl --sql -f ./t1
2023-08-15 10:26:48 [INFO] Parsed args:
[--ddl] true
[--sql] true
[--file-path] ./t1
[--host] 127.0.0.1
[--port] 2881
[--user] root
[--tenant] tenant_homed
[--password] ******
[--sys-user] root@sys
[--sys-password] ******
[--all] true
2023-08-15 10:26:48 [INFO] Load jdbc driver class: "com.oceanbase.jdbc.Driver" finished
2023-08-15 10:26:49 [ERROR] create connection SQLException, url: jdbc:oceanbase://127.0.0.1:2881/root?characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&log=true&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true&useLocalSessionState=true&useCompression=true&noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull&emulateUnsupportedPstmts=true&useServerPrepStmts=true&log=true, errorCode 1049, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to 127.0.0.1:2881 : (conn=3221699191) Unknown database 'root'
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1644) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1427) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:306) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.Driver.connect(Driver.java:89) ~[oceanbase-client-2.4.3.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1691) ~[druid-1.2.18.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1789) ~[druid-1.2.18.jar:?]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2942) ~[druid-1.2.18.jar:?]
Caused by: java.sql.SQLSyntaxErrorException: (conn=3221699191) Unknown database 'root'
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:787) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:591) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1639) ~[oceanbase-client-2.4.3.jar:?]
... 6 more
2023-08-15 10:26:49 [ERROR] create connection SQLException, url: jdbc:oceanbase://127.0.0.1:2881/root?characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&log=true&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true&useLocalSessionState=true&useCompression=true&noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull&emulateUnsupportedPstmts=true&useServerPrepStmts=true&log=true, errorCode 1049, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to 127.0.0.1:2881 : (conn=3221699194) Unknown database 'root'
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1644) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1427) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:306) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.Driver.connect(Driver.java:89) ~[oceanbase-client-2.4.3.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1691) ~[druid-1.2.18.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1789) ~[druid-1.2.18.jar:?]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2942) ~[druid-1.2.18.jar:?]
Caused by: java.sql.SQLSyntaxErrorException: (conn=3221699194) Unknown database 'root'
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:787) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:591) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1639) ~[oceanbase-client-2.4.3.jar:?]
... 6 more
2023-08-15 10:26:49 [ERROR] Dump failed! Error: Init connection key failed. Error: ConnectFailedException: Init DataSourceManager failed. Error: SQLSyntaxErrorException: (conn=3221699194) Unknown database 'root'
2023-08-15 10:26:49 [ERROR] System exit 1
【复现路径】问题出现前后相关操作
【问题现象及影响】
【附件】