I got the following error in several of servoy clients often:
com.servoy.j2db.persistence.RepositoryException:java.util.NoSuchElementException: Timeout waiting f…
I have no idea how to fix this.
Please help me to solve this.
Thanks a lot!
Hameed
This indicates that you ran out of connections. Could you check the servoy-admin page in the database server section if there are connections available when the error occurs?
Thanks,
I have to ask everyone at my client’s office to start use the system again to reproduce that error. So it will take some time.
Before that can you please let me know we have run out what type of connection?
Is that db connection or servoy connection? Can you please help make me clear?
Thanks a lot,
Hameed
I mean database connections.
In servoy-admin/dbservers, where you can see all the server connections, you can see something like this:
Server status: Online
Active connections: 0/20
Idle connections: 1/10
Now when you have a situation where this looks like
Server status: Online
Active connections: 20/20
Idle connections: 0/10
then you might be in trouble.
Ok. Is there a way I can increase this?
I am using mysql. I guess I need to make some changes to my.ini
Do you have any clue on this?
Thanks so much.
Hameed
You can increase the number of connections right there in the servoy-admin page. Just enter a higher number in active connections.
Are you using the streamingplugin of IT2BE?
There seems to be something odd in there, not releasing the Database connections…
I have increased “Maximum connections active:” from 10 to 25. I hope that solves the problem.
I am not using it2be streaming plugin.
One other question is my servoy client seems to run slow. I am not sure why.
I am using two instances of mysql. One is for servoy repository and another is for holding my application databases.
Is it advisable to have servoy repository in mysql?
Using sybase will give increased speed?
Please shed some lights. The client is previously using Filemaker which used to run a bit quicker for normal tasks such going to list and list to detail etc. But my servoy solution is lacking speed in these basic things. I am not sure what I am doing wrong. One thing I am doing is showing the foundset count.
For long running tasks and reports servoy & jasper reports proved better.
Basically I need to improve the speed and that is my task now.
If you can shed some lights on this would be great!
Thanks so much!
Hameed
To speed up your clients, try increasing the servoy.maxClientHeap using the web-admin screen. It’s on the main page. Default is 64. Try increasing to 128 or 256.
I ran into trouble with some clients not being able to run my solution when I set it to 256, so I dialed it down. I also had trouble if I put a number (64) in the servoy.initialClientHeap field. When I remove the value from that field, they could login again. Not sure about this behavior.
But when I increased from 64 to 128 on the maxClientHeap, clients really sped up.
Hope this helps.
The heapsize has been set to 256. I remember I have increased it from it’s default 64.
I will try to adjust that setting and see how it performs.
Do you have an idea for using mysql for repository vs using sybase?
Thanks for your input.
Hameed
faheemhameed:
Do you have an idea for using mysql for repository vs using sybase?
There is no problem to use MySQL to host the repository, just make sure you are using an InnoDB database cause the repo needs transactions support. You could also consider to increase the connection timeout in my.ini, if the connection expires Servoy will throw an error in the log and open a new one, not a big deal but it’s nice to have a clean log.
Have a look at my Servoy&MySQL mini HowTo, there are a lot of suggestions, you can download it from my website.
Hi Nicola,
Thanks for your helping reply.
I have gone through your article about the Mysql-Servoy and found it useful.
I assume I will have to play around with my server settings to make some improvements.
Thanks,
Hameed