obd一键测试tpch连接超时

OceanBase 技术问题
#1

obd test tpch XXXXX，卡在:
Get local repositories and plugins ok

Open ssh connection ok

Cluster status check ok

Connect observer(11.162.218.35:2881) x

[ERROR] OBD-1006: Failed to connect to oceanbase-ce

odb-display-trace:
[test2024@obrd.32c.vd2-s2c0-n0 /home/test2024]

$obd display-trace c3e8730c-ba83-11ee-906b-00163e0a13fc | grep ERROR

[2024-01-24 14:47:40.498] [ERROR] Traceback (most recent call last):

[2024-01-24 14:47:40.498] [ERROR] File “core.py”, line 4117, in tpch

[2024-01-24 14:47:40.498] [ERROR] File “core.py”, line 188, in call_plugin

[2024-01-24 14:47:40.498] [ERROR] File “_plugin.py”, line 343, in call

[2024-01-24 14:47:40.498] [ERROR] File “_plugin.py”, line 302, in _new_func

[2024-01-24 14:47:40.498] [ERROR] File “/home/test2024/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 149, in connect

[2024-01-24 14:47:40.498] [ERROR] cursor = Cursor(ip=server.ip, port=server_config[‘mysql_port’], tenant=’’, password=password if password is not None else ‘’, stdio=stdio)

[2024-01-24 14:47:40.498] [ERROR] File “_stdio.py”, line 906, in wrapper

[2024-01-24 14:47:40.498] [ERROR] File “/home/test2024/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 46, in init

[2024-01-24 14:47:40.498] [ERROR] self._connect()

[2024-01-24 14:47:40.498] [ERROR] File “/home/test2024/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 76, in _connect

[2024-01-24 14:47:40.498] [ERROR] self.db = mysql.connect(host=self.ip, user=self.user, port=int(self.port), password=str(self.password),

[2024-01-24 14:47:40.498] [ERROR] File “pymysql/connections.py”, line 353, in init

[2024-01-24 14:47:40.498] [ERROR] File “pymysql/connections.py”, line 633, in connect

[2024-01-24 14:47:40.498] [ERROR] File “pymysql/connections.py”, line 907, in _request_authentication

[2024-01-24 14:47:40.498] [ERROR] File “pymysql/connections.py”, line 725, in _read_packet

[2024-01-24 14:47:40.498] [ERROR] File “pymysql/protocol.py”, line 221, in raise_for_error

[2024-01-24 14:47:40.498] [ERROR] File “pymysql/err.py”, line 143, in raise_mysql_exception

[2024-01-24 14:47:40.498] [ERROR] pymysql.err.OperationalError: (1045, “Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)”)

[2024-01-24 14:47:40.498] [ERROR]

[2024-01-24 14:47:43.611] [ERROR] OBD-1006: Failed to connect to oceanbase-ce

#3

看着是密码不对，可以参看这个文档 https://www.oceanbase.com/docs/community-obd-cn-1000000000519102#2-title-obd%20test%20tpch

看下指定的租户和密码是否匹配。

#4

我看了一下，我指定的–user=root --password是root的密码，租户test_tpch没有密码
我直接“$obclient -h11.162.218.35 -P2881 -uroot -p密码”可以登陆

#5

这样写 --user=root@test_tpch 指定的是test_tpch租户的root用户

你是使用test_tpch租户测试，sys租户只是管理租户，不建议业务和测试使用的。

ps：-uroot 默认是 root@sys sys租户。

#6

我指定了租户–tenant=test_tpch，也就是说要把“–user=root --password=密码 --tenant=test_tpch”改成“–user=root@test_tpch --password=密码”吗

#7

不好意思说岔劈了。
示例：
obd test tpch test --tenant= test_tpch -s xxx --remote-tbl-dir=/tmp/xxxx

不填写–user 默认是root用户，如果你设置root@test_tpch密码 加上–password=‘密码’ 即可。

#8

我试过指定“tenant=test_tpch user=root password=root密码” 连接不上，然后不指定 user和password 使用默认也连接不上
obd test tpch test2024_lzh_ob --test-server=11.162.218.35 --user=root --password=密码 --tenant=test_tpch --obclient-bin=/data/1/test2024.lzh/oceanbase-all-in-one/obclient --dbgen-bin=/home/test2024/TPC-H3.0.1/dbgen --dss-config=/home/test2024/TPC-H3.0.1/dbgen/queries -s 10 --tmp-dir=/data/1/test2024.lzh/tpch_tmp --ddl-path=/home/test2024/TPC-H3.0.1/dbgen/load --tbl-path=/home/test2024/TPC-H3.0.1/dbgen/tpch10 --sql-path=/home/test2024/TPC-H3.0.1/dbgen/queries^ --remote-tbl-dir=/home/test2024/TPC-H3.0.1/dbgen/dbgen

#9

使用上面的链接信息 连接数据库是正常的吗，截图下连接信息。

#10

截屏2024-01-24 15.56.21
截屏2024-01-24 15.56.211920×1271 226 KB

l连接数据库都是正常的，–password里面写的也是root密码

#11

你的test_tpch租户没密码，不用带–password参数。

我大概知道你对这个参数的误解了。

首先连接数据库时使用的-u参数，正常写法是： -u用户名@租户名，如果直接写-uroot 默认是-uroot@sys，你的root@sys是设置了密码的，而root@test_tpch是没密码的。

而obd tpch 命令的参数写法和上面-u参数其实是拆分出成 租户参数（–tenant）和用户参数（–user）的、因此不涉及root@sys的密码的。

#12

我试了不带–password参数或者 --password填写root密码或者sys密码，都是连接超时

#13

这里和root密码和sys密码没关系，得先搞清楚什么是用户什么是租户。
租户之间是隔离，每个租户都有个默认用户root。
要连接的是test_tpch租户，这里没sys租户任何关系的。

麻烦提供下报错日志。

#14

[test2024@obrd.32c.vd2-s2c0-n0 /home/test2024]

$obd display-trace 890bcd50-ba93-11ee-8e8e-00163e0a13fc

[2024-01-24 16:35:31.727] [DEBUG] - cmd: [‘test2024_lzh_ob’]

[2024-01-24 16:35:31.728] [DEBUG] - opts: {‘component’: None, ‘test_server’: ‘11.162.218.35’, ‘user’: ‘root’, ‘password’: ‘3j2fjYw7rZ7plpJdfsq’, ‘tenant’: ‘test_tpch’, ‘database’: ‘test’, ‘obclient_bin’: ‘/data/1/test2024.lzh/oceanbase-all-in-one/obclient’, ‘dbgen_bin’: ‘/home/test2024/TPC-H3.0.1/dbgen’, ‘scale_factor’: 10, ‘tmp_dir’: ‘/data/1/test2024.lzh/tpch_tmp’, ‘ddl_path’: ‘/home/test2024/TPC-H3.0.1/dbgen/load’, ‘tbl_path’: ‘/home/test2024/TPC-H3.0.1/dbgen/tpch10’, ‘sql_path’: ‘/home/test2024/TPC-H3.0.1/dbgen/queries^’, ‘remote_tbl_dir’: ‘/home/test2024/TPC-H3.0.1/dbgen/dbgen’, ‘disable_transfer’: None, ‘dss_config’: ‘/home/test2024/TPC-H3.0.1/dbgen/queries’, ‘optimization’: 1, ‘test_only’: None, ‘skip_cluster_status_check’: False}

[2024-01-24 16:35:31.728] [DEBUG] - mkdir /home/test2024/.obd/lock/

[2024-01-24 16:35:31.728] [DEBUG] - unknown lock mode

[2024-01-24 16:35:31.728] [DEBUG] - try to get share lock /home/test2024/.obd/lock/global

[2024-01-24 16:35:31.728] [DEBUG] - share lock /home/test2024/.obd/lock/global, count 1

[2024-01-24 16:35:31.728] [DEBUG] - Get Deploy by name

[2024-01-24 16:35:31.728] [DEBUG] - mkdir /home/test2024/.obd/cluster/

[2024-01-24 16:35:31.729] [DEBUG] - mkdir /home/test2024/.obd/config_parser/

[2024-01-24 16:35:31.729] [DEBUG] - try to get exclusive lock /home/test2024/.obd/lock/deploy_test2024_lzh_ob

