Uploaded image for project: 'Opencast'
  1. MH-9636

Referential integrity does not allow to delete certain db records

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed and reviewed
    • Affects versions: 1.4.0
    • Fix versions: 1.4.0
    • Components: Backend Software
    • Labels:
      None
    • Severity:
      Data Loss/Corruption
    • Steps to reproduce:
      Hide
      Steps to reproduce:

      1. Have Matterhorn up and running for a couple of days (workflows)
      2. Try to clear the tables (e. g. using a "trunkate" feature) in order to start over
       
      Actual Results:
       
      The data can't be removed because there are references (foreign key constraints) all over the place but no delete cascades.

      Expected Results:
       
      Referenced data is deleted as a result of deleting data in the first place.
      Show
      Steps to reproduce: 1. Have Matterhorn up and running for a couple of days (workflows) 2. Try to clear the tables (e. g. using a "trunkate" feature) in order to start over   Actual Results:   The data can't be removed because there are references (foreign key constraints) all over the place but no delete cascades. Expected Results:   Referenced data is deleted as a result of deleting data in the first place.
    • Tags (folksonomy):

      TestRail: Results

        Attachments

          Activity

            People

            • Assignee:
              twunden Tobias Wunden
              Reporter:
              twunden Tobias Wunden
            • Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                TestRail: Cases