search

GMOD / Apollo

Genome annotation editor with a Java Server backend and a Javascript client that runs in a web browser as a JBrowse plugin.
http://genomearchitect.readthedocs.io/
Other
128 stars 85 forks source link

Cannot delete user annotation #2497

Open KonoganB opened 4 years ago

KonoganB commented 4 years ago

I am currently running Apollo with run-local for development purposes. I sometimes need to delete user annotations using the interface, but I obtain this error:

Hibernate operation: could not execute statement; SQL [n/a]; Referential integrity constraint violation: "FK_8JM56COVT0M7M0M191BC5JSEH: PUBLIC.FEATURE_RELATIONSHIP FOREIGN KEY(CHILD_FEATURE_ID) REFERENCES PUBLIC.FEATURE(ID) (1202)"; SQL statement: delete from feature where id=? and version=? [23503-176]; nested exception is org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_8JM56COVT0M7M0M191BC5JSEH: PUBLIC.FEATURE_RELATIONSHIP FOREIGN KEY(CHILD_FEATURE_ID) REFERENCES PUBLIC.FEATURE(ID) (1202)"; SQL statement: delete from feature where id=? and version=? [23503-176]

It doesn't happen every time though. apolloerrorscreenshot

nathandunn commented 4 years ago

I hate that this error. We are moving to another backend to help deal with this and other issues, but for now there is not much to do other than live with it.

Sometimes doing this from the Annotator Panel might help.

If you have a specific annotation you can't delete, please let me know.