[2024-01-24 16:35:31.729] [DEBUG] - exclusive lock /home/test2024/.obd/lock/deploy_test2024_lzh_ob, count 1

[2024-01-24 16:35:31.736] [DEBUG] - Check deploy status

[2024-01-24 16:35:31.736] [DEBUG] - Get deploy configuration

[2024-01-24 16:35:31.761] [INFO] Get local repositories and plugins

[2024-01-24 16:35:31.762] [DEBUG] - mkdir /home/test2024/.obd/repository

[2024-01-24 16:35:31.763] [DEBUG] - Get local repository oceanbase-ce-4.2.1.3-None

[2024-01-24 16:35:31.763] [DEBUG] - try to get share lock /home/test2024/.obd/lock/mirror_and_repo

[2024-01-24 16:35:31.763] [DEBUG] - share lock /home/test2024/.obd/lock/mirror_and_repo, count 1

[2024-01-24 16:35:31.764] [DEBUG] - Searching param plugin for components …

[2024-01-24 16:35:31.765] [DEBUG] - Search param plugin for oceanbase-ce

[2024-01-24 16:35:31.765] [DEBUG] - mkdir /home/test2024/.obd/plugins

[2024-01-24 16:35:31.765] [DEBUG] - Found for oceanbase-ce-param-4.2.1.0 for oceanbase-ce-4.2.1.3

[2024-01-24 16:35:31.765] [DEBUG] - Applying oceanbase-ce-param-4.2.1.0 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b

[2024-01-24 16:35:32.320] [INFO] Open ssh connection

[2024-01-24 16:35:32.321] [DEBUG] - host: 11.162.218.226, port: 22, user: test2024, password: None

[2024-01-24 16:35:32.385] [DEBUG] - host: 11.162.218.58, port: 22, user: test2024, password: None

[2024-01-24 16:35:32.454] [DEBUG] - host: 11.162.218.35, port: 22, user: test2024, password: None

[2024-01-24 16:35:32.583] [INFO] Cluster status check

[2024-01-24 16:35:32.583] [DEBUG] - Searching status plugin for components …

[2024-01-24 16:35:32.583] [DEBUG] - Searching status plugin for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b

[2024-01-24 16:35:32.584] [DEBUG] - Found for oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.1.3

[2024-01-24 16:35:32.584] [DEBUG] - Call oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b

[2024-01-24 16:35:32.584] [DEBUG] - import status

[2024-01-24 16:35:32.585] [DEBUG] - add status ref count to 1

[2024-01-24 16:35:32.585] [DEBUG] – test2024@11.162.218.226 execute: cat /home/test2024/test2024_lzh_ob/oceanbase/run/observer.pid

[2024-01-24 16:35:32.641] [DEBUG] – exited code 0

[2024-01-24 16:35:32.642] [DEBUG] – test2024@11.162.218.226 execute: ls /proc/486727

[2024-01-24 16:35:32.739] [DEBUG] – exited code 0

[2024-01-24 16:35:32.740] [DEBUG] – test2024@11.162.218.35 execute: cat /home/test2024/test2024_lzh_ob/oceanbase/run/observer.pid

[2024-01-24 16:35:32.798] [DEBUG] – exited code 0

[2024-01-24 16:35:32.798] [DEBUG] – test2024@11.162.218.35 execute: ls /proc/51444

[2024-01-24 16:35:32.898] [DEBUG] – exited code 0

[2024-01-24 16:35:32.899] [DEBUG] – test2024@11.162.218.58 execute: cat /home/test2024/test2024_lzh_ob/oceanbase/run/observer.pid

[2024-01-24 16:35:33.004] [DEBUG] – exited code 0

[2024-01-24 16:35:33.004] [DEBUG] – test2024@11.162.218.58 execute: ls /proc/370076

[2024-01-24 16:35:33.146] [DEBUG] – exited code 0

[2024-01-24 16:35:33.147] [DEBUG] - sub status ref count to 0

[2024-01-24 16:35:33.147] [DEBUG] - export status

[2024-01-24 16:35:33.237] [DEBUG] - Call oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b

[2024-01-24 16:35:33.237] [DEBUG] - import connect

[2024-01-24 16:35:33.239] [DEBUG] - add connect ref count to 1

[2024-01-24 16:35:33.239] [INFO] Connect observer(11.162.218.35:2881)

[2024-01-24 16:35:33.240] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:35:36.244] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:35:39.248] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:35:42.253] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:35:45.258] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:35:48.262] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:35:51.267] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:35:54.272] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:35:57.277] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:36:00.282] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:36:03.286] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:36:06.290] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:36:09.294] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:36:12.299] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:36:15.304] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:36:18.309] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:36:21.312] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:36:24.317] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:36:27.322] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:36:30.327] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:36:33.331] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:36:36.336] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:36:39.341] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:36:42.345] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:36:45.350] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:36:48.355] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:36:51.359] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:36:54.364] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:36:57.368] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:37:00.373] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:37:03.378] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:37:06.383] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:37:09.388] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:37:12.393] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:37:15.397] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:37:18.401] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:37:21.406] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:37:24.410] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:37:27.415] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:37:30.419] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:37:33.424] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:37:36.428] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:37:39.432] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:37:42.437] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:37:45.441] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:37:48.446] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:37:51.451] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:37:54.456] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:37:57.460] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:38:00.465] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:38:03.467] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:38:06.472] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:38:09.476] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:38:12.479] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:38:15.484] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:38:18.489] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:38:21.493] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:38:24.498] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:38:27.503] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:38:30.508] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:38:33.510] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:38:36.515] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:38:39.520] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:38:42.524] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:38:45.528] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:38:48.533] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:38:51.538] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:38:54.543] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:38:57.548] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:39:00.553] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:39:03.557] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:39:06.562] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:39:09.567] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:39:12.572] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:39:15.576] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:39:18.581] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:39:21.584] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:39:24.589] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:39:27.594] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:39:30.599] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:39:33.603] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:39:36.608] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:39:39.613] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:39:42.618] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:39:45.623] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:39:48.628] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:39:51.632] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:39:54.637] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:39:57.640] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:40:00.645] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:40:03.647] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:40:06.652] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:40:09.654] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:40:12.659] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:40:15.664] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:40:18.669] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:40:21.674] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:40:24.679] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:40:27.684] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:40:30.689] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -p

[2024-01-24 16:40:33.693] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq

[2024-01-24 16:40:33.696] [ERROR] Traceback (most recent call last):

[2024-01-24 16:40:33.696] [ERROR] File “core.py”, line 4117, in tpch

[2024-01-24 16:40:33.696] [ERROR] File “core.py”, line 188, in call_plugin

[2024-01-24 16:40:33.696] [ERROR] File “_plugin.py”, line 343, in call

[2024-01-24 16:40:33.696] [ERROR] File “_plugin.py”, line 302, in _new_func

[2024-01-24 16:40:33.696] [ERROR] File “/home/test2024/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 149, in connect

[2024-01-24 16:40:33.696] [ERROR] cursor = Cursor(ip=server.ip, port=server_config[‘mysql_port’], tenant=’’, password=password if password is not None else ‘’, stdio=stdio)

[2024-01-24 16:40:33.696] [ERROR] File “_stdio.py”, line 906, in wrapper

[2024-01-24 16:40:33.696] [ERROR] File “/home/test2024/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 46, in init

[2024-01-24 16:40:33.696] [ERROR] self._connect()

[2024-01-24 16:40:33.696] [ERROR] File “/home/test2024/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 76, in _connect

[2024-01-24 16:40:33.696] [ERROR] self.db = mysql.connect(host=self.ip, user=self.user, port=int(self.port), password=str(self.password),

[2024-01-24 16:40:33.696] [ERROR] File “pymysql/connections.py”, line 353, in init

[2024-01-24 16:40:33.696] [ERROR] File “pymysql/connections.py”, line 633, in connect

[2024-01-24 16:40:33.697] [ERROR] File “pymysql/connections.py”, line 907, in _request_authentication

[2024-01-24 16:40:33.697] [ERROR] File “pymysql/connections.py”, line 725, in _read_packet

[2024-01-24 16:40:33.697] [ERROR] File “pymysql/protocol.py”, line 221, in raise_for_error

[2024-01-24 16:40:33.697] [ERROR] File “pymysql/err.py”, line 143, in raise_mysql_exception

[2024-01-24 16:40:33.697] [ERROR] pymysql.err.OperationalError: (1045, “Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)”)

