2025-05-24 01:23:46 Using queries from '/usr/share/clickhouse-test/queries' directory 2025-05-24 01:23:46 Connecting to ClickHouse server... OK 2025-05-24 01:23:46 Connected to server 24.3.18.10388.altinitystable @ 0ce6c8f2a4d3031f31446142fde2337a95087b3b HEAD 2025-05-24 01:23:46 Won't run stateless tests because they were manually disabled. 2025-05-24 01:23:46 Found 129 parallel tests and 6 sequential tests 2025-05-24 01:23:47 2025-05-24 01:23:47 Running about 64 stateful tests (ForkPoolWorker-3). 2025-05-24 01:23:47 2025-05-24 01:23:47 00177_memory_bound_merging: [ OK ] 1.00 sec. 2025-05-24 01:23:47 00176_bson_parallel_parsing: [ SKIPPED ] 0.00 sec. - disabled 2025-05-24 01:23:47 00176_distinct_limit_by_limit_bug_43377: [ OK ] 0.10 sec. 2025-05-24 01:23:47 00175_counting_resources_in_subqueries: [ OK ] 0.19 sec. 2025-05-24 01:23:47 2025-05-24 01:23:47 Running about 64 stateful tests (ForkPoolWorker-2). 2025-05-24 01:23:47 2025-05-24 01:23:47 00178_quantile_ddsketch: [ OK ] 1.41 sec. 2025-05-24 01:23:48 00175_obfuscator_schema_inference: [ OK ] 0.88 sec. 2025-05-24 01:23:48 00174_distinct_in_order: [ OK ] 0.82 sec. 2025-05-24 01:23:49 00173_group_by_use_nulls: [ OK ] 0.53 sec. 2025-05-24 01:23:49 00172_early_constant_folding: [ OK ] 0.11 sec. 2025-05-24 01:23:49 00171_grouping_aggregated_transform_bug: [ OK ] 0.44 sec. 2025-05-24 01:23:52 00169_contingency: [ OK ] 2.20 sec. 2025-05-24 01:23:53 00167_read_bytes_from_fs: [ OK ] 1.34 sec. 2025-05-24 01:23:56 00167_parallel_parsing_with_names_and_types: [ OK ] 3.24 sec. 2025-05-24 01:23:56 00166_explain_estimate: [ OK ] 0.08 sec. 2025-05-24 01:23:57 00165_jit_aggregate_functions: [ OK ] 0.58 sec. 2025-05-24 01:23:58 00164_quantileBfloat16: [ OK ] 0.94 sec. 2025-05-24 01:23:59 00163_column_oriented_formats: [ OK ] 1.63 sec. 2025-05-24 01:24:01 00162_mmap_compression_none: [ OK ] 1.62 sec. 2025-05-24 01:24:02 00161_parallel_parsing_with_names: [ OK ] 1.43 sec. 2025-05-24 01:24:03 00160_decode_xml_component: [ OK ] 0.19 sec. 2025-05-24 01:24:09 00172_hits_joins: [ OK ] 20.34 sec. 2025-05-24 01:24:10 00159_parallel_formatting_http: [ OK ] 1.83 sec. 2025-05-24 01:24:11 00159_parallel_formatting_json_and_friends_1: [ OK ] 8.72 sec. 2025-05-24 01:24:15 00159_parallel_formatting_tsv_and_friends: [ OK ] 3.81 sec. 2025-05-24 01:24:17 00159_parallel_formatting_csv_and_friends: [ OK ] 7.01 sec. 2025-05-24 01:24:22 00156_max_execution_speed_sample_merge: [ OK ] 4.33 sec. 2025-05-24 01:24:22 00154_avro: [ OK ] 0.32 sec. 2025-05-24 01:24:22 00159_parallel_formatting_json_and_friends_2: [ OK ] 6.94 sec. 2025-05-24 01:24:22 00151_order_by_read_in_order: [ OK ] 0.11 sec. 2025-05-24 01:24:22 00153_aggregate_arena_race: [ OK ] 0.18 sec. 2025-05-24 01:24:23 00150_quantiles_timing_precision: [ OK ] 0.20 sec. 2025-05-24 01:24:23 00149_quantiles_timing_distributed: [ OK ] 0.48 sec. 2025-05-24 01:24:23 00148_monotonic_functions_and_index: [ OK ] 0.38 sec. 2025-05-24 01:24:24 00147_global_in_aggregate_function: [ OK ] 0.75 sec. 2025-05-24 01:24:24 00146_aggregate_function_uniq: [ OK ] 0.70 sec. 2025-05-24 01:24:24 00144_functions_of_aggregation_states: [ OK ] 0.15 sec. 2025-05-24 01:24:24 00145_aggregate_functions_statistics: [ OK ] 0.24 sec. 2025-05-24 01:24:24 00142_system_columns: [ OK ] 0.07 sec. 2025-05-24 01:24:24 00143_transform_non_const_default: [ OK ] 0.18 sec. 2025-05-24 01:24:24 00141_transform: [ OK ] 0.08 sec. 2025-05-24 01:24:24 00098_primary_key_memory_allocated: [ OK ] 0.10 sec. 2025-05-24 01:24:24 00097_constexpr_in_index: [ OK ] 0.09 sec. 2025-05-24 01:24:24 00139_like: [ OK ] 0.40 sec. 2025-05-24 01:24:25 00095_hyperscan_profiler: [ OK ] 0.35 sec. 2025-05-24 01:24:25 00096_obfuscator_save_load: [ OK ] 0.65 sec. 2025-05-24 01:24:25 00094_order_by_array_join_limit: [ OK ] 0.42 sec. 2025-05-24 01:24:25 00093_prewhere_array_join: [ OK ] 0.48 sec. 2025-05-24 01:24:26 00092_obfuscator: [ OK ] 0.59 sec. 2025-05-24 01:24:27 00091_prewhere_two_conditions: [ OK ] 1.20 sec. 2025-05-24 01:24:29 00089_position_functions_with_non_constant_arg: [ OK ] 2.30 sec. 2025-05-24 01:24:29 00090_thread_pool_deadlock: [ OK ] 3.31 sec. 2025-05-24 01:24:29 00087_where_0: [ OK ] 0.08 sec. 2025-05-24 01:24:29 00088_global_in_one_shard_and_rows_before_limit: [ FAIL ] 0.28 sec. - result differs with reference: 2025-05-24 01:24:29 --- /usr/share/clickhouse-test/queries/1_stateful/00088_global_in_one_shard_and_rows_before_limit.reference 2025-05-24 01:15:26.188706275 +0300 2025-05-24 01:24:29 +++ /tmp/clickhouse-test/1_stateful/00088_global_in_one_shard_and_rows_before_limit.stdout 2025-05-24 01:24:29.702893054 +0300 2025-05-24 01:24:29 @@ -13,11 +13,11 @@ 2025-05-24 01:24:29 2025-05-24 01:24:29 "data": 2025-05-24 01:24:29 [ 2025-05-24 01:24:29 - ["2014-03-17", "1406958"], 2025-05-24 01:24:29 - ["2014-03-18", "1383658"], 2025-05-24 01:24:29 - ["2014-03-19", "1405797"], 2025-05-24 01:24:29 - ["2014-03-20", "1353623"], 2025-05-24 01:24:29 - ["2014-03-21", "1245779"] 2025-05-24 01:24:29 + ["2014-03-17", "1391806"], 2025-05-24 01:24:29 + ["2014-03-18", "1368943"], 2025-05-24 01:24:29 + ["2014-03-19", "1388315"], 2025-05-24 01:24:29 + ["2014-03-20", "1337345"], 2025-05-24 01:24:29 + ["2014-03-21", "1228982"] 2025-05-24 01:24:29 ], 2025-05-24 01:24:29 2025-05-24 01:24:29 "rows": 5, 2025-05-24 01:24:29 2025-05-24 01:24:29 2025-05-24 01:24:29 Settings used in the test: --max_insert_threads 5 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 18528691 --max_read_buffer_size 845075 --prefer_localhost_replica 0 --max_block_size 79636 --max_threads 5 --optimize_append_index 0 --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 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 33 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 42268386 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --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 1 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 7 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 1 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1456472386 --min_compress_block_size 1081767 --max_compress_block_size 1594615 --merge_tree_compact_parts_min_granules_to_multibuffer_read 115 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 2196097 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --prefer_warmed_unmerged_parts_seconds 3 --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.25 2025-05-24 01:24:29 2025-05-24 01:24:29 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.8881523052926201 --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 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 27272997 --merge_max_block_size 16360 --index_granularity 59678 --min_bytes_for_wide_part 549260993 --marks_compress_block_size 90339 --primary_key_compress_block_size 85212 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 274125989 --compact_parts_max_granules_to_buffer 42 --compact_parts_merge_max_bytes_to_prefetch_part 11213497 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 0 --old_parts_lifetime 480 2025-05-24 01:24:29 2025-05-24 01:24:29 Database: test_5977iunz 2025-05-24 01:24:29 00086_array_reduce: [ OK ] 0.13 sec. 2025-05-24 01:24:30 00085_monotonic_evaluation_segfault: [ OK ] 0.52 sec. 2025-05-24 01:24:30 00083_array_filter: [ OK ] 0.24 sec. 2025-05-24 01:24:31 00082_quantiles: [ OK ] 1.10 sec. 2025-05-24 01:24:31 00081_group_by_without_key_and_totals: [ OK ] 0.18 sec. 2025-05-24 01:24:33 00084_external_aggregation: [ OK ] 3.92 sec. 2025-05-24 01:24:34 00079_array_join_not_used_joined_column: [ OK ] 0.37 sec. 2025-05-24 01:24:34 00080_array_join_and_union: [ OK ] 2.90 sec. 2025-05-24 01:24:36 00077_log_tinylog_stripelog: [ OK ] 2.08 sec. 2025-05-24 01:24:36 00076_system_columns_bytes: [ OK ] 0.07 sec. 2025-05-24 01:24:37 00075_left_array_join: [ OK ] 0.26 sec. 2025-05-24 01:24:44 00074_full_join: [ OK ] 7.12 sec. 2025-05-24 01:24:44 00073_uniq_array: [ OK ] 0.08 sec. 2025-05-24 01:24:44 00078_group_by_arrays: [ OK ] 10.38 sec. 2025-05-24 01:24:44 00071_merge_tree_optimize_aio: [ OK ] 0.45 sec. 2025-05-24 01:24:45 00069_duplicate_aggregation_keys: [ OK ] 0.09 sec. 2025-05-24 01:24:45 00068_subquery_in_prewhere: [ OK ] 0.09 sec. 2025-05-24 01:24:45 00072_compare_date_and_string_index: [ OK ] 0.84 sec. 2025-05-24 01:24:45 00067_union_all: [ OK ] 0.11 sec. 2025-05-24 01:24:45 00066_sorting_distributed_many_replicas: [ OK ] 0.05 sec. 2025-05-24 01:24:45 00065_loyalty_with_storage_join: [ OK ] 0.71 sec. 2025-05-24 01:24:46 00062_loyalty: [ OK ] 0.95 sec. 2025-05-24 01:24:47 00061_storage_buffer: [ OK ] 0.39 sec. 2025-05-24 01:24:47 00060_move_to_prewhere_and_sets: [ OK ] 0.09 sec. 2025-05-24 01:24:47 00059_merge_sorting_empty_array_joined: [ OK ] 0.06 sec. 2025-05-24 01:24:47 00056_view: [ OK ] 0.22 sec. 2025-05-24 01:24:47 00055_index_and_not: [ OK ] 0.11 sec. 2025-05-24 01:24:48 00054_merge_tree_partitions: [ OK ] 0.28 sec. 2025-05-24 01:24:49 00063_loyalty_joins: [ OK ] 4.25 sec. 2025-05-24 01:24:49 00053_replicate_segfault: [ OK ] 1.54 sec. 2025-05-24 01:24:50 00051_min_max_array: [ OK ] 0.27 sec. 2025-05-24 01:24:50 00052_group_by_in: [ OK ] 0.58 sec. 2025-05-24 01:24:50 00050_min_max: [ OK ] 0.15 sec. 2025-05-24 01:24:50 00048_min_max: [ OK ] 0.13 sec. 2025-05-24 01:24:50 00049_max_string_if: [ OK ] 0.19 sec. 2025-05-24 01:24:50 00047_bar: [ OK ] 0.14 sec. 2025-05-24 01:24:52 00046_uniq_upto_distributed: [ OK ] 1.84 sec. 2025-05-24 01:24:52 00045_uniq_upto: [ OK ] 2.04 sec. 2025-05-24 01:24:52 00043_any_left_join: [ OK ] 0.40 sec. 2025-05-24 01:24:53 00042_any_left_join: [ OK ] 0.64 sec. 2025-05-24 01:24:54 00041_aggregating_materialized_view: [ OK ] 0.92 sec. 2025-05-24 01:24:54 00040_aggregating_materialized_view: [ OK ] 0.41 sec. 2025-05-24 01:24:55 00039_primary_key: [ OK ] 0.08 sec. 2025-05-24 01:24:55 00038_uniq_state_merge2: [ OK ] 0.26 sec. 2025-05-24 01:24:55 00037_uniq_state_merge1: [ OK ] 0.23 sec. 2025-05-24 01:24:56 00036_aggregate_hashed: [ OK ] 0.61 sec. 2025-05-24 01:24:56 00035_aggregate_keys128: [ OK ] 0.08 sec. 2025-05-24 01:24:56 00034_aggregate_key_fixed_string: [ OK ] 0.13 sec. 2025-05-24 01:24:56 00033_aggregate_key_string: [ OK ] 0.50 sec. 2025-05-24 01:24:57 00032_aggregate_key64: [ OK ] 0.12 sec. 2025-05-24 01:24:57 00031_array_enumerate_uniq: [ OK ] 0.12 sec. 2025-05-24 01:24:57 00030_array_enumerate_uniq: [ OK ] 0.20 sec. 2025-05-24 01:25:05 00024_random_counters: [ OK ] 8.37 sec. 2025-05-24 01:25:06 00044_any_left_join_string: [ OK ] 13.92 sec. 2025-05-24 01:25:06 00023_totals_limit: [ OK ] 0.41 sec. 2025-05-24 01:25:06 00021_2_select_with_in: [ OK ] 0.07 sec. 2025-05-24 01:25:06 00022_merge_prewhere: [ OK ] 0.09 sec. 2025-05-24 01:25:06 00021_3_select_with_in: [ OK ] 0.08 sec. 2025-05-24 01:25:06 00021_1_select_with_in: [ OK ] 0.07 sec. 2025-05-24 01:25:06 00017_aggregation_uninitialized_memory: [ OK ] 0.09 sec. 2025-05-24 01:25:06 00016_any_if_distributed_cond_always_false: [ OK ] 0.17 sec. 2025-05-24 01:25:06 00015_totals_and_no_aggregate_functions: [ OK ] 0.12 sec. 2025-05-24 01:25:06 00014_filtering_arrays: [ OK ] 0.12 sec. 2025-05-24 01:25:07 00013_sorting_of_nested: [ OK ] 0.80 sec. 2025-05-24 01:25:07 00012_sorting_distributed: [ OK ] 0.15 sec. 2025-05-24 01:25:07 00011_sorting: [ OK ] 0.12 sec. 2025-05-24 01:25:08 00010_quantiles_segfault: [ OK ] 0.19 sec. 2025-05-24 01:25:08 00009_uniq_distributed: [ OK ] 0.21 sec. 2025-05-24 01:25:08 00008_uniq: [ OK ] 0.15 sec. 2025-05-24 01:25:08 00007_uniq: [ OK ] 0.07 sec. 2025-05-24 01:25:08 00006_agregates: [ OK ] 0.08 sec. 2025-05-24 01:25:08 00005_filtering: [ OK ] 0.14 sec. 2025-05-24 01:25:09 00004_top_counters: [ OK ] 0.16 sec. 2025-05-24 01:25:09 00002_count_visits: [ OK ] 0.09 sec. 2025-05-24 01:25:09 00001_count_hits: [ OK ] 0.10 sec. 2025-05-24 01:25:09 2025-05-24 01:25:09 Having 1 errors! 54 tests passed. 0 tests skipped. 82.83 s elapsed (ForkPoolWorker-2). 2025-05-24 01:25:09 00020_distinct_order_by_distributed: [ OK ] 2.96 sec. 2025-05-24 01:25:09 2025-05-24 01:25:09 73 tests passed. 1 tests skipped. 82.84 s elapsed (ForkPoolWorker-3). 2025-05-24 01:25:09 2025-05-24 01:25:09 Running 6 stateful tests (MainProcess). 2025-05-24 01:25:09 2025-05-24 01:25:18 00180_no_seek_avoiding_when_reading_from_cache: [ OK ] 9.60 sec. 2025-05-24 01:25:22 00170_s3_cache: [ OK ] 3.58 sec. 2025-05-24 01:26:16 00158_cache_dictionary_has: [ OK ] 54.01 sec. 2025-05-24 01:28:40 00157_cache_dictionary: [ OK ] 144.34 sec. 2025-05-24 01:28:41 00152_insert_different_granularity: [ OK ] 0.47 sec. 2025-05-24 01:28:42 00140_rename: [ OK ] 0.71 sec. 2025-05-24 01:28:42 2025-05-24 01:28:42 6 tests passed. 0 tests skipped. 212.78 s elapsed (MainProcess). 2025-05-24 01:28:42 Checking the hung queries: done 2025-05-24 01:28:42 2025-05-24 01:28:42 No queries hung. 2025-05-24 01:28:42 All tests have finished.