Flaky test: 03822_attach_with_unknown_projection #95989
Description
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: 03822_attach_with_unknown_projection
Failure reason: result differs with reference
CI report: Stateless tests (amd_binary, old analyzer, s3 storage, DatabaseReplicated, parallel)
Failing test history: cidb
Test output:
2026-02-04 20:13:16 Reason: result differs with reference:
2026-02-04 20:13:16 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03822_attach_with_unknown_projection.reference 2026-02-04 20:06:06.983247323 +0000
2026-02-04 20:13:16 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03822_attach_with_unknown_projection.stdout 2026-02-04 20:13:16.214535528 +0000
2026-02-04 20:13:16 @@ -1,3 +1,2 @@
2026-02-04 20:13:16 7
2026-02-04 20:13:16 -Found unexpected projection directories: pp.proj
2026-02-04 20:13:16 -7
2026-02-04 20:13:16 +3
2026-02-04 20:13:16
2026-02-04 20:13:16
2026-02-04 20:13:16 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_qyb806ip/03822_attach_with_unknown_projection.sh.debuglog:
2026-02-04 20:13:16 + [2026-02-04 20:13:15] [:7] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_qyb806ip --log_comment 03822_attach_with_unknown_projection.sh-test_qyb806ip --max_insert_threads 2 --group_by_two_level_threshold 38399 --group_by_two_level_threshold_bytes 8470266 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 11372388 --max_read_buffer_size 753654 --prefer_localhost_replica 1 --max_block_size 83690 --max_joined_block_size_rows 24335 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 775 --max_threads 3 --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 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 38 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 24384906 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --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 1 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 5 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 580132941 --min_compress_block_size 2608451 --max_compress_block_size 2924828 --merge_tree_compact_parts_min_granules_to_multibuffer_read 5 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 4132590 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.63 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 1 --max_parsing_threads 1 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --enable_vertical_final 0 --optimize_extract_common_expressions 1 --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 0 --enable_lazy_columns_replication 0 --allow_special_serialization_kinds_in_output_formats 0 --short_circuit_function_evaluation_for_nulls_threshold 0.7887516525760103 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 887160 --query_plan_optimize_join_order_algorithm dpsize,greedy --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.11 --max_bytes_ratio_before_external_group_by 0.2 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 10644633378 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 7422616 --merge_max_block_size 16519 --index_granularity 40610 --min_bytes_for_wide_part 6984982 --marks_compress_block_size 91078 --primary_key_compress_block_size 46988 --replace_long_file_name_to_hash 1 --max_file_name_length 128 --min_bytes_for_full_part_storage 1867878 --compact_parts_max_bytes_to_buffer 325178513 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 29780954 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 10 --prewarm_mark_cache 0 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 0 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 0 --object_serialization_version v2 --object_shared_data_serialization_version advanced --object_shared_data_serialization_version_for_zero_level_parts advanced --object_shared_data_buckets_for_compact_part 2 --object_shared_data_buckets_for_wide_part 9 --dynamic_serialization_version v3 --auto_statistics_types minmax --serialization_info_version basic --string_serialization_version single_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 1 --min_columns_to_activate_adaptive_write_buffer 47 --reduce_blocking_parts_sleep_ms 1050 --shared_merge_tree_outdated_parts_group_size 2 --shared_merge_tree_max_outdated_parts_to_process_at_once 3 --allow_repeated_settings --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03822_attach_with_unknown_projection.stderr-fatal -m -q '
2026-02-04 20:13:16 drop table if exists attach_with_unknown_projection sync;
2026-02-04 20:13:16
2026-02-04 20:13:16 create table attach_with_unknown_projection (x Int32, y Int32, projection p (select x, y order by x))
2026-02-04 20:13:16 engine = ReplicatedMergeTree('\''/clickhouse/tables/{database}/attach_with_unknown_projection'\'', '\''1'\'')
2026-02-04 20:13:16 order by y
2026-02-04 20:13:16 partition by intDiv(y, 100) settings max_parts_to_merge_at_once=1;
2026-02-04 20:13:16
2026-02-04 20:13:16 insert into attach_with_unknown_projection select number, number from numbers(3);
2026-02-04 20:13:16
2026-02-04 20:13:16 set mutations_sync = 2;
2026-02-04 20:13:16 alter table attach_with_unknown_projection add projection pp (select x, count() group by x);
2026-02-04 20:13:16 insert into attach_with_unknown_projection select number, number from numbers(4);
2026-02-04 20:13:16 select count() from attach_with_unknown_projection;
2026-02-04 20:13:16
2026-02-04 20:13:16 alter table attach_with_unknown_projection detach partition '\''0'\'';
2026-02-04 20:13:16 alter table attach_with_unknown_projection clear projection pp;
2026-02-04 20:13:16 alter table attach_with_unknown_projection drop projection pp;
2026-02-04 20:13:16 alter table attach_with_unknown_projection attach partition '\''0'\'';
2026-02-04 20:13:16 '
2026-02-04 20:13:16 + [2026-02-04 20:13:15] [:31] grep -o 'Found unexpected projection directories: pp.proj
2026-02-04 20:13:16 '
2026-02-04 20:13:16 + [2026-02-04 20:13:15] [:28] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_qyb806ip --log_comment 03822_attach_with_unknown_projection.sh-test_qyb806ip --max_insert_threads 2 --group_by_two_level_threshold 38399 --group_by_two_level_threshold_bytes 8470266 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 11372388 --max_read_buffer_size 753654 --prefer_localhost_replica 1 --max_block_size 83690 --max_joined_block_size_rows 24335 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 775 --max_threads 3 --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 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 38 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 24384906 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --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 1 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 5 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 580132941 --min_compress_block_size 2608451 --max_compress_block_size 2924828 --merge_tree_compact_parts_min_granules_to_multibuffer_read 5 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 4132590 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.63 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 1 --max_parsing_threads 1 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --enable_vertical_final 0 --optimize_extract_common_expressions 1 --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 0 --enable_lazy_columns_replication 0 --allow_special_serialization_kinds_in_output_formats 0 --short_circuit_function_evaluation_for_nulls_threshold 0.7887516525760103 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 887160 --query_plan_optimize_join_order_algorithm dpsize,greedy --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.11 --max_bytes_ratio_before_external_group_by 0.2 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 10644633378 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 7422616 --merge_max_block_size 16519 --index_granularity 40610 --min_bytes_for_wide_part 6984982 --marks_compress_block_size 91078 --primary_key_compress_block_size 46988 --replace_long_file_name_to_hash 1 --max_file_name_length 128 --min_bytes_for_full_part_storage 1867878 --compact_parts_max_bytes_to_buffer 325178513 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 29780954 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 10 --prewarm_mark_cache 0 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 0 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 0 --object_serialization_version v2 --object_shared_data_serialization_version advanced --object_shared_data_serialization_version_for_zero_level_parts advanced --object_shared_data_buckets_for_compact_part 2 --object_shared_data_buckets_for_wide_part 9 --dynamic_serialization_version v3 --auto_statistics_types minmax --serialization_info_version basic --string_serialization_version single_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 1 --min_columns_to_activate_adaptive_write_buffer 47 --reduce_blocking_parts_sleep_ms 1050 --shared_merge_tree_outdated_parts_group_size 2 --shared_merge_tree_max_outdated_parts_to_process_at_once 3 --allow_repeated_settings --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03822_attach_with_unknown_projection.stderr-fatal -m -q '
2026-02-04 20:13:16 set send_logs_level='\''fatal'\'';
2026-02-04 20:13:16 set check_query_single_value_result = 1;
2026-02-04 20:13:16 check table attach_with_unknown_projection settings check_query_single_value_result = 0;'
2026-02-04 20:13:16 + [2026-02-04 20:13:16] [:34] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_qyb806ip --log_comment 03822_attach_with_unknown_projection.sh-test_qyb806ip --max_insert_threads 2 --group_by_two_level_threshold 38399 --group_by_two_level_threshold_bytes 8470266 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 11372388 --max_read_buffer_size 753654 --prefer_localhost_replica 1 --max_block_size 83690 --max_joined_block_size_rows 24335 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 775 --max_threads 3 --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 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 38 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 24384906 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --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 1 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate_express