[2024-01-24 16:40:33.697] [ERROR]

[2024-01-24 16:40:36.807] [ERROR] OBD-1006: Failed to connect to oceanbase-ce

[2024-01-24 16:40:36.807] [DEBUG] - sub connect ref count to 0

[2024-01-24 16:40:36.807] [DEBUG] - export connect

[2024-01-24 16:40:36.807] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes .

[2024-01-24 16:40:36.807] [INFO] Trace ID: 890bcd50-ba93-11ee-8e8e-00163e0a13fc

[2024-01-24 16:40:36.807] [INFO] If you want to view detailed obd logs, please run: obd display-trace 890bcd50-ba93-11ee-8e8e-00163e0a13fc

[2024-01-24 16:40:36.807] [DEBUG] - share lock /home/test2024/.obd/lock/mirror_and_repo release, count 0

[2024-01-24 16:40:36.807] [DEBUG] - unlock /home/test2024/.obd/lock/mirror_and_repo

[2024-01-24 16:40:36.807] [DEBUG] - exclusive lock /home/test2024/.obd/lock/deploy_test2024_lzh_ob release, count 0

[2024-01-24 16:40:36.807] [DEBUG] - unlock /home/test2024/.obd/lock/deploy_test2024_lzh_ob

[2024-01-24 16:40:36.808] [DEBUG] - share lock /home/test2024/.obd/lock/global release, count 0

[2024-01-24 16:40:36.808] [DEBUG] - unlock /home/test2024/.obd/lock/global

#15

$obd display-trace 890bcd50-ba93-11ee-8e8e-00163e0a13fc | grep ERROR

[2024-01-24 16:40:33.696] [ERROR] Traceback (most recent call last):

[2024-01-24 16:40:33.696] [ERROR] File “core.py”, line 4117, in tpch

[2024-01-24 16:40:33.696] [ERROR] File “core.py”, line 188, in call_plugin

[2024-01-24 16:40:33.696] [ERROR] File “_plugin.py”, line 343, in call

[2024-01-24 16:40:33.696] [ERROR] File “_plugin.py”, line 302, in _new_func

[2024-01-24 16:40:33.696] [ERROR] File “/home/test2024/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 149, in connect

[2024-01-24 16:40:33.696] [ERROR] cursor = Cursor(ip=server.ip, port=server_config[‘mysql_port’], tenant=’’, password=password if password is not None else ‘’, stdio=stdio)

[2024-01-24 16:40:33.696] [ERROR] File “_stdio.py”, line 906, in wrapper

[2024-01-24 16:40:33.696] [ERROR] File “/home/test2024/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 46, in init

[2024-01-24 16:40:33.696] [ERROR] self._connect()

[2024-01-24 16:40:33.696] [ERROR] File “/home/test2024/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 76, in _connect

[2024-01-24 16:40:33.696] [ERROR] self.db = mysql.connect(host=self.ip, user=self.user, port=int(self.port), password=str(self.password),

[2024-01-24 16:40:33.696] [ERROR] File “pymysql/connections.py”, line 353, in init

[2024-01-24 16:40:33.696] [ERROR] File “pymysql/connections.py”, line 633, in connect

[2024-01-24 16:40:33.697] [ERROR] File “pymysql/connections.py”, line 907, in _request_authentication

[2024-01-24 16:40:33.697] [ERROR] File “pymysql/connections.py”, line 725, in _read_packet

[2024-01-24 16:40:33.697] [ERROR] File “pymysql/protocol.py”, line 221, in raise_for_error

[2024-01-24 16:40:33.697] [ERROR] File “pymysql/err.py”, line 143, in raise_mysql_exception

[2024-01-24 16:40:33.697] [ERROR] pymysql.err.OperationalError: (1045, “Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)”)

[2024-01-24 16:40:33.697] [ERROR]

[2024-01-24 16:40:36.807] [ERROR] OBD-1006: Failed to connect to oceanbase-ce

#16

obclient -h11.162.218.35 -P2881 -uroot -p’s3j2fjYw7rZ7plpJdfsq’ 能连上吗。