2025-09-24 08:12:42 Reason: result differs with reference:  
2025-09-24 08:12:42 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01040_dictionary_invalidate_query_switchover_long.reference	2025-09-24 07:45:00.309749927 -0400
2025-09-24 08:12:42 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01040_dictionary_invalidate_query_switchover_long.stdout	2025-09-24 08:12:42.278193324 -0400
2025-09-24 08:12:42 @@ -1,5 +1,5 @@
2025-09-24 08:12:42  122
2025-09-24 08:12:42  
2025-09-24 08:12:42  1
2025-09-24 08:12:42  
2025-09-24 08:12:42 -133
2025-09-24 08:12:42 +0
2025-09-24 08:12:42 
2025-09-24 08:12:42 
2025-09-24 08:12:42 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_uw6f2bht/01040_dictionary_invalidate_query_switchover_long.sh.debuglog:
2025-09-24 08:12:42 + [2025-09-24 08:12:21] [:8] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_uw6f2bht --log_comment 01040_dictionary_invalidate_query_switchover_long.sh-test_uw6f2bht --max_insert_threads 1 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 38953212 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 1765296 --max_read_buffer_size 884103 --prefer_localhost_replica 0 --max_block_size 11630 --max_joined_block_size_rows 20344 --max_threads 2 --optimize_append_index 1 --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 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 81 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 20055735 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method read --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 2 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 29 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 895272432 --min_compress_block_size 610184 --max_compress_block_size 835134 --merge_tree_compact_parts_min_granules_to_multibuffer_read 9 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 9105013 --http_wait_end_of_query True --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 Europe/Amsterdam --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.99 --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 0 --query_plan_join_swap_table false --enable_vertical_final 0 --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 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 2772478049 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 20054787 --merge_max_block_size 8465 --index_granularity 15448 --min_bytes_for_wide_part 1921695 --marks_compress_block_size 23549 --primary_key_compress_block_size 70448 --replace_long_file_name_to_hash 1 --max_file_name_length 72 --min_bytes_for_full_part_storage 217636053 --compact_parts_max_bytes_to_buffer 125736267 --compact_parts_max_granules_to_buffer 123 --compact_parts_merge_max_bytes_to_prefetch_part 30130444 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 394 --prewarm_mark_cache 0 --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 1 --object_serialization_version v2 --object_shared_data_serialization_version map_with_buckets --object_shared_data_serialization_version_for_zero_level_parts map_with_buckets --object_shared_data_buckets_for_compact_part 23 --object_shared_data_buckets_for_wide_part 16 --dynamic_serialization_version v2 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01040_dictionary_invalidate_query_switchover_long.stderr-fatal --query '
2025-09-24 08:12:42 CREATE TABLE dict_invalidate
2025-09-24 08:12:42 ENGINE = Memory AS
2025-09-24 08:12:42 SELECT
2025-09-24 08:12:42     122 as dummy,
2025-09-24 08:12:42     toDateTime('\''2019-10-29 18:51:35'\'') AS last_time
2025-09-24 08:12:42 FROM system.one'
2025-09-24 08:12:42 + [2025-09-24 08:12:23] [:17] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_uw6f2bht --log_comment 01040_dictionary_invalidate_query_switchover_long.sh-test_uw6f2bht --max_insert_threads 1 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 38953212 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 1765296 --max_read_buffer_size 884103 --prefer_localhost_replica 0 --max_block_size 11630 --max_joined_block_size_rows 20344 --max_threads 2 --optimize_append_index 1 --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 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 81 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 20055735 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method read --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 2 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 29 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 895272432 --min_compress_block_size 610184 --max_compress_block_size 835134 --merge_tree_compact_parts_min_granules_to_multibuffer_read 9 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 9105013 --http_wait_end_of_query True --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 Europe/Amsterdam --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.99 --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 0 --query_plan_join_swap_table false --enable_vertical_final 0 --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 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 2772478049 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 20054787 --merge_max_block_size 8465 --index_granularity 15448 --min_bytes_for_wide_part 1921695 --marks_compress_block_size 23549 --primary_key_compress_block_size 70448 --replace_long_file_name_to_hash 1 --max_file_name_length 72 --min_bytes_for_full_part_storage 217636053 --compact_parts_max_bytes_to_buffer 125736267 --compact_parts_max_granules_to_buffer 123 --compact_parts_merge_max_bytes_to_prefetch_part 30130444 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 394 --prewarm_mark_cache 0 --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 1 --object_serialization_version v2 --object_shared_data_serialization_version map_with_buckets --object_shared_data_serialization_version_for_zero_level_parts map_with_buckets --object_shared_data_buckets_for_compact_part 23 --object_shared_data_buckets_for_wide_part 16 --dynamic_serialization_version v2 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01040_dictionary_invalidate_query_switchover_long.stderr-fatal --query '
2025-09-24 08:12:42 CREATE DICTIONARY invalidate
2025-09-24 08:12:42 (
2025-09-24 08:12:42   dummy UInt64,
2025-09-24 08:12:42   two UInt8 EXPRESSION dummy
2025-09-24 08:12:42 )
2025-09-24 08:12:42 PRIMARY KEY dummy
2025-09-24 08:12:42 SOURCE(CLICKHOUSE(HOST '\''localhost'\'' PORT tcpPort() USER '\''default'\'' TABLE '\''dict_invalidate'\'' DB currentDatabase() INVALIDATE_QUERY '\''select max(last_time) from dict_invalidate'\''))
2025-09-24 08:12:42 LIFETIME(MIN 0 MAX 1)
2025-09-24 08:12:42 LAYOUT(FLAT())'
2025-09-24 08:12:42 + [2025-09-24 08:12:24] [:28] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_uw6f2bht --log_comment 01040_dictionary_invalidate_query_switchover_long.sh-test_uw6f2bht --max_insert_threads 1 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 38953212 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 1765296 --max_read_buffer_size 884103 --prefer_localhost_replica 0 --max_block_size 11630 --max_joined_block_size_rows 20344 --max_threads 2 --optimize_append_index 1 --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 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 81 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 20055735 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method read --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 2 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 29 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 895272432 --min_compress_block_size 610184 --max_compress_block_size 835134 --merge_tree_compact_parts_min_granules_to_multibuffer_read 9 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 9105013 --http_wait_end_of_query True --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 Europe/Amsterdam --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.99 --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 0 --query_plan_join_swap_table false --enable_vertical_final 0 --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 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 2772478049 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 20054787 --merge_max_block_size 8465 --index_granularity 15448 --min_bytes_for_wide_part 1921695 --marks_compress_block_size 23549 --primary_key_compress_block_size 70448 --replace_long_file_name_to_hash 1 --max_file_name_length 72 --min_bytes_for_full_part_storage 217636053 --compact_parts_max_bytes_to_buffer 125736267 --compact_parts_max_granules_to_buffer 123 --compact_parts_merge_max_bytes_to_prefetch_part 30130444 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 394 --prewarm_mark_cache 0 --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 1 --object_serialization_version v2 --object_shared_data_serialization_version map_with_buckets --object_shared_data_serialization_version_for_zero_level_parts map_with_buckets --object_shared_data_buckets_for_compact_part 23 --object_shared_data_buckets_for_wide_part 16 --dynamic_serialization_version v2 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/01040_dictionary_invalidate_query_switchover_long.stderr-fatal --query 'SELECT dictGetUInt8('\''invalidate'\'', '\''two'\''