Skip to content

00596_limit_on_expanded_ast is flaky #90721

@rschu1ze

Description

@rschu1ze

Example failure (from here):

2025-11-24 07:06:07 Reason: Timeout! Processes left in process group 1348082:
2025-11-24 07:06:07 1348082 /bin/sh -c /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.sh > /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.stdout 2> /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.stderr
2025-11-24 07:06:07 1348083 bash /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.sh
2025-11-24 07:06:07 1348183 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_p5kbfefg --log_comment 00596_limit_on_expanded_ast.sh-test_p5kbfefg --max_insert_threads 3 --group_by_two_level_threshold 974583 --group_by_two_level_threshold_bytes 35790163 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 8923576 --max_read_buffer_size 614810 --prefer_localhost_replica 0 --max_block_size 20546 --max_joined_block_size_rows 38778 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 553 --max_threads 3 --optimize_append_index 1 --use_hedged_requests 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 69 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 5269385 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 3554747755 --local_filesystem_read_method pread --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 25 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 2900559744 --min_compress_block_size 584399 --max_compress_block_size 1982380 --merge_tree_compact_parts_min_granules_to_multibuffer_read 26 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 4670308 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Mazatlan --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.01 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 0 --max_parsing_threads 10 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 0 --query_plan_join_swap_table auto --enable_vertical_final 1 --optimize_extract_common_expressions 0 --use_async_executor_for_materialized_views 1 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 0 --use_skip_indexes_if_final 1 --use_skip_indexes_on_data_read 0 --optimize_rewrite_like_perfect_affix 1 --input_format_parquet_use_native_reader_v3 0 --enable_lazy_columns_replication 1 --allow_special_serialization_kinds_in_output_formats 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0 --use_skip_indexes_if_final_exact_mode 1 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 97160 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 5169848634 --index_granularity_bytes 16969414 --merge_max_block_size 3634 --index_granularity 59002 --min_bytes_for_wide_part 581989704 --marks_compress_block_size 39998 --primary_key_compress_block_size 31205 --replace_long_file_name_to_hash 0 --max_file_name_length 94 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 170554055 --compact_parts_max_granules_to_buffer 226 --compact_parts_merge_max_bytes_to_prefetch_part 30542246 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 13 --old_parts_lifetime 242 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 0 --enable_block_offset_column 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 --object_serialization_version v2 --object_shared_data_serialization_version map --object_shared_data_serialization_version_for_zero_level_parts map --object_shared_data_buckets_for_compact_part 17 --object_shared_data_buckets_for_wide_part 26 --dynamic_serialization_version v2 --auto_statistics_types tdigest,minmax,uniq,countmin --serialization_info_version basic --string_serialization_version single_stream --enable_shared_storage_snapshot_in_query 1 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.stderr-fatal --server_logs_file /dev/null --max_expanded_ast_elements=500000 --query=     select 1 as a, a+a as b, b+b as c, c+c as d, d+d as e, e+e as f, f+f as g, g+g as h, h+h as i, i+i as j, j+j as k, k+k as l, l+l as m, m+m as n, n+n as o, o+o as p, p+p as q, q+q as r, r+r as s, s+s as t, t+t as u, u+u as v, v+v as w, w+w as x, x+x as y, y+y as z 
2025-11-24 07:06:07 1348184 grep -c too big
2025-11-24 07:06:07 Killing process group 1348082
2025-11-24 07:06:07 Processes in process group 1348082:
2025-11-24 07:06:07 1348082 /bin/sh -c /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.sh > /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.stdout 2> /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.stderr
2025-11-24 07:06:07 1348083 bash /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.sh
2025-11-24 07:06:07 1348183 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_p5kbfefg --log_comment 00596_limit_on_expanded_ast.sh-test_p5kbfefg --max_insert_threads 3 --group_by_two_level_threshold 974583 --group_by_two_level_threshold_bytes 35790163 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 8923576 --max_read_buffer_size 614810 --prefer_localhost_replica 0 --max_block_size 20546 --max_joined_block_size_rows 38778 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 553 --max_threads 3 --optimize_append_index 1 --use_hedged_requests 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 69 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 5269385 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 3554747755 --local_filesystem_read_method pread --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 25 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 2900559744 --min_compress_block_size 584399 --max_compress_block_size 1982380 --merge_tree_compact_parts_min_granules_to_multibuffer_read 26 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 4670308 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Mazatlan --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.01 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 0 --max_parsing_threads 10 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 0 --query_plan_join_swap_table auto --enable_vertical_final 1 --optimize_extract_common_expressions 0 --use_async_executor_for_materialized_views 1 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 0 --use_skip_indexes_if_final 1 --use_skip_indexes_on_data_read 0 --optimize_rewrite_like_perfect_affix 1 --input_format_parquet_use_native_reader_v3 0 --enable_lazy_columns_replication 1 --allow_special_serialization_kinds_in_output_formats 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0 --use_skip_indexes_if_final_exact_mode 1 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 97160 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 5169848634 --index_granularity_bytes 16969414 --merge_max_block_size 3634 --index_granularity 59002 --min_bytes_for_wide_part 581989704 --marks_compress_block_size 39998 --primary_key_compress_block_size 31205 --replace_long_file_name_to_hash 0 --max_file_name_length 94 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 170554055 --compact_parts_max_granules_to_buffer 226 --compact_parts_merge_max_bytes_to_prefetch_part 30542246 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 13 --old_parts_lifetime 242 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 0 --enable_block_offset_column 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 --object_serialization_version v2 --object_shared_data_serialization_version map --object_shared_data_serialization_version_for_zero_level_parts map --object_shared_data_buckets_for_compact_part 17 --object_shared_data_buckets_for_wide_part 26 --dynamic_serialization_version v2 --auto_statistics_types tdigest,minmax,uniq,countmin --serialization_info_version basic --string_serialization_version single_stream --enable_shared_storage_snapshot_in_query 1 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.stderr-fatal --server_logs_file /dev/null --max_expanded_ast_elements=500000 --query=     select 1 as a, a+a as b, b+b as c, c+c as d, d+d as e, e+e as f, f+f as g, g+g as h, h+h as i, i+i as j, j+j as k, k+k as l, l+l as m, m+m as n, n+n as o, o+o as p, p+p as q, q+q as r, r+r as s, s+s as t, t+t as u, u+u as v, v+v as w, w+w as x, x+x as y, y+y as z 
2025-11-24 07:06:07 1348184 grep -c too big
2025-11-24 07:06:07 Wait 10 seconds for clickhouse utilities to handle SIGTSTP...
2025-11-24 07:06:07 Process group 1348082 should be killed
2025-11-24 07:06:07 Path: /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00596_limit_on_expanded_ast.stderr-fatal
2025-11-24 07:06:07 ########## Short fault info ############
2025-11-24 07:06:07 (version 25.12.1.106, build id: 431EBF199AECA6791C9A7D53E6450D6847EE2915, git hash: 2a45562973697418e62527d11bdf04e117cebc02, architecture: x86_64) (from thread 1348183) Received signal 20
2025-11-24 07:06:07 Signal description: Stopped
2025-11-24 07:06:07 This is a signal used for debugging purposes by the user.
2025-11-24 07:06:07 Stack trace: 0x00007f7a53d4bc40 0x000055754b0bf29f 0x00005575a0836fb4 0x00005575a0837562 0x000055756c49089b 0x0000557592ba1f90 0x0000557592b855e6 0x0000557592a96c24 0x0000557592a927c8 0x0000557592a8b0ea 0x0000557592ab53a0 0x0000557592aba4ad 0x0000557592ad98bb 0x000055756c5e170f 0x000055756c5e26ef 0x00005575a08c55bf 0x000055756c606949 0x000055754b1056d8 0x00007f7a53c5cd90 0x00007f7a53c5ce40 0x000055754b076c2e
2025-11-24 07:06:07 ########################################
2025-11-24 07:06:07 (version 25.12.1.106, build id: 431EBF199AECA6791C9A7D53E6450D6847EE2915, git hash: 2a45562973697418e62527d11bdf04e117cebc02) (from thread 1348183) (no query) Received signal Stopped (20)
2025-11-24 07:06:07 This is a signal used for debugging purposes by the user.
2025-11-24 07:06:07 Stack trace: 0x00007f7a53d4bc40 0x000055754b0bf29f 0x00005575a0836fb4 0x00005575a0837562 0x000055756c49089b 0x0000557592ba1f90 0x0000557592b855e6 0x0000557592a96c24 0x0000557592a927c8 0x0000557592a8b0ea 0x0000557592ab53a0 0x0000557592aba4ad 0x0000557592ad98bb 0x000055756c5e170f 0x000055756c5e26ef 0x00005575a08c55bf 0x000055756c606949 0x000055754b1056d8 0x00007f7a53c5cd90 0x00007f7a53c5ce40 0x000055754b076c2e
2025-11-24 07:06:07 4. poll @ 0x0000000000118c40
2025-11-24 07:06:07 5. __interceptor_poll @ 0x000000000a86629f
2025-11-24 07:06:07 6. ./ci/tmp/build/./base/poco/Net/src/SocketImpl.cpp:461: Poco::Net::SocketImpl::pollImpl(Poco::Timespan&, int) @ 0x000000005ffddfb4
2025-11-24 07:06:07 7. ./ci/tmp/build/./base/poco/Net/src/SocketImpl.cpp:529: Poco::Net::SocketImpl::poll(Poco::Timespan const&, int) @ 0x000000005ffde562
2025-11-24 07:06:07 8. ./ci/tmp/build/./src/IO/ReadBufferFromPocoSocket.cpp:144: DB::ReadBufferFromPocoSocketBase::poll(unsigned long) const @ 0x000000002bc3789b
2025-11-24 07:06:07 9. ./ci/tmp/build/./src/IO/ReadBufferFromPocoSocketChunked.cpp:51: DB::ReadBufferFromPocoSocketChunked::poll(unsigned long) const @ 0x0000000052348f90
2025-11-24 07:06:07 10. ./ci/tmp/build/./src/Client/Connection.cpp:1261: DB::Connection::poll(unsigned long) @ 0x000000005232c5e6
2025-11-24 07:06:07 11. ./ci/tmp/build/./src/Client/ClientBase.cpp:1398: DB::ClientBase::receiveResult(std::shared_ptr<DB::IAST>, int, bool) @ 0x000000005223dc24
2025-11-24 07:06:07 12. ./ci/tmp/build/./src/Client/ClientBase.cpp:1313: DB::ClientBase::processOrdinaryQuery(String, std::shared_ptr<DB::IAST>) @ 0x00000000522397c8
2025-11-24 07:06:07 13. ./ci/tmp/build/./src/Client/ClientBase.cpp:2338: DB::ClientBase::processParsedSingleQuery(std::basic_string_view<char, std::char_traits<char>>, std::shared_ptr<DB::IAST>, bool&, unsigned long) @ 0x00000000522320ea
2025-11-24 07:06:07 14. ./ci/tmp/build/./src/Client/ClientBase.cpp:2715: DB::ClientBase::executeMultiQuery(String const&) @ 0x000000005225c3a0
2025-11-24 07:06:07 15. ./ci/tmp/build/./src/Client/ClientBase.cpp:2956: DB::ClientBase::processQueryText(String const&) @ 0x00000000522614ad
2025-11-24 07:06:07 16. ./ci/tmp/build/./src/Client/ClientBase.cpp:3755: DB::ClientBase::runNonInteractive() @ 0x00000000522808bb
2025-11-24 07:06:07 17. ./ci/tmp/build/./pr

Test case history

Happens sporadically and it looks like the failures started on 24 Nov 2025

Metadata

Metadata

Assignees

No one assigned

    Labels

    flaky testflaky test found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions