[ome-devel] OMERO 5 deletion performance

[Josh Moore]

Hi Yanling,

>> On Mon, Jun 2, 2014 at 10:02 AM, Yanling Liu <vrnova at gmail.com> wrote:
>> 
>>> I have OMERO 5 installed on Ubuntu 12.04 64bit 8GB Mem, 4 Cores @ 3.47GHz
>>> and NFS mounted storage for OMERO data storage.
>>> 
>>> When deleting couple hundred images (each at 1k x 1k pixels) through
>>> OMERO web, it took long time (> 10 minutes) to finish. In general project
>>> and dataset deletion are very slow in OMERO web. I wonder if there's any
>>> hint to tune the performance of OMERO.
>>> 
>>> I have increased JVM memory usage based on OMERO documentation.

Though there are further tunings you can try, Deletion performance is quite poor at the moment, but it's something we're actively working on.


> On Mon, Jun 2, 2014 at 11:09 AM, Yanling Liu <vrnova at gmail.com> wrote:
> 
>> By looking OMEROweb.log, deleting single file takes 5 good seconds. Is
>> this normal and expected? How could I find out if this because OMERO
>> itself, or postgres, or NFS storage access speed?
>> 
>> Thanks ahead.....

Could you send us the var/log/Blitz-0.log file for the time of the deletion?



On Jun 2, 2014, at 5:12 PM, Yanling Liu wrote:

> Also I am getting this error:
> 
> 2014-06-02 16:07:37,242 ERROR [      omeroweb.webclient.webclient_utils]
> (proc.20168) _formatReport:38 Format report: {'warning': '', 'error':
> 'Failure during DeleteHandle.steps
> :org.hibernate.exception.GenericJDBCException: could not insert/select ids
> for bulk delete'}
> 
> Anything wrong with postgres? Or is it because I selected too many files
> for bulk deletion?

Possibly. Again, the log file would be the most helpful. There may be an issue with your PG installation.

Cheers,
~Josh.