2025-04-04 20:05:29 Using queries from '/repo/tests/queries' directory 2025-04-04 20:05:29 Connecting to ClickHouse server... OK 2025-04-04 20:05:29 Connected to server 24.12.2.20230.altinityantalya @ 68c99b882d1c07298d583abb39b89af0c988aa3a HEAD 2025-04-04 20:05:29 Won't run stateless tests because they were manually disabled. 2025-04-04 20:05:29 Found 133 parallel tests and 6 sequential tests 2025-04-04 20:05:30 Running about 66 stateful tests (Process-3). 2025-04-04 20:05:30 00139_like: [ OK ] 1.37 sec. 2025-04-04 20:05:33 00074_full_join: [ OK ] 2.87 sec. 2025-04-04 20:05:33 00176_bson_parallel_parsing: [ SKIPPED ] 0.00 sec. 2025-04-04 20:05:33 Reason: disabled 2025-04-04 20:05:33 00031_array_enumerate_uniq: [ OK ] 0.17 sec. 2025-04-04 20:05:34 00061_storage_buffer: [ OK ] 0.52 sec. 2025-04-04 20:05:34 00078_group_by_arrays: [ OK ] 0.52 sec. 2025-04-04 20:05:34 00143_transform_non_const_default: [ OK ] 0.17 sec. 2025-04-04 20:05:37 Running about 66 stateful tests (Process-4). 2025-04-04 20:05:37 00159_parallel_formatting_json_and_friends_2: [ OK ] 8.65 sec. 2025-04-04 20:05:38 00171_grouping_aggregated_transform_bug: [ OK ] 0.72 sec. 2025-04-04 20:05:39 00147_global_in_aggregate_function: [ OK ] 0.97 sec. 2025-04-04 20:05:39 00169_contingency: [ OK ] 4.73 sec. 2025-04-04 20:05:39 00011_sorting: [ OK ] 0.27 sec. 2025-04-04 20:05:42 00163_column_oriented_formats: [ OK ] 2.32 sec. 2025-04-04 20:05:42 00046_uniq_upto_distributed: [ OK ] 3.12 sec. 2025-04-04 20:05:42 00004_top_counters: [ OK ] 0.22 sec. 2025-04-04 20:05:44 00146_aggregate_function_uniq: [ OK ] 1.42 sec. 2025-04-04 20:05:44 00154_avro: [ OK ] 0.42 sec. 2025-04-04 20:05:45 00021_1_select_with_in: [ OK ] 0.27 sec. 2025-04-04 20:05:45 00077_log_tinylog_stripelog: [ OK ] 3.02 sec. 2025-04-04 20:05:45 00083_array_filter: [ OK ] 0.17 sec. 2025-04-04 20:05:45 00175_counting_resources_in_subqueries: [ OK ] 0.22 sec. 2025-04-04 20:05:45 00081_group_by_without_key_and_totals: [ OK ] 0.17 sec. 2025-04-04 20:05:45 00151_order_by_read_in_order: [ OK ] 0.17 sec. 2025-04-04 20:05:45 00141_transform: [ OK ] 0.12 sec. 2025-04-04 20:05:46 00045_uniq_upto: [ OK ] 1.07 sec. 2025-04-04 20:05:46 00060_move_to_prewhere_and_sets: [ OK ] 0.17 sec. 2025-04-04 20:05:55 00159_parallel_formatting_csv_and_friends: [ OK ] 9.44 sec. 2025-04-04 20:05:55 00144_functions_of_aggregation_states: [ OK ] 0.27 sec. 2025-04-04 20:05:59 00181_cross_join_compression: [ OK ] 4.58 sec. 2025-04-04 20:06:00 00086_array_reduce: [ OK ] 0.37 sec. 2025-04-04 20:06:00 00142_system_columns: [ OK ] 0.12 sec. 2025-04-04 20:06:03 00080_array_join_and_union: [ OK ] 2.57 sec. 2025-04-04 20:06:04 00043_any_left_join: [ OK ] 1.02 sec. 2025-04-04 20:06:09 00159_parallel_formatting_tsv_and_friends: [ OK ] 5.58 sec. 2025-04-04 20:06:09 00183_prewhere_conditions_order: [ OK ] 0.12 sec. 2025-04-04 20:06:11 00161_parallel_parsing_with_names: [ OK ] 2.12 sec. 2025-04-04 20:06:12 00093_prewhere_array_join: [ OK ] 1.02 sec. 2025-04-04 20:06:13 00049_max_string_if: [ OK ] 0.42 sec. 2025-04-04 20:06:14 00182_simple_squashing_transform_bug: [ OK ] 0.67 sec. 2025-04-04 20:06:14 00033_aggregate_key_string: [ OK ] 0.22 sec. 2025-04-04 20:06:14 00012_sorting_distributed: [ OK ] 0.32 sec. 2025-04-04 20:06:14 00032_aggregate_key64: [ OK ] 0.17 sec. 2025-04-04 20:06:16 00040_aggregating_materialized_view: [ OK ] 1.57 sec. 2025-04-04 20:06:16 00002_count_visits: [ OK ] 0.12 sec. 2025-04-04 20:06:16 00066_sorting_distributed_many_replicas: [ OK ] 0.12 sec. 2025-04-04 20:06:19 00044_any_left_join_string: [ OK ] 32.34 sec. 2025-04-04 20:06:19 00068_subquery_in_prewhere: [ OK ] 0.17 sec. 2025-04-04 20:06:19 00098_primary_key_memory_allocated: [ OK ] 0.12 sec. 2025-04-04 20:06:19 00023_totals_limit: [ OK ] 3.07 sec. 2025-04-04 20:06:19 00034_aggregate_key_fixed_string: [ OK ] 0.22 sec. 2025-04-04 20:06:20 00075_left_array_join: [ OK ] 0.42 sec. 2025-04-04 20:06:20 00048_min_max: [ OK ] 0.12 sec. 2025-04-04 20:06:20 00014_filtering_arrays: [ OK ] 0.17 sec. 2025-04-04 20:06:20 00153_aggregate_arena_race: [ OK ] 0.42 sec. 2025-04-04 20:06:20 00050_min_max: [ OK ] 0.27 sec. 2025-04-04 20:06:20 00006_agregates: [ OK ] 0.17 sec. 2025-04-04 20:06:21 00041_aggregating_materialized_view: [ OK ] 0.72 sec. 2025-04-04 20:06:21 00017_aggregation_uninitialized_memory: [ OK ] 0.17 sec. 2025-04-04 20:06:21 00174_distinct_in_order: [ OK ] 1.02 sec. 2025-04-04 20:06:22 00001_count_hits: [ OK ] 0.12 sec. 2025-04-04 20:06:22 00096_obfuscator_save_load: [ OK ] 0.67 sec. 2025-04-04 20:06:22 00039_primary_key: [ OK ] 0.12 sec. 2025-04-04 20:06:22 00051_min_max_array: [ OK ] 1.62 sec. 2025-04-04 20:06:23 00076_system_columns_bytes: [ OK ] 0.12 sec. 2025-04-04 20:06:23 00065_loyalty_with_storage_join: [ OK ] 0.47 sec. 2025-04-04 20:06:23 00173_group_by_use_nulls: [ OK ] 0.77 sec. 2025-04-04 20:06:23 00055_index_and_not: [ OK ] 0.17 sec. 2025-04-04 20:06:23 00056_view: [ OK ] 0.37 sec. 2025-04-04 20:06:23 00021_2_select_with_in: [ OK ] 0.17 sec. 2025-04-04 20:06:24 00037_uniq_state_merge1: [ OK ] 0.67 sec. 2025-04-04 20:06:25 00148_monotonic_functions_and_index: [ OK ] 0.62 sec. 2025-04-04 20:06:25 00009_uniq_distributed: [ OK ] 0.22 sec. 2025-04-04 20:06:25 00073_uniq_array: [ OK ] 0.12 sec. 2025-04-04 20:06:27 00020_distinct_order_by_distributed: [ OK ] 3.58 sec. 2025-04-04 20:06:27 00090_thread_pool_deadlock: [ OK ] 2.28 sec. 2025-04-04 20:06:29 00072_compare_date_and_string_index: [ OK ] 1.58 sec. 2025-04-04 20:06:29 00015_totals_and_no_aggregate_functions: [ OK ] 0.12 sec. 2025-04-04 20:06:29 00172_early_constant_folding: [ OK ] 0.12 sec. 2025-04-04 20:06:29 00089_position_functions_with_non_constant_arg: [ OK ] 1.43 sec. 2025-04-04 20:06:30 00092_obfuscator: [ OK ] 0.82 sec. 2025-04-04 20:06:30 00094_order_by_array_join_limit: [ OK ] 0.92 sec. 2025-04-04 20:06:30 00150_quantiles_timing_precision: [ OK ] 0.47 sec. 2025-04-04 20:06:30 00097_constexpr_in_index: [ OK ] 0.12 sec. 2025-04-04 20:06:31 00162_mmap_compression_none: [ OK ] 0.87 sec. 2025-04-04 20:06:31 00166_explain_estimate: [ OK ] 0.12 sec. 2025-04-04 20:06:31 00052_group_by_in: [ OK ] 0.37 sec. 2025-04-04 20:06:31 00087_where_0: [ OK ] 0.17 sec. 2025-04-04 20:06:32 00145_aggregate_functions_statistics: [ OK ] 0.62 sec. 2025-04-04 20:06:33 00178_quantile_ddsketch: [ OK ] 2.02 sec. 2025-04-04 20:06:33 00022_merge_prewhere: [ OK ] 0.17 sec. 2025-04-04 20:06:33 00062_loyalty: [ OK ] 0.22 sec. 2025-04-04 20:06:33 00035_aggregate_keys128: [ OK ] 0.17 sec. 2025-04-04 20:06:35 00091_prewhere_two_conditions: [ OK ] 1.17 sec. 2025-04-04 20:06:35 00088_global_in_one_shard_and_rows_before_limit: [ OK ] 0.32 sec. 2025-04-04 20:06:35 00013_sorting_of_nested: [ OK ] 3.88 sec. 2025-04-04 20:06:37 00167_read_bytes_from_fs: [ OK ] 2.22 sec. 2025-04-04 20:06:37 00085_monotonic_evaluation_segfault: [ OK ] 0.12 sec. 2025-04-04 20:06:41 00084_external_aggregation: [ OK ] 3.58 sec. 2025-04-04 20:06:41 00069_duplicate_aggregation_keys: [ OK ] 0.12 sec. 2025-04-04 20:06:46 00159_parallel_formatting_json_and_friends_1: [ OK ] 10.21 sec. 2025-04-04 20:06:47 00175_obfuscator_schema_inference: [ OK ] 0.97 sec. 2025-04-04 20:06:48 00177_memory_bound_merging: [ OK ] 1.37 sec. 2025-04-04 20:06:48 00007_uniq: [ OK ] 0.12 sec. 2025-04-04 20:06:49 00159_parallel_formatting_http: [ OK ] 7.78 sec. 2025-04-04 20:06:49 00021_3_select_with_in: [ OK ] 0.12 sec. 2025-04-04 20:06:53 00167_parallel_parsing_with_names_and_types: [ OK ] 4.48 sec. 2025-04-04 20:06:53 00005_filtering: [ OK ] 0.17 sec. 2025-04-04 20:06:53 00042_any_left_join: [ OK ] 0.17 sec. 2025-04-04 20:06:56 00184_parallel_hash_returns_same_res_as_hash: [ OK ] 2.62 sec. 2025-04-04 20:06:56 00095_hyperscan_profiler: [ SKIPPED ] 0.00 sec. 2025-04-04 20:06:56 Reason: not running for current build 2025-04-04 20:06:56 00079_array_join_not_used_joined_column: [ OK ] 0.47 sec. 2025-04-04 20:06:57 00038_uniq_state_merge2: [ OK ] 0.57 sec. 2025-04-04 20:06:58 00172_hits_joins: [ OK ] 8.79 sec. 2025-04-04 20:06:58 00030_array_enumerate_uniq: [ OK ] 0.42 sec. 2025-04-04 20:06:59 00053_replicate_segfault: [ OK ] 0.77 sec. 2025-04-04 20:06:59 00067_union_all: [ OK ] 0.42 sec. 2025-04-04 20:07:00 00176_distinct_limit_by_limit_bug_43377: [ OK ] 0.17 sec. 2025-04-04 20:07:03 00082_quantiles: [ OK ] 6.48 sec. 2025-04-04 20:07:06 00024_random_counters: [ OK ] 6.18 sec. 2025-04-04 20:07:06 00063_loyalty_joins: [ OK ] 0.57 sec. 2025-04-04 20:07:07 00010_quantiles_segfault: [ OK ] 0.17 sec. 2025-04-04 20:07:07 00008_uniq: [ OK ] 0.27 sec. 2025-04-04 20:07:07 00160_decode_xml_component: [ OK ] 0.47 sec. 2025-04-04 20:07:08 00156_max_execution_speed_sample_merge: [ OK ] 4.28 sec. 2025-04-04 20:07:08 00036_aggregate_hashed: [ OK ] 0.32 sec. 2025-04-04 20:07:08 00054_merge_tree_partitions: [ OK ] 0.32 sec. 2025-04-04 20:07:08 00149_quantiles_timing_distributed: [ OK ] 0.82 sec. 2025-04-04 20:07:09 00165_jit_aggregate_functions: [ OK ] 1.17 sec. 2025-04-04 20:07:09 00047_bar: [ OK ] 0.22 sec. 2025-04-04 20:07:10 00164_quantileBfloat16: [ OK ] 0.67 sec. 2025-04-04 20:07:10 00071_merge_tree_optimize_aio: [ OK ] 1.77 sec. 2025-04-04 20:07:10 00016_any_if_distributed_cond_always_false: [ OK ] 0.22 sec. 2025-04-04 20:07:10 2025-04-04 20:07:10 64 tests passed. 1 tests skipped. 101.72 s elapsed (Process-3). 2025-04-04 20:07:11 00059_merge_sorting_empty_array_joined: [ OK ] 0.52 sec. 2025-04-04 20:07:11 2025-04-04 20:07:11 67 tests passed. 1 tests skipped. 102.13 s elapsed (Process-4). 2025-04-04 20:07:11 Running 6 stateful tests (MainProcess). 2025-04-04 20:07:18 00180_no_seek_avoiding_when_reading_from_cache: [ OK ] 7.35 sec. 2025-04-04 20:07:22 00170_s3_cache: [ OK ] 4.14 sec. 2025-04-04 20:08:10 00158_cache_dictionary_has: [ OK ] 48.24 sec. 2025-04-04 20:13:56 00157_cache_dictionary: [ FAIL ] 345.86 sec. 2025-04-04 20:13:56 Reason: return code: 160 2025-04-04 20:13:56 [43284ad0aef1] 2025.04.04 14:13:56.774213 [ 3666 ] {e0b2fb7d-6f20-4ae3-9553-4fa23273c317} executeQuery: Code: 160. DB::Exception: Estimated query execution time (1029.17362 seconds) is too long. Maximum: 600. Estimated rows to process: 1000000 (335872 read in 345.67060 seconds).: While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (TOO_SLOW) (version 24.12.2.20230.altinityantalya (altinity build)) (from [::1]:52258) (comment: 00157_cache_dictionary.sql) (in query: INSERT INTO test.hits_1m SELECT * FROM test.hits LIMIT 1000000 SETTINGS min_insert_block_size_rows = 0, min_insert_block_size_bytes = 0, max_block_size = 8192, max_insert_threads = 1, max_threads = 1, max_parallel_replicas=1;), Stack trace (when copying this message, always include the lines below): 2025-04-04 20:13:56 2025-04-04 20:13:56 0. /build/contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x0000000017ef67f2 2025-04-04 20:13:56 1. /build/src/Common/Exception.cpp:105: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cd55af9 2025-04-04 20:13:56 2. /build/src/Common/Exception.h:105: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000757c4ec 2025-04-04 20:13:56 3. /build/src/Common/Exception.h:123: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity::type>, double&, int&&, unsigned long&, unsigned long&, double&) @ 0x0000000011af1cd9 2025-04-04 20:13:56 4. /build/src/QueryPipeline/ExecutionSpeedLimits.cpp:87: DB::ExecutionSpeedLimits::throttle(unsigned long, unsigned long, unsigned long, unsigned long, DB::OverflowMode) const @ 0x0000000011af19af 2025-04-04 20:13:56 5. /build/src/QueryPipeline/ReadProgressCallback.cpp:131: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x0000000011af1139 2025-04-04 20:13:56 6. /build/src/Processors/Executors/ExecutionThreadContext.cpp:64: DB::ExecutionThreadContext::executeTask() @ 0x00000000143c59e3 2025-04-04 20:13:56 7. /build/src/Processors/Executors/PipelineExecutor.cpp:290: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x00000000143ba970 2025-04-04 20:13:56 8. /build/src/Processors/Executors/PipelineExecutor.cpp:256: DB::PipelineExecutor::executeSingleThread(unsigned long) @ 0x00000000143bac3e 2025-04-04 20:13:56 9. /build/src/Processors/Executors/PipelineExecutor.cpp:442: DB::PipelineExecutor::executeImpl(unsigned long, bool) @ 0x00000000143b948c 2025-04-04 20:13:56 10. /build/src/Processors/Executors/PipelineExecutor.cpp:127: DB::PipelineExecutor::execute(unsigned long, bool) @ 0x00000000143b8e8f 2025-04-04 20:13:56 11. /build/src/Processors/Executors/CompletedPipelineExecutor.cpp:49: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl(DB::CompletedPipelineExecutor::execute()::$_0&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x00000000143b8287 2025-04-04 20:13:56 12. /build/contrib/llvm-project/libcxx/include/__functional/function.h:848: ? @ 0x000000000ce12ac0 2025-04-04 20:13:56 13. /build/contrib/llvm-project/libcxx/include/__functional/invoke.h:359: ? @ 0x000000000ce183d2 2025-04-04 20:13:56 14. ? @ 0x00007f10f135cac3 2025-04-04 20:13:56 15. ? @ 0x00007f10f13ee850 2025-04-04 20:13:56 2025-04-04 20:13:56 Received exception from server (version 24.12.2): 2025-04-04 20:13:56 Code: 160. DB::Exception: Received from localhost:9000. DB::Exception: Estimated query execution time (1029.17362 seconds) is too long. Maximum: 600. Estimated rows to process: 1000000 (335872 read in 345.67060 seconds).: While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (TOO_SLOW) 2025-04-04 20:13:56 (query: INSERT INTO test.hits_1m SELECT * FROM test.hits LIMIT 1000000 2025-04-04 20:13:56 SETTINGS min_insert_block_size_rows = 0, min_insert_block_size_bytes = 0, max_block_size = 8192, max_insert_threads = 1, max_threads = 1, max_parallel_replicas=1;) 2025-04-04 20:13:56 , result: 2025-04-04 20:13:56 2025-04-04 20:13:56 2025-04-04 20:13:56 2025-04-04 20:13:56 stdout: 2025-04-04 20:13:56 2025-04-04 20:13:56 2025-04-04 20:13:56 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 885089 --group_by_two_level_threshold_bytes 21658335 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 10837708 --max_read_buffer_size 963813 --prefer_localhost_replica 0 --max_block_size 37929 --max_joined_block_size_rows 31300 --max_threads 2 --optimize_append_index 1 --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 0 --read_in_order_two_level_merge_threshold 91 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 9566008 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10318199117 --local_filesystem_read_method mmap --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 5 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 21 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1736680354 --min_compress_block_size 1450093 --max_compress_block_size 2442354 --merge_tree_compact_parts_min_granules_to_multibuffer_read 44 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 1196352 --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 3 --min_count_to_compile_sort_description 0 --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.71 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 1 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --output_format_native_write_json_as_string 0 --enable_vertical_final 0 2025-04-04 20:13:56 2025-04-04 20:13:56 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 395089 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 28778063 --merge_max_block_size 1827 --index_granularity 46095 --min_bytes_for_wide_part 677004675 --marks_compress_block_size 54374 --primary_key_compress_block_size 45764 --replace_long_file_name_to_hash 0 --max_file_name_length 22 --min_bytes_for_full_part_storage 338124335 --compact_parts_max_bytes_to_buffer 54351180 --compact_parts_max_granules_to_buffer 119 --compact_parts_merge_max_bytes_to_prefetch_part 25546451 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 0 --old_parts_lifetime 394 --prewarm_mark_cache 0 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 2025-04-04 20:13:56 2025-04-04 20:13:56 Database: test_dvmqezlo 2025-04-04 20:13:58 00152_insert_different_granularity: [ OK ] 1.62 sec. 2025-04-04 20:14:00 00140_rename: [ OK ] 1.82 sec. 2025-04-04 20:14:00 2025-04-04 20:14:00 Having 1 errors! 5 tests passed. 0 tests skipped. 409.15 s elapsed (MainProcess). 2025-04-04 20:14:00 Checking the hung queries: done 2025-04-04 20:14:00 2025-04-04 20:14:00 No queries hung. 2025-04-04 20:14:00 All tests have finished.