victord Posted May 4 Posted May 4 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 Posted May 4 Posted May 4 Users have a concurrent connection limit of 10 for mariadb, so this would be a reduction. 1
KazVee Posted May 4 Posted May 4 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. π 1
victord Posted May 5 Author Posted May 5 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 Posted May 5 Posted May 5 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 Posted May 6 Posted May 6 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. 1
victord Posted May 7 Author Posted May 7 Oh! After checking, you're totally right! It seems that the default configuration makes the app use 10 connections. After overriding the default configuration to a lower number, everything started working. Β Thanks for your help, guys! 1
Recommended Posts