[ome-devel] OMERO 5 deletion performance

[Yanling Liu]

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?

Thanks again,


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.....
>
> tail var/log/OMEROweb.log
> 2014-06-02 16:04:47,481  INFO [                           omero.gateway]
> (proc.20169) connect:1705 created connection
> (uuid=a040dd26-7e10-4ce4-bb18-5f8497f4d7b7)
> 2014-06-02 16:04:52,623  INFO [                           omero.gateway]
> (proc.20169) connect:1705 created connection
> (uuid=a040dd26-7e10-4ce4-bb18-5f8497f4d7b7)
> 2014-06-02 16:04:57,237  INFO [                           omero.gateway]
> (proc.20168) connect:1705 created connection
> (uuid=a040dd26-7e10-4ce4-bb18-5f8497f4d7b7)
> 2014-06-02 16:05:02,236  INFO [                           omero.gateway]
> (proc.20167) connect:1705 created connection
> (uuid=a040dd26-7e10-4ce4-bb18-5f8497f4d7b7)
> 2014-06-02 16:05:07,264  INFO [                           omero.gateway]
> (proc.20167) connect:1705 created connection
> (uuid=a040dd26-7e10-4ce4-bb18-5f8497f4d7b7)
> 2014-06-02 16:05:12,239  INFO [                           omero.gateway]
> (proc.20166) connect:1705 created connection
> (uuid=a040dd26-7e10-4ce4-bb18-5f8497f4d7b7)
> 2014-06-02 16:05:17,242  INFO [                           omero.gateway]
> (proc.20166) connect:1705 created connection
> (uuid=a040dd26-7e10-4ce4-bb18-5f8497f4d7b7)
> 2014-06-02 16:05:22,321  INFO [                           omero.gateway]
> (proc.20169) connect:1705 created connection
> (uuid=a040dd26-7e10-4ce4-bb18-5f8497f4d7b7)
> 2014-06-02 16:05:27,351  INFO [                           omero.gateway]
> (proc.20166) connect:1705 created connection
> (uuid=a040dd26-7e10-4ce4-bb18-5f8497f4d7b7)
> 2014-06-02 16:05:32,419  INFO [                           omero.gateway]
> (proc.20165) connect:1705 created connection
> (uuid=a040dd26-7e10-4ce4-bb18-5f8497f4d7b7)
>
>
>
> On Mon, Jun 2, 2014 at 10:02 AM, Yanling Liu <vrnova at gmail.com> wrote:
>
>> Hi,
>>
>> 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.
>>
>> Thanks,
>> Yanling
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-devel/attachments/20140602/826f10d8/attachment.html>