2024-07-22 01:16:32 Using queries from '/usr/share/clickhouse-test/queries' directory 2024-07-22 01:16:32 Connecting to ClickHouse server... OK 2024-07-22 01:16:32 Connected to server 24.3.5.47.altinitystable @ b6642564dbf296d6e55b907d7af6c8087470b672 HEAD 2024-07-22 01:16:32 Won't run stateless tests because they were manually disabled. 2024-07-22 01:16:32 Found 129 parallel tests and 6 sequential tests 2024-07-22 01:16:46 2024-07-22 01:16:46 Running about 64 stateful tests (ForkPoolWorker-3). 2024-07-22 01:16:46 2024-07-22 01:16:46 00177_memory_bound_merging: [ OK ] 14.03 sec. 2024-07-22 01:16:46 00176_bson_parallel_parsing: [ SKIPPED ] 0.00 sec. - disabled 2024-07-22 01:16:48 00176_distinct_limit_by_limit_bug_43377: [ OK ] 1.60 sec. 2024-07-22 01:16:52 00175_obfuscator_schema_inference: [ OK ] 4.18 sec. 2024-07-22 01:16:55 00175_counting_resources_in_subqueries: [ OK ] 3.25 sec. 2024-07-22 01:17:18 00174_distinct_in_order: [ OK ] 22.91 sec. 2024-07-22 01:17:52 00173_group_by_use_nulls: [ OK ] 33.32 sec. 2024-07-22 01:19:51 2024-07-22 01:19:51 Running about 64 stateful tests (ForkPoolWorker-2). 2024-07-22 01:19:51 2024-07-22 01:19:51 00178_quantile_ddsketch: [ OK ] 199.09 sec. 2024-07-22 01:19:52 00172_early_constant_folding: [ OK ] 0.56 sec. 2024-07-22 01:21:18 00171_grouping_aggregated_transform_bug: [ OK ] 85.81 sec. 2024-07-22 01:22:19 00172_hits_joins: [ OK ] 266.76 sec. 2024-07-22 01:22:40 00167_parallel_parsing_with_names_and_types: [ OK ] 21.57 sec. 2024-07-22 01:24:17 00167_read_bytes_from_fs: [ OK ] 96.67 sec. 2024-07-22 01:24:18 00166_explain_estimate: [ OK ] 0.64 sec. 2024-07-22 01:24:22 00169_contingency: [ OK ] 183.80 sec. 2024-07-22 01:24:36 00165_jit_aggregate_functions: [ OK ] 18.46 sec. 2024-07-22 01:25:04 00163_column_oriented_formats: [ OK ] 27.49 sec. 2024-07-22 01:25:51 00162_mmap_compression_none: [ OK ] 47.51 sec. 2024-07-22 01:26:04 00161_parallel_parsing_with_names: [ OK ] 12.58 sec. 2024-07-22 01:26:04 00164_quantileBfloat16: [ OK ] 102.42 sec. 2024-07-22 01:26:28 00160_decode_xml_component: [ OK ] 24.30 sec. 2024-07-22 01:27:40 00159_parallel_formatting_http: [ OK ] 95.43 sec. 2024-07-22 01:28:49 00159_parallel_formatting_csv_and_friends: [ OK ] 140.89 sec. 2024-07-22 01:29:16 00159_parallel_formatting_json_and_friends_2: [ OK ] 96.60 sec. 2024-07-22 01:30:39 00159_parallel_formatting_tsv_and_friends: [ OK ] 82.37 sec. 2024-07-22 01:30:44 00156_max_execution_speed_sample_merge: [ OK ] 5.49 sec. 2024-07-22 01:30:46 00159_parallel_formatting_json_and_friends_1: [ OK ] 117.11 sec. 2024-07-22 01:30:49 00154_avro: [ OK ] 5.08 sec. 2024-07-22 01:30:50 00151_order_by_read_in_order: [ OK ] 1.18 sec. 2024-07-22 01:30:54 00153_aggregate_arena_race: [ OK ] 7.41 sec. 2024-07-22 01:30:54 00150_quantiles_timing_precision: [ OK ] 3.39 sec. 2024-07-22 01:31:13 00149_quantiles_timing_distributed: [ OK ] 19.48 sec. 2024-07-22 01:31:19 00148_monotonic_functions_and_index: [ OK ] 24.99 sec. 2024-07-22 01:31:39 00147_global_in_aggregate_function: [ OK ] 25.61 sec. 2024-07-22 01:31:45 00146_aggregate_function_uniq: [ OK ] 26.15 sec. 2024-07-22 01:31:47 00144_functions_of_aggregation_states: [ OK ] 1.44 sec. 2024-07-22 01:31:48 00143_transform_non_const_default: [ OK ] 1.23 sec. 2024-07-22 01:31:48 00142_system_columns: [ OK ] 0.40 sec. 2024-07-22 01:31:51 00141_transform: [ OK ] 2.44 sec. 2024-07-22 01:32:00 00145_aggregate_functions_statistics: [ OK ] 21.23 sec. 2024-07-22 01:32:00 00098_primary_key_memory_allocated: [ OK ] 0.48 sec. 2024-07-22 01:32:01 00097_constexpr_in_index: [ OK ] 0.60 sec. 2024-07-22 01:32:05 00096_obfuscator_save_load: [ OK ] 4.00 sec. 2024-07-22 01:32:38 00095_hyperscan_profiler: [ OK ] 32.66 sec. 2024-07-22 01:32:38 00139_like: [ OK ] 47.27 sec. 2024-07-22 01:32:51 00093_prewhere_array_join: [ OK ] 13.17 sec. 2024-07-22 01:32:55 00092_obfuscator: [ OK ] 4.15 sec. 2024-07-22 01:33:01 00094_order_by_array_join_limit: [ OK ] 23.33 sec. 2024-07-22 01:33:31 00090_thread_pool_deadlock: [ OK ] 29.18 sec. 2024-07-22 01:33:33 00091_prewhere_two_conditions: [ OK ] 37.28 sec. 2024-07-22 01:33:40 00088_global_in_one_shard_and_rows_before_limit: [ OK ] 7.42 sec. 2024-07-22 01:33:41 00087_where_0: [ OK ] 0.77 sec. 2024-07-22 01:33:53 00086_array_reduce: [ OK ] 11.84 sec. 2024-07-22 01:33:54 00085_monotonic_evaluation_segfault: [ OK ] 0.72 sec. 2024-07-22 01:35:03 00089_position_functions_with_non_constant_arg: [ OK ] 92.80 sec. 2024-07-22 01:35:07 00083_array_filter: [ OK ] 4.10 sec. 2024-07-22 01:35:26 00082_quantiles: [ OK ] 18.81 sec. 2024-07-22 01:35:28 00081_group_by_without_key_and_totals: [ OK ] 1.24 sec. 2024-07-22 01:35:28 00080_array_join_and_union: [ OK ] 0.89 sec. 2024-07-22 01:35:41 00079_array_join_not_used_joined_column: [ OK ] 12.36 sec. 2024-07-22 01:36:02 00078_group_by_arrays: [ OK ] 20.92 sec. 2024-07-22 01:36:34 00084_external_aggregation: [ OK ] 160.40 sec. 2024-07-22 01:36:34 00076_system_columns_bytes: [ OK ] 0.43 sec. 2024-07-22 01:36:39 00075_left_array_join: [ OK ] 4.33 sec. 2024-07-22 01:36:53 00077_log_tinylog_stripelog: [ OK ] 50.81 sec. 2024-07-22 01:36:54 00073_uniq_array: [ OK ] 0.84 sec. 2024-07-22 01:37:13 00072_compare_date_and_string_index: [ OK ] 19.75 sec. 2024-07-22 01:37:35 00071_merge_tree_optimize_aio: [ OK ] 22.10 sec. 2024-07-22 01:37:38 00069_duplicate_aggregation_keys: [ OK ] 2.77 sec. 2024-07-22 01:37:41 00068_subquery_in_prewhere: [ OK ] 2.84 sec. 2024-07-22 01:37:49 00067_union_all: [ OK ] 7.65 sec. 2024-07-22 01:37:50 00066_sorting_distributed_many_replicas: [ OK ] 1.22 sec. 2024-07-22 01:37:56 00065_loyalty_with_storage_join: [ OK ] 5.47 sec. 2024-07-22 01:38:15 00063_loyalty_joins: [ OK ] 18.89 sec. 2024-07-22 01:38:32 00062_loyalty: [ OK ] 17.18 sec. 2024-07-22 01:38:32 00074_full_join: [ OK ] 113.41 sec. 2024-07-22 01:38:34 00060_move_to_prewhere_and_sets: [ OK ] 1.87 sec. 2024-07-22 01:38:35 00059_merge_sorting_empty_array_joined: [ OK ] 0.49 sec. 2024-07-22 01:38:37 00056_view: [ OK ] 2.14 sec. 2024-07-22 01:38:37 00055_index_and_not: [ OK ] 0.51 sec. 2024-07-22 01:38:38 00061_storage_buffer: [ OK ] 6.21 sec. 2024-07-22 01:38:38 00054_merge_tree_partitions: [ OK ] 1.19 sec. 2024-07-22 01:38:39 00052_group_by_in: [ OK ] 0.58 sec. 2024-07-22 01:38:43 00051_min_max_array: [ OK ] 4.26 sec. 2024-07-22 01:38:48 00050_min_max: [ OK ] 4.24 sec. 2024-07-22 01:38:53 00049_max_string_if: [ OK ] 5.79 sec. 2024-07-22 01:38:54 00048_min_max: [ OK ] 0.49 sec. 2024-07-22 01:38:55 00047_bar: [ OK ] 1.25 sec. 2024-07-22 01:38:57 00046_uniq_upto_distributed: [ OK ] 1.78 sec. 2024-07-22 01:38:58 00045_uniq_upto: [ OK ] 0.86 sec. 2024-07-22 01:39:10 00044_any_left_join_string: [ OK ] 11.74 sec. 2024-07-22 01:39:12 00043_any_left_join: [ OK ] 1.87 sec. 2024-07-22 01:39:13 00053_replicate_segfault: [ OK ] 34.83 sec. 2024-07-22 01:39:13 00042_any_left_join: [ OK ] 1.29 sec. 2024-07-22 01:39:17 00040_aggregating_materialized_view: [ OK ] 4.34 sec. 2024-07-22 01:39:18 00039_primary_key: [ OK ] 0.45 sec. 2024-07-22 01:39:20 00041_aggregating_materialized_view: [ OK ] 6.98 sec. 2024-07-22 01:39:40 00038_uniq_state_merge2: [ OK ] 22.20 sec. 2024-07-22 01:39:41 00037_uniq_state_merge1: [ OK ] 20.86 sec. 2024-07-22 01:39:46 00035_aggregate_keys128: [ OK ] 5.16 sec. 2024-07-22 01:39:51 00034_aggregate_key_fixed_string: [ OK ] 4.45 sec. 2024-07-22 01:40:07 00036_aggregate_hashed: [ OK ] 26.50 sec. 2024-07-22 01:40:08 00032_aggregate_key64: [ OK ] 1.35 sec. 2024-07-22 01:40:09 00031_array_enumerate_uniq: [ OK ] 1.09 sec. 2024-07-22 01:40:17 00033_aggregate_key_string: [ OK ] 25.89 sec. 2024-07-22 01:40:20 00030_array_enumerate_uniq: [ OK ] 10.57 sec. 2024-07-22 01:40:20 00023_totals_limit: [ OK ] 0.53 sec. 2024-07-22 01:40:21 00022_merge_prewhere: [ OK ] 0.60 sec. 2024-07-22 01:40:21 00021_1_select_with_in: [ OK ] 0.45 sec. 2024-07-22 01:40:22 00021_3_select_with_in: [ OK ] 0.51 sec. 2024-07-22 01:40:22 00021_2_select_with_in: [ OK ] 0.42 sec. 2024-07-22 01:40:23 00020_distinct_order_by_distributed: [ OK ] 1.05 sec. 2024-07-22 01:40:24 00017_aggregation_uninitialized_memory: [ OK ] 0.42 sec. 2024-07-22 01:40:28 00016_any_if_distributed_cond_always_false: [ OK ] 3.87 sec. 2024-07-22 01:40:28 00015_totals_and_no_aggregate_functions: [ OK ] 0.43 sec. 2024-07-22 01:40:29 00014_filtering_arrays: [ OK ] 1.24 sec. 2024-07-22 01:40:30 00013_sorting_of_nested: [ OK ] 1.09 sec. 2024-07-22 01:40:32 00012_sorting_distributed: [ OK ] 1.46 sec. 2024-07-22 01:40:35 00011_sorting: [ OK ] 2.88 sec. 2024-07-22 01:40:37 00010_quantiles_segfault: [ OK ] 2.31 sec. 2024-07-22 01:40:43 00009_uniq_distributed: [ OK ] 5.52 sec. 2024-07-22 01:40:45 00008_uniq: [ OK ] 2.15 sec. 2024-07-22 01:40:45 00007_uniq: [ OK ] 0.48 sec. 2024-07-22 01:40:47 00006_agregates: [ OK ] 2.08 sec. 2024-07-22 01:40:48 00005_filtering: [ OK ] 0.47 sec. 2024-07-22 01:40:50 00004_top_counters: [ OK ] 2.35 sec. 2024-07-22 01:40:51 00002_count_visits: [ OK ] 0.49 sec. 2024-07-22 01:40:51 00001_count_hits: [ OK ] 0.44 sec. 2024-07-22 01:40:51 2024-07-22 01:40:51 75 tests passed. 0 tests skipped. 1459.08 s elapsed (ForkPoolWorker-2). 2024-07-22 01:41:20 00024_random_counters: [ OK ] 63.67 sec. 2024-07-22 01:41:20 2024-07-22 01:41:20 53 tests passed. 1 tests skipped. 1487.99 s elapsed (ForkPoolWorker-3). 2024-07-22 01:41:20 2024-07-22 01:41:20 Running 6 stateful tests (MainProcess). 2024-07-22 01:41:20 2024-07-22 01:43:17 00180_no_seek_avoiding_when_reading_from_cache: [ OK ] 116.60 sec. 2024-07-22 01:45:14 00170_s3_cache: [ OK ] 117.23 sec. 2024-07-22 01:45:22 00158_cache_dictionary_has: [ OK ] 8.23 sec. 2024-07-22 01:45:22 00157_cache_dictionary: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 01:45:22 00152_insert_different_granularity: [ SKIPPED ] 0.00 sec. - not running for current build 2024-07-22 01:45:24 00140_rename: [ OK ] 1.27 sec. 2024-07-22 01:45:24 2024-07-22 01:45:24 4 tests passed. 2 tests skipped. 243.41 s elapsed (MainProcess). 2024-07-22 01:45:24 Checking the hung queries: done 2024-07-22 01:45:24 2024-07-22 01:45:24 No queries hung. 2024-07-22 01:45:24 All tests have finished.