[2023-10-13 02:29:00.557] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 02:29:00.558] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] -- load /tmp/tpch100/nation.tbl [2023-10-13 02:29:00.558] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/tmp/tpch100/nation.tbl' into table nation fields terminated by '|';" [2023-10-13 02:29:01.504] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 02:29:01.504] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] -- load /tmp/tpch100/orders.tbl [2023-10-13 02:29:01.504] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/tmp/tpch100/orders.tbl' into table orders fields terminated by '|';" [2023-10-13 03:17:28.906] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] -- exited code 1, error output: [2023-10-13 03:17:28.907] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] ERROR 1048 (23000) at line 1: Column cannot be null [2023-10-13 03:17:28.907] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] [2023-10-13 03:17:28.980] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] -- load /tmp/tpch100/customer.tbl [2023-10-13 03:17:28.980] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/tmp/tpch100/customer.tbl' into table customer fields terminated by '|';" -- exited code 0 [2023-10-13 03:17:28.980] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] -- load /tmp/tpch100/lineitem.tbl [2023-10-13 03:17:28.980] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/tmp/tpch100/lineitem.tbl' into table lineitem fields terminated by '|';" -- exited code 0 [2023-10-13 03:17:28.980] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] -- load /tmp/tpch100/nation.tbl [2023-10-13 03:17:28.980] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/tmp/tpch100/nation.tbl' into table nation fields terminated by '|';" -- exited code 0 [2023-10-13 03:17:28.980] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] -- load /tmp/tpch100/orders.tbl [2023-10-13 03:17:28.980] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/tmp/tpch100/orders.tbl' into table orders fields terminated by '|';" -- exited code 1, error output: [2023-10-13 03:17:28.980] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] ERROR 1048 (23000) at line 1: Column cannot be null [2023-10-13 03:17:28.981] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] [2023-10-13 03:17:28.981] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] [2023-10-13 03:17:28.981] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] ERROR 1048 (23000) at line 1: Column cannot be null [2023-10-13 03:17:28.981] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] [2023-10-13 03:17:28.981] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] Traceback (most recent call last): [2023-10-13 03:17:28.981] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] File "core.py", line 3481, in tpch [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] File "core.py", line 184, in call_plugin [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] File "_plugin.py", line 324, in __call__ [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] File "_plugin.py", line 286, in _new_func [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] File "/home/user1/.obd/plugins/tpch/4.0.0.0/run_test.py", line 168, in run_test [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] raise Exception(ret.stderr) [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] Exception: ERROR 1048 (23000) at line 1: Column cannot be null [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [ERROR] [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] - sub run_test ref count to 0 [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] - export run_test [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes . [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] Trace ID: e0adc20e-6906-11ee-8485-6c0b848faf17 [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [INFO] If you want to view detailed obd logs, please run: obd display-trace e0adc20e-6906-11ee-8485-6c0b848faf17 [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] - share lock /home/user1/.obd/lock/mirror_and_repo release, count 0 [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] - unlock /home/user1/.obd/lock/mirror_and_repo [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] - exclusive lock /home/user1/.obd/lock/deploy_obtest release, count 0 [2023-10-13 03:17:28.982] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] - unlock /home/user1/.obd/lock/deploy_obtest [2023-10-13 03:17:28.983] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] - share lock /home/user1/.obd/lock/global release, count 0 [2023-10-13 03:17:28.983] [e0adc20e-6906-11ee-8485-6c0b848faf17] [DEBUG] - unlock /home/user1/.obd/lock/global [2023-10-13 10:08:45.906] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - cmd: ['obtest'] [2023-10-13 10:08:45.906] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - opts: {'component': None, 'test_server': None, 'user': 'root', 'password': None, 'tenant': 'tpch_test', 'database': 'test', 'obclient_bin': 'obclient', 'dbgen_bin': '/usr/tpc-h-tools/tpc-h-tools/bin/dbgen', 'scale_factor': 100, 'tmp_dir': '/home/user1/tpch100/tmp_dir1', 'ddl_path': None, 'tbl_path': None, 'sql_path': None, 'remote_tbl_dir': '/home/user1/tpch100', 'disable_transfer': None, 'dss_config': '/usr/tpc-h-tools/tpc-h-tools/', 'optimization': 0, 'test_only': None, 'skip_cluster_status_check': False} [2023-10-13 10:08:45.906] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - mkdir /home/user1/.obd/lock/ [2023-10-13 10:08:45.906] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - unknown lock mode [2023-10-13 10:08:45.906] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - try to get share lock /home/user1/.obd/lock/global [2023-10-13 10:08:45.906] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - share lock `/home/user1/.obd/lock/global`, count 1 [2023-10-13 10:08:45.906] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Get Deploy by name [2023-10-13 10:08:45.907] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - mkdir /home/user1/.obd/cluster/ [2023-10-13 10:08:45.907] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - mkdir /home/user1/.obd/config_parser/ [2023-10-13 10:08:45.907] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - try to get exclusive lock /home/user1/.obd/lock/deploy_obtest [2023-10-13 10:08:45.907] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - exclusive lock `/home/user1/.obd/lock/deploy_obtest`, count 1 [2023-10-13 10:08:45.912] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Check deploy status [2023-10-13 10:08:45.912] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Get deploy configuration [2023-10-13 10:08:45.937] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Get local repositories and plugins [2023-10-13 10:08:45.937] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - mkdir /home/user1/.obd/repository [2023-10-13 10:08:45.938] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Get local repository oceanbase-ce-4.2.0.0-None [2023-10-13 10:08:45.938] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - try to get share lock /home/user1/.obd/lock/mirror_and_repo [2023-10-13 10:08:45.938] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - share lock `/home/user1/.obd/lock/mirror_and_repo`, count 1 [2023-10-13 10:08:45.939] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Searching param plugin for components ... [2023-10-13 10:08:45.939] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Search param plugin for oceanbase-ce [2023-10-13 10:08:45.939] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - mkdir /home/user1/.obd/plugins [2023-10-13 10:08:45.940] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Found for oceanbase-ce-param-4.2.0.0 for oceanbase-ce-4.2.0.0 [2023-10-13 10:08:45.940] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Applying oceanbase-ce-param-4.2.0.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - mkdir /home/user1/.obd/repository [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - Get local repository oceanbase-ce-4.2.0.0-None [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - try to get share lock /home/user1/.obd/lock/mirror_and_repo [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - share lock `/home/user1/.obd/lock/mirror_and_repo`, count 1 [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - Searching param plugin for components ... [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - Search param plugin for oceanbase-ce [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - mkdir /home/user1/.obd/plugins [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - Found for oceanbase-ce-param-4.2.0.0 for oceanbase-ce-4.2.0.0 [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - Applying oceanbase-ce-param-4.2.0.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] [2023-10-13 10:08:46.385] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Open ssh connection [2023-10-13 10:08:46.777] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Cluster status check [2023-10-13 10:08:46.778] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Searching status plugin for components ... [2023-10-13 10:08:46.778] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Searching status plugin for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-13 10:08:46.778] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Found for oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.0.0 [2023-10-13 10:08:46.778] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Call oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-13 10:08:46.779] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - import status [2023-10-13 10:08:46.779] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - add status ref count to 1 [2023-10-13 10:08:46.779] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-13 10:08:46.793] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:46.793] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: ls /proc/19001 [2023-10-13 10:08:46.845] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:46.846] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.143 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-13 10:08:46.859] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:46.859] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.143 execute: ls /proc/19046 [2023-10-13 10:08:46.912] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:46.913] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@202.199.6.247 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-13 10:08:46.926] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:46.927] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@202.199.6.247 execute: ls /proc/15901 [2023-10-13 10:08:46.980] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:46.981] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.47 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-13 10:08:46.994] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:46.994] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.47 execute: ls /proc/20119 [2023-10-13 10:08:47.047] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:47.048] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.86 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-13 10:08:47.061] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:47.061] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.86 execute: ls /proc/20325 [2023-10-13 10:08:47.114] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:47.115] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.159 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-13 10:08:47.128] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:47.128] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.159 execute: ls /proc/20551 [2023-10-13 10:08:47.182] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:47.182] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - sub status ref count to 0 [2023-10-13 10:08:47.182] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - export status [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - Searching status plugin for components ... [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - Searching status plugin for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - Found for oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.0.0 [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - Call oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - import status [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - add status ref count to 1 [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: ls /proc/19001 -- exited code 0 [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.143 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.143 execute: ls /proc/19046 -- exited code 0 [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@202.199.6.247 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@202.199.6.247 execute: ls /proc/15901 -- exited code 0 [2023-10-13 10:08:47.299] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.47 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-13 10:08:47.300] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.47 execute: ls /proc/20119 -- exited code 0 [2023-10-13 10:08:47.300] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.86 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-13 10:08:47.300] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.86 execute: ls /proc/20325 -- exited code 0 [2023-10-13 10:08:47.300] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.159 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-13 10:08:47.300] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.159 execute: ls /proc/20551 -- exited code 0 [2023-10-13 10:08:47.300] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - sub status ref count to 0 [2023-10-13 10:08:47.300] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - export status [2023-10-13 10:08:47.300] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] [2023-10-13 10:08:47.300] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Call oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-13 10:08:47.300] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - import connect [2023-10-13 10:08:47.321] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - add connect ref count to 1 [2023-10-13 10:08:47.322] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Connect observer(219.216.64.127:2881) [2023-10-13 10:08:47.322] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- connect 219.216.64.127 -P2881 -uroot -plinux123 [2023-10-13 10:08:50.327] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- connect 219.216.64.127 -P2881 -uroot -p [2023-10-13 10:08:50.328] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- execute sql: select 1. args: None [2023-10-13 10:08:50.451] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- connect 219.216.64.127 -P2881 -uroot -plinux123 [2023-10-13 10:08:50.451] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- connect 219.216.64.127 -P2881 -uroot -p [2023-10-13 10:08:50.451] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- execute sql: select 1. args: None [2023-10-13 10:08:50.451] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] [2023-10-13 10:08:50.451] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - sub connect ref count to 0 [2023-10-13 10:08:50.451] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - export connect [2023-10-13 10:08:50.452] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Call tpch-py_script_pre_test-4.0.0.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-13 10:08:50.452] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - import pre_test [2023-10-13 10:08:50.453] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - add pre_test ref count to 1 [2023-10-13 10:08:50.453] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: dbgen_bin value /usr/tpc-h-tools/tpc-h-tools/bin/dbgen [2023-10-13 10:08:50.453] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: dss_config value /usr/tpc-h-tools/tpc-h-tools/ [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: scale_factor value 100 [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: disable_transfer value False [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: remote_tbl_dir value /home/user1/tpch100 [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: tenant value tpch_test [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: host value 219.216.64.127 [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: port value 2881 [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: database value test [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: user value root [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: password value [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: test_server value 219.216.64.127 [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: tmp_dir value /home/user1/tpch100/tmp_dir1 [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: ddl_path value [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get ddl_path: [2023-10-13 10:08:50.454] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- set ddl_path: ['/home/user1/.obd/plugins/tpch/4.0.0.0/create_tpch_mysql_table_part.ddl'] [2023-10-13 10:08:50.455] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: tbl_path value [2023-10-13 10:08:50.455] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get tbl_path: [2023-10-13 10:08:50.455] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: sql_path value [2023-10-13 10:08:50.455] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get sql_path: [2023-10-13 10:08:50.455] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- set sql_path: ['/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db20.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db16.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db6.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db11.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db13.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db14.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db9.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db3.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db1.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db4.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db21.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db12.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db8.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db10.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db19.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db5.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db7.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db2.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db22.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db15.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db17.sql', '/home/user1/.obd/plugins/tpch/4.0.0.0/queries/db18.sql'] [2023-10-13 10:08:50.455] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: obclient_bin value obclient [2023-10-13 10:08:50.455] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient --help [2023-10-13 10:08:50.459] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:08:50.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- mkdir /home/user1/tpch100/tmp_dir1 [2023-10-13 10:08:50.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- set tmp_dir: /home/user1/tpch100/tmp_dir1 [2023-10-13 10:08:50.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- execute sql: select * from oceanbase.DBA_OB_TENANTS where TENANT_NAME = tpch_test [2023-10-13 10:08:50.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- execute sql: select * from oceanbase.DBA_OB_TENANTS where TENANT_NAME = %s. args: ['tpch_test'] [2023-10-13 10:08:51.028] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- execute sql: select * from oceanbase.__all_resource_pool where tenant_id = 1008. args: None [2023-10-13 10:08:51.029] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- execute sql: select * from oceanbase.__all_unit_config where unit_config_id = 1002. args: None [2023-10-13 10:08:51.031] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- execute sql: select count(1) server_num from oceanbase.__all_server where status = 'active'. args: None [2023-10-13 10:08:51.032] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- get option: test_only value [2023-10-13 10:08:51.032] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: /usr/tpc-h-tools/tpc-h-tools/bin/dbgen -h [2023-10-13 10:08:51.044] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 1, error output: [2023-10-13 10:08:51.044] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] THE TPC SOFTWARE IS AVAILABLE WITHOUT CHARGE FROM TPC.TPC-H Population Generator (Version 3.0.0 build 0) [2023-10-13 10:08:51.044] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] Copyright Transaction Processing Performance Council 1994 - 2010 [2023-10-13 10:08:51.044] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] USAGE: [2023-10-13 10:08:51.044] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] dbgen [-{vf}][-T {pcsoPSOL}] [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] [-s ][-C ][-S ] [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] dbgen [-v] [-O m] [-s ] [-U ] [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] Basic Options [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] =========================== [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -C -- separate data set into chunks (requires -S, default: 1) [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -f -- force. Overwrite existing files [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -h -- display this message [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -q -- enable QUIET mode [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -s -- set Scale Factor (SF) to (default: 1) [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -S -- build the th step of the data/update set (used with -C or -U) [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -U -- generate update sets [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -v -- enable VERBOSE mode [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] Advanced Options [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] =========================== [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -b -- load distributions for (default: dists.dss) [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -d -- split deletes between files (requires -U) [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -i -- split inserts between files (requires -U) [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T c -- generate cutomers ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T l -- generate nation/region ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T L -- generate lineitem ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T n -- generate nation ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T o -- generate orders/lineitem ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T O -- generate orders ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T p -- generate parts/partsupp ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T P -- generate parts ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T r -- generate region ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T s -- generate suppliers ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -T S -- generate partsupp ONLY [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] To generate the SF=1 (1GB), validation database population, use: [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] dbgen -vf -s 1 [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] [2023-10-13 10:08:51.045] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] To generate updates for a SF=1 (1GB), use: [2023-10-13 10:08:51.046] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] dbgen -v -U 1 -s 1 [2023-10-13 10:08:51.046] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] [2023-10-13 10:08:51.046] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- mkdir /home/user1/tpch100/tmp_dir1/s100 [2023-10-13 10:08:51.046] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Generate Data (Scale Factor: 100) [2023-10-13 10:08:51.047] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: cd /home/user1/tpch100/tmp_dir1/s100; /usr/tpc-h-tools/tpc-h-tools/bin/dbgen -s 100 -b /usr/tpc-h-tools/tpc-h-tools/dists.dss [2023-10-13 10:31:51.987] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:31:52.109] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: cd /home/user1/tpch100/tmp_dir1/s100; /usr/tpc-h-tools/tpc-h-tools/bin/dbgen -s 100 -b /usr/tpc-h-tools/tpc-h-tools/dists.dss -- exited code 0 [2023-10-13 10:31:52.109] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] [2023-10-13 10:32:00.332] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Send tbl to remote (219.216.64.127) [2023-10-13 10:32:01.915] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - current remote_transporter RemoteTransporter.CLIENT [2023-10-13 10:32:01.916] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/supplier.tbl [2023-10-13 10:32:01.929] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:32:01.929] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/supplier.tbl to /home/user1/tpch100/supplier.tbl [2023-10-13 10:32:20.574] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/supplier.tbl [2023-10-13 10:32:20.614] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-13 10:32:20.615] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/customer.tbl [2023-10-13 10:32:20.668] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:32:20.668] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/customer.tbl to /home/user1/tpch100/customer.tbl [2023-10-13 10:33:47.629] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/customer.tbl [2023-10-13 10:33:47.642] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-13 10:33:47.642] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/orders.tbl [2023-10-13 10:33:47.694] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:33:47.695] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/orders.tbl to /home/user1/tpch100/orders.tbl [2023-10-13 10:40:06.002] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/orders.tbl [2023-10-13 10:40:06.035] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-13 10:40:06.035] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/lineitem.tbl [2023-10-13 10:40:06.119] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 10:40:06.119] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/lineitem.tbl to /home/user1/tpch100/lineitem.tbl [2023-10-13 11:08:59.219] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/lineitem.tbl [2023-10-13 11:09:01.595] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-13 11:09:01.595] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/part.tbl [2023-10-13 11:09:01.954] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:09:01.954] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/part.tbl to /home/user1/tpch100/part.tbl [2023-10-13 11:09:53.375] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/part.tbl [2023-10-13 11:09:53.388] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-13 11:09:53.388] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/partsupp.tbl [2023-10-13 11:09:53.441] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:09:53.441] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/partsupp.tbl to /home/user1/tpch100/partsupp.tbl [2023-10-13 11:14:10.123] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/partsupp.tbl [2023-10-13 11:14:10.159] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-13 11:14:10.159] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/nation.tbl [2023-10-13 11:14:10.251] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:10.252] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/nation.tbl to /home/user1/tpch100/nation.tbl [2023-10-13 11:14:10.306] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/nation.tbl [2023-10-13 11:14:10.319] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-13 11:14:10.320] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/region.tbl [2023-10-13 11:14:10.373] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:10.373] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/region.tbl to /home/user1/tpch100/region.tbl [2023-10-13 11:14:10.423] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/region.tbl [2023-10-13 11:14:10.435] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - current remote_transporter RemoteTransporter.CLIENT [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/supplier.tbl -- exited code 0 [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/supplier.tbl to /home/user1/tpch100/supplier.tbl [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/supplier.tbl - exited code 0 [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/customer.tbl -- exited code 0 [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/customer.tbl to /home/user1/tpch100/customer.tbl [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/customer.tbl - exited code 0 [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/orders.tbl -- exited code 0 [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/orders.tbl to /home/user1/tpch100/orders.tbl [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/orders.tbl - exited code 0 [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/lineitem.tbl -- exited code 0 [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/lineitem.tbl to /home/user1/tpch100/lineitem.tbl [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/lineitem.tbl - exited code 0 [2023-10-13 11:14:10.460] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/part.tbl -- exited code 0 [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/part.tbl to /home/user1/tpch100/part.tbl [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/part.tbl - exited code 0 [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/partsupp.tbl -- exited code 0 [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/partsupp.tbl to /home/user1/tpch100/partsupp.tbl [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/partsupp.tbl - exited code 0 [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/nation.tbl -- exited code 0 [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/nation.tbl to /home/user1/tpch100/nation.tbl [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/nation.tbl - exited code 0 [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/region.tbl -- exited code 0 [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/region.tbl to /home/user1/tpch100/region.tbl [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/region.tbl - exited code 0 [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- set tbl_path: ['/home/user1/tpch100/supplier.tbl', '/home/user1/tpch100/customer.tbl', '/home/user1/tpch100/orders.tbl', '/home/user1/tpch100/lineitem.tbl', '/home/user1/tpch100/part.tbl', '/home/user1/tpch100/partsupp.tbl', '/home/user1/tpch100/nation.tbl', '/home/user1/tpch100/region.tbl'] [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - sub pre_test ref count to 0 [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - export pre_test [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - Call tpch-py_script_run_test-4.0.0.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-13 11:14:10.461] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - import run_test [2023-10-13 11:14:10.491] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - add run_test ref count to 1 [2023-10-13 11:14:10.491] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -e "create database if not exists test" [2023-10-13 11:14:10.539] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:10.540] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -e "select version();" [2023-10-13 11:14:10.548] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:10.548] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-13 11:14:10.821] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:10.822] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.143 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-13 11:14:10.835] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:10.836] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@202.199.6.247 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-13 11:14:10.850] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:10.850] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.47 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-13 11:14:10.864] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:10.864] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.86 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-13 11:14:10.878] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:10.879] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- user1@219.216.64.159 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-13 11:14:10.892] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:10.893] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- execute sql: select value from oceanbase.__all_virtual_sys_variable where tenant_id = 1008 and name = 'secure_file_priv'. args: None [2023-10-13 11:14:10.896] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Format DDL [2023-10-13 11:14:10.896] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: sed /home/user1/.obd/plugins/tpch/4.0.0.0/create_tpch_mysql_table_part.ddl -e 's/partitions cpu_num/partitions 24/' > /home/user1/tpch100/tmp_dir1/create_tpch_mysql_table_part.ddl [2023-10-13 11:14:10.914] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:14:11.028] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: sed /home/user1/.obd/plugins/tpch/4.0.0.0/create_tpch_mysql_table_part.ddl -e 's/partitions cpu_num/partitions 24/' > /home/user1/tpch100/tmp_dir1/create_tpch_mysql_table_part.ddl -- exited code 0 [2023-10-13 11:14:11.028] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] [2023-10-13 11:14:11.028] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Create table [2023-10-13 11:14:11.028] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/tmp_dir1/create_tpch_mysql_table_part.ddl [2023-10-13 11:14:11.029] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test < /home/user1/tpch100/tmp_dir1/create_tpch_mysql_table_part.ddl [2023-10-13 11:15:28.694] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:15:28.710] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- load /home/user1/tpch100/tmp_dir1/create_tpch_mysql_table_part.ddl [2023-10-13 11:15:28.710] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test < /home/user1/tpch100/tmp_dir1/create_tpch_mysql_table_part.ddl -- exited code 0 [2023-10-13 11:15:28.710] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] [2023-10-13 11:15:28.710] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Load data [2023-10-13 11:15:28.711] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/supplier.tbl [2023-10-13 11:15:28.711] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/supplier.tbl' into table supplier fields terminated by '|';" [2023-10-13 11:16:17.397] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:16:17.398] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/customer.tbl [2023-10-13 11:16:17.398] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/customer.tbl' into table customer fields terminated by '|';" [2023-10-13 11:26:58.525] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 11:26:58.525] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/orders.tbl [2023-10-13 11:26:58.525] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/orders.tbl' into table orders fields terminated by '|';" [2023-10-13 13:01:54.929] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 13:01:54.929] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/lineitem.tbl [2023-10-13 13:01:54.929] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/lineitem.tbl' into table lineitem fields terminated by '|';" [2023-10-13 20:17:44.004] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 20:17:44.004] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/part.tbl [2023-10-13 20:17:44.004] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/part.tbl' into table part fields terminated by '|';" [2023-10-13 20:30:52.151] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 20:30:52.151] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/partsupp.tbl [2023-10-13 20:30:52.151] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/partsupp.tbl' into table partsupp fields terminated by '|';" [2023-10-13 21:29:01.107] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 21:29:01.108] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/nation.tbl [2023-10-13 21:29:01.108] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/nation.tbl' into table nation fields terminated by '|';" [2023-10-13 21:29:01.322] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 21:29:01.322] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/region.tbl [2023-10-13 21:29:01.322] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/region.tbl' into table region fields terminated by '|';" [2023-10-13 21:29:01.569] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- load /home/user1/tpch100/supplier.tbl [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/supplier.tbl' into table supplier fields terminated by '|';" -- exited code 0 [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- load /home/user1/tpch100/customer.tbl [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/customer.tbl' into table customer fields terminated by '|';" -- exited code 0 [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- load /home/user1/tpch100/orders.tbl [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/orders.tbl' into table orders fields terminated by '|';" -- exited code 0 [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- load /home/user1/tpch100/lineitem.tbl [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/lineitem.tbl' into table lineitem fields terminated by '|';" -- exited code 0 [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- load /home/user1/tpch100/part.tbl [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/part.tbl' into table part fields terminated by '|';" -- exited code 0 [2023-10-13 21:29:01.663] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- load /home/user1/tpch100/partsupp.tbl [2023-10-13 21:29:01.664] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/partsupp.tbl' into table partsupp fields terminated by '|';" -- exited code 0 [2023-10-13 21:29:01.664] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- load /home/user1/tpch100/nation.tbl [2023-10-13 21:29:01.664] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/nation.tbl' into table nation fields terminated by '|';" -- exited code 0 [2023-10-13 21:29:01.664] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- load /home/user1/tpch100/region.tbl [2023-10-13 21:29:01.664] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -c -e "load data /*+ parallel(24) */ infile '/home/user1/tpch100/region.tbl' into table region fields terminated by '|';" -- exited code 0 [2023-10-13 21:29:01.664] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] [2023-10-13 21:29:01.664] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Merge [2023-10-13 21:29:01.664] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] -- execute sql: select FROZEN_SCN, LAST_SCN from oceanbase.CDB_OB_MAJOR_COMPACTION where tenant_id = 1008. args: None [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [ERROR] OBD-5000: select FROZEN_SCN, LAST_SCN from oceanbase.CDB_OB_MAJOR_COMPACTION where tenant_id = 1008 execute failed [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - sub run_test ref count to 0 [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - export run_test [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes . [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Trace ID: 70c02c86-696d-11ee-ae4b-6c0b848faf17 [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] If you want to view detailed obd logs, please run: obd display-trace 70c02c86-696d-11ee-ae4b-6c0b848faf17 [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - share lock /home/user1/.obd/lock/mirror_and_repo release, count 0 [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - unlock /home/user1/.obd/lock/mirror_and_repo [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - exclusive lock /home/user1/.obd/lock/deploy_obtest release, count 0 [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - unlock /home/user1/.obd/lock/deploy_obtest [2023-10-13 21:29:01.665] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - share lock /home/user1/.obd/lock/global release, count 0 [2023-10-13 21:29:01.666] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [DEBUG] - unlock /home/user1/.obd/lock/global [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] -- execute sql: select FROZEN_SCN, LAST_SCN from oceanbase.CDB_OB_MAJOR_COMPACTION where tenant_id = 1008. args: None [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] [ERROR] OBD-5000: select FROZEN_SCN, LAST_SCN from oceanbase.CDB_OB_MAJOR_COMPACTION where tenant_id = 1008 execute failed [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - sub run_test ref count to 0 [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - export run_test [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes . [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] Trace ID: 70c02c86-696d-11ee-ae4b-6c0b848faf17 [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] If you want to view detailed obd logs, please run: obd display-trace 70c02c86-696d-11ee-ae4b-6c0b848faf17 [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - share lock /home/user1/.obd/lock/mirror_and_repo release, count 0 [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - unlock /home/user1/.obd/lock/mirror_and_repo [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - exclusive lock /home/user1/.obd/lock/deploy_obtest release, count 0 [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - unlock /home/user1/.obd/lock/deploy_obtest [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - share lock /home/user1/.obd/lock/global release, count 0 [2023-10-13 21:29:01.795] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO] - unlock /home/user1/.obd/lock/global [2023-10-13 21:29:01.796] [70c02c86-696d-11ee-ae4b-6c0b848faf17] [INFO]