Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cannot delete Entitites associated with multiple Datastreams #15

Open
SpeckiJ opened this issue Jun 28, 2019 · 1 comment
Open

Cannot delete Entitites associated with multiple Datastreams #15

SpeckiJ opened this issue Jun 28, 2019 · 1 comment
Labels
bug Something isn't working v1 affects v1 (olingo-version) of the STA v2 affects v2 (no-olingo version) of the STA

Comments

@SpeckiJ
Copy link
Member

SpeckiJ commented Jun 28, 2019 •
edited
Loading

If a Thing is linked to multiple Datastreams, or two Datastreams reference the same Dataset, deleting it fails due to ConstraintViolationExceptions.

o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: update or delete on table "dataset" violates foreign key constraint "fk_dataset_datastream" on table "datastream_dataset"

This is caused by the cascading delete failing to delete the underlying dataset as it is still linked to other entities.
@SpeckiJ SpeckiJ added the bug Something isn't working label Jun 28, 2019
@SpeckiJ SpeckiJ changed the title Cannot delete Thing with multiple Datastreams Cannot delete Thing associated with multiple Datastreams Jun 28, 2019
@SpeckiJ SpeckiJ changed the title Cannot delete Thing associated with multiple Datastreams Cannot delete Entitites associated with multiple Datastreams Jun 28, 2019
@SpeckiJ SpeckiJ added v1 affects v1 (olingo-version) of the STA v2 affects v2 (no-olingo version) of the STA labels Feb 12, 2020
@SpeckiJ
Copy link
Member Author

SpeckiJ commented Aug 26, 2020

This will be no problem for v2 after db-model is updated to version 4.x as the relation is completely refactored there

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working v1 affects v1 (olingo-version) of the STA v2 affects v2 (no-olingo version) of the STA
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@SpeckiJ