Quanlong Huang created IMPALA-13974:
---------------------------------------

             Summary: test_hms_event_sync_with_commit_compaction is flaky
                 Key: IMPALA-13974
                 URL: https://issues.apache.org/jira/browse/IMPALA-13974
             Project: IMPALA
          Issue Type: Bug
            Reporter: Quanlong Huang
            Assignee: Quanlong Huang


Saw this failed in several builds:
{code}
custom_cluster.test_events_custom_configs.TestEventSyncWaiting.test_hms_event_sync_with_commit_compaction[protocol:
 beeswax | table_format: text/none | exec_option: {'test_replan': 1, 
'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 
'disable_codegen': False, 'abort_on_error': 1, 
'exec_single_node_rows_threshold': 0}] (from pytest){code}
Stacktrace
{code:python}
custom_cluster/test_events_custom_configs.py:1639: in 
test_hms_event_sync_with_commit_compaction
    assert len(res.data) == 1
E   assert 2 == 1
E    +  where 2 = 
len(['hdfs://localhost:20500/test-warehouse/managed/test_hms_event_sync_with_commit_compaction_1ac0b73.db/foo/p=0/delta_00...aged/test_hms_event_sync_with_commit_compaction_1ac0b73.db/foo/p=0/delta_0000002_0000002_0000/000000_0\t2B\tp=0\tNONE'])
E    +    where 
['hdfs://localhost:20500/test-warehouse/managed/test_hms_event_sync_with_commit_compaction_1ac0b73.db/foo/p=0/delta_00...aged/test_hms_event_sync_with_commit_compaction_1ac0b73.db/foo/p=0/delta_0000002_0000002_0000/000000_0\t2B\tp=0\tNONE']
 = <tests.beeswax.impala_beeswax.ImpalaBeeswaxResult object at 
0x7f9113257e50>.data{code}
Standard Error
{noformat}
-- 2025-04-17 18:26:35,817 INFO     MainThread: Starting cluster with command: 
/home/ubuntu/Impala/bin/start-impala-cluster.py 
'--state_store_args=--statestore_update_frequency_ms=50 
--statestore_priority_update_frequency_ms=50 
--statestore_heartbeat_frequency_ms=50' --cluster_size=3 --num_coordinators=3 
--log_dir=/home/ubuntu/Impala/logs/custom_cluster_tests --log_level=1 
'--catalogd_args=--debug_actions=catalogd_event_processing_delay:SLEEP@200 ' 
--impalad_args=--default_query_options=
18:26:36 MainThread: Found 0 impalad/0 statestored/0 catalogd process(es)
18:26:36 MainThread: Starting State Store logging to 
/home/ubuntu/Impala/logs/custom_cluster_tests/statestored.INFO
18:26:36 MainThread: Starting Catalog Service logging to 
/home/ubuntu/Impala/logs/custom_cluster_tests/catalogd.INFO
18:26:36 MainThread: Starting Impala Daemon logging to 
/home/ubuntu/Impala/logs/custom_cluster_tests/impalad.INFO
18:26:36 MainThread: Starting Impala Daemon logging to 
/home/ubuntu/Impala/logs/custom_cluster_tests/impalad_node1.INFO
18:26:36 MainThread: Starting Impala Daemon logging to 
/home/ubuntu/Impala/logs/custom_cluster_tests/impalad_node2.INFO
18:26:38 MainThread: Found 3 impalad/1 statestored/1 catalogd process(es)
18:26:38 MainThread: wait_num_table=1
18:26:38 MainThread: Waiting for Impalad webserver port 25000
18:26:38 MainThread: Waiting for Impalad webserver port 25000
18:26:38 MainThread: Waiting for Impalad webserver port 25001
18:26:38 MainThread: Waiting for Impalad webserver port 25002
18:26:41 MainThread: Waiting for coordinator client services - hs2 port: 21050 
hs2-http port: 28000 beeswax port: 21000
18:26:42 MainThread: Waiting for coordinator client services - hs2 port: 21051 
hs2-http port: 28001 beeswax port: 21001
18:26:44 MainThread: Waiting for coordinator client services - hs2 port: 21052 
hs2-http port: 28002 beeswax port: 21002
18:26:44 MainThread: Getting num_known_live_backends from ip-172-31-61-143:25000
18:26:44 MainThread: num_known_live_backends has reached value: 3
18:26:44 MainThread: Getting num_known_live_backends from ip-172-31-61-143:25001
18:26:44 MainThread: num_known_live_backends has reached value: 3
18:26:44 MainThread: Getting num_known_live_backends from ip-172-31-61-143:25002
18:26:44 MainThread: num_known_live_backends has reached value: 3
18:26:44 MainThread: Total wait: 6.46s
18:26:44 MainThread: Impala Cluster Running with 3 nodes (3 coordinators, 3 
executors).
-- 2025-04-17 18:26:44,955 DEBUG    MainThread: Found 3 impalad/1 statestored/1 
catalogd process(es)
-- 2025-04-17 18:26:44,955 INFO     MainThread: Getting metric: 
statestore.live-backends from ip-172-31-61-143:25010
-- 2025-04-17 18:26:44,958 INFO     MainThread: Metric 
'statestore.live-backends' has reached desired value: 4. total_wait: 0s
-- 2025-04-17 18:26:44,958 DEBUG    MainThread: Getting num_known_live_backends 
from ip-172-31-61-143:25000
-- 2025-04-17 18:26:44,959 INFO     MainThread: num_known_live_backends has 
reached value: 3
-- 2025-04-17 18:26:44,959 DEBUG    MainThread: Getting num_known_live_backends 
from ip-172-31-61-143:25001
-- 2025-04-17 18:26:44,961 INFO     MainThread: num_known_live_backends has 
reached value: 3
-- 2025-04-17 18:26:44,961 DEBUG    MainThread: Getting num_known_live_backends 
from ip-172-31-61-143:25002
-- 2025-04-17 18:26:44,962 INFO     MainThread: num_known_live_backends has 
reached value: 3
-- 2025-04-17 18:26:44,962 INFO     MainThread: beeswax: 

