Connection pool for server _sv_inmem exhausted

[sbutler]

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

[sbutler]

Been a while. Any update on this?

[jcompagner]

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?

[sbutler]

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

[jcompagner]

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

inmem.png (26.05 KiB) Viewed 345 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..