Multiple plugins explode when a Bedrock players joins my Geyser-enabled server

[22:07:22] [pool-70-thread-1/ERROR]: [LushRewards] An error occurred whilst getting a connection: java.sql.SQLNonTransientConnectionException: Too many connections

This is something you need to talk to your host about // if its a VPS Or self hosted you need to modify max_connections variable to allow more. That or configure this to use less connections as it might be a mysq connection leak

Your other DB's freak out because it eventually runs out of connection threads and they all can't continue functioning.

You could use MYSQL CLI or some sort of IDE and run show processlist to identify which plugin is using an unreasonable amount of connections unless this is a host then it might be their limit is too low or someone is abusing and using them all up

Yeah, this is a MariaDB instance that's self-hosted with default connection settings. I never encountered this issue before I hopped on my Bedrock account to test that most plugins still worked as intended with Geyser/Floodgate. I'm suspecting ONE plugin is acting up in a catastrophic manner, exhausting the connection pool, and then all other plugins explode because of that. Thanks for mentioning show processlist. Should I run this WHILE the server is busy imploding? Or will it show historical connections/processes too?

I somehow suspect it's [FancyWaystones](https://www.spigotmc.org/resources/fancywaystones-waystones-waypoints-warpstones-a-teleporter-location-marker-and-fast-travel.94376/), but I don't even remember if that plugin has a DB connection...all I know is both times I triggered it, it happened either immediately after or shortly after I teleported from one waystone to another on my Bedrock account

run it now and see what it shows then join the server and observe

I'll have to test when I get home from work unfortunately, but I will keep this in mind

Finally got around to checking. This is after a fresh "crash" of the server. No idea what's going on...

I'm guessing that's because this happened awhile ago. It causes SO many issues on the pc hosting the server I lose internet access entirely, so I'm going to have to debug the database with an entirely different PC

What's tf2c_mc used for

that's the db the server uses

btw are you wanting to keep your IP private?

it's a local IP so idc really lol

Ah yeah just read the file now

So from what i seen you got a ton of sleep which is unusual. How many plugins use that db?

pretty much all of them. well, ones that access the db. mcmmo, griefdefender, fancywaystones (the plugin that I think is responsible), TNE, coreprotect, etc

I think sleep is what shows after the command is sent, so I think I need to re-trigger this manually to see what the commands are?

not a db expert

okay, I think something is already funky. The server is just idling and I haven't even tried to re-trigger the issue, and there is a massive amount of connections in show processlist;

ballpark between 80 and 100 connections with 1 player freshly joined

all Sleep

i'll have to look more into this tomorrow ig, barely had any time to investigate

I don't think this is actually related to Geyser/Bedrock as I was able to trigger this on my Java Edition account. No clue what plugin is causing this.

if you want my opinion seperate your DBs per plugin. You're honestly risking your data by doing it like this

I'll probably try that

I'll be working on a db per plugin approach today, this also means that show_processlist will show me which db is being spammed with connections, it's likely one or two problem plugins leaking or unnecessarily creating connections if I had to guess

pray I can figure out wtf is going on, I'm gonna guess that I just kept creeping closer and closer to the max connection limit as I added more db-accessing plugins

okay we've made progress after migrating to a db per plugin

seems many plugins like to keep ~10 idle connections for whatever purposes