Skip to content

01281_unsucceeded_insert_select_queries_counter fails (extremely) sporadically #81529

@rschu1ze

Description

@rschu1ze

Example test failure:

2025-06-08 15:32:22 Reason: result differs with reference:  
2025-06-08 15:32:22 --- /repo/tests/queries/0_stateless/01281_unsucceeded_insert_select_queries_counter.reference	2025-06-08 15:32:21.974047775 +0000
2025-06-08 15:32:22 +++ /repo/tests/queries/0_stateless/01281_unsucceeded_insert_select_queries_counter.stdout	2025-06-08 15:32:22.240048166 +0000
2025-06-08 15:32:22 @@ -1,4 +1,4 @@
2025-06-08 15:32:22  1
2025-06-08 15:32:22  2
2025-06-08 15:32:22 -1
2025-06-08 15:32:22  2
2025-06-08 15:32:22 +3
2025-06-08 15:32:22 
2025-06-08 15:32:22 
2025-06-08 15:32:22 Settings used in the test: --max_insert_threads 12 --group_by_two_level_threshold 367209 --group_by_two_level_threshold_bytes 36069111 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 11252428 --max_read_buffer_size 518735 --prefer_localhost_replica 1 --max_block_size 35966 --max_joined_block_size_rows 39685 --max_threads 1 --optimize_append_index 1 --use_hedged_requests 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 58 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 39684804 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method pread --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 0 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 0 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 10 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1525848961 --min_compress_block_size 2049056 --max_compress_block_size 2655462 --merge_tree_compact_parts_min_granules_to_multibuffer_read 62 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 3510828 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.95 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table true --enable_vertical_final 0 --optimize_extract_common_expressions 1 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 0 --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 0
2025-06-08 15:32:22 
2025-06-08 15:32:22 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 28730924 --merge_max_block_size 22398 --index_granularity 40422 --min_bytes_for_wide_part 235066017 --marks_compress_block_size 42325 --primary_key_compress_block_size 48625 --replace_long_file_name_to_hash 0 --max_file_name_length 88 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 54904465 --compact_parts_max_granules_to_buffer 233 --compact_parts_merge_max_bytes_to_prefetch_part 31152923 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 45 --old_parts_lifetime 296 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 0 --enable_block_offset_column 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 1
2025-06-08 15:32:22 
2025-06-08 15:32:22 Database: test_d4b34l4a

Test history: https://play.clickhouse.com/play?user=play#U0VMRUNUIHB1bGxfcmVxdWVzdF9udW1iZXIgYXMgcHIsIGNoZWNrX3N0YXJ0X3RpbWUsIGNoZWNrX25hbWUsIHRlc3RfbmFtZSwgdGVzdF9zdGF0dXMsIHJlcG9ydF91cmwtLSwgdGVzdF9jb250ZXh0X3JhdwpGUk9NIGNoZWNrcwpXSEVSRSAxCiAgICAtLUFORCBwdWxsX3JlcXVlc3RfbnVtYmVyID0gMAogICAgQU5EIHRlc3Rfc3RhdHVzIElOICgnRkFJTCcsICdFUlJPUicsICdCUk9LRU4nKQogICAgQU5EIHRvRGF0ZShjaGVja19zdGFydF90aW1lKSA+ICcyMDI1LTAxLTAxJwogICAgQU5EIHRlc3RfbmFtZSBsaWtlICclMDEyODFfdW5zdWNjZWVkZWRfaW5zZXJ0X3NlbGVjdF9xdWVyaWVzX2NvdW50ZXIlJwogICAgLS1BTkQgdGVzdF9jb250ZXh0X3JhdyBsaWtlICclQmxvY2sgc3RydWN0dXJlIG1pc21hdGNoJScKT1JERVIgQlkgY2hlY2tfc3RhcnRfdGltZSBERVNDCgo=

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions