2025-09-06 08:28:04 Using queries from '/usr/share/clickhouse-test/queries' directory 2025-09-06 08:28:04 Connecting to ClickHouse server... OK 2025-09-06 08:28:04 Connected to server 24.8.14.10512.altinitytest @ f6c53af9730619e8f58bf3b144f970d5134a810e HEAD 2025-09-06 08:28:05 Won't run stateless tests because they were manually disabled. 2025-09-06 08:28:05 Found 131 parallel tests and 6 sequential tests 2025-09-06 08:28:06 Running about 65 stateful tests (Process-4). 2025-09-06 08:28:06 00006_agregates: [ OK ] 1.53 sec. 2025-09-06 08:28:07 00151_order_by_read_in_order: [ OK ] 0.88 sec. 2025-09-06 08:28:14 Running about 65 stateful tests (Process-3). 2025-09-06 08:28:14 00061_storage_buffer: [ OK ] 9.80 sec. 2025-09-06 08:28:22 00067_union_all: [ OK ] 7.34 sec. 2025-09-06 08:28:27 00009_uniq_distributed: [ OK ] 5.14 sec. 2025-09-06 08:28:44 00071_merge_tree_optimize_aio: [ OK ] 37.32 sec. 2025-09-06 08:28:48 00063_loyalty_joins: [ OK ] 21.33 sec. 2025-09-06 08:28:54 00016_any_if_distributed_cond_always_false: [ OK ] 5.95 sec. 2025-09-06 08:28:57 00005_filtering: [ OK ] 2.65 sec. 2025-09-06 08:29:00 00010_quantiles_segfault: [ OK ] 3.13 sec. 2025-09-06 08:29:25 00072_compare_date_and_string_index: [ OK ] 24.79 sec. 2025-09-06 08:29:27 00053_replicate_segfault: [ OK ] 42.99 sec. 2025-09-06 08:29:29 00022_merge_prewhere: [ OK ] 1.15 sec. 2025-09-06 08:29:29 00011_sorting: [ OK ] 4.45 sec. 2025-09-06 08:29:32 00045_uniq_upto: [ OK ] 3.89 sec. 2025-09-06 08:29:46 00030_array_enumerate_uniq: [ OK ] 13.66 sec. 2025-09-06 08:29:47 00081_group_by_without_key_and_totals: [ OK ] 1.29 sec. 2025-09-06 08:29:49 00085_monotonic_evaluation_segfault: [ OK ] 1.63 sec. 2025-09-06 08:29:50 00069_duplicate_aggregation_keys: [ OK ] 0.84 sec. 2025-09-06 08:29:55 00144_functions_of_aggregation_states: [ OK ] 5.09 sec. 2025-09-06 08:29:57 00015_totals_and_no_aggregate_functions: [ OK ] 1.93 sec. 2025-09-06 08:30:01 00075_left_array_join: [ OK ] 3.89 sec. 2025-09-06 08:30:01 00093_prewhere_array_join: [ OK ] 32.01 sec. 2025-09-06 08:30:02 00097_constexpr_in_index: [ OK ] 0.53 sec. 2025-09-06 08:30:04 00141_transform: [ OK ] 2.03 sec. 2025-09-06 08:30:05 00176_distinct_limit_by_limit_bug_43377: [ OK ] 1.33 sec. 2025-09-06 08:30:06 00001_count_hits: [ OK ] 0.48 sec. 2025-09-06 08:30:13 00079_array_join_not_used_joined_column: [ OK ] 12.26 sec. 2025-09-06 08:30:14 00142_system_columns: [ OK ] 0.48 sec. 2025-09-06 08:30:17 00150_quantiles_timing_precision: [ OK ] 2.93 sec. 2025-09-06 08:30:19 00054_merge_tree_partitions: [ OK ] 1.93 sec. 2025-09-06 08:30:26 00080_array_join_and_union: [ OK ] 6.96 sec. 2025-09-06 08:30:30 00175_obfuscator_schema_inference: [ OK ] 4.39 sec. 2025-09-06 08:30:31 00076_system_columns_bytes: [ OK ] 0.64 sec. 2025-09-06 08:33:20 00167_read_bytes_from_fs: [ OK ] 168.83 sec. 2025-09-06 08:33:41 00171_grouping_aggregated_transform_bug: [ OK ] 20.94 sec. 2025-09-06 08:33:42 00002_count_visits: [ OK ] 1.13 sec. 2025-09-06 08:34:04 00094_order_by_array_join_limit: [ OK ] 22.29 sec. 2025-09-06 08:34:05 00159_parallel_formatting_http: [ FAIL ] 238.97 sec. 2025-09-06 08:34:05 Reason: having stderror: 2025-09-06 08:34:05 curl: (28) Operation timed out after 120000 milliseconds with 17476848 bytes received 2025-09-06 08:34:05 2025-09-06 08:34:05 stdout: 2025-09-06 08:34:05 TSV, false 2025-09-06 08:34:05 9e0a1b1db4d1e56b4b571a8824dde35b - 2025-09-06 08:34:05 TSV, true 2025-09-06 08:34:05 9e0a1b1db4d1e56b4b571a8824dde35b - 2025-09-06 08:34:05 CSV, false 2025-09-06 08:34:05 c8d09e7fb4eba1ac3311007783729dd6 - 2025-09-06 08:34:05 CSV, true 2025-09-06 08:34:05 c9c6f633a59d349f9f8a14ee2f1cb1b3 - 2025-09-06 08:34:05 JSONCompactEachRow, false 2025-09-06 08:34:05 826e244bd6c547b52955dd69df61ea22 - 2025-09-06 08:34:05 JSONCompactEachRow, true 2025-09-06 08:34:05 826e244bd6c547b52955dd69df61ea22 - 2025-09-06 08:34:05 2025-09-06 08:34:05 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 14136086 --max_read_buffer_size 944572 --prefer_localhost_replica 1 --max_block_size 20478 --max_joined_block_size_rows 64175 --max_threads 2 --optimize_append_index 0 --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 61 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 49760799 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method pread --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 3 --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 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 25 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1876099239 --min_compress_block_size 992152 --max_compress_block_size 963826 --merge_tree_compact_parts_min_granules_to_multibuffer_read 25 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 9100540 --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 0 --session_timezone Asia/Dhaka --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.14 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 1 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 2025-09-06 08:34:05 2025-09-06 08:34:05 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 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 2889118020 --index_granularity_bytes 28479184 --merge_max_block_size 18449 --index_granularity 701 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 34952 --primary_key_compress_block_size 39591 --replace_long_file_name_to_hash 0 --max_file_name_length 68 --min_bytes_for_full_part_storage 292361791 --compact_parts_max_bytes_to_buffer 110456429 --compact_parts_max_granules_to_buffer 164 --compact_parts_merge_max_bytes_to_prefetch_part 18202378 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 61 --old_parts_lifetime 480 2025-09-06 08:34:05 2025-09-06 08:34:05 Database: test_tioehizk 2025-09-06 08:34:07 00035_aggregate_keys128: [ OK ] 2.63 sec. 2025-09-06 08:34:11 00023_totals_limit: [ OK ] 4.55 sec. 2025-09-06 08:34:12 00021_3_select_with_in: [ OK ] 0.58 sec. 2025-09-06 08:34:15 00096_obfuscator_save_load: [ OK ] 3.44 sec. 2025-09-06 08:34:16 00055_index_and_not: [ OK ] 0.83 sec. 2025-09-06 08:34:18 00175_counting_resources_in_subqueries: [ OK ] 1.23 sec. 2025-09-06 08:34:20 00047_bar: [ OK ] 2.38 sec. 2025-09-06 08:34:51 00091_prewhere_two_conditions: [ OK ] 45.80 sec. 2025-09-06 08:34:52 00066_sorting_distributed_many_replicas: [ OK ] 0.87 sec. 2025-09-06 08:34:54 00004_top_counters: [ OK ] 2.68 sec. 2025-09-06 08:34:57 00032_aggregate_key64: [ OK ] 2.13 sec. 2025-09-06 08:34:58 00031_array_enumerate_uniq: [ OK ] 1.13 sec. 2025-09-06 08:35:47 00024_random_counters: [ OK ] 87.07 sec. 2025-09-06 08:36:13 00159_parallel_formatting_tsv_and_friends: [ OK ] 75.38 sec. 2025-09-06 08:36:16 00008_uniq: [ OK ] 3.14 sec. 2025-09-06 08:36:29 00038_uniq_state_merge2: [ OK ] 42.08 sec. 2025-09-06 08:36:37 00086_array_reduce: [ OK ] 21.13 sec. 2025-09-06 08:36:38 00007_uniq: [ OK ] 0.58 sec. 2025-09-06 08:36:41 00062_loyalty: [ OK ] 2.58 sec. 2025-09-06 08:36:47 00083_array_filter: [ OK ] 6.69 sec. 2025-09-06 08:36:48 00172_early_constant_folding: [ OK ] 0.93 sec. 2025-09-06 08:36:56 00177_memory_bound_merging: [ OK ] 8.05 sec. 2025-09-06 08:36:57 00048_min_max: [ OK ] 0.53 sec. 2025-09-06 08:37:05 00143_transform_non_const_default: [ OK ] 7.84 sec. 2025-09-06 08:37:25 00182_simple_squashing_transform_bug: [ OK ] 19.73 sec. 2025-09-06 08:37:56 00159_parallel_formatting_json_and_friends_2: [ OK ] 86.40 sec. 2025-09-06 08:38:06 00077_log_tinylog_stripelog: [ OK ] 41.54 sec. 2025-09-06 08:38:08 00181_cross_join_compression: [ OK ] 12.61 sec. 2025-09-06 08:38:17 00046_uniq_upto_distributed: [ OK ] 10.75 sec. 2025-09-06 08:38:35 00074_full_join: [ OK ] 27.05 sec. 2025-09-06 08:38:36 00149_quantiles_timing_distributed: [ OK ] 18.68 sec. 2025-09-06 08:38:52 00174_distinct_in_order: [ OK ] 16.57 sec. 2025-09-06 08:39:21 00178_quantile_ddsketch: [ OK ] 29.00 sec. 2025-09-06 08:39:25 00154_avro: [ OK ] 4.44 sec. 2025-09-06 08:41:00 00159_parallel_formatting_csv_and_friends: [ OK ] 144.20 sec. 2025-09-06 08:41:08 00041_aggregating_materialized_view: [ OK ] 7.80 sec. 2025-09-06 08:41:08 00098_primary_key_memory_allocated: [ OK ] 0.53 sec. 2025-09-06 08:41:34 00082_quantiles: [ OK ] 25.35 sec. 2025-09-06 08:41:52 00084_external_aggregation: [ OK ] 146.33 sec. 2025-09-06 08:42:35 00139_like: [ OK ] 61.25 sec. 2025-09-06 08:42:36 00166_explain_estimate: [ OK ] 0.79 sec. 2025-09-06 08:42:43 00169_contingency: [ OK ] 51.67 sec. 2025-09-06 08:42:46 00013_sorting_of_nested: [ OK ] 2.83 sec. 2025-09-06 08:42:48 00153_aggregate_arena_race: [ OK ] 12.51 sec. 2025-09-06 08:42:49 00052_group_by_in: [ OK ] 0.88 sec. 2025-09-06 08:42:52 00156_max_execution_speed_sample_merge: [ OK ] 5.74 sec. 2025-09-06 08:42:53 00017_aggregation_uninitialized_memory: [ OK ] 0.58 sec. 2025-09-06 08:42:59 00020_distinct_order_by_distributed: [ OK ] 9.76 sec. 2025-09-06 08:43:05 00145_aggregate_functions_statistics: [ OK ] 12.61 sec. 2025-09-06 08:43:18 00146_aggregate_function_uniq: [ OK ] 18.89 sec. 2025-09-06 08:43:22 00034_aggregate_key_fixed_string: [ OK ] 4.29 sec. 2025-09-06 08:43:31 00163_column_oriented_formats: [ OK ] 25.39 sec. 2025-09-06 08:43:34 00051_min_max_array: [ OK ] 11.90 sec. 2025-09-06 08:43:35 00092_obfuscator: [ OK ] 3.74 sec. 2025-09-06 08:43:45 00161_parallel_parsing_with_names: [ OK ] 10.60 sec. 2025-09-06 08:44:05 00167_parallel_parsing_with_names_and_types: [ OK ] 19.93 sec. 2025-09-06 08:44:13 00162_mmap_compression_none: [ OK ] 38.63 sec. 2025-09-06 08:44:13 00021_2_select_with_in: [ OK ] 0.58 sec. 2025-09-06 08:44:20 00173_group_by_use_nulls: [ OK ] 15.02 sec. 2025-09-06 08:44:24 00164_quantileBfloat16: [ OK ] 11.06 sec. 2025-09-06 08:44:31 00088_global_in_one_shard_and_rows_before_limit: [ OK ] 6.09 sec. 2025-09-06 08:45:44 00089_position_functions_with_non_constant_arg: [ OK ] 73.01 sec. 2025-09-06 08:45:46 00095_hyperscan_profiler: [ OK ] 85.54 sec. 2025-09-06 08:45:50 00049_max_string_if: [ OK ] 6.59 sec. 2025-09-06 08:45:53 00050_min_max: [ OK ] 2.94 sec. 2025-09-06 08:45:53 00065_loyalty_with_storage_join: [ OK ] 7.70 sec. 2025-09-06 08:45:54 00021_1_select_with_in: [ OK ] 0.53 sec. 2025-09-06 08:46:05 00056_view: [ OK ] 10.75 sec. 2025-09-06 08:46:35 00044_any_left_join_string: [ OK ] 30.36 sec. 2025-09-06 08:46:44 00014_filtering_arrays: [ OK ] 8.35 sec. 2025-09-06 08:47:27 00037_uniq_state_merge1: [ OK ] 43.49 sec. 2025-09-06 08:47:47 00159_parallel_formatting_json_and_friends_1: [ OK ] 113.73 sec. 2025-09-06 08:47:48 00147_global_in_aggregate_function: [ OK ] 20.58 sec. 2025-09-06 08:47:49 00060_move_to_prewhere_and_sets: [ OK ] 2.08 sec. 2025-09-06 08:47:56 00040_aggregating_materialized_view: [ OK ] 6.79 sec. 2025-09-06 08:47:58 00042_any_left_join: [ OK ] 2.28 sec. 2025-09-06 08:48:03 00090_thread_pool_deadlock: [ OK ] 14.97 sec. 2025-09-06 08:48:16 00043_any_left_join: [ OK ] 13.26 sec. 2025-09-06 08:48:17 00039_primary_key: [ OK ] 0.86 sec. 2025-09-06 08:48:24 00073_uniq_array: [ OK ] 7.15 sec. 2025-09-06 08:48:28 00078_group_by_arrays: [ OK ] 30.11 sec. 2025-09-06 08:48:28 00176_bson_parallel_parsing: [ SKIPPED ] 0.00 sec. 2025-09-06 08:48:28 Reason: disabled 2025-09-06 08:48:29 00087_where_0: [ OK ] 0.63 sec. 2025-09-06 08:48:30 00012_sorting_distributed: [ OK ] 5.57 sec. 2025-09-06 08:48:31 00059_merge_sorting_empty_array_joined: [ OK ] 1.58 sec. 2025-09-06 08:48:37 00148_monotonic_functions_and_index: [ OK ] 8.36 sec. 2025-09-06 08:48:58 00165_jit_aggregate_functions: [ OK ] 20.13 sec. 2025-09-06 08:49:00 00033_aggregate_key_string: [ OK ] 2.19 sec. 2025-09-06 08:49:03 00036_aggregate_hashed: [ OK ] 3.54 sec. 2025-09-06 08:49:24 00160_decode_xml_component: [ OK ] 20.23 sec. 2025-09-06 08:49:25 00068_subquery_in_prewhere: [ OK ] 1.33 sec. 2025-09-06 08:49:25 2025-09-06 08:49:25 Having 1 errors! 64 tests passed. 1 tests skipped. 1280.41 s elapsed (Process-3). 2025-09-06 08:51:01 00172_hits_joins: [ OK ] 149.30 sec. 2025-09-06 08:51:01 2025-09-06 08:51:01 65 tests passed. 0 tests skipped. 1376.12 s elapsed (Process-4). 2025-09-06 08:51:09 Running 6 stateful tests (MainProcess). 2025-09-06 08:52:23 00180_no_seek_avoiding_when_reading_from_cache: [ OK ] 74.69 sec. 2025-09-06 08:54:39 00170_s3_cache: [ OK ] 135.36 sec. 2025-09-06 08:55:37 00158_cache_dictionary_has: [ OK ] 58.20 sec. 2025-09-06 08:55:37 00157_cache_dictionary: [ SKIPPED ] 0.00 sec. 2025-09-06 08:55:37 Reason: not running for current build 2025-09-06 08:55:37 00152_insert_different_granularity: [ SKIPPED ] 0.00 sec. 2025-09-06 08:55:37 Reason: not running for current build 2025-09-06 08:55:38 00140_rename: [ OK ] 1.08 sec. 2025-09-06 08:55:38 2025-09-06 08:55:38 4 tests passed. 2 tests skipped. 269.44 s elapsed (MainProcess). 2025-09-06 08:55:38 Checking the hung queries: done 2025-09-06 08:55:38 2025-09-06 08:55:38 No queries hung. 2025-09-06 08:55:38 All tests have finished.