Skip to content

03562_parallel_replicas_remote_with_cluster failed #89974

@tuanpach

Description

@tuanpach

CIDB link

2025-11-13 04:17:35 Reason: result differs with reference:  
2025-11-13 04:17:35 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03562_parallel_replicas_remote_with_cluster.reference	2025-11-13 04:00:13.548767958 -0100
2025-11-13 04:17:35 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03562_parallel_replicas_remote_with_cluster.stdout	2025-11-13 04:17:35.262300154 -0100
2025-11-13 04:17:35 @@ -1,4 +1,4 @@
2025-11-13 04:17:35  45
2025-11-13 04:17:35  90
2025-11-13 04:17:35 -1
2025-11-13 04:17:35 +2
2025-11-13 04:17:35  2
2025-11-13 04:17:35 
2025-11-13 04:17:35 
2025-11-13 04:17:35 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 29638999 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 11768789 --max_read_buffer_size 529398 --prefer_localhost_replica 1 --max_block_size 88571 --max_joined_block_size_rows 36406 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 0 --max_threads 1 --optimize_append_index 0 --use_hedged_requests 1 --optimize_if_chain_to_multiif 0 --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 84 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 23979086 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 3123706460 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 10 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --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 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_expressions 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 10 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 2152310131 --min_compress_block_size 564637 --max_compress_block_size 2882301 --merge_tree_compact_parts_min_granules_to_multibuffer_read 4 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 7573978 --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 3 --min_count_to_compile_sort_description 0 --session_timezone Mexico/BajaSur --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.6 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 1 --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 auto --enable_vertical_final 1 --optimize_extract_common_expressions 1 --use_async_executor_for_materialized_views 0 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 0 --use_skip_indexes_on_data_read 1 --optimize_rewrite_like_perfect_affix 1 --enable_lazy_columns_replication 0 --allow_special_serialization_kinds_in_output_formats 1 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.0 --max_bytes_ratio_before_external_group_by 0.2 --use_skip_indexes_if_final_exact_mode 0
2025-11-13 04:17:35 
2025-11-13 04:17:35 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 918352 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 10384864781 --index_granularity_bytes 3965345 --merge_max_block_size 15342 --index_granularity 10998 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 88177 --primary_key_compress_block_size 91844 --replace_long_file_name_to_hash 0 --max_file_name_length 18 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 98721217 --compact_parts_max_granules_to_buffer 35 --compact_parts_merge_max_bytes_to_prefetch_part 11519621 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 0 --old_parts_lifetime 208 --prewarm_mark_cache 1 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 0 --enable_block_number_column 1 --enable_block_offset_column 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 --object_serialization_version v2 --object_shared_data_serialization_version map --object_shared_data_serialization_version_for_zero_level_parts advanced --object_shared_data_buckets_for_compact_part 23 --object_shared_data_buckets_for_wide_part 7 --dynamic_serialization_version v2 --auto_statistics_types tdigest,uniq,minmax --serialization_info_version basic --string_serialization_version single_stream --enable_shared_storage_snapshot_in_query 1
2025-11-13 04:17:35 
2025-11-13 04:17:35 Database: test_2vl53cc5

Test link

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