Connection pool for server _sv_inmem exhausted

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Connection pool for server _sv_inmem exhausted

Postby sbutler » Fri May 20, 2022 7:46 pm

What is the property in the servoy.properties file where I can increase the svy_inmem pool size? 2020.9.0 -releaseNumber 3602. Getting errors like this:

Code: Select all
DB Pool for server _sv_inmemis empty for a while, you need to increase max connection usage (especially when using long transactions)


Code: Select all
Could not create temporary table: Connection pool for server _sv_inmem exhausted


I think its these, because I know I can change the url with server.inMemory.URL, but can I get some official confirmation please?
Code: Select all
server.inMemory.maxConnectionsActive
server.inMemory.maxConnectionsIdle
Scott Butler
iTech Professionals, Inc.
SAN Partner

Servoy Consulting & Development
Servoy University- Training Videos
Servoy Components- Plugins, Beans, and Web Components
Servoy Guy- Tips & Resources
ServoyForge- Open Source Components
User avatar
sbutler
Servoy Expert
 
Posts: 768
Joined: Sun Jan 08, 2006 7:15 am
Location: Cincinnati, OH

Re: Connection pool for server _sv_inmem exhausted

Postby sbutler » Tue Jun 11, 2024 3:46 pm

Been a while. Any update on this?
Scott Butler
iTech Professionals, Inc.
SAN Partner

Servoy Consulting & Development
Servoy University- Training Videos
Servoy Components- Plugins, Beans, and Web Components
Servoy Guy- Tips & Resources
ServoyForge- Open Source Components
User avatar
sbutler
Servoy Expert
 
Posts: 768
Joined: Sun Jan 08, 2006 7:15 am
Location: Cincinnati, OH

Re: Connection pool for server _sv_inmem exhausted

Postby jcompagner » Tue Jun 11, 2024 4:07 pm

no that doesn't work i think, we have a hard coded value of: .setMaxActive(200)

is that not enough? you need even more then 200 active connections?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8865
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Connection pool for server _sv_inmem exhausted

Postby sbutler » Tue Jun 11, 2024 5:25 pm

Are you sure? I don't see that anywhere in github, so its in private code I guess? https://github.com/search?q=repo%3AServ ... &type=code

Was it possibly different in 2020.9.0 -releaseNumber 3602 ? Or maybe lower value than 200? The server usually has 150-250 concurrent users.

This seems to make a difference and get those errors to go away.
Code: Select all
server.inMemory.maxConnectionsActive=100
server.inMemory.maxConnectionsIdle=25


Is there any other way for me to change the maxConnectionsActive and maxConnectionsIdle in a Java way to get around these errors?

Code: Select all
DB Pool for server _sv_inmemis empty for a while, you need to increase max connection usage (especially when using long transactions)
...
Could not create temporary table: Connection pool for server _sv_inmem exhausted
Scott Butler
iTech Professionals, Inc.
SAN Partner

Servoy Consulting & Development
Servoy University- Training Videos
Servoy Components- Plugins, Beans, and Web Components
Servoy Guy- Tips & Resources
ServoyForge- Open Source Components
User avatar
sbutler
Servoy Expert
 
Posts: 768
Joined: Sun Jan 08, 2006 7:15 am
Location: Cincinnati, OH

Re: Connection pool for server _sv_inmem exhausted

Postby jcompagner » Tue Jun 11, 2024 5:42 pm

i don't see where those are used the only once that i can find are these 5:

inmem.png
inmem.png (26.05 KiB) Viewed 1478 times


i also did go back in history but no changes for that.

and as i set the default is even 200... not what you set as 100..

for me if you are really hitting the 200 then it could be that you just hit a problem (memory leak)

and if i look back a while (around 2021) i think it was even back then -1..

but you can't really change this, its more that you really need to know why..
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8865
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 2 guests