active connections -47/30

Classic Servoy
1

Hi all, I have been told by my client that they are getting “could not retrieve more form data” errors. I have logged into the Servoy server admin page and see that there are -47 out of 30 active connections (and 7/20 idle connections). Any thoughts on what could be wrong?

Thhanks

Bevil

2

if you dont have many many clients using connections at the same time, so at that time you look.

Then it can be 2 things, or you use long transactions in your code and per client you have a connections for a long time in use.
Or you use plugins that dont release connections the right way.

3

Bevel,
you are using the streaming plugin of IT2BE right?
I can remember there were some issue with that, not releasing db connections,
are you using the latest version?

4

Bevil,

What version of Servoy are you using?
A connection leak issue was fixed in Servoy 4.1.5.

Rob

5

Hi again

Rob, I am using Servoy 4.1.7.

I have also updated my streaming plugin, and confirmed with Marcel that this is not causing the problem per your suggestion Harjo. Yet the problem remains. I have to restart Servoy Server every few days, and if I don’t, they seem to have an increase in ‘error in relation’ errors.

Is there anything that I may have done in coding that causes it to not release database connections or is it purely a Servoy application thing?

Thanks

Bevil

6

that you can get a minus number there is already very weird…
and if you would get that then you would never run out of connections because you will never grow beyond your max value.
if you can reproduce it somehow when you are not using any outside plugins then let us know that, or else it has to be some 3th party plugin
what kind of db are you using?

7

Hi Johan

The database is Sybase 10.

I have just had to restart the servoy server again now to resolve this (they become unable to print, they cannot choose dropdown menus, they have error messages etc.) As soon as I restart Servoy server, the problem is resolved for a few days.

The only plugins that I am using are the datastream and tools plugins from it2be.

Thanks

Bevil

8

the only thing i can say is that it has to be the datastream plugin or something
there must be something that is eating connections from the pool.

9

As an update, I have disabled and replaced the streaming plugin, and have had no issues since. You were right Johan…

Thanks for all your help. :)

Happy New Year

Bevil