[2023-10-17 14:56:42.591] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - cmd: ['obtest'] [2023-10-17 14:56:42.591] [541c2cb0-6cba-11ee-8429-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-17 14:56:42.592] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - mkdir /home/user1/.obd/lock/ [2023-10-17 14:56:42.592] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - unknown lock mode [2023-10-17 14:56:42.592] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - try to get share lock /home/user1/.obd/lock/global [2023-10-17 14:56:42.592] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - share lock `/home/user1/.obd/lock/global`, count 1 [2023-10-17 14:56:42.592] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Get Deploy by name [2023-10-17 14:56:42.592] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - mkdir /home/user1/.obd/cluster/ [2023-10-17 14:56:42.592] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - mkdir /home/user1/.obd/config_parser/ [2023-10-17 14:56:42.593] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - try to get exclusive lock /home/user1/.obd/lock/deploy_obtest [2023-10-17 14:56:42.593] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - exclusive lock `/home/user1/.obd/lock/deploy_obtest`, count 1 [2023-10-17 14:56:42.598] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Check deploy status [2023-10-17 14:56:42.598] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Get deploy configuration [2023-10-17 14:56:42.623] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Get local repositories and plugins [2023-10-17 14:56:42.623] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - mkdir /home/user1/.obd/repository [2023-10-17 14:56:42.623] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Get local repository oceanbase-ce-4.2.0.0-None [2023-10-17 14:56:42.623] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - try to get share lock /home/user1/.obd/lock/mirror_and_repo [2023-10-17 14:56:42.623] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - share lock `/home/user1/.obd/lock/mirror_and_repo`, count 1 [2023-10-17 14:56:42.625] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Searching param plugin for components ... [2023-10-17 14:56:42.625] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Search param plugin for oceanbase-ce [2023-10-17 14:56:42.625] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - mkdir /home/user1/.obd/plugins [2023-10-17 14:56:42.625] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Found for oceanbase-ce-param-4.2.0.0 for oceanbase-ce-4.2.0.0 [2023-10-17 14:56:42.625] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Applying oceanbase-ce-param-4.2.0.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-17 14:56:43.080] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - mkdir /home/user1/.obd/repository [2023-10-17 14:56:43.080] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - Get local repository oceanbase-ce-4.2.0.0-None [2023-10-17 14:56:43.080] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - try to get share lock /home/user1/.obd/lock/mirror_and_repo [2023-10-17 14:56:43.080] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - share lock `/home/user1/.obd/lock/mirror_and_repo`, count 1 [2023-10-17 14:56:43.080] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - Searching param plugin for components ... [2023-10-17 14:56:43.081] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - Search param plugin for oceanbase-ce [2023-10-17 14:56:43.081] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - mkdir /home/user1/.obd/plugins [2023-10-17 14:56:43.081] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - Found for oceanbase-ce-param-4.2.0.0 for oceanbase-ce-4.2.0.0 [2023-10-17 14:56:43.081] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - Applying oceanbase-ce-param-4.2.0.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-17 14:56:43.081] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] [2023-10-17 14:56:43.081] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Open ssh connection [2023-10-17 14:56:43.473] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Cluster status check [2023-10-17 14:56:43.473] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Searching status plugin for components ... [2023-10-17 14:56:43.473] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Searching status plugin for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-17 14:56:43.474] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Found for oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.0.0 [2023-10-17 14:56:43.474] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Call oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-17 14:56:43.474] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - import status [2023-10-17 14:56:43.475] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - add status ref count to 1 [2023-10-17 14:56:43.475] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-17 14:56:43.488] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.488] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: ls /proc/19001 [2023-10-17 14:56:43.541] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.542] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.143 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-17 14:56:43.555] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.556] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.143 execute: ls /proc/19046 [2023-10-17 14:56:43.609] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.610] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@202.199.6.247 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-17 14:56:43.623] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.624] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@202.199.6.247 execute: ls /proc/15901 [2023-10-17 14:56:43.677] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.678] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.47 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-17 14:56:43.691] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.691] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.47 execute: ls /proc/20119 [2023-10-17 14:56:43.744] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.745] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.86 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-17 14:56:43.758] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.758] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.86 execute: ls /proc/20325 [2023-10-17 14:56:43.812] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.812] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.159 execute: cat /home/user1/obtest/oceanbase/run/observer.pid [2023-10-17 14:56:43.825] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.826] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.159 execute: ls /proc/20551 [2023-10-17 14:56:43.879] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:43.879] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - sub status ref count to 0 [2023-10-17 14:56:43.879] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - export status [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - Searching status plugin for components ... [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - Searching status plugin for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - Found for oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.0.0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - Call oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - import status [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - add status ref count to 1 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@219.216.64.127 execute: ls /proc/19001 -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@219.216.64.143 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@219.216.64.143 execute: ls /proc/19046 -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@202.199.6.247 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@202.199.6.247 execute: ls /proc/15901 -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@219.216.64.47 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@219.216.64.47 execute: ls /proc/20119 -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@219.216.64.86 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@219.216.64.86 execute: ls /proc/20325 -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@219.216.64.159 execute: cat /home/user1/obtest/oceanbase/run/observer.pid -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- user1@219.216.64.159 execute: ls /proc/20551 -- exited code 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - sub status ref count to 0 [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - export status [2023-10-17 14:56:43.996] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] [2023-10-17 14:56:43.997] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Call oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-17 14:56:43.997] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - import connect [2023-10-17 14:56:44.019] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - add connect ref count to 1 [2023-10-17 14:56:44.019] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Connect observer(219.216.64.127:2881) [2023-10-17 14:56:44.019] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- connect 219.216.64.127 -P2881 -uroot -plinux123 [2023-10-17 14:56:47.024] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- connect 219.216.64.127 -P2881 -uroot -p [2023-10-17 14:56:47.025] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- execute sql: select 1. args: None [2023-10-17 14:56:47.148] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- connect 219.216.64.127 -P2881 -uroot -plinux123 [2023-10-17 14:56:47.148] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- connect 219.216.64.127 -P2881 -uroot -p [2023-10-17 14:56:47.148] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- execute sql: select 1. args: None [2023-10-17 14:56:47.148] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] [2023-10-17 14:56:47.148] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - sub connect ref count to 0 [2023-10-17 14:56:47.148] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - export connect [2023-10-17 14:56:47.149] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Call tpch-py_script_pre_test-4.0.0.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-17 14:56:47.149] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - import pre_test [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - add pre_test ref count to 1 [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: dbgen_bin value /usr/tpc-h-tools/tpc-h-tools/bin/dbgen [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: dss_config value /usr/tpc-h-tools/tpc-h-tools/ [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: scale_factor value 100 [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: disable_transfer value False [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: remote_tbl_dir value /home/user1/tpch100 [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: tenant value tpch_test [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: host value 219.216.64.127 [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: port value 2881 [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: database value test [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: user value root [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: password value [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: test_server value 219.216.64.127 [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: tmp_dir value /home/user1/tpch100/tmp_dir1 [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: ddl_path value [2023-10-17 14:56:47.151] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get ddl_path: [2023-10-17 14:56:47.152] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- set ddl_path: ['/home/user1/.obd/plugins/tpch/4.0.0.0/create_tpch_mysql_table_part.ddl'] [2023-10-17 14:56:47.152] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: tbl_path value [2023-10-17 14:56:47.152] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get tbl_path: [2023-10-17 14:56:47.152] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: sql_path value [2023-10-17 14:56:47.152] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get sql_path: [2023-10-17 14:56:47.152] [541c2cb0-6cba-11ee-8429-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-17 14:56:47.152] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: obclient_bin value obclient [2023-10-17 14:56:47.152] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- local execute: obclient --help [2023-10-17 14:56:47.157] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:47.157] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- mkdir /home/user1/tpch100/tmp_dir1 [2023-10-17 14:56:47.157] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- set tmp_dir: /home/user1/tpch100/tmp_dir1 [2023-10-17 14:56:47.157] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- execute sql: select * from oceanbase.DBA_OB_TENANTS where TENANT_NAME = tpch_test [2023-10-17 14:56:47.158] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- execute sql: select * from oceanbase.DBA_OB_TENANTS where TENANT_NAME = %s. args: ['tpch_test'] [2023-10-17 14:56:48.514] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- execute sql: select * from oceanbase.__all_resource_pool where tenant_id = 1008. args: None [2023-10-17 14:56:48.516] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- execute sql: select * from oceanbase.__all_unit_config where unit_config_id = 1002. args: None [2023-10-17 14:56:48.518] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- execute sql: select count(1) server_num from oceanbase.__all_server where status = 'active'. args: None [2023-10-17 14:56:48.520] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- get option: test_only value [2023-10-17 14:56:48.520] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Send tbl to remote (219.216.64.127) [2023-10-17 14:56:48.580] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - current remote_transporter RemoteTransporter.CLIENT [2023-10-17 14:56:48.580] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/supplier.tbl [2023-10-17 14:56:48.596] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:48.596] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/supplier.tbl to /home/user1/tpch100/supplier.tbl [2023-10-17 14:56:51.788] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/supplier.tbl [2023-10-17 14:56:51.835] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-17 14:56:51.836] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/customer.tbl [2023-10-17 14:56:51.921] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:56:51.921] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/customer.tbl to /home/user1/tpch100/customer.tbl [2023-10-17 14:57:46.755] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/customer.tbl [2023-10-17 14:57:46.768] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-17 14:57:46.768] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/orders.tbl [2023-10-17 14:57:47.045] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 14:57:47.045] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/orders.tbl to /home/user1/tpch100/orders.tbl [2023-10-17 15:03:57.313] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/orders.tbl [2023-10-17 15:03:57.715] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-17 15:03:57.715] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/lineitem.tbl [2023-10-17 15:03:58.083] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:03:58.083] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/lineitem.tbl to /home/user1/tpch100/lineitem.tbl [2023-10-17 15:32:04.969] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/lineitem.tbl [2023-10-17 15:32:09.266] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-17 15:32:09.281] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/part.tbl [2023-10-17 15:32:09.417] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:32:09.417] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/part.tbl to /home/user1/tpch100/part.tbl [2023-10-17 15:32:59.120] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/part.tbl [2023-10-17 15:32:59.133] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-17 15:32:59.133] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/partsupp.tbl [2023-10-17 15:32:59.186] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:32:59.187] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/partsupp.tbl to /home/user1/tpch100/partsupp.tbl [2023-10-17 15:37:10.182] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/partsupp.tbl [2023-10-17 15:37:10.272] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-17 15:37:10.273] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/nation.tbl [2023-10-17 15:37:10.565] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:10.565] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/nation.tbl to /home/user1/tpch100/nation.tbl [2023-10-17 15:37:10.620] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/nation.tbl [2023-10-17 15:37:10.633] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-17 15:37:10.634] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: mkdir -p /home/user1/tpch100 && rm -fr /home/user1/tpch100/region.tbl [2023-10-17 15:37:10.687] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:10.687] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- send /home/user1/tpch100/tmp_dir1/s100/region.tbl to /home/user1/tpch100/region.tbl [2023-10-17 15:37:10.737] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/region.tbl [2023-10-17 15:37:10.749] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - exited code 0 [2023-10-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - current remote_transporter RemoteTransporter.CLIENT [2023-10-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-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-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/supplier.tbl to /home/user1/tpch100/supplier.tbl [2023-10-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/supplier.tbl - exited code 0 [2023-10-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-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-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/customer.tbl to /home/user1/tpch100/customer.tbl [2023-10-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/customer.tbl - exited code 0 [2023-10-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-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-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/orders.tbl to /home/user1/tpch100/orders.tbl [2023-10-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/orders.tbl - exited code 0 [2023-10-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-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-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/lineitem.tbl to /home/user1/tpch100/lineitem.tbl [2023-10-17 15:37:10.790] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/lineitem.tbl - exited code 0 [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-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-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/part.tbl to /home/user1/tpch100/part.tbl [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/part.tbl - exited code 0 [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-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-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/partsupp.tbl to /home/user1/tpch100/partsupp.tbl [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/partsupp.tbl - exited code 0 [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-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-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/nation.tbl to /home/user1/tpch100/nation.tbl [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/nation.tbl - exited code 0 [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-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-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- send /home/user1/tpch100/tmp_dir1/s100/region.tbl to /home/user1/tpch100/region.tbl [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - user1@219.216.64.127 execute: chmod 664 /home/user1/tpch100/region.tbl - exited code 0 [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-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-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - sub pre_test ref count to 0 [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - export pre_test [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - Call tpch-py_script_run_test-4.0.0.0 for oceanbase-ce-4.2.0.0-100010022023081817.el7-bf178e82c99ca1324a3df9e1a21cbbb8f8c4d46c [2023-10-17 15:37:10.791] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - import run_test [2023-10-17 15:37:10.842] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - add run_test ref count to 1 [2023-10-17 15:37:10.842] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -e "create database if not exists test" [2023-10-17 15:37:11.143] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:11.143] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- local execute: obclient -h219.216.64.127 -P2881 -uroot@tpch_test -A -D test -e "select version();" [2023-10-17 15:37:11.152] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:11.153] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.127 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-17 15:37:13.159] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:13.160] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.143 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-17 15:37:13.173] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:13.174] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@202.199.6.247 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-17 15:37:13.188] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:13.188] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.47 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-17 15:37:13.202] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:13.203] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.86 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-17 15:37:13.217] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:13.217] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- user1@219.216.64.159 execute: grep -e 'processor\s*:' /proc/cpuinfo | wc -l [2023-10-17 15:37:13.231] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:13.231] [541c2cb0-6cba-11ee-8429-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-17 15:37:13.281] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Format DDL [2023-10-17 15:37:13.282] [541c2cb0-6cba-11ee-8429-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-17 15:37:13.345] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:37:13.413] [541c2cb0-6cba-11ee-8429-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-17 15:37:13.413] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] [2023-10-17 15:37:13.413] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Create table [2023-10-17 15:37:13.414] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/tmp_dir1/create_tpch_mysql_table_part.ddl [2023-10-17 15:37:13.414] [541c2cb0-6cba-11ee-8429-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-17 15:38:18.127] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:38:18.193] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- load /home/user1/tpch100/tmp_dir1/create_tpch_mysql_table_part.ddl [2023-10-17 15:38:18.193] [541c2cb0-6cba-11ee-8429-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-17 15:38:18.193] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] [2023-10-17 15:38:18.194] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Load data [2023-10-17 15:38:18.194] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/supplier.tbl [2023-10-17 15:38:18.194] [541c2cb0-6cba-11ee-8429-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-17 15:38:59.776] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:38:59.776] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/customer.tbl [2023-10-17 15:38:59.776] [541c2cb0-6cba-11ee-8429-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-17 15:49:42.214] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 15:49:42.214] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/orders.tbl [2023-10-17 15:49:42.214] [541c2cb0-6cba-11ee-8429-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-17 17:24:12.495] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-17 17:24:12.495] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/lineitem.tbl [2023-10-17 17:24:12.495] [541c2cb0-6cba-11ee-8429-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-18 00:29:58.966] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-18 00:29:58.966] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/part.tbl [2023-10-18 00:29:58.966] [541c2cb0-6cba-11ee-8429-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-18 00:43:40.991] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-18 00:43:40.991] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/partsupp.tbl [2023-10-18 00:43:40.991] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.242] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-18 01:41:15.242] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/nation.tbl [2023-10-18 01:41:15.243] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.527] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-18 01:41:15.528] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- load /home/user1/tpch100/region.tbl [2023-10-18 01:41:15.528] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.663] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- exited code 0 [2023-10-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- load /home/user1/tpch100/supplier.tbl [2023-10-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- load /home/user1/tpch100/customer.tbl [2023-10-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- load /home/user1/tpch100/orders.tbl [2023-10-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- load /home/user1/tpch100/lineitem.tbl [2023-10-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- load /home/user1/tpch100/part.tbl [2023-10-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- load /home/user1/tpch100/partsupp.tbl [2023-10-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- load /home/user1/tpch100/nation.tbl [2023-10-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- load /home/user1/tpch100/region.tbl [2023-10-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-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-18 01:41:15.690] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] [2023-10-18 01:41:15.691] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Merge [2023-10-18 01:41:15.691] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] -- execute sql: select FROZEN_SCN, LAST_SCN from oceanbase.CDB_OB_MAJOR_COMPACTION where tenant_id = 1008. args: None [2023-10-18 01:41:15.691] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [ERROR] OBD-5000: select FROZEN_SCN, LAST_SCN from oceanbase.CDB_OB_MAJOR_COMPACTION where tenant_id = 1008 execute failed [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - sub run_test ref count to 0 [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - export run_test [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes . [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Trace ID: 541c2cb0-6cba-11ee-8429-6c0b848faf17 [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] If you want to view detailed obd logs, please run: obd display-trace 541c2cb0-6cba-11ee-8429-6c0b848faf17 [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - share lock /home/user1/.obd/lock/mirror_and_repo release, count 0 [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - unlock /home/user1/.obd/lock/mirror_and_repo [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - exclusive lock /home/user1/.obd/lock/deploy_obtest release, count 0 [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - unlock /home/user1/.obd/lock/deploy_obtest [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - share lock /home/user1/.obd/lock/global release, count 0 [2023-10-18 01:41:15.692] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [DEBUG] - unlock /home/user1/.obd/lock/global [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] -- execute sql: select FROZEN_SCN, LAST_SCN from oceanbase.CDB_OB_MAJOR_COMPACTION where tenant_id = 1008. args: None [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] [ERROR] OBD-5000: select FROZEN_SCN, LAST_SCN from oceanbase.CDB_OB_MAJOR_COMPACTION where tenant_id = 1008 execute failed [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - sub run_test ref count to 0 [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - export run_test [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes . [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] Trace ID: 541c2cb0-6cba-11ee-8429-6c0b848faf17 [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] If you want to view detailed obd logs, please run: obd display-trace 541c2cb0-6cba-11ee-8429-6c0b848faf17 [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - share lock /home/user1/.obd/lock/mirror_and_repo release, count 0 [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - unlock /home/user1/.obd/lock/mirror_and_repo [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - exclusive lock /home/user1/.obd/lock/deploy_obtest release, count 0 [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - unlock /home/user1/.obd/lock/deploy_obtest [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - share lock /home/user1/.obd/lock/global release, count 0 [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO] - unlock /home/user1/.obd/lock/global [2023-10-18 01:41:15.822] [541c2cb0-6cba-11ee-8429-6c0b848faf17] [INFO]