【 使用环境 】测试环境内核 6.5.9-200
【 OB or 其他组件 】OB、OBD
【问题描述】进行TPCH测试，在Merge步骤报错：
[root@node zhangL]# obd test tpch testob --tenant=tpctest -s 10 --remote-tbl-dir=/tmp/tpch100
Get local repositories and plugins ok
Open ssh connection ok
Cluster status check ok
Connect to observer 127.0.0.1:2881 ok
Send tbl to remote (127.0.0.1) ok
Optimize for stage test ok
Format DDL ok
Create table ok
Load data ok
Merge x
[ERROR] ERROR 1049 (42000) at line 1: Unknown database ‘dbms_stats’
Recover ok
See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: 9ff9dbfa-8858-11ee-8b85-bc16951efd0d
If you want to view detailed obd logs, please run: obd display-trace 9ff9dbfa-8858-11ee-8b85-bc16951efd0d
【问题现象及影响】
根据提示查看日志：
[2023-11-21 05:05:49.027] [DEBUG] – local execute: obclient -h127.0.0.1 -P2881 -uroot@tpctest -A -D test -e “”“call dbms_stats.gather_table_stats(‘test’, ‘lineitem’, degree=>112, granularity=>‘GLOBAL’, method_opt=>‘FOR ALL COLUMNS SIZE AUTO’);
[2023-11-21 05:05:49.027] [DEBUG] call dbms_stats.gather_table_stats(‘test’, ‘orders’, degree=>112, granularity=>‘GLOBAL’, method_opt=>‘FOR ALL COLUMNS SIZE AUTO’);
[2023-11-21 05:05:49.027] [DEBUG] call dbms_stats.gather_table_stats(‘test’, ‘partsupp’, degree=>112, granularity=>‘GLOBAL’, method_opt=>‘FOR ALL COLUMNS SIZE AUTO’);
[2023-11-21 05:05:49.027] [DEBUG] call dbms_stats.gather_table_stats(‘test’, ‘part’, degree=>112, granularity=>‘GLOBAL’, method_opt=>‘FOR ALL COLUMNS SIZE AUTO’);
[2023-11-21 05:05:49.027] [DEBUG] call dbms_stats.gather_table_stats(‘test’, ‘customer’, degree=>112, granularity=>‘GLOBAL’, method_opt=>‘FOR ALL COLUMNS SIZE AUTO’);
[2023-11-21 05:05:49.027] [DEBUG] call dbms_stats.gather_table_stats(‘test’, ‘supplier’, degree=>112, granularity=>‘GLOBAL’, method_opt=>‘FOR ALL COLUMNS SIZE AUTO’);
[2023-11-21 05:05:49.027] [DEBUG] call dbms_stats.gather_table_stats(‘test’, ‘nation’, degree=>112, granularity=>‘AUTO’, method_opt=>‘FOR ALL COLUMNS SIZE AUTO’);
[2023-11-21 05:05:49.027] [DEBUG] call dbms_stats.gather_table_stats(‘test’, ‘region’, degree=>112, granularity=>‘AUTO’, method_opt=>‘FOR ALL COLUMNS SIZE AUTO’);”""
[2023-11-21 05:05:49.058] [DEBUG] – exited code 1, error output:
[2023-11-21 05:05:49.058] [DEBUG] ERROR 1049 (42000) at line 1: Unknown database ‘dbms_stats’
[2023-11-21 05:05:49.058] [DEBUG]
[2023-11-21 05:05:49.129] [ERROR] ERROR 1049 (42000) at line 1: Unknown database ‘dbms_stats’
[2023-11-21 05:05:49.129] [ERROR]
[2023-11-21 05:05:49.129] [ERROR] Traceback (most recent call last):
[2023-11-21 05:05:49.129] [ERROR] File “core.py”, line 3752, in tpch
[2023-11-21 05:05:49.129] [ERROR] File “core.py”, line 184, in call_plugin
[2023-11-21 05:05:49.129] [ERROR] File “_plugin.py”, line 324, in call
[2023-11-21 05:05:49.129] [ERROR] File “_plugin.py”, line 286, in _new_func
[2023-11-21 05:05:49.129] [ERROR] File “/root/.obd/plugins/tpch/4.2.0.0/run_test.py”, line 203, in run_test
[2023-11-21 05:05:49.129] [ERROR] raise Exception(ret.stderr)
[2023-11-21 05:05:49.129] [ERROR] Exception: ERROR 1049 (42000) at line 1: Unknown database ‘dbms_stats’
[2023-11-21 05:05:49.130] [ERROR]
[2023-11-21 05:05:49.130] [ERROR]