-
Notifications
You must be signed in to change notification settings - Fork 8.3k
03141_fetches_errors_stress is flaky #83373
Copy link
Copy link
Closed
Labels
flaky testflaky test found by CIflaky test found by CI
Description
Example failure from here:
2025-07-06 07:58:41 Reason: result differs with reference:
2025-07-06 07:58:41 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03141_fetches_errors_stress.reference 2025-07-06 07:25:59.582108755 -1000
2025-07-06 07:58:41 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03141_fetches_errors_stress.stdout 2025-07-06 07:58:41.069585041 -1000
2025-07-06 07:58:41 @@ -1,12 +1,13 @@
2025-07-06 07:58:41 -- { echoOn }
2025-07-06 07:58:41 select table, errorCodeToName(error), count() from system.part_log where
2025-07-06 07:58:41 database = currentDatabase()
2025-07-06 07:58:41 and error > 0
2025-07-06 07:58:41 and errorCodeToName(error) not in ('FAULT_INJECTED', 'NO_REPLICA_HAS_PART', 'ATTEMPT_TO_READ_AFTER_EOF')
2025-07-06 07:58:41 and (errorCodeToName(error) != 'POCO_EXCEPTION' or exception not like '%Malformed message: Unexpected EOF%')
2025-07-06 07:58:41 group by 1, 2
2025-07-06 07:58:41 order by 1, 2;
2025-07-06 07:58:41 +data_r2 CHECKSUM_DOESNT_MATCH 1
2025-07-06 07:58:41 select count() from data_r1;
2025-07-06 07:58:41 100000
2025-07-06 07:58:41 select count() from data_r2;
2025-07-06 07:58:41 100000
2025-07-06 07:58:41
2025-07-06 07:58:41
2025-07-06 07:58:41 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 82786 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 10251455 --max_read_buffer_size 981363 --prefer_localhost_replica 0 --max_block_size 16502 --max_joined_block_size_rows 92928 --max_threads 1 --optimize_append_index 0 --use_hedged_requests 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 39 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 23699671 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 3979759474 --min_bytes_to_use_mmap_io 10737418240 --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 1 --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 64Mi --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 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 9 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 2058716030 --min_compress_block_size 2827343 --max_compress_block_size 578700 --merge_tree_compact_parts_min_granules_to_multibuffer_read 99 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 8899308 --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 --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.33 --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 1 --max_parsing_threads 10 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table true --enable_vertical_final 0 --optimize_extract_common_expressions 0 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 1 --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 1
2025-07-06 07:58:41
2025-07-06 07:58:41 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 1 --min_merge_bytes_to_use_direct_io 9604009293 --index_granularity_bytes 8779751 --merge_max_block_size 22149 --index_granularity 22347 --min_bytes_for_wide_part 0 --marks_compress_block_size 17760 --primary_key_compress_block_size 75493 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 113676200 --compact_parts_max_granules_to_buffer 159 --compact_parts_merge_max_bytes_to_prefetch_part 25713647 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 0 --old_parts_lifetime 480 --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 1 --prewarm_primary_key_cache 1
2025-07-06 07:58:41
2025-07-06 07:58:41 Database: test_4bt5yu6p
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
flaky testflaky test found by CIflaky test found by CI