Update 11.9 to 12.4 : Issues

47 views
Skip to first unread message

Lylian

unread,
Nov 2, 2022, 6:25:14 AM11/2/22
to Opencast Users
Hello,

I have some problems with updating my opencast from 11.9 to 12.4.

ERROR 1 : Internal Exception: java.sql.SQLSyntaxErrorException: (conn=26) Unknown column 'delete_me' in 'field list'

Everytime admin interface is refresh, this error is written in log. How do i fix it ?

ERROR 2 : I am unable to delete event.

When i try to delete an event with retract or delete workflow i've got this error in opencast.log :

2022-11-02T11:23:49,182 | ERROR | (IndexServiceImpl:1509) - Unable to remove the event 'ecca0665-074f-41b5-a2cf-54e3534bc539' because removing workflow failed:
org.opencastproject.workflow.api.WorkflowDatabaseException: Could not delete workflow with ID '320828'

Does someone already fixed this ?

Best regards,

Lylian.

Lylian

unread,
Nov 2, 2022, 9:18:06 AM11/2/22
to Opencast Users, Lylian
I fixed the second problem by changing the configuration "delete-external" to false in retract workflow.

But now i have a new error for some media (not all) that i cannot delete and show that error :
2022-11-02T13:52:39,743 | ERROR | (AbstractFileSystemAssetStore:85) - Error while linking/copying file /stockage_opencast/opencast/workspace/collection/archive/manifest_0bbc75da-9d28-414d-8d39-1331acc72a4f_8-a589f28e-0949-4502-abcf-aba1f73fba0e.xml to /stockage_opencast/opencast/archive/mh_default_org/0bbc75da-9d28-414d-8d39-1331acc72a4f/8/manifest.xml: IOException: There is already a file/directory at /stockage_opencast/opencast/archive/mh_default_org/0bbc75da-9d28-414d-8d39-1331acc72a4f/8/manifest.xml

Lylian

unread,
Nov 2, 2022, 10:00:45 AM11/2/22
to Opencast Users, Lylian
ERRATUM : i still have the error 2022-11-02T14:59:30,861 | ERROR | (IndexServiceImpl:1509) - Unable to remove the event 'd0b62ca9-c4e6-4762-9c0c-c5d75f4da66a' because removing workflow failed:
org.opencastproject.workflow.api.WorkflowDatabaseException: Could not delete workflow with ID '319495'

On blank media.

Does someone has information about this error ?

Greg Logan

unread,
Dec 1, 2022, 4:43:12 PM12/1/22
to us...@opencast.org
Hi Lylian,

I'm late to the party here, but did you run the database migration scripts?  That SQL Exception says you're missing a column, which *should* be in the upgrade scripts.  Regarding the rest, I'm not sure.  The IOException looks like there could be some filesystem weirdness going on.

G

--
To unsubscribe from this group and stop receiving emails from it, send an email to users+un...@opencast.org.

Lylian

unread,
Dec 5, 2022, 10:27:29 AM12/5/22
to Opencast Users, Greg Logan
Hi Greg,

We started the database migration scripts but he was missing some things. Matthias Neugebauer gave us some fix for our database and it's working from now !

Best regards,

Lylian.
Reply all
Reply to author
Forward
0 new messages