Skip to content

Flaky test: 03206_replication_lag_metric #97472

@nikitamikhaylov

Description

@nikitamikhaylov

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: 03206_replication_lag_metric
Failure reason: result differs with reference
CI report: Stateless tests (amd_ubsan, sequential)

Failing test history: cidb

Test output:

2026-02-16 15:21:10 Reason: result differs with reference:  
2026-02-16 15:21:10 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03206_replication_lag_metric.reference	2026-02-16 15:11:35.655364116 +0400
2026-02-16 15:21:10 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03206_replication_lag_metric.stdout	2026-02-16 15:21:10.369316448 +0400
2026-02-16 15:21:10 @@ -1,4 +1,4 @@
2026-02-16 15:21:10  0
2026-02-16 15:21:10 -2
2026-02-16 15:21:10 +3
2026-02-16 15:21:10  0
2026-02-16 15:21:10 -2
2026-02-16 15:21:10 +3
2026-02-16 15:21:10 
2026-02-16 15:21:10 
2026-02-16 15:21:10 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 671077 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 10873207 --max_read_buffer_size 894266 --prefer_localhost_replica 0 --max_block_size 42142 --max_joined_block_size_rows 23148 --joined_block_split_single_row 0 --join_output_by_rowlist_perkey_rows_threshold 429 --max_threads 3 --optimize_append_index 0 --use_hedged_requests 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 37 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 25282606 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method pread --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --distributed_cache_discard_connection_if_unread_data 0 --distributed_cache_use_clients_cache_for_write 1 --distributed_cache_use_clients_cache_for_read 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 0 --filesystem_prefetch_step_bytes 0 --enable_filesystem_cache 0 --enable_filesystem_cache_on_write_operations 0 --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 6 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 633194190 --min_compress_block_size 463962 --max_compress_block_size 486309 --merge_tree_compact_parts_min_granules_to_multibuffer_read 11 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 4015224 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache True --use_page_cache_for_local_disks False --use_page_cache_for_object_storage False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.11 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 0 --max_parsing_threads 0 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --enable_vertical_final 1 --optimize_extract_common_expressions 0 --use_async_executor_for_materialized_views 0 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 0 --use_skip_indexes_if_final 0 --use_skip_indexes_on_data_read 1 --optimize_rewrite_like_perfect_affix 1 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 1 --allow_special_serialization_kinds_in_output_formats 1 --short_circuit_function_evaluation_for_nulls_threshold 0.6273486378608256 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 925221 --query_plan_optimize_join_order_algorithm dpsize,greedy --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0 --use_skip_indexes_if_final_exact_mode 0
2026-02-16 15:21:10 
2026-02-16 15:21:10 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 830408 --vertical_merge_algorithm_min_columns_to_activate 66 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 16124012 --merge_max_block_size 21602 --index_granularity 34201 --min_bytes_for_wide_part 1029713071 --marks_compress_block_size 48339 --primary_key_compress_block_size 13935 --replace_long_file_name_to_hash 0 --max_file_name_length 110 --min_bytes_for_full_part_storage 155893748 --compact_parts_max_bytes_to_buffer 398137417 --compact_parts_max_granules_to_buffer 136 --compact_parts_merge_max_bytes_to_prefetch_part 22447195 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 264 --prewarm_mark_cache 1 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 0 --enable_block_number_column 0 --enable_block_offset_column 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 --object_serialization_version v3 --object_shared_data_serialization_version map --object_shared_data_serialization_version_for_zero_level_parts advanced --object_shared_data_buckets_for_compact_part 8 --object_shared_data_buckets_for_wide_part 10 --dynamic_serialization_version v3 --auto_statistics_types tdigest --serialization_info_version basic --string_serialization_version single_stream --nullable_serialization_version allow_sparse --enable_shared_storage_snapshot_in_query 1 --min_columns_to_activate_adaptive_write_buffer 595 --reduce_blocking_parts_sleep_ms 1913 --shared_merge_tree_outdated_parts_group_size 2 --shared_merge_tree_max_outdated_parts_to_process_at_once 2
2026-02-16 15:21:10 
2026-02-16 15:21:10 Database: test_846j47au

Metadata

Metadata

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