Excessive and Unreleased memory

Customer experiencing a persistent memory leak issue that arises during query execution. This problem is characterized by the system continuously allocating memory for running queries without subsequently releasing it once the memory is no longer required. As a result, we have observed a steady increase in memory consumption over time.

Even when the server is experiencing periods of inactivity or low workload, the memory usage remains at an elevated level. This ongoing memory leak has unfortunately led to out-of-memory (OOM) conditions on the server. In such situations, the operating system may terminate MariaDB service processes in an attempt to reclaim memory resources.

We are seeking root cause of this memory leak to implement a solution and prevent future occurrences of these critical issues.

During the reproduction of this issue, we observed the following MariaDB RAM usage

...05-23-2025-21:08:47 MariaDB RAM Usage: 798.062 MB
...05-23-2025-21:08:48 MariaDB RAM Usage: 803 MB
...05-23-2025-21:08:48 MariaDB RAM Usage: 804.062 MB
..05-23-2025-21:08:49 MariaDB RAM Usage: 807.875 MB
...05-23-2025-21:08:50 MariaDB RAM Usage: 812.688 MB
...05-23-2025-21:08:51 MariaDB RAM Usage: 817 MB
..05-23-2025-21:08:52 MariaDB RAM Usage: 819.375 MB
.05-23-2025-21:08:52 MariaDB RAM Usage: 821.375 MB
...05-23-2025-21:08:53 MariaDB RAM Usage: 825.562 MB
...05-23-2025-21:08:54 MariaDB RAM Usage: 829.75 MB
...05-23-2025-21:08:55 MariaDB RAM Usage: 833.562 MB
05-23-2025-21:08:55 MariaDB RAM Usage: 834.062 MB
...05-23-2025-21:08:56 MariaDB RAM Usage: 838.375 MB
...05-23-2025-21:08:57 MariaDB RAM Usage: 842.688 MB
...05-23-2025-21:08:58 MariaDB RAM Usage: 846.5 MB
.05-23-2025-21:08:59 MariaDB RAM Usage: 847.312 MB
..05-23-2025-21:08:59 MariaDB RAM Usage: 850.562 MB
...05-23-2025-21:09:01 MariaDB RAM Usage: 855 MB
...05-23-2025-21:09:02 MariaDB RAM Usage: 859.312 MB
..05-23-2025-21:09:02 MariaDB RAM Usage: 861.75 MB
.05-23-2025-21:09:03 MariaDB RAM Usage: 863.688 MB
...05-23-2025-21:09:04 MariaDB RAM Usage: 868 MB
...05-23-2025-21:09:05 MariaDB RAM Usage: 872.375 MB
...05-23-2025-21:09:06 MariaDB RAM Usage: 876.25 MB
05-23-2025-21:09:06 MariaDB RAM Usage: 876.75 MB
...05-23-2025-21:09:07 MariaDB RAM Usage: 881.062 MB
...05-23-2025-21:09:08 MariaDB RAM Usage: 885.375 MB
...05-23-2025-21:09:09 MariaDB RAM Usage: 890.188 MB
.05-23-2025-21:09:09 MariaDB RAM Usage: 891.312 MB
..05-23-2025-21:09:10 MariaDB RAM Usage: 895.062 MB
...05-23-2025-21:09:11 MariaDB RAM Usage: 899.438 MB
...05-23-2025-21:09:12 MariaDB RAM Usage: 903.688 MB
..05-23-2025-21:09:13 MariaDB RAM Usage: 906 MB
.05-23-2025-21:09:14 MariaDB RAM Usage: 907.812 MB
...05-23-2025-21:09:15 MariaDB RAM Usage: 912.188 MB
...05-23-2025-21:09:16 MariaDB RAM Usage: 916.562 MB
...05-23-2025-21:09:16 MariaDB RAM Usage: 920.375 MB
05-23-2025-21:09:17 MariaDB RAM Usage: 920.875 MB
...05-23-2025-21:09:18 MariaDB RAM Usage: 925.5 MB
...05-23-2025-21:09:19 MariaDB RAM Usage: 930.375 MB
...05-23-2025-21:09:20 MariaDB RAM Usage: 934.688 MB
.05-23-2025-21:09:20 MariaDB RAM Usage: 935.625 MB
..05-23-2025-21:09:21 MariaDB RAM Usage: 939 MB
...05-23-2025-21:09:22 MariaDB RAM Usage: 943.312 MB
...05-23-2025-21:09:23 MariaDB RAM Usage: 947.625 MB
..05-23-2025-21:09:23 MariaDB RAM Usage: 949.875 MB
.05-23-2025-21:09:24 MariaDB RAM Usage: 951.75 MB
...05-23-2025-21:09:25 MariaDB RAM Usage: 956 MB
...05-23-2025-21:09:26 MariaDB RAM Usage: 960.312 MB
...05-23-2025-21:09:27 MariaDB RAM Usage: 964.125 MB
05-23-2025-21:09:27 MariaDB RAM Usage: 964.625 MB
...05-23-2025-21:09:28 MariaDB RAM Usage: 968.812 MB
...05-23-2025-21:09:29 MariaDB RAM Usage: 972.688 MB
...05-23-2025-21:09:30 MariaDB RAM Usage: 977.1 MB
.05-23-2025-21:09:30 MariaDB RAM Usage: 978.0 MB
..05-23-2025-21:09:31 MariaDB RAM Usage: 981.3 MB
...05-23-2025-21:09:32 MariaDB RAM Usage: 985.8 MB
...05-23-2025-21:09:33 MariaDB RAM Usage: 990.1 MB
..05-23-2025-21:09:34 MariaDB RAM Usage: 992.8 MB
.05-23-2025-21:09:34 MariaDB RAM Usage: 994.9 MB
...05-23-2025-21:09:35 MariaDB RAM Usage: 999.2 MB
...05-23-2025-21:09:36 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:37 MariaDB RAM Usage: 1024 MB
05-23-2025-21:09:38 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:39 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:40 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:41 MariaDB RAM Usage: 1024 MB
.05-23-2025-21:09:41 MariaDB RAM Usage: 1024 MB
..05-23-2025-21:09:42 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:43 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:44 MariaDB RAM Usage: 1024 MB
..05-23-2025-21:09:44 MariaDB RAM Usage: 1024 MB
.05-23-2025-21:09:45 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:46 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:47 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:48 MariaDB RAM Usage: 1024 MB
05-23-2025-21:09:48 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:49 MariaDB RAM Usage: 1024 MB
...05-23-2025-21:09:50 MariaDB RAM Usage: 1024 MB
.......05-23-2025-21:09:53 MariaDB RAM Usage: 1024 MB
..........05-23-2025-21:09:55 MariaDB RAM Usage: 1024 MB
..........05-23-2025-21:09:57 MariaDB RAM Usage: 1024 MB
..........05-23-2025-21:09:59 MariaDB RAM Usage: 1024 MB
..........05-23-2025-21:10:02 MariaDB RAM Usage: 1024 MB
..........05-23-2025-21:10:04 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:06 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:08 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:11 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:13 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:15 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:17 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:19 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:22 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:24 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:26 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:28 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:10:30 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:11:57 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:11:59 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:12:01 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:12:04 MariaDB RAM Usage: 1126.4 MB
..........05-23-2025-21:12:06 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:08 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:10 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:12 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:14 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:17 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:19 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:21 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:23 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:25 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:27 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:30 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:32 MariaDB RAM Usage: 1228.8 MB
..........05-23-2025-21:12:34 MariaDB RAM Usage: 1228.8 MB
.05-23-2025-22:04:24 MariaDB RAM Usage: 1228.8 MB
...05-23-2025-22:04:25 MariaDB RAM Usage: 1331.2 MB
.05-23-2025-22:04:26 MariaDB RAM Usage: 1331.2 MB
..05-23-2025-22:04:26 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:28 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:29 MariaDB RAM Usage: 1331.2 MB
..05-23-2025-22:04:29 MariaDB RAM Usage: 1331.2 MB
.05-23-2025-22:04:30 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:31 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:32 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:33 MariaDB RAM Usage: 1331.2 MB
05-23-2025-22:04:33 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:34 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:35 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:36 MariaDB RAM Usage: 1331.2 MB
.05-23-2025-22:04:36 MariaDB RAM Usage: 1331.2 MB
..05-23-2025-22:04:37 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:38 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:39 MariaDB RAM Usage: 1331.2 MB
..05-23-2025-22:04:40 MariaDB RAM Usage: 1331.2 MB
.05-23-2025-22:04:41 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:42 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:43 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:44 MariaDB RAM Usage: 1331.2 MB
05-23-2025-22:04:44 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:45 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:46 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:47 MariaDB RAM Usage: 1331.2 MB
.05-23-2025-22:04:47 MariaDB RAM Usage: 1331.2 MB
..05-23-2025-22:04:48 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:49 MariaDB RAM Usage: 1331.2 MB
...05-23-2025-22:04:50 MariaDB RAM Usage: 1331.2 MB
..05-23-2025-22:04:51 MariaDB RAM Usage: 1433.6 MB
.05-23-2025-22:04:52 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:04:53 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:04:54 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:04:54 MariaDB RAM Usage: 1433.6 MB
05-23-2025-22:04:55 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:04:56 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:04:57 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:04:58 MariaDB RAM Usage: 1433.6 MB
.05-23-2025-22:04:58 MariaDB RAM Usage: 1433.6 MB
..05-23-2025-22:04:59 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:00 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:01 MariaDB RAM Usage: 1433.6 MB
..05-23-2025-22:05:02 MariaDB RAM Usage: 1433.6 MB
.05-23-2025-22:05:02 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:03 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:04 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:05 MariaDB RAM Usage: 1433.6 MB
05-23-2025-22:05:06 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:07 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:08 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:09 MariaDB RAM Usage: 1433.6 MB
.05-23-2025-22:05:09 MariaDB RAM Usage: 1433.6 MB
..05-23-2025-22:05:10 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:11 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:12 MariaDB RAM Usage: 1433.6 MB
..05-23-2025-22:05:12 MariaDB RAM Usage: 1433.6 MB
.05-23-2025-22:05:13 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:14 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:15 MariaDB RAM Usage: 1433.6 MB
...05-23-2025-22:05:16 MariaDB RAM Usage: 1536 MB
05-23-2025-22:05:16 MariaDB RAM Usage: 1536 MB
...05-23-2025-22:05:17 MariaDB RAM Usage: 1536 MB
...05-23-2025-22:05:18 MariaDB RAM Usage: 1536 MB
...05-23-2025-22:05:19 MariaDB RAM Usage: 1536 MB
.05-23-2025-22:05:20 MariaDB RAM Usage: 1536 MB
..05-23-2025-22:05:20 MariaDB RAM Usage: 1536 MB
...05-23-2025-22:05:21 MariaDB RAM Usage: 1536 MB
...05-23-2025-22:05:22 MariaDB RAM Usage: 1536 MB
..05-23-2025-22:05:23 MariaDB RAM Usage: 1536 MB
.05-23-2025-22:05:24 MariaDB RAM Usage: 1536 MB
...05-23-2025-22:05:25 MariaDB RAM Usage: 1536 MB
...05-23-2025-22:05:26 MariaDB RAM Usage: 1536 MB
...05-23-2025-22:05:26 MariaDB RAM Usage: 1536 MB
05-23-2025-22:05:27 MariaDB RAM Usage: 1536 MB
...05-23-2025-22:05:28 MariaDB RAM Usage: 1536 MB
...05-23-2025-22:05:29 MariaDB RAM Usage: 1536 MB
..........05-23-2025-22:06:16 MariaDB RAM Usage: 1536 MB
..........05-23-2025-22:06:18 MariaDB RAM Usage: 1536 MB
..........05-23-2025-22:06:20 MariaDB RAM Usage: 1536 MB
..........05-23-2025-22:06:23 MariaDB RAM Usage: 1536 MB
..........05-23-2025-22:06:25 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:27 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:29 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:32 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:34 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:36 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:38 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:40 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:43 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:45 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:47 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:50 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:06:52 MariaDB RAM Usage: 1638.4 MB
.........05-23-2025-22:08:20 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:08:22 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:08:24 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:08:27 MariaDB RAM Usage: 1638.4 MB
..........05-23-2025-22:08:29 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:31 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:33 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:35 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:38 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:40 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:42 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:44 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:47 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:49 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:51 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:53 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:56 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:08:58 MariaDB RAM Usage: 1740.8 MB
....05-23-2025-22:10:24 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:10:26 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:10:29 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:10:31 MariaDB RAM Usage: 1740.8 MB
..........05-23-2025-22:10:33 MariaDB RAM Usage: 1843.2 MB
..........05-23-2025-22:10:35 MariaDB RAM Usage: 1843.2 MB
..........05-23-2025-22:10:38 MariaDB RAM Usage: 1843.2 MB
..........05-23-2025-22:10:40 MariaDB RAM Usage: 1843.2 MB
..........05-23-2025-22:10:42 MariaDB RAM Usage: 1843.2 MB
..........05-23-2025-22:10:44 MariaDB RAM Usage: 1843.2 MB
..........05-23-2025-22:10:47 MariaDB RAM Usage: 1843.2 MB
..........05-23-2025-22:10:49 MariaDB RAM Usage: 1843.2 MB
..........05-23-2025-22:10:51 MariaDB RAM Usage: 1843.2 MB