[BUG?] memory leak of 10.8GB

[RunqRun]

My lobby server suddenly started experiencing high CPU load.
Checking with jstack revealed frequent garbage collection due to excessively high memory usage.
Suspecting a memory leak, I analyzed a memory dump using jmap.
(We confirmed a temporary recovery by restarting the server.)

This showed objects related to SayanVanish's SQLiteDatabase consuming a whopping 10.8GB of memory.
I have attached the jmap analysis results.

[RunqRun]

I forgot to provide the server information.

Server Software: Purpur 1.21.8-2497-HEAD@a49cdb9
Plugin Version: 1.7.2-build.32-3a05a35

ℹ Server Plugins (39):

Paper Plugins (3):

FancyHolograms, FancyNpcs, PlugManX

Bukkit Plugins (36):

AntiPopup, ArmorStandEditor, BetterPrefix, *BungeePortals, ClientDetectorPlus, CoreProtect, DiscordSRV, Donatai, FastAsyncWorldEdit, GSit
ImageFrame, ImageOnMap, LuckPerms, *LunaChat, NekoHub, NekoLobby, OpenInv, OPJoinMsg, packetevents, PlaceholderAPI
PlayerListSorter, ProtocolLib, SayanVanish, ServerAPI, SkBee, SkQuery, Skript, UltimateAutoRestart, UltraBar, UnifiedMetrics
Vault, ViaBackwards, ViaRewind, ViaVersion, Vulcan, WorldGuard

Custom plugins are included, but none of them integrate with SayanVanish.
(Donatai, OPJoinMsg, PlayerListSorter, ServerAPI)

[Syrent]

hey, could you try it with MySQL as your database method?

[RunqRun]

After testing with MySQL, the memory leak has been resolved for now.

[RunqRun]

We switched to MySQL, but it appears that memory leaks (8.9GB) are still occurring even with MySQL.
If desired, I can provide a memory dump.

[RunqRun]

Hi!
Has there been any progress?

[Syrent]

there have been several internet outages in my country which prevented me from coding. i'll try to update it in a few days

[Syrent]

try this version:
https://cdn.discordapp.com/attachments/1036292004650418216/1469934817331384433/SayanVanish-1.7.3-build.dev-local-bukkit.jar?ex=698976fa&is=6988257a&hm=473b452c6372eb114b672968f8e3d6696e07c97c15bca16e10e320d4edab9099&
https://cdn.discordapp.com/attachments/1036292004650418216/1469934817645691045/SayanVanish-1.7.3-build.dev-local-proxy-velocity.jar?ex=698976fa&is=6988257a&hm=805d7c9db9c460610c81cc7258b72b830116599efabab81cc7984a6838440f1c&

[RunqRun]

I shall attempt to reproduce the issue using the version you provided.

[Syrent]

if you got any database errors switch to these versions. and change your sql method to MARIADB instead of MYSQL if you're using mariadb.
https://cdn.discordapp.com/attachments/1036292004650418216/1470457515941560320/SayanVanish-1.7.3-build.dev-local-bukkit.jar?ex=698b5dc7&is=698a0c47&hm=84e081667edd7fa8cea5d5806a648f605771bcd9020615916fa7c048d007396e&
https://cdn.discordapp.com/attachments/1036292004650418216/1470457516457464073/SayanVanish-1.7.3-build.dev-local-proxy-velocity.jar?ex=698b5dc7&is=698a0c47&hm=71ee99635305218175eb533ae33e330b1e245ef29a557e138d543887f1ff314f&

[RunqRun]

I tried to test the new version just now, but it displayed This content is no longer available. and I couldn't download the Jar file.

[Syrent]

sayanvanish-local.zip

[RunqRun]

With that build, there probably aren't any memory leaks!