Feedback 1075: Error during delete

[omero-qa]

​http://qa.openmicroscopy.org.uk/qa/feedback/1075/

Delete issues:

• can't find image. (haven't reproduced)
• rois not deleted (done)
• screen link not deleted (done)
• See #1482

[omero-qa]

​http://qa.openmicroscopy.org.uk/qa/feedback/1826/

Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on "plate" violates foreign key constraint "fkscreenplatelink_child_plate" on "screenplatelink"
  Detail: Key (id)=(7) is still referenced from table "screenplatelink".
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
        at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)
        ... 62 more

[jmoore]

Ruben's error was:

    serverStackTrace = "ome.conditions.ApiUsageException: Error while deleting image 2750
                        Cannot find image: 2750
                        	at ome.services.delete.DeleteBean.deleteImages(DeleteBean.java:208)
                        	at ome.services.delete.DeleteBean$5.runAsAdmin(DeleteBean.java:309)
                        	at ome.security.basic.BasicSecuritySystem$1.doInHibernate(BasicSecuritySystem.java:504)
                        	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
                        	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
                        	at ome.logic.QueryImpl.execute(QueryImpl.j

[jmoore]

Related? ​http://qa.openmicroscopy.org.uk/qa/feedback/1547/http://qa.openmicroscopy.org.uk/qa/feedback/1547/

[jmoore]

Ruben, I haven't been able to reproduce this issue. A couple of possibilities occur to me:

1. The security settings on the image somehow make them unfindable (unlikely)
2. Some object which the delete bean is assuming mandatory is not present (unlikely)
3. The images are doubly linked and so when they are looked for the second time, they've already been deleted.

Do you have any clues for me? Would it be possible to get a database dump of a plate that acts this way? Thanks!