Skip to content

fix DatabaseConstraint exceptions upon DB Cleanup and pathological Biomodel saves. #840

@jcschaff

Description

@jcschaff

Background - two problems - one on save, one on delete/cleanup

  • ~260 times a day, the health monitor saves the exact same BioModel (same XML) with cleared biomodel key.
  • incomplete periodic cleanup of orphaned records (once a day).
    • cbit.vcell.modeldb.DatabaseServerImpl.cleanupDatabase(DatabaseServerImpl.java:133) fails with a complementary failure (java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (VCELL.SYS_C0022037) violated - child record found)
    • the order of the delete operations should have prevented such a failure.

Metadata

Metadata

Assignees

Type

No type

Projects

Status

Queued

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions