PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: /var and /OMERO are full, how can I free up space without removing data?
Topic Summary: removing/truncating log files
Created On: 12/23/2015 5:05 AM
Status Post and Reply
Linear : Threading : Single : Branch
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
 12/23/2015 5:05 AM
User is offline View Users Profile Print this message


Posts: 76
Joined: 5/16/2014

1) The Acapella disk cache resides in the following location:


Its fine to delete the contents if there are no running jobs on the server, switch to the Columbus job status page to check. In theory the max you would ever recover is 4GB as Acapella monitors the size of the folder to ensure it is kept below that level.

To remove:

$ sudo /etc/init.d/columbus stop

$ sudo rm -rf /var/lib/acapella/.imacro/diskcache/*

$ sudo /etc/init.d/columbus start


2) OMERO stores it's own database logs but they aren't used by Columbus. The logs which is likely to take up most of the space and which definitely aren't utilized by Columbus are found under the 'pg_log', this can be safely removed. It can be found in the following location:


Removing unused database logs:

$ sudo /etc/init.d/columbus stop

$ sudo rm -rf /var/lib/pgsql/data/pg_log/*

$ sudo /etc/init.d/columbus start


3) For any large database it's possible to reduce the database size by truncating the eventlog table, which is a fairly large table and contains information that Columbus does not use in any way.

##NOTE## Only perform these steps once you have confirmed that you have a recent database dump stored in /OMERO/OMERO4_4/db_backup. This backup can be used to recover the eventlog table to the database in the event of an error.

The command line workflow would be as follows

$ sudo su columbus

$ psql omero4_4

truncate eventlog;


In case of an error, its possible to restore the original table from a complete dump like this:

$ pg_restore -v -c -t eventlog -d omero4_4 omero4_4-dateofmostrecentdump.pg_dbdump

Edited: 12/23/2015 at 7:43 AM by RAH

FuseTalk Basic Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.