Hi Team Any idea about below clickhouse error
{"da...
# supports
sudhanshu dev
01/13/2025, 10:59 AMHi Team Any idea about below clickhouse error
{"date_time":"1736765497.171751","thread_name":"","thread_id":"587","level":"Error","query_id":"","logger_name":"MergeTreeBackgroundExecutor","message":"Exception while executing background task {7165cb86-e3b3-4832-9778-cf6a91b2273c:20250113 19972 20005 2} Code: 241. DB:Exception Memory limit (total) exceeded: would use 6.17 GiB (attempt to allocate chunk of 4860928 bytes), maximum: 6.15 GiB. OvercommitTracker decision: Memory overcommit isn't used. Waiting time or overcommit denominator are set to zero.: While executing MergingSortedTransform. (MEMORY_LIMIT_EXCEEDED), Stack trace (when copying this message, always include the lines below):\n\n0. DB:Exception:Exception(DB:Exception:MessageMasked&&, int, bool) @ 0x000000000c800f1b in \/usr\/bin\/clickhouse\n1. 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>>&&) @ 0x000000000c816d0a in \/usr\/bin\/clickhouse\n2. MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000000c816948 in \/usr\/bin\/clickhouse\n3. MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000000c816389 in \/usr\/bin\/clickhouse\n4. MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000000c816389 in \/usr\/bin\/clickhouse\n5. MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000000c816389 in \/usr\/bin\/clickhouse\n6. Allocator<false, false>::realloc(void*, unsigned long, unsigned long, unsigned long) @ 0x000000000c7d5d87 in \/usr\/bin\/clickhouse\n7. void DB::PODArrayBase<1ul, 4096ul, Allocator<false, false>, 63ul, 64ul>::resize<>(unsigned long) @ 0x00000000072221c7 in \/usr\/bin\/clickhouse\n8. DB:ColumnString:insertFrom(DB::IColumn const&, unsigned long) @ 0x0000000011ae8c6c in \/usr\/bin\/clickhouse\n9. decltype(auto) std: variant detail visitation base dispatcher<25ul> dispatch[abiv15000]<std: variant detail visitation variant value visitor<DBMergingSortedAlgorithm:merge()::$_0&>&&, std: variant detail:__base<(std: variant detail:_Trait)1, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<char8_t>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<unsigned short>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<unsigned int>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<unsigned long>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<wide:integer<128ul, unsigned int>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<wide:integer<256ul, unsigned int>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<signed char>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<short>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<int>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<long>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<wide:integer<128ul, int>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<wide:integer<256ul, int>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<float>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<double>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnDecimal<DB:Decimal<int>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnDecimal<DB:Decimal<long>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnDecimal<DBDecimal<wide:integer<128ul, int>>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnDecimal<DBDecimal<wide:integer<256ul, int>>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnDecimal<DB:DateTime64>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<StrongTypedef<wide:integer<128ul, unsigned int>, DB::UUIDTag>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<DB:IPv4>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<DB:IPv6>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnString>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnFixedString>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DB:SimpleSortCursor, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DB:SortCursor, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DB:SortCursorWithCollation, (DB::SortingQueueStrategy)0>>&>(std: variant detail visitation variant value visitor<DBMergingSortedAlgorithm:merge()::$_0&>&&, std: variant detail:__base<(std: variant detail:_Trait)1, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<char8_t>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<unsigned short>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<unsigned int>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<unsigned long>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<wide:integer<128ul, unsigned int>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<wide:integer<256ul, unsigned int>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<signed char>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<short>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<int>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<long>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<wide:integer<128ul, int>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<wide:integer<256ul, int>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<float>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnVector<double>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnDecimal<DB:Decimal<int>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnDecimal<DB:Decimal<long>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnDecimal<DBDecimal<wide:integer<128ul, int>>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnDecimal<DBDecimal<wide:integer<256ul, int>>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnDecimal<DB:DateTime64>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<StrongTypedef<wide:integer<128ul, unsigned int>, DB::UUIDTag>>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<DB:IPv4>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DBColumnVector<DB:IPv6>>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnString>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DBSpecializedSingleColumnSortCursor<DB:ColumnFixedString>, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DB:SimpleSortCursor, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DB:SortCursor, (DB::SortingQueueStrategy)0>, DB:SortingQueueImpl<DB:SortCursorWithCollation, (DB::SortingQueueStrategy)0>>&) (.llvm.16852483119150238054) @ 0x0000000012d090cb in \/usr\/bin\/clickhouse\n10. DB:IMergingTransform<DBMergingSortedAlgorithm>:work() @ 0x00000000116db56f in \/usr\/bin\/clickhouse\n11. DB:ExecutionThreadContext:executeTask() @ 0x000000001299371a in \/usr\/bin\/clickhouse\n12. DB:PipelineExecutor:executeStepImpl(unsigned long, std::atomic<bool>*) @ 0x000000001298a170 in \/usr\/bin\/clickhouse\n13. DB:PipelineExecutor:executeStep(std::atomic<bool>*) @ 0x0000000012989928 in \/usr\/bin\/clickhouse\n14. DB:PullingPipelineExecutor:pull(DB::Chunk&) @ 0x0000000012998017 in \/usr\/bin\/clickhouse\n15. DB:PullingPipelineExecutor:pull(DB::Block&) @ 0x00000000129981d3 in \/usr\/bin\/clickhouse\n16. DB:MergeTaskExecuteAndFinalizeHorizontalPart:executeImpl() @ 0x000000001233b6f2 in \/usr\/bin\/clickhouse\n17. DB:MergeTaskExecuteAndFinalizeHorizontalPart:execute() @ 0x000000001233b64b in \/usr\/bin\/clickhouse\n18. DB:MergeTask:execute() @ 0x0000000012340d99 in \/usr\/bin\/clickhouse\n19. DB:MergePlainMergeTreeTask:executeStep() @ 0x0000000012723517 in \/usr\/bin\/clickhouse\n20. DB:MergeTreeBackgroundExecutor<DBDynamicRuntimeQueue>:threadFunction() @ 0x00000000123532c4 in \/usr\/bin\/clickhouse\n21. ThreadPoolImpl<ThreadFromGlobalPoolImpl<false>>::worker(std::__list_iterator<ThreadFromGlobalPoolImpl<false>, void*>) @ 0x000000000c8eb0c1 in \/usr\/bin\/clickhouse\n22. void std: function:__policy_invoker<void ()>: call impl<std function default alloc func<ThreadFromGlobalPoolImpl<false>:ThreadFromGlobalPoolImpl<void ThreadPoolImpl<ThreadFromGlobalPoolImpl<false>>::scheduleImpl<void>(std::function<void ()>, Priority, std::optional<unsigned long>, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std: function:__policy_storage const*) @ 0x000000000c8ee8fa in \/usr\/bin\/clickhouse\n23. void* std: thread proxy[abiv15000]<std:tuple<stdunique ptr<std:__thread_struct, std:default delete<std:__thread_struct>>, void ThreadPoolImpl<std:thread>:scheduleImpl<void>(std::function<void ()>, Priority, std::optional<unsigned long>, bool)::'lambda0'()>>(void*) @ 0x000000000c8ed6fe in \/usr\/bin\/clickhouse\n24. ? @ 0x00007fed33e3e609\n25. ? @ 0x00007fed33d63353\n (version 24.1.2.5 (official build))","source_file":"src\/Common\/Exception.cpp; void DB::tryLogCurrentExceptionImpl(Poco::Logger *, const std::string &)","source_line":"222"}
n
nitya-signoz
01/13/2025, 1:47 PMTry to post it in just a single place https://signoz-community.slack.com/archives/C01HWUTP4HH/p1736745353764209 : )
s
sudhanshu dev
01/13/2025, 2:35 PMUnderstood.
27 Views