ClickHouse Stateful Tests (asan) for master
run.log Commit check_status.tsv 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 | 2.29 |
2024-09-24 09:21:17 [aa08eedc8d2f] 2024.09.24 09:21:16.771636 [ 1776 ] {c36c4a19-9cf3-42ab-b35b-e940cc9f181d} <Error> executeQuery: Code: 241. DB::Exception: Memory limit (total) exceeded: would use 27.72 GiB (attempt to allocate chunk of 1114397 bytes), maximum: 27.55 GiB. OvercommitTracker decision: Memory overcommit has freed not enough memory.: (while reading column UserID): (while reading from part /var/lib/clickhouse/store/5f5/5f55316c-8657-4e60-b714-e6ae3b6e5743/201403_10_18_2/ in table test.hits (5f55316c-8657-4e60-b714-e6ae3b6e5743) located on disk default of type local, from mark 0 with max_rows_to_read = 19001): While executing MergeTreeThread. (MEMORY_LIMIT_EXCEEDED) (version 23.8.16.41.altinitystable (altinity build)) (from [::1]:54706) (comment: 00088_global_in_one_shard_and_rows_before_limit.sql) (in query: SELECT EventDate, count() FROM remote('127.0.0.1', test.hits) WHERE UserID GLOBAL IN (SELECT UserID FROM test.hits) GROUP BY EventDate ORDER BY EventDate LIMIT 5 FORMAT JSONCompact;), Stack trace (when copying this message, always include the lines below):
2024-09-24 09:21:17
2024-09-24 09:21:17 0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x000000003e077d33 in /usr/bin/clickhouse
2024-09-24 09:21:17 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001d5c5dd0 in /usr/bin/clickhouse
2024-09-24 09:21:17 2. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception<char const*, char const*, String, long&, String, char const*, std::basic_string_view<char, std::char_traits<char>>>(int, FormatStringHelperImpl<std::type_identity<char const*>::type, std::type_identity<char const*>::type, std::type_identity<String>::type, std::type_identity<long&>::type, std::type_identity<String>::type, std::type_identity<char const*>::type, std::type_identity<std::basic_string_view<char, std::char_traits<char>>>::type>, char const*&&, char const*&&, String&&, long&, String&&, char const*&&, std::basic_string_view<char, std::char_traits<char>>&&) @ 0x000000001d60ab71 in /usr/bin/clickhouse
2024-09-24 09:21:17 3. ./build_docker/./src/Common/MemoryTracker.cpp:340: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d608239 in /usr/bin/clickhouse
2024-09-24 09:21:17 4. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse
2024-09-24 09:21:17 5. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse
2024-09-24 09:21:17 6. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse
2024-09-24 09:21:17 7. ./build_docker/./src/Common/CurrentMemoryTracker.cpp:59: CurrentMemoryTracker::alloc(long) @ 0x000000001d534f9d in /usr/bin/clickhouse
2024-09-24 09:21:17 8. ./build_docker/./src/Common/Allocator.h:102: Allocator<false, false>::alloc(unsigned long, unsigned long) @ 0x000000001d52966f in /usr/bin/clickhouse
2024-09-24 09:21:17 9. void DB::PODArrayBase<8ul, 4096ul, Allocator<false, false>, 63ul, 64ul>::resize<>(unsigned long) @ 0x000000000bd861c5 in /usr/bin/clickhouse
2024-09-24 09:21:17 10. ./build_docker/./src/Common/PODArray.h:321: DB::SerializationNumber<unsigned long>::deserializeBinaryBulk(DB::IColumn&, DB::ReadBuffer&, unsigned long, double) const @ 0x000000002f211566 in /usr/bin/clickhouse
2024-09-24 09:21:17 11. ./build_docker/./src/DataTypes/Serializations/ISerialization.cpp:0: DB::ISerialization::deserializeBinaryBulkWithMultipleStreams(COW<DB::IColumn>::immutable_ptr<DB::IColumn>&, unsigned long, DB::ISerialization::DeserializeBinaryBulkSettings&, std::shared_ptr<DB::ISerialization::DeserializeBinaryBulkState>&, std::unordered_map<String, COW<DB::IColumn>::immutable_ptr<DB::IColumn>, std::hash<String>, std::equal_to<String>, std:: | ||
| 00089_position_functions_with_non_constant_arg | FAIL | 6.16 |
2024-09-24 09:21:17 [aa08eedc8d2f] 2024.09.24 01:21:17.277583 [ 1778 ] {af48bfb0-7942-4f3a-a580-43d97bbe94c3} <Error> executeQuery: Code: 241. DB::Exception: Memory limit (total) exceeded: would use 27.55 GiB (attempt to allocate chunk of 2883584 bytes), maximum: 27.55 GiB. OvercommitTracker decision: Memory overcommit has freed not enough memory.: (while reading column URL): (while reading from part /var/lib/clickhouse/store/5f5/5f55316c-8657-4e60-b714-e6ae3b6e5743/201403_10_18_2/ in table test.hits (5f55316c-8657-4e60-b714-e6ae3b6e5743) located on disk default of type local, from mark 40 with max_rows_to_read = 8192): While executing MergeTreeThread. (MEMORY_LIMIT_EXCEEDED) (version 23.8.16.41.altinitystable (altinity build)) (from [::1]:54676) (comment: 00089_position_functions_with_non_constant_arg.sql) (in query: SELECT count() FROM test.hits WHERE position(URL, 'metrika') != position(URL, materialize('metrika'));), Stack trace (when copying this message, always include the lines below):
2024-09-24 09:21:17
2024-09-24 09:21:17 0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x000000003e077d33 in /usr/bin/clickhouse
2024-09-24 09:21:17 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001d5c5dd0 in /usr/bin/clickhouse
2024-09-24 09:21:17 2. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception<char const*, char const*, String, long&, String, char const*, std::basic_string_view<char, std::char_traits<char>>>(int, FormatStringHelperImpl<std::type_identity<char const*>::type, std::type_identity<char const*>::type, std::type_identity<String>::type, std::type_identity<long&>::type, std::type_identity<String>::type, std::type_identity<char const*>::type, std::type_identity<std::basic_string_view<char, std::char_traits<char>>>::type>, char const*&&, char const*&&, String&&, long&, String&&, char const*&&, std::basic_string_view<char, std::char_traits<char>>&&) @ 0x000000001d60ab71 in /usr/bin/clickhouse
2024-09-24 09:21:17 3. ./build_docker/./src/Common/MemoryTracker.cpp:340: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d608239 in /usr/bin/clickhouse
2024-09-24 09:21:17 4. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse
2024-09-24 09:21:17 5. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse
2024-09-24 09:21:17 6. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse
2024-09-24 09:21:17 7. ./build_docker/./src/Common/CurrentMemoryTracker.cpp:59: CurrentMemoryTracker::alloc(long) @ 0x000000001d534f9d in /usr/bin/clickhouse
2024-09-24 09:21:17 8. ./build_docker/./src/Common/Allocator.h:0: Allocator<false, false>::realloc(void*, unsigned long, unsigned long, unsigned long) @ 0x000000001d52b2c7 in /usr/bin/clickhouse
2024-09-24 09:21:17 9. void DB::PODArrayBase<1ul, 4096ul, Allocator<false, false>, 63ul, 64ul>::resize<>(unsigned long) @ 0x000000000bdbee29 in /usr/bin/clickhouse
2024-09-24 09:21:17 10. ./build_docker/./src/DataTypes/Serializations/SerializationString.cpp:176: void DB::deserializeBinarySSE2<4>(DB::PODArray<char8_t, 4096ul, Allocator<false, false>, 63ul, 64ul>&, DB::PODArray<unsigned long, 4096ul, Allocator<false, false>, 63ul, 64ul>&, DB::ReadBuffer&, unsigned long) @ 0x000000002f275ec4 in /usr/bin/clickhouse
2024-09-24 09:21:17 11. ./build_docker/./src/DataTypes/Serializations/SerializationString.cpp:0: DB::SerializationString::deserializeBinaryBulk(DB::IColumn&, DB::ReadBuffer&, unsigned long, double) const @ 0x000000002f274736 in /usr/bin/clickhouse
2024-09-24 09:21:17 12. ./build_docker/./src/DataTypes/Serializations/ISerialization.cpp:0: DB::ISerialization::deserializeBinaryBulkWithMultipleSt | ||
| 00176_distinct_limit_by_limit_bug_43377 | OK | 0.57 |
| 00176_bson_parallel_parsing | SKIPPED | 0.0 |
| 00177_memory_bound_merging | OK | 4.12 |
| 00175_obfuscator_schema_inference | OK | 3.42 |
| 00175_counting_resources_in_subqueries | OK | 0.8 |
| 00174_distinct_in_order | OK | 2.41 |
| 00173_group_by_use_nulls | OK | 2.96 |
| 00172_early_constant_folding | OK | 0.4 |
| 00171_grouping_aggregated_transform_bug | OK | 6.51 |
| 00172_hits_joins | OK | 25.62 |
| 00169_contingency | OK | 17.48 |
| 00167_parallel_parsing_with_names_and_types | OK | 18.14 |
| 00167_read_bytes_from_fs | OK | 18.11 |
| 00166_explain_estimate | OK | 0.42 |
| 00164_quantileBfloat16 | OK | 3.79 |
| 00165_jit_aggregate_functions | OK | 5.51 |
| 00163_column_oriented_formats | OK | 8.83 |
| 00162_mmap_compression_none | OK | 8.63 |
| 00160_decode_xml_component | OK | 2.85 |
| 00161_parallel_parsing_with_names | OK | 8.12 |
| 00159_parallel_formatting_http | OK | 12.8 |
| 00159_parallel_formatting_tsv_and_friends | OK | 33.35 |
| 00159_parallel_formatting_json_and_friends | OK | 63.82 |
| 00159_parallel_formatting_csv_and_friends | OK | 24.78 |
| 00154_avro | OK | 1.17 |
| 00156_max_execution_speed_sample_merge | OK | 4.58 |
| 00151_order_by_read_in_order | OK | 0.91 |
| 00153_aggregate_arena_race | OK | 1.67 |
| 00150_quantiles_timing_precision | OK | 0.81 |
| 00149_quantiles_timing_distributed | OK | 6.43 |
| 00148_monotonic_functions_and_index | OK | 7.16 |
| 00147_global_in_aggregate_function | OK | 4.01 |
| 00146_aggregate_function_uniq | OK | 4.99 |
| 00145_aggregate_functions_statistics | OK | 2.04 |
| 00144_functions_of_aggregation_states | OK | 0.77 |
| 00143_transform_non_const_default | OK | 0.95 |
| 00142_system_columns | OK | 0.34 |
| 00141_transform | OK | 0.39 |
| 00097_constexpr_in_index | OK | 0.42 |
| 00096_obfuscator_save_load | OK | 3.07 |
| 00139_like | OK | 5.3 |
| 00094_order_by_array_join_limit | OK | 2.85 |
| 00095_hyperscan_profiler | OK | 5.11 |
| 00093_prewhere_array_join | OK | 3.05 |
| 00092_obfuscator | OK | 3.51 |
| 00091_prewhere_two_conditions | OK | 20.48 |
| 00090_thread_pool_deadlock | OK | 22.22 |
| 00087_where_0 | OK | 0.51 |
| 00085_monotonic_evaluation_segfault | OK | 1.06 |
| 00086_array_reduce | OK | 3.89 |
| 00083_array_filter | OK | 1.74 |
| 00082_quantiles | OK | 6.85 |
| 00081_group_by_without_key_and_totals | OK | 0.66 |
| 00080_array_join_and_union | OK | 0.39 |
| 00079_array_join_not_used_joined_column | OK | 1.08 |
| 00078_group_by_arrays | OK | 2.97 |
| 00084_external_aggregation | OK | 21.57 |
| 00077_log_tinylog_stripelog | OK | 5.1 |
| 00076_system_columns_bytes | OK | 0.35 |
| 00075_left_array_join | OK | 0.61 |
| 00073_uniq_array | OK | 0.4 |
| 00074_full_join | OK | 1.65 |
| 00071_merge_tree_optimize_aio | OK | 4.75 |
| 00069_duplicate_aggregation_keys | OK | 0.38 |
| 00068_subquery_in_prewhere | OK | 0.49 |
| 00067_union_all | OK | 1.26 |
| 00066_sorting_distributed_many_replicas | OK | 0.36 |
| 00072_compare_date_and_string_index | OK | 8.66 |
| 00065_loyalty_with_storage_join | OK | 1.04 |
| 00062_loyalty | OK | 0.8 |
| 00063_loyalty_joins | OK | 2.6 |
| 00060_move_to_prewhere_and_sets | OK | 0.57 |
| 00061_storage_buffer | OK | 1.72 |
| 00059_merge_sorting_empty_array_joined | OK | 0.33 |
| 00055_index_and_not | OK | 0.49 |
| 00056_view | OK | 1.01 |
| 00054_merge_tree_partitions | OK | 0.84 |
| 00052_group_by_in | OK | 0.35 |
| 00053_replicate_segfault | OK | 2.94 |
| 00050_min_max | OK | 1.31 |
| 00051_min_max_array | OK | 3.55 |
| 00048_min_max | OK | 0.38 |
| 00049_max_string_if | OK | 1.41 |
| 00047_bar | OK | 0.89 |
| 00046_uniq_upto_distributed | OK | 0.64 |
| 00045_uniq_upto | OK | 0.57 |
| 00043_any_left_join | OK | 0.91 |
| 00042_any_left_join | OK | 0.78 |
| 00044_any_left_join_string | OK | 2.47 |
| 00041_aggregating_materialized_view | OK | 1.93 |
| 00040_aggregating_materialized_view | OK | 1.58 |
| 00039_primary_key | OK | 0.36 |
| 00038_uniq_state_merge2 | OK | 2.61 |
| 00036_aggregate_hashed | OK | 0.85 |
| 00037_uniq_state_merge1 | OK | 3.81 |
| 00035_aggregate_keys128 | OK | 0.46 |
| 00034_aggregate_key_fixed_string | OK | 0.76 |
| 00033_aggregate_key_string | OK | 0.79 |
| 00032_aggregate_key64 | OK | 0.43 |
| 00031_array_enumerate_uniq | OK | 0.43 |
| 00030_array_enumerate_uniq | OK | 1.16 |
| 00023_totals_limit | OK | 0.35 |
| 00022_merge_prewhere | OK | 0.44 |
| 00021_3_select_with_in | OK | 0.34 |
| 00021_2_select_with_in | OK | 0.33 |
| 00021_1_select_with_in | OK | 0.34 |
| 00020_distinct_order_by_distributed | OK | 0.44 |
| 00017_aggregation_uninitialized_memory | OK | 0.34 |
| 00016_any_if_distributed_cond_always_false | OK | 0.72 |
| 00015_totals_and_no_aggregate_functions | OK | 0.33 |
| 00014_filtering_arrays | OK | 0.47 |
| 00013_sorting_of_nested | OK | 0.71 |
| 00012_sorting_distributed | OK | 0.57 |
| 00011_sorting | OK | 0.44 |
| 00010_quantiles_segfault | OK | 0.68 |
| 00009_uniq_distributed | OK | 1.15 |
| 00008_uniq | OK | 0.91 |
| 00007_uniq | OK | 0.34 |
| 00006_agregates | OK | 0.46 |
| 00005_filtering | OK | 0.36 |
| 00004_top_counters | OK | 0.53 |
| 00002_count_visits | OK | 0.33 |
| 00001_count_hits | OK | 0.37 |
| 00024_random_counters | OK | 28.54 |
| 00170_s3_cache | OK | 32.1 |
| 00158_cache_dictionary_has | OK | 1.91 |
| 00157_cache_dictionary | OK | 8.86 |
| 00152_insert_different_granularity | OK | 1.88 |
| 00140_rename | OK | 0.55 |
