Vallishp commented on PR #43107: URL: https://github.com/apache/doris/pull/43107#issuecomment-2481315759
> What's more, if you considerring a regression test contains restart fe, decommission be, ... . Then I recommand you can add a docker suite test. It can run a suite in an new creatting and indepent docker cluster. Docker suite example can see: demo_p0/docker_action.groovy. > > Notice the github pr regression pipeline wouldn't run the docker suite test. Only selectdb's daily internal pipeline will run the docker suite test. If add a docker suite, the pr author need to run it local and pass the test. > > Yet this pr no need to add docker suites if you think your regression test is ok. 024-11-17 20:52:04.842 INFO [script-thread-6] (SuiteScript.groovy:48) - run /home/vallish/doris/workspace/doris/regression-test/suites/catalog_recycle_bin_p0/test_truncate_recover_restart_fe.groovy 2024-11-17 20:52:04.848 INFO [script-thread-6] (SuiteContext.groovy:101) - packageName: catalog_recycle_bin_p0/test_truncate_recover_restart_fe.groovy 2024-11-17 20:52:04.848 INFO [script-thread-6] (SuiteContext.groovy:112) - scriptFileName: test_truncate_recover_restart_fe.groovy 2024-11-17 20:52:04.848 INFO [script-thread-6] (SuiteContext.groovy:96) - flowName: catalog_recycle_bin_p0.test_truncate_recover_restart_fe.test_truncate_recover_restart_fe, flowId: catalog_recycle_bin_p0/test_truncate_recover_restart_fe.groovy#test_truncate_recover_restart_fe 2024-11-17 20:52:04.858 INFO [docker-suite-thread-1] (ScriptContext.groovy:100) - Run test_truncate_recover_restart_fe in /home/vallish/doris/workspace/doris/regression-test/suites/catalog_recycle_bin_p0/test_truncate_recover_restart_fe.groovy 2024-11-17 20:52:04.864 INFO [docker-suite-thread-1] (Suite.groovy:316) - === start run suite test_truncate_recover_restart_fe in not_cloud mode. === 2024-11-17 20:52:04.865 INFO [docker-suite-thread-1] (SuiteCluster.groovy:640) - Run doris compose cmd: python -W ignore /home/vallish/doris/workspace/doris/docker/runtime/doris-compose/doris-compose.py down test_truncate_recover_restart_fe --clean --output-json 2024-11-17 20:52:05.087 INFO [docker-suite-thread-1] (SuiteCluster.groovy:640) - Run doris compose cmd: python -W ignore /home/vallish/doris/workspace/doris/docker/runtime/doris-compose/doris-compose.py up test_truncate_recover_restart_fe ae819a634da1 --add-fe-num 1 --add-be-num 3 --fe-config heartbeat_interval_second=5 enable_debug_points=true publish_wait_time_second=-1 commit_timeout_second=10 sys_log_verbose_modules=org.apache.doris --be-config max_sys_mem_available_low_water_mark_bytes=0 report_disk_state_interval_seconds=2 report_random_wait=false enable_debug_points=true enable_java_support=false --no-be-cluster-id --wait-timeout 180 --output-json 2024-11-17 20:52:44.656 INFO [docker-suite-thread-1] (SuiteCluster.groovy:640) - Run doris compose cmd: python -W ignore /home/vallish/doris/workspace/doris/docker/runtime/doris-compose/doris-compose.py ls test_truncate_recover_restart_fe --detail --output-json 2024-11-17 20:52:44.914 INFO [docker-suite-thread-1] (SuiteCluster.groovy:438) - get all nodes [[CLUSTER, NAME, IP, STATUS, CONTAINER ID, IMAGE, CREATED, alive, is_master, backend_id, tablet_num, last_heartbeat, err_msg, query_port, http_port, path, edit_log_port, heartbeat_port], [test_truncate_recover_restart_fe, fe-1, 150.34.1.1, running, db46e97e9e, apache/doris:vallishtest, 2024-11-17 20:52:08, true, true, , , 2024-11-17 20:52:44, , 9030, 8030, /tmp/doris/test_truncate_recover_restart_fe/fe-1, 9010, ], [test_truncate_recover_restart_fe, be-1, 150.34.51.1, running, aacbda5e4f, apache/doris:vallishtest, 2024-11-17 20:52:08, true, , 10004, 6, 2024-11-17 20:52:44, , , 8040, /tmp/doris/test_truncate_recover_restart_fe/be-1, , 9050], [test_truncate_recover_restart_fe, be-2, 150.34.51.2, running, 255acd32b0, apache/doris:vallishtest, 2024-11-17 20:52:08, true, , 10003, 8, 2024-11-17 20:52:44, , , 8040, /tmp/doris/test_truncate_recover_restart_fe/be-2, , 9050], [test_truncate_recover _restart_fe, be-3, 150.34.51.3, running, 37add09ba0, apache/doris:vallishtest, 2024-11-17 20:52:08, true, , 10002, 8, 2024-11-17 20:52:44, , , 8040, /tmp/doris/test_truncate_recover_restart_fe/be-3, , 9050]] 2024-11-17 20:52:45.942 INFO [docker-suite-thread-1] (Suite.groovy:333) - get fe org.apache.doris.regression.suite.Frontend@3acf82ea 2024-11-17 20:52:45.947 INFO [docker-suite-thread-1] (SuiteCluster.groovy:640) - Run doris compose cmd: python -W ignore /home/vallish/doris/workspace/doris/docker/runtime/doris-compose/doris-compose.py ls test_truncate_recover_restart_fe --detail --output-json 2024-11-17 20:52:46.232 INFO [docker-suite-thread-1] (SuiteCluster.groovy:438) - get all nodes [[CLUSTER, NAME, IP, STATUS, CONTAINER ID, IMAGE, CREATED, alive, is_master, backend_id, tablet_num, last_heartbeat, err_msg, query_port, http_port, path, edit_log_port, heartbeat_port], [test_truncate_recover_restart_fe, fe-1, 150.34.1.1, running, db46e97e9e, apache/doris:vallishtest, 2024-11-17 20:52:08, true, true, , , 2024-11-17 20:52:44, , 9030, 8030, /tmp/doris/test_truncate_recover_restart_fe/fe-1, 9010, ], [test_truncate_recover_restart_fe, be-1, 150.34.51.1, running, aacbda5e4f, apache/doris:vallishtest, 2024-11-17 20:52:08, true, , 10004, 6, 2024-11-17 20:52:44, , , 8040, /tmp/doris/test_truncate_recover_restart_fe/be-1, , 9050], [test_truncate_recover_restart_fe, be-2, 150.34.51.2, running, 255acd32b0, apache/doris:vallishtest, 2024-11-17 20:52:08, true, , 10003, 8, 2024-11-17 20:52:44, , , 8040, /tmp/doris/test_truncate_recover_restart_fe/be-2, , 9050], [test_truncate_recover _restart_fe, be-3, 150.34.51.3, running, 37add09ba0, apache/doris:vallishtest, 2024-11-17 20:52:08, true, , 10002, 8, 2024-11-17 20:52:44, , , 8040, /tmp/doris/test_truncate_recover_restart_fe/be-3, , 9050]] 2024-11-17 20:52:46.262 INFO [docker-suite-thread-1] (Http.groovy:56) - http post url=http://150.34.51.1:8040/api/report/disk, isJson=true, response code=200, text={ "status": "OK", "msg": "OK" } 2024-11-17 20:52:46.294 INFO [docker-suite-thread-1] (Http.groovy:56) - http post url=http://150.34.51.2:8040/api/report/disk, isJson=true, response code=200, text={ "status": "OK", "msg": "OK" } 2024-11-17 20:52:46.297 INFO [docker-suite-thread-1] (Http.groovy:56) - http post url=http://150.34.51.3:8040/api/report/disk, isJson=true, response code=200, text={ "status": "OK", "msg": "OK" } 2024-11-17 20:52:51.402 INFO [docker-suite-thread-1] (Suite.groovy:348) - try create database if not exists regression_test_catalog_recycle_bin_p0 2024-11-17 20:52:51.446 INFO [docker-suite-thread-1] (Suite.groovy:352) - connect to docker cluster: suite=test_truncate_recover_restart_fe, url=jdbc:mysql://150.34.1.1:9030/regression_test_catalog_recycle_bin_p0?useLocalSessionState=true&allowLoadLocalInfile=false&verifyServerCertificate=false&useSSL=true&requireSSL=false&enabledTLSProtocols=TLSv1.2&connectTimeout=5000&socketTimeout=1800000 2024-11-17 20:52:51.449 INFO [docker-suite-thread-1] (SuiteContext.groovy:300) - Create new connection for user 'root' to 'jdbc:mysql://150.34.1.1:9030/regression_test_catalog_recycle_bin_p0?useLocalSessionState=true&allowLoadLocalInfile=false&verifyServerCertificate=false&useSSL=true&requireSSL=false&enabledTLSProtocols=TLSv1.2&connectTimeout=5000&socketTimeout=1800000' 2024-11-17 20:52:51.477 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: drop table if exists test_truncate_recover_restart_fe force 2024-11-17 20:52:51.488 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: create table test_truncate_recover_restart_fe ( `id` int(11), `name` varchar(128), `da` date ) engine=olap duplicate key(id) partition by range(da)( PARTITION p3 VALUES LESS THAN ('2023-01-01'), PARTITION p4 VALUES LESS THAN ('2024-01-01'), PARTITION p5 VALUES LESS THAN ('2025-01-01') ) distributed by hash(id) buckets 2 properties( "replication_num"="1", "light_schema_change"="true" ); 2024-11-17 20:52:51.535 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: insert into test_truncate_recover_restart_fe values(1, 'a', '2022-01-02'); 2024-11-17 20:52:51.684 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: insert into test_truncate_recover_restart_fe values(2, 'a', '2023-01-02'); 2024-11-17 20:52:51.749 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: insert into test_truncate_recover_restart_fe values(3, 'a', '2024-01-02'); 2024-11-17 20:52:51.814 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: SYNC; 2024-11-17 20:52:51.819 INFO [docker-suite-thread-1] (Suite.groovy:1356) - Execute tag: select_check_1, sql: select * from test_truncate_recover_restart_fe order by id,name,da; 2024-11-17 20:52:51.937 INFO [docker-suite-thread-1] (SuiteContext.groovy:400) - Generate /home/vallish/doris/workspace/doris/regression-test/data/catalog_recycle_bin_p0/test_truncate_recover_restart_fe.out 2024-11-17 20:52:51.943 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: truncate table test_truncate_recover_restart_fe; 2024-11-17 20:52:51.986 INFO [docker-suite-thread-1] (SuiteCluster.groovy:640) - Run doris compose cmd: python -W ignore /home/vallish/doris/workspace/doris/docker/runtime/doris-compose/doris-compose.py restart --wait-timeout 120 test_truncate_recover_restart_fe --fe-id --output-json 2024-11-17 20:53:40.247 INFO [docker-suite-thread-1] (Suite.groovy:1356) - Execute tag: select_check_2, sql: select * from test_truncate_recover_restart_fe order by id,name,da; 2024-11-17 20:53:40.262 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: ALTER TABLE test_truncate_recover_restart_fe DROP PARTITION p3 force; 2024-11-17 20:53:40.289 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: ALTER TABLE test_truncate_recover_restart_fe DROP PARTITION p4 force; 2024-11-17 20:53:40.296 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: ALTER TABLE test_truncate_recover_restart_fe DROP PARTITION p5 force; 2024-11-17 20:53:40.302 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: recover partition p3 from test_truncate_recover_restart_fe; 2024-11-17 20:53:40.317 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: recover partition p4 from test_truncate_recover_restart_fe; 2024-11-17 20:53:40.324 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: recover partition p5 from test_truncate_recover_restart_fe; 2024-11-17 20:53:40.331 INFO [docker-suite-thread-1] (Suite.groovy:1356) - Execute tag: select_check_3, sql: select * from test_truncate_recover_restart_fe order by id,name,da; 2024-11-17 20:53:40.434 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: truncate table test_truncate_recover_restart_fe PARTITION(p3); 2024-11-17 20:53:40.500 INFO [docker-suite-thread-1] (Suite.groovy:1356) - Execute tag: select_check_4, sql: select * from test_truncate_recover_restart_fe order by id,name,da; 2024-11-17 20:53:40.543 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: ALTER TABLE test_truncate_recover_restart_fe DROP PARTITION p3 force; 2024-11-17 20:53:40.554 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: recover partition p3 from test_truncate_recover_restart_fe; 2024-11-17 20:53:40.560 INFO [docker-suite-thread-1] (Suite.groovy:1356) - Execute tag: select_check_5, sql: select * from test_truncate_recover_restart_fe order by id,name,da; 2024-11-17 20:53:40.597 INFO [docker-suite-thread-1] (Suite.groovy:387) - Execute sql: truncate table test_truncate_recover_restart_fe force; 2024-11-17 20:53:40.621 INFO [docker-suite-thread-1] (SuiteCluster.groovy:640) - Run doris compose cmd: python -W ignore /home/vallish/doris/workspace/doris/docker/runtime/doris-compose/doris-compose.py restart --wait-timeout 120 test_truncate_recover_restart_fe --fe-id --output-json 2024-11-17 20:54:27.743 INFO [docker-suite-thread-1] (Suite.groovy:1356) - Execute tag: select_check_6, sql: select * from test_truncate_recover_restart_fe order by id,name,da; 2024-11-17 20:54:27.757 INFO [docker-suite-thread-1] (SuiteContext.groovy:310) - Recover original connection to 'jdbc:mysql://150.34.1.1:9030/regression_test_catalog_recycle_bin_p0?useLocalSessionState=true&allowLoadLocalInfile=false&verifyServerCertificate=false&useSSL=true&requireSSL=false&enabledTLSProtocols=TLSv1.2&connectTimeout=5000&socketTimeout=1800000' 2024-11-17 20:54:27.758 INFO [docker-suite-thread-1] (SuiteCluster.groovy:640) - Run doris compose cmd: python -W ignore /home/vallish/doris/workspace/doris/docker/runtime/doris-compose/doris-compose.py down test_truncate_recover_restart_fe --output-json 2024-11-17 20:54:39.360 INFO [docker-suite-thread-1] (ScriptContext.groovy:120) - Run test_truncate_recover_restart_fe in /home/vallish/doris/workspace/doris/regression-test/suites/catalog_recycle_bin_p0/test_truncate_recover_restart_fe.groovy succeed 2024-11-17 20:54:39.367 INFO [main] (RegressionTest.groovy:410) - Success suites: /home/vallish/doris/workspace/doris/regression-test/suites/catalog_recycle_bin_p0/test_truncate_recover_restart_fe.groovy: group=docker,p0, name=test_truncate_recover_restart_fe 2024-11-17 20:54:39.368 INFO [main] (RegressionTest.groovy:492) - All suites success. ____ _ ____ ____ _____ ____ | _ \ / \ / ___/ ___|| ____| _ \ | |_) / _ \ \___ \___ \| _| | | | | | __/ ___ \ ___) |__) | |___| |_| | |_| /_/ \_\____/____/|_____|____/ 2024-11-17 20:54:39.368 INFO [main] (RegressionTest.groovy:440) - Test 1 suites, failed 0 suites, fatal 0 scripts, skipped 0 scripts 2024-11-17 20:54:39.368 INFO [main] (RegressionTest.groovy:126) - Test finished -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
