Opened 10 years ago

Closed 10 years ago

#1800 closed defect (fixed)

Missing check for associated items when deleting jobs

Reported by: Nicklas Nordborg Owned by: everyone
Priority: minor Milestone: BASE 3.3
Component: core Version:
Keywords: Cc:


It seems like there is a missing check for "used items" when deleting jobs that are associated with a derived bioassay. The jobs are listed as not having any dependency but when trying to delete them a stacktrace appears:

ERROR: update or delete on table "Jobs" violates foreign key constraint "fkb7e746c5b92076ba" on table "DerivedBioAssays"
Detail: Key (id)=(472075) is still referenced from table "DerivedBioAssays".

DatabaseException HibernateUtil.commit( DbControl.commit( Trashcan.delete( org.apache.jsp.views.trashcan.index_jsp._jspService( org.apache.jasper.runtime.HttpJspBase.service( javax.servlet.http.HttpServlet.service( org.apache.jasper.servlet.JspServletWrapper.service( org.apache.jasper.servlet.JspServlet.serviceJspFile(

Change History (1)

comment:1 by Nicklas Nordborg, 10 years ago

Resolution: fixed
Status: newclosed

(In [6442]) Fixes #1800: Missing check for associated items when deleting jobs

Note: See TracTickets for help on using tickets.