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

Prematurely deleted scheduler properties lead to undeletable events

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed and reviewed
    • Affects versions: 4.0
    • Fix versions: 4.0
    • Labels:
      None
    • Severity:
      Data Loss/Corruption
    • Steps to reproduce:
      Hide
      Steps to reproduce:
      1. Create a scheduled event.
      2. Delete the scheduler snapshot's properties for the event, using something like "DELETE FROM mh_assets_properties WHERE namespace = 'org.opencastproject.scheduler' AND mediapackage_id = 'foo-bar-baz-qux';
      3. Try to delete the event.
       
       Actual Results:
       
      The UI implies successful deletion. However, the event remains in the event list, ready to be deleted again.
       
       Expected Results:
       
       The event should be deleted.

       Workaround (if any):
       
      There's no real workaround, though you could delete the event from the database manually.

      Note that, as of now, we weren't able to consistently reproduce the problem, aside from manually altering the database. However, we _do_ have production cases where events are not deletable because of missing properties.
      Show
      Steps to reproduce: 1. Create a scheduled event. 2. Delete the scheduler snapshot's properties for the event, using something like "DELETE FROM mh_assets_properties WHERE namespace = 'org.opencastproject.scheduler' AND mediapackage_id = 'foo-bar-baz-qux'; 3. Try to delete the event.    Actual Results:   The UI implies successful deletion. However, the event remains in the event list, ready to be deleted again.    Expected Results:    The event should be deleted.  Workaround (if any):   There's no real workaround, though you could delete the event from the database manually. Note that, as of now, we weren't able to consistently reproduce the problem, aside from manually altering the database. However, we _do_ have production cases where events are not deletable because of missing properties.

      TestRail: Results

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              middendorf Philipp Middendorf
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                TestRail: Cases