[ome-users] excessive time to upgrade database

[Olivier Miquel]

Hello,

Dont'know if the size is ok or not i could just say that i observed  the 
same behaviour when we had upgraded to 5.1.
Our database size is now about 36 G, and it tooks 5 or 6 hours to 
complete the upgrade.

Is there somewhere a script to check and clean the database?
Our omero.server  is in production for about five years now and perhaps 
we now need to clean some unused stuff in the database?

Thanks,

O.


On 06/03/2016 23:30, Carnë Draug wrote:
> Hello
>
> I have been upgrading our omero installations this weekend and found
> that the step to upgrade the database takes an excessive amount of
> time.  It took more than 9 hours and caused a temporary >3x increase on
> the database size (from 30GB to 100GB but at the end it was down to 64GB).
>
> To be more exact, this is during the 5.0 to 5.1 upgrade, using the
> "sql/psql/OMERO5.1__1/OMERO5.0__0.sql" database upgrade script.
>
> I did notice that more than 8 hours were spent on a single step (I can't
> tell which from the output of the upgrade but it was something that updated
> 50183812 rows).
>
> I'm asking because the documentation states that this should execute quickly.
>  From the upgrade instructions [1]:
>
>      The 5.1 upgrade script should execute in a short time.
>
> Could there be something wrong with our database?  Or is ours just abnormally
> large?
>
> Thank you
> Carnë
>
> [1] http://www.openmicroscopy.org/site/support/omero5.1/sysadmins/server-upgrade.html#run-the-upgrade-script
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users


-- 
Olivier Miquel
Administrateur Système et Réseau
Plate-forme technologique MRI
Tel : 06.50.19.27.43
Mail:olivier.miquel at mri.cnrs.fr