Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.
Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Bug #1654 (closed)

Opened 12 years ago

Closed 12 years ago

Feedback 1075: Error during delete

Reported by: omero-qa Owned by: jamoore
Priority: critical Cc: ruben.munoz@…, jburel
Sprint: n.a.
Total Remaining Time: n.a.

Description (last modified by jmoore)

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

Attachments (1)

ticket1654.log (7.7 KB) - added by jmoore 12 years ago.
Edited log file showing that a second delete occurs before the first completes.

Download all attachments as: .zip

Change History (12)

comment:1 Changed 12 years ago by jmoore

  • Milestone changed from Unscheduled to OMERO-Beta4.1.1

comment:2 Changed 12 years ago by 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

comment:3 Changed 12 years ago by 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

comment:5 Changed 12 years ago by jmoore

  • Description modified (diff)

comment:6 Changed 12 years ago by jmoore

  • Cc jburel added
  • Description modified (diff)

comment:7 Changed 12 years ago by jmoore

  • Description modified (diff)

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!

comment:8 Changed 12 years ago by jmoore

r5827 (trunk) and r5828 (b_4_1) contain fixes for roi and screen links on deletePlate.

comment:9 Changed 12 years ago by omero-qa

http://qa.openmicroscopy.org.uk/qa/feedback/2102/

Rather than "No row with given identifier: Image" this is a "no row" for PlaneInfo?.

comment:10 Changed 12 years ago by jmoore

Pieces of the PlaneInfo puzzle:

omero3=> select l.id, e.time, l.entitytype, entityid, action from eventlog l, event e where e.id = l.event and e.experimenter = 3159 and entitytype like '%PlaneInfo' and entityid = 170892593 order by l.id desc limit 100;
    id     |          time           |        entitytype        | entityid  | action 
-----------+-------------------------+--------------------------+-----------+--------
 263623221 | 2009-11-24 17:19:00.942 | ome.model.core.PlaneInfo | 170892593 | DELETE
 263581670 | 2009-11-18 17:27:29.463 | ome.model.core.PlaneInfo | 170892593 | INSERT
(2 rows)

Changed 12 years ago by jmoore

Edited log file showing that a second delete occurs before the first completes.

comment:11 Changed 12 years ago by jmoore

  • Resolution set to fixed
  • Status changed from new to closed

Closing this ticket. These issues seem mostly fixed or understood. #1706 has been opened to improve the exception strategy when a user continually tries to delete the same object.

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.64984 sec.)

We're Hiring!