2024-10-21 18:14:18 Using queries from '/usr/share/clickhouse-test/queries' directory 2024-10-21 18:14:18 Connecting to ClickHouse server... OK 2024-10-21 18:14:18 Won't run stateless tests because they were manually disabled. 2024-10-21 18:14:18 Found 126 parallel tests and 5 sequential tests 2024-10-21 18:14:18 2024-10-21 18:14:18 Running about 63 stateful tests (ForkPoolWorker-3). 2024-10-21 18:14:18 2024-10-21 18:14:18 00176_bson_parallel_parsing: [ SKIPPED ] 0.00 sec. - disabled 2024-10-21 18:14:19 00176_distinct_limit_by_limit_bug_43377: [ OK ] 1.10 sec. 2024-10-21 18:14:22 00175_counting_resources_in_subqueries: [ OK ] 2.61 sec. 2024-10-21 18:14:25 2024-10-21 18:14:25 Running about 63 stateful tests (ForkPoolWorker-2). 2024-10-21 18:14:25 2024-10-21 18:14:25 00177_memory_bound_merging: [ OK ] 6.63 sec. 2024-10-21 18:14:28 00175_obfuscator_schema_inference: [ OK ] 5.87 sec. 2024-10-21 18:14:30 00174_distinct_in_order: [ OK ] 5.62 sec. 2024-10-21 18:14:36 00173_group_by_use_nulls: [ OK ] 7.98 sec. 2024-10-21 18:14:37 00172_early_constant_folding: [ OK ] 0.86 sec. 2024-10-21 18:14:47 00171_grouping_aggregated_transform_bug: [ OK ] 10.25 sec. 2024-10-21 18:15:19 00172_hits_joins: [ OK ] 48.27 sec. 2024-10-21 18:15:50 00167_read_bytes_from_fs: [ OK ] 31.62 sec. 2024-10-21 18:15:53 00169_contingency: [ OK ] 65.44 sec. 2024-10-21 18:15:54 00166_explain_estimate: [ OK ] 0.95 sec. 2024-10-21 18:16:10 00165_jit_aggregate_functions: [ OK ] 15.56 sec. 2024-10-21 18:16:17 00164_quantileBfloat16: [ OK ] 7.73 sec. 2024-10-21 18:16:20 00167_parallel_parsing_with_names_and_types: [ OK ] 29.26 sec. 2024-10-21 18:16:33 00163_column_oriented_formats: [ OK ] 15.45 sec. 2024-10-21 18:16:38 00162_mmap_compression_none: [ OK ] 17.73 sec. 2024-10-21 18:16:43 00160_decode_xml_component: [ OK ] 5.23 sec. 2024-10-21 18:16:46 00161_parallel_parsing_with_names: [ OK ] 12.92 sec. 2024-10-21 18:17:09 00159_parallel_formatting_http: [ OK ] 25.60 sec. 2024-10-21 18:17:59 00159_parallel_formatting_csv_and_friends: [ OK ] 50.06 sec. 2024-10-21 18:19:11 00159_parallel_formatting_tsv_and_friends: [ OK ] 71.69 sec. 2024-10-21 18:19:16 00156_max_execution_speed_sample_merge: [ OK ] 5.47 sec. 2024-10-21 18:19:20 00154_avro: [ OK ] 3.38 sec. 2024-10-21 18:19:23 00153_aggregate_arena_race: [ OK ] 3.46 sec. 2024-10-21 18:19:24 00159_parallel_formatting_json_and_friends: [ OK ] 157.65 sec. 2024-10-21 18:19:24 00151_order_by_read_in_order: [ OK ] 1.07 sec. 2024-10-21 18:19:29 00150_quantiles_timing_precision: [ OK ] 5.61 sec. 2024-10-21 18:19:35 00149_quantiles_timing_distributed: [ OK ] 10.96 sec. 2024-10-21 18:19:38 00148_monotonic_functions_and_index: [ OK ] 8.47 sec. 2024-10-21 18:19:45 00147_global_in_aggregate_function: [ OK ] 9.87 sec. 2024-10-21 18:19:49 00146_aggregate_function_uniq: [ OK ] 11.01 sec. 2024-10-21 18:19:49 00145_aggregate_functions_statistics: [ OK ] 3.67 sec. 2024-10-21 18:19:51 00143_transform_non_const_default: [ OK ] 1.41 sec. 2024-10-21 18:19:51 00144_functions_of_aggregation_states: [ OK ] 1.58 sec. 2024-10-21 18:19:51 00142_system_columns: [ OK ] 0.65 sec. 2024-10-21 18:19:51 00141_transform: [ OK ] 0.76 sec. 2024-10-21 18:19:52 00097_constexpr_in_index: [ OK ] 0.76 sec. 2024-10-21 18:19:57 00096_obfuscator_save_load: [ OK ] 4.62 sec. 2024-10-21 18:20:11 00095_hyperscan_profiler: [ OK ] 14.16 sec. 2024-10-21 18:20:12 00139_like: [ OK ] 20.76 sec. 2024-10-21 18:20:19 00093_prewhere_array_join: [ OK ] 6.64 sec. 2024-10-21 18:20:24 00094_order_by_array_join_limit: [ OK ] 12.29 sec. 2024-10-21 18:20:24 00092_obfuscator: [ OK ] 5.29 sec. 2024-10-21 18:20:48 00090_thread_pool_deadlock: [ OK ] 23.36 sec. 2024-10-21 18:20:53 00091_prewhere_two_conditions: [ OK ] 29.46 sec. 2024-10-21 18:20:57 00088_global_in_one_shard_and_rows_before_limit: [ OK ] 3.15 sec. 2024-10-21 18:20:58 00087_where_0: [ OK ] 0.99 sec. 2024-10-21 18:21:04 00086_array_reduce: [ OK ] 6.74 sec. 2024-10-21 18:21:05 00085_monotonic_evaluation_segfault: [ OK ] 0.77 sec. 2024-10-21 18:21:25 00089_position_functions_with_non_constant_arg: [ OK ] 37.46 sec. 2024-10-21 18:21:29 00083_array_filter: [ OK ] 3.37 sec. 2024-10-21 18:21:41 00082_quantiles: [ OK ] 12.38 sec. 2024-10-21 18:21:43 00081_group_by_without_key_and_totals: [ OK ] 1.46 sec. 2024-10-21 18:21:44 00080_array_join_and_union: [ OK ] 0.80 sec. 2024-10-21 18:21:46 00079_array_join_not_used_joined_column: [ OK ] 2.03 sec. 2024-10-21 18:21:53 00078_group_by_arrays: [ OK ] 7.25 sec. 2024-10-21 18:22:00 00084_external_aggregation: [ OK ] 54.65 sec. 2024-10-21 18:22:01 00076_system_columns_bytes: [ OK ] 0.80 sec. 2024-10-21 18:22:02 00075_left_array_join: [ OK ] 1.17 sec. 2024-10-21 18:22:07 00074_full_join: [ OK ] 4.22 sec. 2024-10-21 18:22:07 00073_uniq_array: [ OK ] 0.71 sec. 2024-10-21 18:22:10 00077_log_tinylog_stripelog: [ OK ] 16.96 sec. 2024-10-21 18:22:15 00071_merge_tree_optimize_aio: [ OK ] 4.82 sec. 2024-10-21 18:22:16 00069_duplicate_aggregation_keys: [ OK ] 0.66 sec. 2024-10-21 18:22:17 00068_subquery_in_prewhere: [ OK ] 0.77 sec. 2024-10-21 18:22:19 00067_union_all: [ OK ] 1.88 sec. 2024-10-21 18:22:19 00066_sorting_distributed_many_replicas: [ OK ] 0.58 sec. 2024-10-21 18:22:22 00065_loyalty_with_storage_join: [ OK ] 2.73 sec. 2024-10-21 18:22:23 00072_compare_date_and_string_index: [ OK ] 15.12 sec. 2024-10-21 18:22:25 00062_loyalty: [ OK ] 1.90 sec. 2024-10-21 18:22:27 00063_loyalty_joins: [ OK ] 4.38 sec. 2024-10-21 18:22:28 00060_move_to_prewhere_and_sets: [ OK ] 0.94 sec. 2024-10-21 18:22:29 00059_merge_sorting_empty_array_joined: [ OK ] 0.74 sec. 2024-10-21 18:22:30 00061_storage_buffer: [ OK ] 4.96 sec. 2024-10-21 18:22:30 00056_view: [ OK ] 1.50 sec. 2024-10-21 18:22:30 00055_index_and_not: [ OK ] 0.76 sec. 2024-10-21 18:22:32 00054_merge_tree_partitions: [ OK ] 2.06 sec. 2024-10-21 18:22:33 00052_group_by_in: [ OK ] 0.66 sec. 2024-10-21 18:22:40 00051_min_max_array: [ OK ] 7.13 sec. 2024-10-21 18:22:42 00050_min_max: [ OK ] 1.24 sec. 2024-10-21 18:22:42 00053_replicate_segfault: [ OK ] 11.63 sec. 2024-10-21 18:22:43 00048_min_max: [ OK ] 1.14 sec. 2024-10-21 18:22:44 00049_max_string_if: [ OK ] 2.53 sec. 2024-10-21 18:22:45 00047_bar: [ OK ] 1.32 sec. 2024-10-21 18:22:45 00046_uniq_upto_distributed: [ OK ] 1.05 sec. 2024-10-21 18:22:46 00045_uniq_upto: [ OK ] 0.79 sec. 2024-10-21 18:22:48 00043_any_left_join: [ OK ] 1.70 sec. 2024-10-21 18:22:49 00044_any_left_join_string: [ OK ] 3.12 sec. 2024-10-21 18:22:49 00042_any_left_join: [ OK ] 0.97 sec. 2024-10-21 18:22:51 00040_aggregating_materialized_view: [ OK ] 2.08 sec. 2024-10-21 18:22:52 00039_primary_key: [ OK ] 0.68 sec. 2024-10-21 18:22:53 00041_aggregating_materialized_view: [ OK ] 4.49 sec. 2024-10-21 18:23:01 00038_uniq_state_merge2: [ OK ] 9.44 sec. 2024-10-21 18:23:01 00037_uniq_state_merge1: [ OK ] 8.02 sec. 2024-10-21 18:23:03 00035_aggregate_keys128: [ OK ] 1.51 sec. 2024-10-21 18:23:03 00036_aggregate_hashed: [ OK ] 1.96 sec. 2024-10-21 18:23:05 00033_aggregate_key_string: [ OK ] 1.92 sec. 2024-10-21 18:23:05 00034_aggregate_key_fixed_string: [ OK ] 2.24 sec. 2024-10-21 18:23:06 00032_aggregate_key64: [ OK ] 0.91 sec. 2024-10-21 18:23:06 00031_array_enumerate_uniq: [ OK ] 1.15 sec. 2024-10-21 18:23:08 00030_array_enumerate_uniq: [ OK ] 2.01 sec. 2024-10-21 18:23:09 00023_totals_limit: [ OK ] 0.74 sec. 2024-10-21 18:23:10 00022_merge_prewhere: [ OK ] 0.80 sec. 2024-10-21 18:23:11 00021_1_select_with_in: [ OK ] 0.66 sec. 2024-10-21 18:23:11 00021_2_select_with_in: [ OK ] 0.65 sec. 2024-10-21 18:23:12 00021_3_select_with_in: [ OK ] 0.64 sec. 2024-10-21 18:23:13 00020_distinct_order_by_distributed: [ OK ] 0.77 sec. 2024-10-21 18:23:14 00017_aggregation_uninitialized_memory: [ OK ] 0.67 sec. 2024-10-21 18:23:16 00016_any_if_distributed_cond_always_false: [ OK ] 1.96 sec. 2024-10-21 18:23:17 00015_totals_and_no_aggregate_functions: [ OK ] 0.68 sec. 2024-10-21 18:23:18 00014_filtering_arrays: [ OK ] 1.55 sec. 2024-10-21 18:23:20 00013_sorting_of_nested: [ OK ] 1.19 sec. 2024-10-21 18:23:21 00012_sorting_distributed: [ OK ] 1.00 sec. 2024-10-21 18:23:21 00011_sorting: [ OK ] 0.65 sec. 2024-10-21 18:23:23 00010_quantiles_segfault: [ OK ] 1.13 sec. 2024-10-21 18:23:24 00009_uniq_distributed: [ OK ] 1.24 sec. 2024-10-21 18:23:25 00008_uniq: [ OK ] 1.37 sec. 2024-10-21 18:23:26 00007_uniq: [ OK ] 0.67 sec. 2024-10-21 18:23:27 00006_agregates: [ OK ] 0.99 sec. 2024-10-21 18:23:28 00005_filtering: [ OK ] 0.66 sec. 2024-10-21 18:23:29 00004_top_counters: [ OK ] 0.90 sec. 2024-10-21 18:23:30 00002_count_visits: [ OK ] 0.66 sec. 2024-10-21 18:23:30 00001_count_hits: [ OK ] 0.64 sec. 2024-10-21 18:23:30 2024-10-21 18:23:30 71 tests passed. 1 tests skipped. 552.38 s elapsed (ForkPoolWorker-3). 2024-10-21 18:24:28 00024_random_counters: [ OK ] 81.79 sec. 2024-10-21 18:24:28 2024-10-21 18:24:28 54 tests passed. 0 tests skipped. 610.28 s elapsed (ForkPoolWorker-2). 2024-10-21 18:24:28 2024-10-21 18:24:28 Running 5 stateful tests (MainProcess). 2024-10-21 18:24:28 2024-10-21 18:25:28 00170_s3_cache: [ OK ] 59.28 sec. 2024-10-21 18:25:31 00158_cache_dictionary_has: [ OK ] 3.36 sec. 2024-10-21 18:26:02 00157_cache_dictionary: [ OK ] 31.07 sec. 2024-10-21 18:26:08 00152_insert_different_granularity: [ OK ] 5.24 sec. 2024-10-21 18:26:09 00140_rename: [ OK ] 1.45 sec. 2024-10-21 18:26:09 2024-10-21 18:26:09 5 tests passed. 0 tests skipped. 100.79 s elapsed (MainProcess). 2024-10-21 18:26:09 2024-10-21 18:26:09 No queries hung. 2024-10-21 18:26:09 All tests have finished.