Skip to content

Flaky test: 02350_views_max_insert_threads #93249

@KochetovNicolai

Description

@KochetovNicolai

Important: This issue was automatically generated and is used by CI for matching failures. DO NOT modify the body content. DO NOT remove labels.

Test name: 02350_views_max_insert_threads
Failure reason: result differs with reference
CI report: Stateless tests (amd_binary, old analyzer, s3 storage, DatabaseReplicated, sequential)

CIDB statistics: cidb

Test output:

2025-12-30 15:18:59 Reason: result differs with reference:  
2025-12-30 15:18:59 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02350_views_max_insert_threads.reference	2025-12-30 15:00:25.469161063 +0100
2025-12-30 15:18:59 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02350_views_max_insert_threads.stdout	2025-12-30 15:18:59.086439338 +0100
2025-12-30 15:18:59 @@ -1 +1 @@
2025-12-30 15:18:59 -1
2025-12-30 15:18:59 +0
2025-12-30 15:18:59 
2025-12-30 15:18:59 
2025-12-30 15:18:59 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 70375 --group_by_two_level_threshold_bytes 32820771 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 11152294 --max_read_buffer_size 1005044 --prefer_localhost_replica 0 --max_block_size 34288 --max_joined_block_size_rows 39051 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 447 --max_threads 1 --optimize_append_index 1 --use_hedged_requests 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 88 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 42439906 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 4490243599 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 5 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 21 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1013762207 --min_compress_block_size 1883876 --max_compress_block_size 1547954 --merge_tree_compact_parts_min_granules_to_multibuffer_read 98 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 4439651 --http_wait_end_of_query True --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 3 --session_timezone Europe/Amsterdam --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.81 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 10 --optimize_functions_to_subcolumns 0 --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 0 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 0 --use_skip_indexes_on_data_read 0 --optimize_rewrite_like_perfect_affix 0 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 1 --allow_special_serialization_kinds_in_output_formats 0 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.2 --max_bytes_ratio_before_external_group_by 0.2 --use_skip_indexes_if_final_exact_mode 0
2025-12-30 15:18:59 
2025-12-30 15:18:59 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 6871310396 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 15770717 --merge_max_block_size 17129 --index_granularity 36114 --min_bytes_for_wide_part 1027433834 --marks_compress_block_size 88399 --primary_key_compress_block_size 90631 --replace_long_file_name_to_hash 1 --max_file_name_length 128 --min_bytes_for_full_part_storage 4847258 --compact_parts_max_bytes_to_buffer 499934885 --compact_parts_max_granules_to_buffer 209 --compact_parts_merge_max_bytes_to_prefetch_part 3338511 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 51 --old_parts_lifetime 10 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 1 --object_serialization_version v3 --object_shared_data_serialization_version map_with_buckets --object_shared_data_serialization_version_for_zero_level_parts map --object_shared_data_buckets_for_compact_part 2 --object_shared_data_buckets_for_wide_part 3 --dynamic_serialization_version v2 --serialization_info_version basic --string_serialization_version with_size_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 1
2025-12-30 15:18:59 
2025-12-30 15:18:59 Database: test_iqyfbkcn

Metadata

Metadata

Assignees

No one assigned

    Labels

    flaky testflaky test found by CItestingSpecial issue with list of bugs found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions