<div dir="ltr"><div><div>Hello, I'd like to have some suggestion on configuring OMERO 5.0.2 + postgres 9.1 on Ubuntu 12.04 for file deletion.<br><br></div>Basically when I tried to delete a set of 910 images in OMERO 5, I am getting follow error in Blitz-0.log file:<br>
<br>2014-06-03 08:43:19,924 WARN  [ o.h.h.ast.exec.<div>MultiTableDeleteExecutor]
 (2-thread-3) unable to drop temporary id table after use [ERROR: 
current transaction is aborted, commands ignored until end of 
transaction block]<br>
2014-06-03 08:43:19,927 ERROR [            ome.services.delete.Deletion] (2-thread-3) Failure during DeleteHandle.steps :<div class="im"><br>org.hibernate.exception.GenericJDBCException: could not insert/select ids for bulk delete<br>
</div>    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) ~[hibernate-core.jar:na]<br>
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) ~[hibernate-core.jar:na]<br>    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core.jar:na]<br>

    at org.hibernate.hql.ast.exec.MultiTableDeleteExecutor.execute(MultiTableDeleteExecutor.java:125) ~[hibernate-core.jar:na]<br>    at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:421) ~[hibernate-core.jar:na]<br>

    at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283) ~[hibernate-core.jar:na]<br>    at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1280) ~[hibernate-core.jar:na]<br>

    at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117) ~[hibernate-core.jar:na]<br>    at ome.services.delete.DeleteStep.action(DeleteStep.java:97) ~[server.jar:na]<br>    at ome.services.graphs.GraphState.perform(GraphState.java:410) ~[server.jar:na]<br>

    at ome.services.graphs.GraphState.execute(GraphState.java:334) ~[server.jar:na]<br>    at ome.services.delete.Deletion.execute(Deletion.java:304) ~[server.jar:na]<br>    at omero.cmd.graphs.DeleteI.step(DeleteI.java:120) ~[blitz.jar:na]<br>

    at omero.cmd.basic.DoAllI$X.step(DoAllI.java:107) ~[blitz.jar:na]<br>    at omero.cmd.basic.DoAllI.step(DoAllI.java:319) ~[blitz.jar:na]<br>    at omero.cmd.HandleI.steps(HandleI.java:435) ~[blitz.jar:na]<br>    at omero.cmd.HandleI$1.doWork(HandleI.java:365) ~[blitz.jar:na]<br>

    at omero.cmd.HandleI$1.doWork(HandleI.java:361) ~[blitz.jar:na]<br>    at sun.reflect.GeneratedMethodAccessor272.invoke(Unknown Source) ~[na:na]<br>    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_30]<br>

    at java.lang.reflect.Method.invoke(Method.java:622) ~[na:1.6.0_30]<br>    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) ~[org.springframework.aop.jar:3.0.1.RELEASE-A]<br>

    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) ~[org.springframework.aop.jar:3.0.1.RELEASE-A]<br>    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) ~[org.springframework.aop.jar:3.0.1.RELEASE-A]<br>

    at ome.services.util.Executor$Impl$Interceptor.invoke(Executor.java:576) ~[server.jar:na]<br>    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[org.springframework.aop.jar:3.0.1.RELEASE-A]<br>

    at ome.security.basic.EventHandler.invoke(EventHandler.java:154) ~[server.jar:na]<br>    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[org.springframework.aop.jar:3.0.1.RELEASE-A]<br>

    at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) ~[org.springframework.orm.jar:3.0.1.RELEASE-A]<br>    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[org.springframework.aop.jar:3.0.1.RELEASE-A]<br>

    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108) ~[org.springframework.transaction.jar:3.0.1.RELEASE-A]<br>    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[org.springframework.aop.jar:3.0.1.RELEASE-A]<br>

    at ome.tools.hibernate.ProxyCleanupFilter$Interceptor.invoke(ProxyCleanupFilter.java:241) ~[server.jar:na]<br>    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[org.springframework.aop.jar:3.0.1.RELEASE-A]<br>

    at ome.services.util.ServiceHandler.invoke(ServiceHandler.java:116) ~[server.jar:na]<br>    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[org.springframework.aop.jar:3.0.1.RELEASE-A]<br>

    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) ~[org.springframework.aop.jar:3.0.1.RELEASE-A]<br>    at com.sun.proxy.$Proxy66.doWork(Unknown Source) ~[na:na]<br>    at ome.services.util.Executor$Impl.execute(Executor.java:457) ~[server.jar:na]<br>

    at omero.cmd.HandleI.run(HandleI.java:359) ~[blitz.jar:na]<br>    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) ~[na:1.6.0_30]<br>    at ome.services.util.Executor$Impl$1.call(Executor.java:498) ~[server.jar:na]<br>

    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) ~[na:1.6.0_30]<br>    at java.util.concurrent.FutureTask.run(FutureTask.java:166) ~[na:1.6.0_30]<br>    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) ~[na:1.6.0_30]<br>

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) ~[na:1.6.0_30]<br>    at java.lang.Thread.run(Thread.java:701) ~[na:1.6.0_30]<br>Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) ~[postgresql.jar:na]<br>    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[postgresql.jar:na]<br>

    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql.jar:na]<br>    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) ~[postgresql.jar:na]<br>

    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[postgresql.jar:na]<br>    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) ~[postgresql.jar:na]<br>

    at sun.reflect.GeneratedMethodAccessor256.invoke(Unknown Source) ~[na:na]<br>    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_30]<br>    at java.lang.reflect.Method.invoke(Method.java:622) ~[na:1.6.0_30]<br>

    at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64) ~[btm.jar:2.1.3]<br>    at com.sun.proxy.$Proxy9.executeUpdate(Unknown Source) ~[na:na]<br>    at org.hibernate.hql.ast.exec.MultiTableDeleteExecutor.execute(MultiTableDeleteExecutor.java:116) ~[hibernate-core.jar:na]<br>

    ... 43 common frames omitted<br><br></div><div>Plus there's error message in postgres log file:<br><br>2014-06-03 08:43:19 EDT WARNING:  out of shared memory<br>
2014-06-03 08:43:19 EDT ERROR:  out of shared memory<br>2014-06-03 08:43:19 EDT HINT:  You might need to increase max_locks_per_transaction.<br>2014-06-03 08:43:19 EDT STATEMENT:  create temporary table HT_job (id int8 not null) on commit drop<br>

2014-06-03 08:43:19 EDT ERROR:  current transaction is aborted, commands ignored until end of transaction block<br>2014-06-03 08:43:19 EDT STATEMENT:  insert into HT_job select job0_.id as id from job job0_ where <br>    ( <br>

      1 = $1 OR <br>      1 = $2 OR <br>      (group_id in ($3)) OR <br>      (owner_id = $4 AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __<a href="http://g.id" target="_blank">g.id</a> = group_id)) OR <br>

      (group_id in ($5,$6) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __<a href="http://g.id" target="_blank">g.id</a> = group_id)) OR <br>      ((select (__g.permissions & 4) = 4 from experimentergroup __g where __<a href="http://g.id" target="_blank">g.id</a> = group_id)) <br>

    ) and id=$7 and owner_id=$8<br>2014-06-03 08:43:19 EDT ERROR:  current transaction is aborted, commands ignored until end of transaction block<br>2014-06-03 08:43:19 EDT STATEMENT:  drop table HT_job<br><br><br></div>
The reason I am deleting file in OMERO is after import failure I  need to remove whatever existing in OMERO before doing import again.<br><br>Any comments? Anyone had similar issue before?<br><br></div>Thanks,<br>Yanling<br>
</div>