maximum releases in an application server

[jos@devoon.nl]

Has anyone any experience with the number of releases one can have in an application server?
We just hit nummer 100 of our main solution but the whole thing slowed down enormously and things got very buggy. Finally it did not finish starting up so I wasn't able to get to the Admin pages. Upgrading de repository did not work, or it took infinitly. I stopped the proces.
I just deleted the whole repository database and created a new one. After upgrading the new one I could import the solutions again end restart the server as usual.

[mboegem]

Hi Jos,

the number of releases will depend on the size of the solution.
Which - in your case - is quite big.

There's an option to consolidate the repository without the need to create a new one.
You can find the options on the solution page.

[jos@devoon.nl]

Hi Marc,

Thanks.

You're right about the size of the solution (how did you guess ). So there is a limit. Is it the disk vs. database size or something else in Servoy (If it is not the number of releases)?. It might be convenient to check on this before (auto) updating a solution.

Please can you be more specific on the option on 'the solutionspage'. It is not entirely clear to me. I suppose you mean the solutions page in the Servoy Admin?

[Harjo]

Indeed, how more versions you keep of a solution, how longer it will take the update, until a point that it is unworkable...
The exact size is difficult to say... but we cleanup the repository, after 100 updates...

[jos@devoon.nl]

Aha! Thanks Harjo.

This might explain the problems at exactly 100 releases?

Can anyone think of somthing to check on this before (auto) updating solutions? Can the number of releases be retrieved from the database? Is it possible to delete the first batch (say the first 10 or 20) releases?

I guess a truncate all tables on the repository database in a pre-import-hook-module will stop the whole script... But basicly this is what I have done manually this time to make things work again.

[Harjo]

100 is for us just a rule of thumb! I have seen other solution working nicely after 400 updates!

you can see the number of releases, under de solution-node in the servoy-admin page.
there you can also, hit the Compact button, that will throw away every release, except the last one
(you can only do this, when no clients are logged-in!)

You could also hit the button: delete all releases, but that could take VERY long! (hours!) restart, and do a fresh import afterwards
in the latest version of Servoy 7.4, there will be an update/fix for this...

[david]

We never make it to 100 releases before the repository gets bugged and we have to reset it. Before 6.1 the repository was never an issue. Now if we have an unexplained client bug it's almost the first thing we do.

[mboegem]

You're right about the size of the solution (how did you guess )

I've got my sources...

Indeed I was pointing to the solutions page in the Servoy Admin.
For each solution you have a compact button which will consolidate all the delta imports done by Servoy into 1 release.