[Krydos] Database max connections

[victord]

Hello!  
I want to know if it's possible to increase the number of maxConnections to the DB in my account to 2.

Usually, when developing, my backend is connected to the DB, and I'm not able to connect from the DB manager.

 

Thanks for your help with this

[wolstech]

Users have a concurrent connection limit of 10 for mariadb, so this would be a reduction.

[KazVee]

You're on the Tommy server, and that has a limit of 10 database connections at a time. When you say you're not able to connect from the DB manager, could you give a little more info please about what is happening when you try? Do you get an error message or does it just hang? As well, please let us know what type of database (MariaDB/MySQL or PostgreSQL) you're using. 

You might also get more details on the issue from your error logs inside Plesk. Here's a page explaining how to check the logs: https://wiki.helionet.org/View_Error_Logs
If you see any db-related errors, please post them here. It'll help us try to help you resolve the issue. 🙂

[victord]

Hello!  
Thank you for your answers.  

So, basically, if I run my app locally with IntelliJ and then try to connect to the DB with DBeaver, it shows the message:

"User victord1_weddingwise already has more than 'max_user_connections' active connections."  

It is a MariaDB instance.  

[wolstech]

Are you sure the app isn't opening multiple connections at once? Some apps are designed to open multiple connections, and these will fail if they cause the limit to exceed 10. If there is a way to limit the number of connections your app opens in your code, I would suggest setting the limit to 1 and seeing if the issue persists.

Krydos may have more information about this.

[Krydos]

It might be the app itself too. If the app opens all 10 connections and then DBeaver tries to open 1 more you would get that error too. By default most software assumes you have a 8 GB VPS and can have 100 database connections open at once.