Skip to content

03141_fetches_errors_stress is flaky #83373

@rschu1ze

Description

@rschu1ze

Test case history

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

Metadata

Metadata

Assignees

Labels

flaky testflaky test found by CI

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions