ClickHouse Stateful Tests (release) for PR #807
check_status.tsv Commit clickhouse-server.err.log clickhouse-server.log.zst run.log stderr.log stdout.log test_result.txt test_results.tsv Task (github actions) Job (github actions)
Test name | Test status | Test time, sec. |
---|---|---|
00088_global_in_one_shard_and_rows_before_limit | FAIL | 0.28 |
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 --mi | ||
00078_group_by_arrays | NOT_FAILED | 10.38 |
This test passed. Update analyzer_tech_debt.txt. | ||
00177_memory_bound_merging | OK | 1.0 |
00176_bson_parallel_parsing | SKIPPED | 0.0 |
00176_distinct_limit_by_limit_bug_43377 | OK | 0.1 |
00175_counting_resources_in_subqueries | OK | 0.19 |
00178_quantile_ddsketch | OK | 1.41 |
00175_obfuscator_schema_inference | OK | 0.88 |
00174_distinct_in_order | OK | 0.82 |
00173_group_by_use_nulls | OK | 0.53 |
00172_early_constant_folding | OK | 0.11 |
00171_grouping_aggregated_transform_bug | OK | 0.44 |
00169_contingency | OK | 2.2 |
00167_read_bytes_from_fs | OK | 1.34 |
00167_parallel_parsing_with_names_and_types | OK | 3.24 |
00166_explain_estimate | OK | 0.08 |
00165_jit_aggregate_functions | OK | 0.58 |
00164_quantileBfloat16 | OK | 0.94 |
00163_column_oriented_formats | OK | 1.63 |
00162_mmap_compression_none | OK | 1.62 |
00161_parallel_parsing_with_names | OK | 1.43 |
00160_decode_xml_component | OK | 0.19 |
00172_hits_joins | OK | 20.34 |
00159_parallel_formatting_http | OK | 1.83 |
00159_parallel_formatting_json_and_friends_1 | OK | 8.72 |
00159_parallel_formatting_tsv_and_friends | OK | 3.81 |
00159_parallel_formatting_csv_and_friends | OK | 7.01 |
00156_max_execution_speed_sample_merge | OK | 4.33 |
00154_avro | OK | 0.32 |
00159_parallel_formatting_json_and_friends_2 | OK | 6.94 |
00151_order_by_read_in_order | OK | 0.11 |
00153_aggregate_arena_race | OK | 0.18 |
00150_quantiles_timing_precision | OK | 0.2 |
00149_quantiles_timing_distributed | OK | 0.48 |
00148_monotonic_functions_and_index | OK | 0.38 |
00147_global_in_aggregate_function | OK | 0.75 |
00146_aggregate_function_uniq | OK | 0.7 |
00144_functions_of_aggregation_states | OK | 0.15 |
00145_aggregate_functions_statistics | OK | 0.24 |
00142_system_columns | OK | 0.07 |
00143_transform_non_const_default | OK | 0.18 |
00141_transform | OK | 0.08 |
00098_primary_key_memory_allocated | OK | 0.1 |
00097_constexpr_in_index | OK | 0.09 |
00139_like | OK | 0.4 |
00095_hyperscan_profiler | OK | 0.35 |
00096_obfuscator_save_load | OK | 0.65 |
00094_order_by_array_join_limit | OK | 0.42 |
00093_prewhere_array_join | OK | 0.48 |
00092_obfuscator | OK | 0.59 |
00091_prewhere_two_conditions | OK | 1.2 |
00089_position_functions_with_non_constant_arg | OK | 2.3 |
00090_thread_pool_deadlock | OK | 3.31 |
00087_where_0 | OK | 0.08 |
00086_array_reduce | OK | 0.13 |
00085_monotonic_evaluation_segfault | OK | 0.52 |
00083_array_filter | OK | 0.24 |
00082_quantiles | OK | 1.1 |
00081_group_by_without_key_and_totals | OK | 0.18 |
00084_external_aggregation | OK | 3.92 |
00079_array_join_not_used_joined_column | OK | 0.37 |
00080_array_join_and_union | OK | 2.9 |
00077_log_tinylog_stripelog | OK | 2.08 |
00076_system_columns_bytes | OK | 0.07 |
00075_left_array_join | OK | 0.26 |
00074_full_join | OK | 7.12 |
00073_uniq_array | OK | 0.08 |
00071_merge_tree_optimize_aio | OK | 0.45 |
00069_duplicate_aggregation_keys | OK | 0.09 |
00068_subquery_in_prewhere | OK | 0.09 |
00072_compare_date_and_string_index | OK | 0.84 |
00067_union_all | OK | 0.11 |
00066_sorting_distributed_many_replicas | OK | 0.05 |
00065_loyalty_with_storage_join | OK | 0.71 |
00062_loyalty | OK | 0.95 |
00061_storage_buffer | OK | 0.39 |
00060_move_to_prewhere_and_sets | OK | 0.09 |
00059_merge_sorting_empty_array_joined | OK | 0.06 |
00056_view | OK | 0.22 |
00055_index_and_not | OK | 0.11 |
00054_merge_tree_partitions | OK | 0.28 |
00063_loyalty_joins | OK | 4.25 |
00053_replicate_segfault | OK | 1.54 |
00051_min_max_array | OK | 0.27 |
00052_group_by_in | OK | 0.58 |
00050_min_max | OK | 0.15 |
00048_min_max | OK | 0.13 |
00049_max_string_if | OK | 0.19 |
00047_bar | OK | 0.14 |
00046_uniq_upto_distributed | OK | 1.84 |
00045_uniq_upto | OK | 2.04 |
00043_any_left_join | OK | 0.4 |
00042_any_left_join | OK | 0.64 |
00041_aggregating_materialized_view | OK | 0.92 |
00040_aggregating_materialized_view | OK | 0.41 |
00039_primary_key | OK | 0.08 |
00038_uniq_state_merge2 | OK | 0.26 |
00037_uniq_state_merge1 | OK | 0.23 |
00036_aggregate_hashed | OK | 0.61 |
00035_aggregate_keys128 | OK | 0.08 |
00034_aggregate_key_fixed_string | OK | 0.13 |
00033_aggregate_key_string | OK | 0.5 |
00032_aggregate_key64 | OK | 0.12 |
00031_array_enumerate_uniq | OK | 0.12 |
00030_array_enumerate_uniq | OK | 0.2 |
00024_random_counters | OK | 8.37 |
00044_any_left_join_string | OK | 13.92 |
00023_totals_limit | OK | 0.41 |
00021_2_select_with_in | OK | 0.07 |
00022_merge_prewhere | OK | 0.09 |
00021_3_select_with_in | OK | 0.08 |
00021_1_select_with_in | OK | 0.07 |
00017_aggregation_uninitialized_memory | OK | 0.09 |
00016_any_if_distributed_cond_always_false | OK | 0.17 |
00015_totals_and_no_aggregate_functions | OK | 0.12 |
00014_filtering_arrays | OK | 0.12 |
00013_sorting_of_nested | OK | 0.8 |
00012_sorting_distributed | OK | 0.15 |
00011_sorting | OK | 0.12 |
00010_quantiles_segfault | OK | 0.19 |
00009_uniq_distributed | OK | 0.21 |
00008_uniq | OK | 0.15 |
00007_uniq | OK | 0.07 |
00006_agregates | OK | 0.08 |
00005_filtering | OK | 0.14 |
00004_top_counters | OK | 0.16 |
00002_count_visits | OK | 0.09 |
00001_count_hits | OK | 0.1 |
00020_distinct_order_by_distributed | OK | 2.96 |
00180_no_seek_avoiding_when_reading_from_cache | OK | 9.6 |
00170_s3_cache | OK | 3.58 |
00158_cache_dictionary_has | OK | 54.01 |
00157_cache_dictionary | OK | 144.34 |
00152_insert_different_granularity | OK | 0.47 |
00140_rename | OK | 0.71 |