set 
client_identifier=custom_cluster/test_events_custom_configs.py::TestEventSyncWaiting::()::test_hms_event_sync_with_commit_compaction[protocol:beeswax|table_format:text/none|exec_option:{'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disabl;

-- 2025-04-17 18:26:44,963 INFO     MainThread: beeswax: connected to 
localhost:21000 with beeswax
-- 2025-04-17 18:26:44,963 INFO     MainThread: hs2: 

set 
client_identifier=custom_cluster/test_events_custom_configs.py::TestEventSyncWaiting::()::test_hms_event_sync_with_commit_compaction[protocol:beeswax|table_format:text/none|exec_option:{'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disabl;

-- 2025-04-17 18:26:44,963 INFO     MainThread: hs2: connected to 
localhost:21050 with impyla hs2
-- 2025-04-17 18:26:44,963 INFO     MainThread: hs2-http: 

set 
client_identifier=custom_cluster/test_events_custom_configs.py::TestEventSyncWaiting::()::test_hms_event_sync_with_commit_compaction[protocol:beeswax|table_format:text/none|exec_option:{'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disabl;

-- 2025-04-17 18:26:44,963 INFO     MainThread: hs2-http: connected to 
localhost:28000 with impyla hs2-http
-- 2025-04-17 18:26:44,963 INFO     MainThread: hs2: 

set 
client_identifier=custom_cluster/test_events_custom_configs.py::TestEventSyncWaiting::()::test_hms_event_sync_with_commit_compaction[protocol:beeswax|table_format:text/none|exec_option:{'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disabl;

-- 2025-04-17 18:26:44,964 INFO     MainThread: hs2: connected to 
localhost:21050 with impyla hs2
-- 2025-04-17 18:26:44,964 INFO     MainThread: hs2: 

set 
client_identifier=custom_cluster/test_events_custom_configs.py::TestEventSyncWaiting::()::test_hms_event_sync_with_commit_compaction[protocol:beeswax|table_format:text/none|exec_option:{'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disabl;

-- 2025-04-17 18:26:44,964 INFO     MainThread: hs2: set_configuration:

set sync_ddl=False;

-- 2025-04-17 18:26:44,964 INFO     MainThread: hs2: executing against Impala 
at localhost:21050. session: 264cb39583af1aab:d409990d6e5744b1 main_cursor: 
True user: None

DROP DATABASE IF EXISTS `test_hms_event_sync_with_commit_compaction_1ac0b73` 
CASCADE;

-- 2025-04-17 18:26:45,190 INFO     MainThread: 
77491be3975d74fb:049dc1f200000000: query started
-- 2025-04-17 18:26:45,191 INFO     MainThread: 
77491be3975d74fb:049dc1f200000000: getting log for operation
-- 2025-04-17 18:26:45,192 INFO     MainThread: 
77491be3975d74fb:049dc1f200000000: getting runtime profile operation
-- 2025-04-17 18:26:45,192 INFO     MainThread: 
77491be3975d74fb:049dc1f200000000: closing query for operation
-- 2025-04-17 18:26:45,196 INFO     MainThread: hs2: executing against Impala 
at localhost:21050. session: 264cb39583af1aab:d409990d6e5744b1 main_cursor: 
True user: None

CREATE DATABASE `test_hms_event_sync_with_commit_compaction_1ac0b73`;

-- 2025-04-17 18:26:45,361 INFO     MainThread: 
ae4576375fa730dc:52b77e0a00000000: query started
-- 2025-04-17 18:26:45,362 INFO     MainThread: 
ae4576375fa730dc:52b77e0a00000000: getting log for operation
-- 2025-04-17 18:26:45,362 INFO     MainThread: 
ae4576375fa730dc:52b77e0a00000000: getting runtime profile operation
-- 2025-04-17 18:26:45,362 INFO     MainThread: 
ae4576375fa730dc:52b77e0a00000000: closing query for operation
-- 2025-04-17 18:26:45,362 INFO     MainThread: Created database 
"test_hms_event_sync_with_commit_compaction_1ac0b73" for test ID 
"custom_cluster/test_events_custom_configs.py::TestEventSyncWaiting::()::test_hms_event_sync_with_commit_compaction[protocol:
 beeswax | table_format: text/none | exec_option: {'test_replan': 1, 
'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 
'disable_codegen': False, 'abort_on_error': 1, 
'exec_single_node_rows_threshold': 0}]"
-- 2025-04-17 18:26:45,362 INFO     MainThread: hs2: closing 1 sync and 0 async 
hs2 connections to: localhost:21050
-- 2025-04-17 18:26:45,363 INFO     MainThread: beeswax: 

set 
client_identifier=custom_cluster/test_events_custom_configs.py::TestEventSyncWaiting::()::test_hms_event_sync_with_commit_compaction[protocol:beeswax|table_format:text/none|exec_option:{'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disabl;

-- 2025-04-17 18:26:45,363 INFO     MainThread: beeswax: set_configuration:

set sync_hms_events_wait_time_s=10;

-- 2025-04-17 18:26:45,363 INFO     MainThread: -- executing in HiveServer2

create transactional table 
test_hms_event_sync_with_commit_compaction_1ac0b73.foo partitioned by(p)
        as select 0 as i, 0 as p

-- 2025-04-17 18:26:54,943 INFO     MainThread: -- executing in HiveServer2

insert into test_hms_event_sync_with_commit_compaction_1ac0b73.foo select 1,0

-- 2025-04-17 18:27:05,047 INFO     MainThread: beeswax: executing against 
localhost:21000

show files in test_hms_event_sync_with_commit_compaction_1ac0b73.foo;

-- 2025-04-17 18:27:05,728 INFO     MainThread: Started query 
984b75d9783805e3:33f0f1b800000000
-- 2025-04-17 18:27:05,731 INFO     MainThread: -- executing in HiveServer2

alter table test_hms_event_sync_with_commit_compaction_1ac0b73.foo 
partition(p=0) compact 'minor' and wait

-- 2025-04-17 18:27:36,156 INFO     MainThread: beeswax: executing against 
localhost:21000

show files in test_hms_event_sync_with_commit_compaction_1ac0b73.foo;

-- 2025-04-17 18:27:36,776 INFO     MainThread: Started query 
2b476442f82351d8:371b333b00000000{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to