I’m using MariaDB 10.5.29 with the ColumnStore engine configured. I’ve noticed that memory usage keeps increasing over time and is not released after query execution completes. Eventually, queries that previously worked start failing—especially ones involving large datasets.
After restarting the MariaDB service, the same queries work again temporarily, until the memory (held by PrimeProc) accumulates once more.
Has anyone encountered a similar issue with memory not being freed in ColumnStore? Are there any recommended configurations or best practices to manage or release memory properly? Exact error :
ERROR 1815 (HY000): Internal error: IDB-2057: There is insufficient memory to process the query (PrimProc)
Asked by Amalka
(13 rep)
May 29, 2025, 01:39 AM
Last activity: Jun 3, 2025, 06:41 AM
Last activity: Jun 3, 2025, 06:41 AM