2024-03-19 19:10:48 Using queries from '/usr/share/clickhouse-test/queries' directory 2024-03-19 19:10:48 Connecting to ClickHouse server... OK 2024-03-19 19:10:48 Won't run stateless tests because they were manually disabled. 2024-03-19 19:10:48 Found 128 parallel tests and 5 sequential tests 2024-03-19 19:10:48 2024-03-19 19:10:48 Running about 64 stateful tests (ForkPoolWorker-2). 2024-03-19 19:10:48 2024-03-19 19:10:48 00178_query_datetime64_index: [ OK ] 0.29 sec. 2024-03-19 19:10:49 00176_distinct_limit_by_limit_bug_43377: [ OK ] 0.54 sec. 2024-03-19 19:10:49 00176_bson_parallel_parsing: [ SKIPPED ] 0.00 sec. - disabled 2024-03-19 19:10:51 2024-03-19 19:10:51 Running about 64 stateful tests (ForkPoolWorker-3). 2024-03-19 19:10:51 2024-03-19 19:10:51 00177_memory_bound_merging: [ OK ] 3.41 sec. 2024-03-19 19:10:51 00175_obfuscator_schema_inference: [ OK ] 2.72 sec. 2024-03-19 19:10:52 00175_partition_by_ignore: [ OK ] 0.34 sec. 2024-03-19 19:10:52 00175_counting_resources_in_subqueries: [ OK ] 0.71 sec. 2024-03-19 19:10:56 00174_distinct_in_order: [ OK ] 4.14 sec. 2024-03-19 19:10:56 00173_group_by_use_nulls: [ OK ] 3.93 sec. 2024-03-19 19:10:56 00172_early_constant_folding: [ OK ] 0.26 sec. 2024-03-19 19:11:04 00171_grouping_aggregated_transform_bug: [ OK ] 7.33 sec. 2024-03-19 19:11:19 00169_contingency: [ OK ] 15.08 sec. 2024-03-19 19:11:25 00172_hits_joins: [ OK ] 28.77 sec. 2024-03-19 19:11:33 00167_parallel_parsing_with_names_and_types: [ OK ] 14.19 sec. 2024-03-19 19:11:34 00166_explain_estimate: [ OK ] 0.82 sec. 2024-03-19 19:11:45 00167_read_bytes_from_fs: [ OK ] 19.88 sec. 2024-03-19 19:11:47 00165_jit_aggregate_functions: [ OK ] 13.39 sec. 2024-03-19 19:11:49 00164_quantileBfloat16: [ OK ] 4.73 sec. 2024-03-19 19:11:55 00162_mmap_compression_none: [ OK ] 5.37 sec. 2024-03-19 19:11:55 00163_column_oriented_formats: [ OK ] 7.54 sec. 2024-03-19 19:11:57 00160_decode_xml_component: [ OK ] 2.00 sec. 2024-03-19 19:12:01 00161_parallel_parsing_with_names: [ OK ] 6.23 sec. 2024-03-19 19:12:06 00159_parallel_formatting_http: [ OK ] 9.49 sec. 2024-03-19 19:12:42 00159_parallel_formatting_tsv_and_friends: [ OK ] 35.96 sec. 2024-03-19 19:13:00 00159_parallel_formatting_json_and_friends: [ OK ] 59.02 sec. 2024-03-19 19:13:05 00156_max_execution_speed_sample_merge: [ OK ] 4.68 sec. 2024-03-19 19:13:05 00159_parallel_formatting_csv_and_friends: [ OK ] 22.37 sec. 2024-03-19 19:13:07 00153_aggregate_arena_race: [ OK ] 1.78 sec. 2024-03-19 19:13:07 00151_order_by_read_in_order: [ OK ] 0.41 sec. 2024-03-19 19:13:07 00154_avro: [ OK ] 2.42 sec. 2024-03-19 19:13:10 00150_quantiles_timing_precision: [ OK ] 2.77 sec. 2024-03-19 19:13:13 00149_quantiles_timing_distributed: [ OK ] 5.68 sec. 2024-03-19 19:13:14 00148_monotonic_functions_and_index: [ OK ] 4.11 sec. 2024-03-19 19:13:15 00147_global_in_aggregate_function: [ OK ] 2.52 sec. 2024-03-19 19:13:18 00145_aggregate_functions_statistics: [ OK ] 2.23 sec. 2024-03-19 19:13:19 00144_functions_of_aggregation_states: [ OK ] 1.06 sec. 2024-03-19 19:13:19 00143_transform_non_const_default: [ OK ] 0.66 sec. 2024-03-19 19:13:20 00146_aggregate_function_uniq: [ OK ] 5.60 sec. 2024-03-19 19:13:20 00142_system_columns: [ OK ] 0.27 sec. 2024-03-19 19:13:20 00141_transform: [ OK ] 0.78 sec. 2024-03-19 19:13:21 00097_constexpr_in_index: [ OK ] 0.65 sec. 2024-03-19 19:13:24 00096_obfuscator_save_load: [ OK ] 2.39 sec. 2024-03-19 19:13:27 00139_like: [ OK ] 7.54 sec. 2024-03-19 19:13:29 00095_hyperscan_profiler: [ OK ] 5.10 sec. 2024-03-19 19:13:32 00094_order_by_array_join_limit: [ OK ] 4.65 sec. 2024-03-19 19:13:32 00093_prewhere_array_join: [ OK ] 3.40 sec. 2024-03-19 19:13:35 00092_obfuscator: [ OK ] 2.59 sec. 2024-03-19 19:13:39 00091_prewhere_two_conditions: [ OK ] 7.20 sec. 2024-03-19 19:13:54 00090_thread_pool_deadlock: [ OK ] 19.61 sec. 2024-03-19 19:13:56 00088_global_in_one_shard_and_rows_before_limit: [ OK ] 1.97 sec. 2024-03-19 19:13:57 00087_where_0: [ OK ] 0.36 sec. 2024-03-19 19:14:00 00089_position_functions_with_non_constant_arg: [ OK ] 20.61 sec. 2024-03-19 19:14:00 00085_monotonic_evaluation_segfault: [ OK ] 0.30 sec. 2024-03-19 19:14:03 00086_array_reduce: [ OK ] 5.98 sec. 2024-03-19 19:14:04 00083_array_filter: [ OK ] 1.76 sec. 2024-03-19 19:14:16 00082_quantiles: [ OK ] 11.71 sec. 2024-03-19 19:14:17 00081_group_by_without_key_and_totals: [ OK ] 0.83 sec. 2024-03-19 19:14:17 00080_array_join_and_union: [ OK ] 0.42 sec. 2024-03-19 19:14:20 00079_array_join_not_used_joined_column: [ OK ] 2.65 sec. 2024-03-19 19:14:25 00078_group_by_arrays: [ OK ] 4.87 sec. 2024-03-19 19:14:32 00077_log_tinylog_stripelog: [ OK ] 7.17 sec. 2024-03-19 19:14:33 00076_system_columns_bytes: [ OK ] 0.39 sec. 2024-03-19 19:14:33 00075_left_array_join: [ OK ] 0.64 sec. 2024-03-19 19:14:35 00074_full_join: [ OK ] 1.50 sec. 2024-03-19 19:14:35 00073_uniq_array: [ OK ] 0.33 sec. 2024-03-19 19:14:39 00072_compare_date_and_string_index: [ OK ] 3.78 sec. 2024-03-19 19:14:41 00084_external_aggregation: [ OK ] 40.55 sec. 2024-03-19 19:14:41 00069_duplicate_aggregation_keys: [ OK ] 0.36 sec. 2024-03-19 19:14:42 00068_subquery_in_prewhere: [ OK ] 0.72 sec. 2024-03-19 19:14:43 00067_union_all: [ OK ] 1.50 sec. 2024-03-19 19:14:44 00066_sorting_distributed_many_replicas: [ OK ] 0.46 sec. 2024-03-19 19:14:44 00071_merge_tree_optimize_aio: [ OK ] 5.19 sec. 2024-03-19 19:14:46 00065_loyalty_with_storage_join: [ OK ] 2.03 sec. 2024-03-19 19:14:47 00062_loyalty: [ OK ] 1.01 sec. 2024-03-19 19:14:47 00063_loyalty_joins: [ OK ] 3.37 sec. 2024-03-19 19:14:48 00060_move_to_prewhere_and_sets: [ OK ] 0.61 sec. 2024-03-19 19:14:48 00059_merge_sorting_empty_array_joined: [ OK ] 0.29 sec. 2024-03-19 19:14:49 00061_storage_buffer: [ OK ] 1.79 sec. 2024-03-19 19:14:49 00055_index_and_not: [ OK ] 0.40 sec. 2024-03-19 19:14:49 00056_view: [ OK ] 0.86 sec. 2024-03-19 19:14:50 00054_merge_tree_partitions: [ OK ] 0.76 sec. 2024-03-19 19:14:50 00052_group_by_in: [ OK ] 0.31 sec. 2024-03-19 19:14:52 00053_replicate_segfault: [ OK ] 2.29 sec. 2024-03-19 19:14:53 00050_min_max: [ OK ] 1.09 sec. 2024-03-19 19:14:54 00049_max_string_if: [ OK ] 1.49 sec. 2024-03-19 19:14:54 00051_min_max_array: [ OK ] 4.02 sec. 2024-03-19 19:14:55 00048_min_max: [ OK ] 0.34 sec. 2024-03-19 19:14:55 00047_bar: [ OK ] 0.73 sec. 2024-03-19 19:14:56 00045_uniq_upto: [ OK ] 0.35 sec. 2024-03-19 19:14:56 00046_uniq_upto_distributed: [ OK ] 1.17 sec. 2024-03-19 19:14:58 00044_any_left_join_string: [ OK ] 2.31 sec. 2024-03-19 19:14:58 00042_any_left_join: [ OK ] 0.39 sec. 2024-03-19 19:14:58 00043_any_left_join: [ OK ] 2.54 sec. 2024-03-19 19:14:59 00041_aggregating_materialized_view: [ OK ] 1.02 sec. 2024-03-19 19:14:59 00040_aggregating_materialized_view: [ OK ] 1.16 sec. 2024-03-19 19:15:00 00039_primary_key: [ OK ] 0.29 sec. 2024-03-19 19:15:03 00037_uniq_state_merge1: [ OK ] 3.60 sec. 2024-03-19 19:15:04 00038_uniq_state_merge2: [ OK ] 4.67 sec. 2024-03-19 19:15:04 00036_aggregate_hashed: [ OK ] 1.04 sec. 2024-03-19 19:15:05 00035_aggregate_keys128: [ OK ] 0.65 sec. 2024-03-19 19:15:05 00034_aggregate_key_fixed_string: [ OK ] 0.88 sec. 2024-03-19 19:15:06 00032_aggregate_key64: [ OK ] 0.58 sec. 2024-03-19 19:15:06 00033_aggregate_key_string: [ OK ] 0.91 sec. 2024-03-19 19:15:07 00031_array_enumerate_uniq: [ OK ] 0.91 sec. 2024-03-19 19:15:07 00030_array_enumerate_uniq: [ OK ] 1.03 sec. 2024-03-19 19:15:07 00023_totals_limit: [ OK ] 0.28 sec. 2024-03-19 19:15:07 00022_merge_prewhere: [ OK ] 0.37 sec. 2024-03-19 19:15:08 00021_3_select_with_in: [ OK ] 0.28 sec. 2024-03-19 19:15:08 00021_2_select_with_in: [ OK ] 0.25 sec. 2024-03-19 19:15:08 00021_1_select_with_in: [ OK ] 0.25 sec. 2024-03-19 19:15:09 00020_distinct_order_by_distributed: [ OK ] 0.40 sec. 2024-03-19 19:15:09 00017_aggregation_uninitialized_memory: [ OK ] 0.27 sec. 2024-03-19 19:15:10 00016_any_if_distributed_cond_always_false: [ OK ] 0.62 sec. 2024-03-19 19:15:10 00015_totals_and_no_aggregate_functions: [ OK ] 0.31 sec. 2024-03-19 19:15:11 00014_filtering_arrays: [ OK ] 0.57 sec. 2024-03-19 19:15:11 00013_sorting_of_nested: [ OK ] 0.59 sec. 2024-03-19 19:15:12 00012_sorting_distributed: [ OK ] 0.41 sec. 2024-03-19 19:15:12 00011_sorting: [ OK ] 0.43 sec. 2024-03-19 19:15:13 00010_quantiles_segfault: [ OK ] 0.50 sec. 2024-03-19 19:15:14 00009_uniq_distributed: [ OK ] 1.07 sec. 2024-03-19 19:15:14 00008_uniq: [ OK ] 0.58 sec. 2024-03-19 19:15:15 00007_uniq: [ OK ] 0.27 sec. 2024-03-19 19:15:15 00006_agregates: [ OK ] 0.29 sec. 2024-03-19 19:15:15 00005_filtering: [ OK ] 0.27 sec. 2024-03-19 19:15:16 00004_top_counters: [ OK ] 0.55 sec. 2024-03-19 19:15:16 00002_count_visits: [ OK ] 0.25 sec. 2024-03-19 19:15:16 00001_count_hits: [ OK ] 0.24 sec. 2024-03-19 19:15:16 2024-03-19 19:15:16 74 tests passed. 0 tests skipped. 268.32 s elapsed (ForkPoolWorker-3). 2024-03-19 19:15:33 00024_random_counters: [ OK ] 25.99 sec. 2024-03-19 19:15:33 2024-03-19 19:15:33 53 tests passed. 1 tests skipped. 284.76 s elapsed (ForkPoolWorker-2). 2024-03-19 19:15:33 2024-03-19 19:15:33 Running 5 stateful tests (MainProcess). 2024-03-19 19:15:33 2024-03-19 19:16:11 00170_s3_cache: [ OK ] 38.00 sec. 2024-03-19 19:16:13 00158_cache_dictionary_has: [ OK ] 2.14 sec. 2024-03-19 19:16:23 00157_cache_dictionary: [ OK ] 10.12 sec. 2024-03-19 19:16:25 00152_insert_different_granularity: [ OK ] 2.06 sec. 2024-03-19 19:16:26 00140_rename: [ OK ] 0.53 sec. 2024-03-19 19:16:26 2024-03-19 19:16:26 5 tests passed. 0 tests skipped. 52.91 s elapsed (MainProcess). 2024-03-19 19:16:26 2024-03-19 19:16:26 No queries hung. 2024-03-19 19:16:26 All tests have finished.