database upgrade fails after upgrade 11.4.0 -> 11.4.1

For help and support with Universal Media Server
Forum rules
Please make sure you follow the Problem Reporting Guidelines before posting if you want a reply
Post Reply
thedude
Posts: 11
Joined: Sun Feb 07, 2021 8:07 am

database upgrade fails after upgrade 11.4.0 -> 11.4.1

Post by thedude »

Hi,

On Ubuntu 22.04.1 a database upgrade fails after a SW update and is reproducable on every restart of ums:

Sep 26 03:16:51 linux-flo UMS.sh[2120]: INFO 03:16:51.673 [main] Upgrading database "medias" table "FILES" from version 32 to 33
Sep 26 03:16:51 linux-flo UMS.sh[2120]: ERROR 03:16:51.748 [main] Failed upgrading database "medias" table FILES for Feld "IMDBID" nicht gefunden
Sep 26 03:16:51 linux-flo UMS.sh[2120]: Column "IMDBID" not found; SQL statement:
Sep 26 03:16:51 linux-flo UMS.sh[2120]: UPDATE FILES SET IMDBID = NULL WHERE RIGHT(CREDITS, 1) = ',' [42122-214]
Sep 26 03:16:51 linux-flo UMS.sh[2120]: ERROR 03:16:51.755 [main] SQL error while (re)initializing tables: Kann "FILES" nicht löschen weil "CONSTRAINT_C, CONSTRAINT_8, CONSTRAINT_D2, VIDEO_METADATA_FILEID_FK" davon abhängt
Sep 26 03:16:51 linux-flo UMS.sh[2120]: Cannot drop "FILES" because "CONSTRAINT_C, CONSTRAINT_8, CONSTRAINT_D2, VIDEO_METADATA_FILEID_FK" depends on it; SQL statement:
Sep 26 03:16:51 linux-flo UMS.sh[2120]: DROP TABLE IF EXISTS FILES [90107-214]
Sep 26 03:16:51 linux-flo UMS.sh[2120]: INFO 03:16:51.790 [main] Upgrading database "medias" table "VIDEO_METADATA_ACTORS" from version 1 to 2
Sep 26 03:16:52 linux-flo UMS.sh[2120]: ERROR 03:16:52.489 [main] Error checking tables: Feld wird referenziert durch "PUBLIC.FILENAME_ACTOR_TVSERIESID_IDX"
Sep 26 03:16:52 linux-flo UMS.sh[2120]: Column may be referenced by "PUBLIC.FILENAME_ACTOR_TVSERIESID_IDX"; SQL statement:
Sep 26 03:16:52 linux-flo UMS.sh[2120]: ALTER TABLE VIDEO_METADATA_ACTORS DROP COLUMN IF EXISTS FILENAME [90083-214]

BR
Post Reply