Episode status switches from Finished to Recording after running WorkflowCleanupScanner
Steps to reproduce
Steps to reproduce:
1. Set enabled to true in https://bitbucket.org/opencast-community/matterhorn/src/445645a2d58be8bd25ec44ba7ab6f9342118aee2/etc/org.opencastproject.workflow.impl.WorkflowCleanupScanner.cfg?at=r%2F2.2.x&fileviewer=file-view-default
2. Wait for the job to run
3. Inspect the results in the admin interface. We had about 440 jobs with status finished, after the run, there were only about 320 showing as finished; the remaining finished ones show up as recording
Finished jobs showing up as recording in admin interface
Finished jobs remain finished
Workaround (if any):
Is there a possibility to manually reset the status using an SQL query?
Possibly the issue here is that the event status is not a true status field, i.e. it does not map to a field value in persistent storage, but is derived from different sources of information. So if an event no longer has workflows associated with it that have finished, then I imagine the status calculation would be wrong.
Maybe rebuilding the elastic search index as mentioned on https://groups.google.com/a/opencast.org/d/msg/users/vN5fD-J_0dU/jvt1McDRDAAJ would help:
To rebuild it, go to:
on your Opencast server, click on Testing form and then click on Submit.