使用obd test进行tpc-c和tpc-h测试，报错显示：No such deploy
但是在OceanBase云平台上查看集群状态显示正在运行中：
终端：
1、确认执行 obd test 的命令是之前obd 部署OB集群的用户吗，obd相关操作是区分用户的。
2、如果操作系统用户没有问题，obd cluster list 看一下是否有name为 test2024_lzh_ob 的记录，
obd test tpch xxx 这里的名字是deploy_name,不一定对应的是集群名，需要确认一下。
我部署了三台集群，在其中一台上不会报错，是因为这台机器是OBProxy还是什么原因吗
obd 的环境只在最初部署集群的那个机器对应的用户下才有，其他机器/用户下是没有obd的。
明白，谢谢
后续测试时这个Access denied 指哪个权限不够
$obd test tpch test2024_lzh_ob --tenant=test_tpch -s 10 --remote-tbl-dir=/home/test2024/TPC-H3.0.1/dbgen/tpch10 --dbgen-bin=/home/test2024/TPC-H3.0.1/dbgen/dbgen --dss-config=/home/test2024/TPC-H3.0.1/dbgen/queries/ --test-server=11.162.218.35 --password=XXXXXX --tenant=test_tpch
Get local repositories and plugins ok
Open ssh connection ok
Cluster status check ok
Connect to observer 11.162.218.35:2881 ok
Send tbl to remote (11.162.218.35) ok
Optimize for stage test ok
[ERROR] ERROR 1045 (42000): Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
Recover ok
See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: a4a7f6e8-b5fb-11ee-b59b-00163e0a13fc
If you want to view detailed obd logs, please run: obd display-trace a4a7f6e8-b5fb-11ee-b59b-00163e0a13fc
麻烦贴一下执行结果看看：
obd display-trace a4a7f6e8-b5fb-11ee-b59b-00163e0a13fc
[test2024@obrd.32c.vd2-s2c0-n0 /home/test2024]
$obd display-trace a4a7f6e8-b5fb-11ee-b59b-00163e0a13fc
[2024-01-18 20:18:09.895] [DEBUG] - cmd: [‘test2024_lzh_ob’]
[2024-01-18 20:18:09.896] [DEBUG] - opts: {‘component’: None, ‘test_server’: ‘11.162.218.35’, ‘user’: ‘root’, ‘password’: ‘s3j2fjYw7rZ7plpJdfsq’, ‘tenant’: ‘test_tpch’, ‘database’: ‘test’, ‘obclient_bin’: ‘obclient’, ‘dbgen_bin’: ‘/home/test2024/TPC-H3.0.1/dbgen/dbgen’, ‘scale_factor’: 10, ‘tmp_dir’: ‘./tmp’, ‘ddl_path’: None, ‘tbl_path’: None, ‘sql_path’: None, ‘remote_tbl_dir’: ‘/home/test2024/TPC-H3.0.1/dbgen/tpch10’, ‘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-18 20:18:09.896] [DEBUG] - mkdir /home/test2024/.obd/lock/
[2024-01-18 20:18:09.896] [DEBUG] - unknown lock mode
[2024-01-18 20:18:09.896] [DEBUG] - try to get share lock /home/test2024/.obd/lock/global
[2024-01-18 20:18:09.896] [DEBUG] - share lock /home/test2024/.obd/lock/global, count 1
[2024-01-18 20:18:09.896] [DEBUG] - Get Deploy by name
[2024-01-18 20:18:09.896] [DEBUG] - mkdir /home/test2024/.obd/cluster/
[2024-01-18 20:18:09.896] [DEBUG] - mkdir /home/test2024/.obd/config_parser/
[2024-01-18 20:18:09.897] [DEBUG] - try to get exclusive lock /home/test2024/.obd/lock/deploy_test2024_lzh_ob
[2024-01-18 20:18:09.897] [DEBUG] - exclusive lock /home/test2024/.obd/lock/deploy_test2024_lzh_ob, count 1
[2024-01-18 20:18:09.904] [DEBUG] - Check deploy status
[2024-01-18 20:18:09.904] [DEBUG] - Get deploy configuration
[2024-01-18 20:18:09.929] [INFO] Get local repositories and plugins
[2024-01-18 20:18:09.929] [DEBUG] - mkdir /home/test2024/.obd/repository
[2024-01-18 20:18:09.930] [DEBUG] - Get local repository oceanbase-ce-4.2.1.3-None
[2024-01-18 20:18:09.930] [DEBUG] - try to get share lock /home/test2024/.obd/lock/mirror_and_repo
[2024-01-18 20:18:09.930] [DEBUG] - share lock /home/test2024/.obd/lock/mirror_and_repo, count 1
[2024-01-18 20:18:09.932] [DEBUG] - Searching param plugin for components …
[2024-01-18 20:18:09.932] [DEBUG] - Search param plugin for oceanbase-ce
[2024-01-18 20:18:09.932] [DEBUG] - mkdir /home/test2024/.obd/plugins
[2024-01-18 20:18:09.932] [DEBUG] - Found for oceanbase-ce-param-4.2.1.0 for oceanbase-ce-4.2.1.3
[2024-01-18 20:18:09.933] [DEBUG] - Applying oceanbase-ce-param-4.2.1.0 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b
[2024-01-18 20:18:10.496] [INFO] Open ssh connection
[2024-01-18 20:18:10.497] [DEBUG] - host: 11.162.218.58, port: 22, user: test2024, password: None
[2024-01-18 20:18:10.569] [DEBUG] - host: 11.162.218.226, port: 22, user: test2024, password: None
[2024-01-18 20:18:10.634] [DEBUG] - host: 11.162.218.35, port: 22, user: test2024, password: None
[2024-01-18 20:18:10.759] [INFO] Cluster status check
[2024-01-18 20:18:10.760] [DEBUG] - Searching status plugin for components …
[2024-01-18 20:18:10.760] [DEBUG] - Searching status plugin for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b
[2024-01-18 20:18:10.761] [DEBUG] - Found for oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.1.3
[2024-01-18 20:18:10.761] [DEBUG] - Call oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b
[2024-01-18 20:18:10.761] [DEBUG] - import status
[2024-01-18 20:18:10.762] [DEBUG] - add status ref count to 1
[2024-01-18 20:18:10.762] [DEBUG] – test2024@11.162.218.226 execute: cat /home/test2024/test2024_lzh_ob/oceanbase/run/observer.pid
[2024-01-18 20:18:10.821] [DEBUG] – exited code 0
[2024-01-18 20:18:10.822] [DEBUG] – test2024@11.162.218.226 execute: ls /proc/486727
[2024-01-18 20:18:10.918] [DEBUG] – exited code 0
[2024-01-18 20:18:10.919] [DEBUG] – test2024@11.162.218.35 execute: cat /home/test2024/test2024_lzh_ob/oceanbase/run/observer.pid
[2024-01-18 20:18:10.983] [DEBUG] – exited code 0
[2024-01-18 20:18:10.983] [DEBUG] – test2024@11.162.218.35 execute: ls /proc/51444
[2024-01-18 20:18:11.089] [DEBUG] – exited code 0
[2024-01-18 20:18:11.090] [DEBUG] – test2024@11.162.218.58 execute: cat /home/test2024/test2024_lzh_ob/oceanbase/run/observer.pid
[2024-01-18 20:18:11.199] [DEBUG] – exited code 0
[2024-01-18 20:18:11.200] [DEBUG] – test2024@11.162.218.58 execute: ls /proc/370076
[2024-01-18 20:18:11.344] [DEBUG] – exited code 0
[2024-01-18 20:18:11.345] [DEBUG] - sub status ref count to 0
[2024-01-18 20:18:11.345] [DEBUG] - export status
[2024-01-18 20:18:11.412] [DEBUG] - Call oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b
[2024-01-18 20:18:11.413] [DEBUG] - import connect
[2024-01-18 20:18:11.414] [DEBUG] - add connect ref count to 1
[2024-01-18 20:18:11.415] [INFO] Connect observer(11.162.218.35:2881)
[2024-01-18 20:18:11.415] [DEBUG] – connect 11.162.218.35 -P2881 -uroot -ps3j2fjYw7rZ7plpJdfsq
[2024-01-18 20:18:11.417] [DEBUG] – execute sql: select 1. args: None
[2024-01-18 20:18:11.546] [DEBUG] - sub connect ref count to 0
[2024-01-18 20:18:11.546] [DEBUG] - export connect
[2024-01-18 20:18:11.548] [DEBUG] - Call tpch-py_script_pre_test-4.0.0.0 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b
[2024-01-18 20:18:11.548] [DEBUG] - import pre_test
[2024-01-18 20:18:11.549] [DEBUG] - add pre_test ref count to 1
[2024-01-18 20:18:11.549] [DEBUG] – get option: dbgen_bin value /home/test2024/TPC-H3.0.1/dbgen/dbgen
[2024-01-18 20:18:11.550] [DEBUG] – get option: dss_config value /home/test2024/TPC-H3.0.1/dbgen/queries/
[2024-01-18 20:18:11.550] [DEBUG] – get option: scale_factor value 10
[2024-01-18 20:18:11.550] [DEBUG] – get option: disable_transfer value False
[2024-01-18 20:18:11.550] [DEBUG] – get option: remote_tbl_dir value /home/test2024/TPC-H3.0.1/dbgen/tpch10
[2024-01-18 20:18:11.550] [DEBUG] – get option: tenant value test_tpch
[2024-01-18 20:18:11.550] [DEBUG] – get option: host value 11.162.218.35
[2024-01-18 20:18:11.550] [DEBUG] – get option: port value 2881
[2024-01-18 20:18:11.550] [DEBUG] – get option: database value test
[2024-01-18 20:18:11.550] [DEBUG] – get option: user value root
[2024-01-18 20:18:11.550] [DEBUG] – get option: password value s3j2fjYw7rZ7plpJdfsq
[2024-01-18 20:18:11.550] [DEBUG] – get option: test_server value 11.162.218.35
[2024-01-18 20:18:11.550] [DEBUG] – get option: tmp_dir value ./tmp
[2024-01-18 20:18:11.550] [DEBUG] – get option: ddl_path value
[2024-01-18 20:18:11.550] [DEBUG] – get ddl_path:
[2024-01-18 20:18:11.550] [DEBUG] – set ddl_path: [’/home/test2024/.obd/plugins/tpch/4.0.0.0/create_tpch_mysql_table_part.ddl’]
[2024-01-18 20:18:11.550] [DEBUG] – get option: tbl_path value
[2024-01-18 20:18:11.550] [DEBUG] – get tbl_path:
[2024-01-18 20:18:11.551] [DEBUG] – get option: sql_path value
[2024-01-18 20:18:11.551] [DEBUG] – get sql_path:
[2024-01-18 20:18:11.551] [DEBUG] – set sql_path: [’/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db4.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db1.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db17.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db9.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db6.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db10.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db12.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db2.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db16.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db18.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db5.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db11.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db8.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db7.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db14.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db19.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db20.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db22.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db13.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db3.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db15.sql’, ‘/home/test2024/.obd/plugins/tpch/4.0.0.0/queries/db21.sql’]
[2024-01-18 20:18:11.551] [DEBUG] – get option: obclient_bin value obclient
[2024-01-18 20:18:11.551] [DEBUG] – local execute: obclient --help
[2024-01-18 20:18:11.558] [DEBUG] – exited code 0
[2024-01-18 20:18:11.558] [DEBUG] – mkdir /home/test2024/TPC-H3.0.1/dbgen/tmp
[2024-01-18 20:18:11.558] [DEBUG] – set tmp_dir: /home/test2024/TPC-H3.0.1/dbgen/tmp
[2024-01-18 20:18:11.558] [DEBUG] – execute sql: select * from oceanbase.DBA_OB_TENANTS where TENANT_NAME = test_tpch
[2024-01-18 20:18:11.558] [DEBUG] – execute sql: select * from oceanbase.DBA_OB_TENANTS where TENANT_NAME = %s. args: [‘test_tpch’]
[2024-01-18 20:18:11.603] [DEBUG] – execute sql: select * from oceanbase.__all_resource_pool where tenant_id = 1008. args: None
[2024-01-18 20:18:11.605] [DEBUG] – execute sql: select * from oceanbase.__all_unit_config where unit_config_id = 1007. args: None
[2024-01-18 20:18:11.607] [DEBUG] – execute sql: select count(1) server_num from oceanbase.__all_server where status = ‘active’. args: None
[2024-01-18 20:18:11.609] [DEBUG] – get option: test_only value
[2024-01-18 20:18:11.610] [INFO] Send tbl to remote (11.162.218.35)
[2024-01-18 20:18:11.737] [DEBUG] - local execute: rsync -h
[2024-01-18 20:18:11.743] [DEBUG] - exited code 0
[2024-01-18 20:18:11.743] [DEBUG] - test2024@11.162.218.35 execute: rsync -h
[2024-01-18 20:18:11.806] [DEBUG] - exited code 0
[2024-01-18 20:18:11.806] [DEBUG] - current remote_transporter RemoteTransporter.RSYNC
[2024-01-18 20:18:11.807] [DEBUG] – test2024@11.162.218.35 execute: mkdir -p /home/test2024/TPC-H3.0.1/dbgen/tpch10
[2024-01-18 20:18:11.906] [DEBUG] – exited code 0
[2024-01-18 20:18:11.906] [DEBUG] – send /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/part.tbl to /home/test2024/TPC-H3.0.1/dbgen/tpch10/part.tbl by rsync
[2024-01-18 20:18:11.907] [DEBUG] – local execute: rsync -a -W -e “ssh -p 22” /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/part.tbl test2024@11.162.218.35:/home/test2024/TPC-H3.0.1/dbgen/tpch10/part.tbl
[2024-01-18 20:18:12.134] [DEBUG] – exited code 0
[2024-01-18 20:18:12.134] [DEBUG] – test2024@11.162.218.35 execute: mkdir -p /home/test2024/TPC-H3.0.1/dbgen/tpch10
[2024-01-18 20:18:12.197] [DEBUG] – exited code 0
[2024-01-18 20:18:12.198] [DEBUG] – send /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/lineitem.tbl to /home/test2024/TPC-H3.0.1/dbgen/tpch10/lineitem.tbl by rsync
[2024-01-18 20:18:12.198] [DEBUG] – local execute: rsync -a -W -e “ssh -p 22” /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/lineitem.tbl test2024@11.162.218.35:/home/test2024/TPC-H3.0.1/dbgen/tpch10/lineitem.tbl
[2024-01-18 20:18:12.420] [DEBUG] – exited code 0
[2024-01-18 20:18:12.421] [DEBUG] – test2024@11.162.218.35 execute: mkdir -p /home/test2024/TPC-H3.0.1/dbgen/tpch10
[2024-01-18 20:18:12.485] [DEBUG] – exited code 0
[2024-01-18 20:18:12.485] [DEBUG] – send /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/customer.tbl to /home/test2024/TPC-H3.0.1/dbgen/tpch10/customer.tbl by rsync
[2024-01-18 20:18:12.485] [DEBUG] – local execute: rsync -a -W -e “ssh -p 22” /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/customer.tbl test2024@11.162.218.35:/home/test2024/TPC-H3.0.1/dbgen/tpch10/customer.tbl
[2024-01-18 20:18:12.700] [DEBUG] – exited code 0
[2024-01-18 20:18:12.700] [DEBUG] – test2024@11.162.218.35 execute: mkdir -p /home/test2024/TPC-H3.0.1/dbgen/tpch10
[2024-01-18 20:18:12.758] [DEBUG] – exited code 0
[2024-01-18 20:18:12.759] [DEBUG] – send /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/orders.tbl to /home/test2024/TPC-H3.0.1/dbgen/tpch10/orders.tbl by rsync
[2024-01-18 20:18:12.759] [DEBUG] – local execute: rsync -a -W -e “ssh -p 22” /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/orders.tbl test2024@11.162.218.35:/home/test2024/TPC-H3.0.1/dbgen/tpch10/orders.tbl
[2024-01-18 20:18:12.974] [DEBUG] – exited code 0
[2024-01-18 20:18:12.975] [DEBUG] – test2024@11.162.218.35 execute: mkdir -p /home/test2024/TPC-H3.0.1/dbgen/tpch10
[2024-01-18 20:18:13.030] [DEBUG] – exited code 0
[2024-01-18 20:18:13.031] [DEBUG] – send /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/nation.tbl to /home/test2024/TPC-H3.0.1/dbgen/tpch10/nation.tbl by rsync
[2024-01-18 20:18:13.031] [DEBUG] – local execute: rsync -a -W -e “ssh -p 22” /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/nation.tbl test2024@11.162.218.35:/home/test2024/TPC-H3.0.1/dbgen/tpch10/nation.tbl
[2024-01-18 20:18:13.253] [DEBUG] – exited code 0
[2024-01-18 20:18:13.254] [DEBUG] – test2024@11.162.218.35 execute: mkdir -p /home/test2024/TPC-H3.0.1/dbgen/tpch10
[2024-01-18 20:18:13.311] [DEBUG] – exited code 0
[2024-01-18 20:18:13.312] [DEBUG] – send /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/supplier.tbl to /home/test2024/TPC-H3.0.1/dbgen/tpch10/supplier.tbl by rsync
[2024-01-18 20:18:13.312] [DEBUG] – local execute: rsync -a -W -e “ssh -p 22” /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/supplier.tbl test2024@11.162.218.35:/home/test2024/TPC-H3.0.1/dbgen/tpch10/supplier.tbl
[2024-01-18 20:18:13.532] [DEBUG] – exited code 0
[2024-01-18 20:18:13.533] [DEBUG] – test2024@11.162.218.35 execute: mkdir -p /home/test2024/TPC-H3.0.1/dbgen/tpch10
[2024-01-18 20:18:13.589] [DEBUG] – exited code 0
[2024-01-18 20:18:13.589] [DEBUG] – send /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/partsupp.tbl to /home/test2024/TPC-H3.0.1/dbgen/tpch10/partsupp.tbl by rsync
[2024-01-18 20:18:13.589] [DEBUG] – local execute: rsync -a -W -e “ssh -p 22” /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/partsupp.tbl test2024@11.162.218.35:/home/test2024/TPC-H3.0.1/dbgen/tpch10/partsupp.tbl
[2024-01-18 20:18:13.807] [DEBUG] – exited code 0
[2024-01-18 20:18:13.808] [DEBUG] – test2024@11.162.218.35 execute: mkdir -p /home/test2024/TPC-H3.0.1/dbgen/tpch10
[2024-01-18 20:18:13.866] [DEBUG] – exited code 0
[2024-01-18 20:18:13.867] [DEBUG] – send /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/region.tbl to /home/test2024/TPC-H3.0.1/dbgen/tpch10/region.tbl by rsync
[2024-01-18 20:18:13.867] [DEBUG] – local execute: rsync -a -W -e “ssh -p 22” /home/test2024/TPC-H3.0.1/dbgen/tmp/s10/region.tbl test2024@11.162.218.35:/home/test2024/TPC-H3.0.1/dbgen/tpch10/region.tbl
[2024-01-18 20:18:14.082] [DEBUG] – exited code 0
[2024-01-18 20:18:14.089] [DEBUG] – set tbl_path: [’/home/test2024/TPC-H3.0.1/dbgen/tpch10/part.tbl’, ‘/home/test2024/TPC-H3.0.1/dbgen/tpch10/lineitem.tbl’, ‘/home/test2024/TPC-H3.0.1/dbgen/tpch10/customer.tbl’, ‘/home/test2024/TPC-H3.0.1/dbgen/tpch10/orders.tbl’, ‘/home/test2024/TPC-H3.0.1/dbgen/tpch10/nation.tbl’, ‘/home/test2024/TPC-H3.0.1/dbgen/tpch10/supplier.tbl’, ‘/home/test2024/TPC-H3.0.1/dbgen/tpch10/partsupp.tbl’, ‘/home/test2024/TPC-H3.0.1/dbgen/tpch10/region.tbl’]
[2024-01-18 20:18:14.089] [DEBUG] - sub pre_test ref count to 0
[2024-01-18 20:18:14.089] [DEBUG] - export pre_test
[2024-01-18 20:18:14.090] [DEBUG] - mkdir /home/test2024/.obd/optimize/
[2024-01-18 20:18:14.090] [DEBUG] - register component oceanbase-ce-4.2.1.3 to optimize manager
[2024-01-18 20:18:14.090] [DEBUG] - register component obproxy-ce-4.2.1.0 to optimize manager
[2024-01-18 20:18:14.090] [DEBUG] - register component obagent-4.2.1 to optimize manager
[2024-01-18 20:18:14.090] [DEBUG] - register component ocp-express-4.2.1 to optimize manager
[2024-01-18 20:18:14.090] [DEBUG] - load default optimize config for tpch
[2024-01-18 20:18:14.090] [DEBUG] - load optimize parser: /home/test2024/.obd/optimize/optimize_parser/0.1/optimize_parser.py
[2024-01-18 20:18:14.090] [DEBUG] - import optimize_parser
[2024-01-18 20:18:14.094] [DEBUG] - add optimize_parser ref count to 1
[2024-01-18 20:18:14.095] [DEBUG] - yaml file /home/test2024/.obd/optimize/oceanbase-ce/4.2.1.3/optimizer.yaml not found, try to get earlier version.
[2024-01-18 20:18:14.095] [DEBUG] - find earlier version yaml file: /home/test2024/.obd/optimize/oceanbase-ce/4.1.0/optimizer.yaml
[2024-01-18 20:18:14.100] [DEBUG] - yaml file /home/test2024/.obd/optimize/obproxy-ce/4.2.1.0/optimizer.yaml not found, try to get earlier version.
[2024-01-18 20:18:14.100] [DEBUG] - try to use top yaml file: /home/test2024/.obd/optimize/obproxy-ce/optimizer.yaml
[2024-01-18 20:18:14.101] [DEBUG] - no optimize config for component obagent
[2024-01-18 20:18:14.101] [DEBUG] - no optimize config for component ocp-express
[2024-01-18 20:18:14.101] [DEBUG] - yaml file /home/test2024/.obd/optimize/oceanbase-ce/4.2.1.3/tpch.yaml not found, try to get earlier version.
[2024-01-18 20:18:14.102] [DEBUG] - find earlier version yaml file: /home/test2024/.obd/optimize/oceanbase-ce/4.2.0/tpch.yaml
[2024-01-18 20:18:14.102] [DEBUG] - open /home/test2024/.obd/optimize/oceanbase-ce/4.2.0/tpch.yaml for rb
[2024-01-18 20:18:14.109] [DEBUG] - yaml file /home/test2024/.obd/optimize/obproxy-ce/4.2.1.0/tpch.yaml not found, try to get earlier version.
[2024-01-18 20:18:14.110] [DEBUG] - try to use top yaml file: /home/test2024/.obd/optimize/obproxy-ce/tpch.yaml
[2024-01-18 20:18:14.110] [DEBUG] - No such yaml file: /home/test2024/.obd/optimize/obproxy-ce/tpch.yaml
[2024-01-18 20:18:14.110] [DEBUG] - no optimize config for component obagent
[2024-01-18 20:18:14.110] [DEBUG] - no optimize config for component ocp-express
[2024-01-18 20:18:14.110] [DEBUG] - Get optimize config
[2024-01-18 20:18:14.111] [DEBUG] - Call optimize-py_script_check_options-0.1 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b
[2024-01-18 20:18:14.111] [DEBUG] - import check_options
[2024-01-18 20:18:14.111] [DEBUG] - add check_options ref count to 1
[2024-01-18 20:18:14.112] [DEBUG] - sub check_options ref count to 0
[2024-01-18 20:18:14.112] [DEBUG] - export check_options
[2024-01-18 20:18:14.112] [DEBUG] - Optimize for stage test
[2024-01-18 20:18:14.112] [DEBUG] - Call optimize-py_script_optimize-0.1 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b
[2024-01-18 20:18:14.113] [DEBUG] - import optimize
[2024-01-18 20:18:14.113] [DEBUG] - add optimize ref count to 1
[2024-01-18 20:18:14.114] [INFO] Optimize for stage test
[2024-01-18 20:18:14.114] [DEBUG] – optimize_envs: {‘obclient_bin’: ‘obclient’, ‘host’: ‘11.162.218.35’, ‘port’: 2881, ‘user’: ‘root’, ‘password’: ‘s3j2fjYw7rZ7plpJdfsq’, ‘database’: ‘test’, ‘max_cpu’: 8.0, ‘min_memory’: 1073741824, ‘unit_count’: 1, ‘server_num’: 3, ‘tenant’: ‘test_tpch’, ‘tenant_id’: 1008, ‘format_size’: <function format_size at 0x7f886a21a550>}
[2024-01-18 20:18:14.115] [DEBUG] – execute sql: select value from oceanbase.__all_virtual_sys_parameter_stat where name=“enable_sql_audit”. args: None
[2024-01-18 20:18:14.120] [DEBUG] – origin_value False(str) target_value False(bool) condition lambda n, o: n != o
[2024-01-18 20:18:14.121] [DEBUG] – execute sql: alter system set enable_sql_audit=%s. args: (False,)
[2024-01-18 20:18:14.129] [DEBUG] – execute sql: select value from oceanbase.__all_virtual_sys_parameter_stat where name=“syslog_level”. args: None
[2024-01-18 20:18:14.133] [DEBUG] – origin_value PERF(str) target_value PERF(str) condition lambda n, o: n != o
[2024-01-18 20:18:14.133] [DEBUG] – execute sql: select value from oceanbase.__all_virtual_sys_parameter_stat where name=“enable_perf_event”. args: None
[2024-01-18 20:18:14.137] [DEBUG] – origin_value False(str) target_value False(bool) condition lambda n, o: n != o
[2024-01-18 20:18:14.137] [DEBUG] – execute sql: alter system set enable_perf_event=%s. args: (False,)
[2024-01-18 20:18:14.146] [DEBUG] – execute sql: select value from oceanbase.__all_virtual_sys_parameter_stat where name=“enable_record_trace_log”. args: None
[2024-01-18 20:18:14.149] [DEBUG] – origin_value False(str) target_value false(str) condition lambda n, o: n != o
[2024-01-18 20:18:14.150] [DEBUG] – execute sql: alter system set enable_record_trace_log=%s. args: (‘false’,)
[2024-01-18 20:18:14.157] [DEBUG] – optimize SystemConfigEntrance success
[2024-01-18 20:18:14.158] [DEBUG] – execute sql: select value from oceanbase.__all_virtual_sys_variable where tenant_id = 1008 and name = ‘ob_sql_work_area_percentage’. args: None
[2024-01-18 20:18:14.161] [DEBUG] – origin_value 80(int) target_value 80(int) condition lambda n, o: n != o
[2024-01-18 20:18:14.162] [DEBUG] – execute sql: select value from oceanbase.__all_virtual_sys_variable where tenant_id = 1008 and name = ‘ob_query_timeout’. args: None
[2024-01-18 20:18:14.164] [DEBUG] – origin_value 36000000000(int) target_value 36000000000(int) condition lambda n, o: n != o
[2024-01-18 20:18:14.165] [DEBUG] – execute sql: select value from oceanbase.__all_virtual_sys_variable where tenant_id = 1008 and name = ‘ob_trx_timeout’. args: None
[2024-01-18 20:18:14.166] [DEBUG] – origin_value 36000000000(int) target_value 36000000000(int) condition lambda n, o: n != o
[2024-01-18 20:18:14.167] [DEBUG] – execute sql: select value from oceanbase.__all_virtual_sys_variable where tenant_id = 1008 and name = ‘max_allowed_packet’. args: None
[2024-01-18 20:18:14.168] [DEBUG] – origin_value 67108864(int) target_value 67108864(int) condition lambda n, o: n != o
[2024-01-18 20:18:14.169] [DEBUG] – execute sql: select value from oceanbase.__all_virtual_sys_variable where tenant_id = 1008 and name = ‘secure_file_priv’. args: None
[2024-01-18 20:18:14.171] [DEBUG] – origin_value (str) target_value /(str) condition lambda n, o: n != o
[2024-01-18 20:18:14.172] [DEBUG] – execute sql: ALTER TENANT test_tpch SET VARIABLES secure_file_priv = %s. args: (’/’,)
[2024-01-18 20:18:14.220] [DEBUG] – execute sql: select value from oceanbase.__all_virtual_sys_variable where tenant_id = 1008 and name = ‘parallel_servers_target’. args: None
[2024-01-18 20:18:14.221] [DEBUG] – origin_value 90(int) target_value 192(int) condition lambda n, o: n != o
[2024-01-18 20:18:14.222] [DEBUG] – execute sql: ALTER TENANT test_tpch SET VARIABLES parallel_servers_target = %s. args: (192,)
[2024-01-18 20:18:14.271] [DEBUG] – optimize VariableEntrance success
[2024-01-18 20:18:14.272] [DEBUG] – execute sql: alter system flush plan cache global. args: None
[2024-01-18 20:18:14.325] [DEBUG] – optimize ExecSqlEntrance success
[2024-01-18 20:18:14.375] [DEBUG] - sub optimize ref count to 0
[2024-01-18 20:18:14.375] [DEBUG] - export optimize
[2024-01-18 20:18:14.375] [DEBUG] - Call tpch-py_script_run_test-4.2.0.0 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b
[2024-01-18 20:18:14.376] [DEBUG] - import run_test
[2024-01-18 20:18:14.378] [DEBUG] - add run_test ref count to 1
[2024-01-18 20:18:14.378] [DEBUG] – local execute: obclient -h11.162.218.35 -P2881 -uroot@test_tpch -p’s3j2fjYw7rZ7plpJdfsq’ -A -e “create database if not exists test”
[2024-01-18 20:18:14.389] [DEBUG] – exited code 1, error output:
[2024-01-18 20:18:14.389] [DEBUG] ERROR 1045 (42000): Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
[2024-01-18 20:18:14.389] [DEBUG]
[2024-01-18 20:18:14.389] [ERROR] ERROR 1045 (42000): Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
[2024-01-18 20:18:14.389] [ERROR]
[2024-01-18 20:18:14.389] [DEBUG] - sub run_test ref count to 0
[2024-01-18 20:18:14.389] [DEBUG] - export run_test
[2024-01-18 20:18:14.390] [DEBUG] - Recover the optimizes
[2024-01-18 20:18:14.391] [DEBUG] - Call optimize-py_script_recover-0.1 for oceanbase-ce-4.2.1.3-103000032023122818.el7-92798718ffdffd15b269c70bfc71e9f31e8d642b
[2024-01-18 20:18:14.391] [DEBUG] - import recover
[2024-01-18 20:18:14.391] [DEBUG] - add recover ref count to 1
[2024-01-18 20:18:14.392] [INFO] Recover
[2024-01-18 20:18:14.394] [DEBUG] – execute sql: ALTER TENANT test_tpch SET VARIABLES parallel_servers_target = %s. args: (90,)
[2024-01-18 20:18:14.467] [DEBUG] – execute sql: ALTER TENANT test_tpch SET VARIABLES secure_file_priv = %s. args: (’’,)
[2024-01-18 20:18:14.515] [DEBUG] – execute sql: alter system set enable_record_trace_log=%s. args: (‘False’,)
[2024-01-18 20:18:14.529] [DEBUG] – execute sql: alter system set enable_perf_event=%s. args: (‘False’,)
[2024-01-18 20:18:14.538] [DEBUG] – execute sql: alter system set enable_sql_audit=%s. args: (‘False’,)
[2024-01-18 20:18:14.655] [DEBUG] - sub recover ref count to 0
[2024-01-18 20:18:14.656] [DEBUG] - export recover
[2024-01-18 20:18:14.656] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes .
[2024-01-18 20:18:14.656] [INFO] Trace ID: a4a7f6e8-b5fb-11ee-b59b-00163e0a13fc
[2024-01-18 20:18:14.656] [INFO] If you want to view detailed obd logs, please run: obd display-trace a4a7f6e8-b5fb-11ee-b59b-00163e0a13fc
[2024-01-18 20:18:14.656] [DEBUG] - share lock /home/test2024/.obd/lock/mirror_and_repo release, count 0
[2024-01-18 20:18:14.656] [DEBUG] - unlock /home/test2024/.obd/lock/mirror_and_repo
[2024-01-18 20:18:14.656] [DEBUG] - exclusive lock /home/test2024/.obd/lock/deploy_test2024_lzh_ob release, count 0
[2024-01-18 20:18:14.656] [DEBUG] - unlock /home/test2024/.obd/lock/deploy_test2024_lzh_ob
[2024-01-18 20:18:14.656] [DEBUG] - share lock /home/test2024/.obd/lock/global release, count 0
[2024-01-18 20:18:14.656] [DEBUG] - unlock /home/test2024/.obd/lock/global
[2024-01-18 20:18:14.378] [DEBUG] – local execute: obclient -h11.162.218.35 -P2881 -uroot@test_tpch -p’s3j2fjYw7rZ7plpJdfsq’ -A -e “create database if not exists test”
[2024-01-18 20:18:14.389] [DEBUG] – exited code 1, error output:
手动命令行验证一下这里看起来登录失败
obclient -h11.162.218.35 -P2881 -uroot@test_tpch -p’s3j2fjYw7rZ7plpJdfsq’ -A
在sys租户oceanbase库下去确认一下 test_tpch 租户IP白名单：
select name,value from CDB_OB_SYS_VARIABLES
where tenant_id=(select tenant_id from dba_ob_tenants where tenant_name=‘test_tpch’)
and name like ‘%tcp%’;
默认只允许127.0.0.1 本地登录，可以按需调整，也可以调整为‘%’ 允许所有IP访问
alter tenant test_tpch set variables ob_tcp_invited_nodes=’%’;
再次验证：obclient -h11.162.218.35 -P2881 -uroot@test_tpch -p’s3j2fjYw7rZ7plpJdfsq’ -A
确认没有问题了，再执行 obd test 命令。
obclient [oceanbase]> select name, value from CDB_OB_SYS_VARIABLES where tenant_id=(select tenant_id from dba_ob_tenants where tenant_name=‘test_tpch’) and name like ‘%tcp’;
Empty set (0.003 sec)
obclient [oceanbase]> alter tenant test_tpch set variables ob_tcp_invited_nodes=’%’;
Query OK, 0 rows affected (0.002 sec)
为什么会查不到这个用户
租户可以类比MySQL的一个实例，用户概念和MySQL一致，看你截图的是租户列表的，是存在 test_tpch 这个租户的。
我在OceanBase云平台上查看test_tpch这个租户的白名单是这样，为什么还是会
Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
确认root用户的密码是否正确了。