Hi, I tried to update my Uyuni installation from 4.0.2 to 2020.03 (the current version). I did " spacewalk-service stop", changed the repo and made a zypper update. After that I startet the postgresql database and tried the schema upgrade. But the upgrade didn't finished succesfully: Schema upgrade: [susemanager-schema-4.0.13-400.3.1.uyunimaster] -> [susemanager-schema-4.1.5-1.1.uyuni] Searching for upgrade path to: [susemanager-schema-4.1.5-1] Searching for upgrade path to: [susemanager-schema-4.1.5] Searching for start path: [susemanager-schema-4.0.13-400] Searching for start path: [susemanager-schema-4.0.13] The path: [susemanager-schema-4.0.13] -> [susemanager-schema-4.0.14] -> [susemanager-schema-4.1.0] -> [susemanager-schema-4.1.1] -> [susemanager-schema-4.1.2] -> [susemanager-schema-4.1.3] -> [susemanager-schema-4.1.4] -> [susemanager-schema-4.1.5] Planning to run schema upgrade with dir '/var/log/spacewalk/schema-upgrade/schema-from-20200327-142721' Hit Enter to continue or Ctrl+C to interrupt: Executing spacewalk-sql, the log is in [/var/log/spacewalk/schema-upgrade/schema-from-20200327-142721-to-susemanager-schema-4.1.5.log]. (22/26) apply upgrade [susemanager-schema-4.1.3-to-susemanager-schema-4.1.4/004-drop-mgr-register-task.sql.postgresql] sql.postgresql] Upgrade failed, please see log [/var/log/spacewalk/schema-upgrade/schema-from-20200327-142721-to-susemanager-schema-4.1.5.log]. You can fix the failed migration in [/var/log/spacewalk/schema-upgrade/schema-from-20200327-142721] and run spacewalk-schema-upgrade again The last element in [/var/log/spacewalk/schema-upgrade/schema-from-20200327-142721-to-susemanager-schema-4.1.5.log shows: ?column? ------------------------------------------------------------------------------------------------ susemanager-schema-4.1.3-to-susemanager-schema-4.1.4/004-drop-mgr-register-task.sql.postgresql (1 row) psql:<stdin>:4: ERROR: update or delete on table "rhntaskotemplate" violates foreign key constraint "rhn_tasko_run_template_fk" on table "rhntaskorun" DETAIL: Key (id)=(18) is still referenced from table "rhntaskorun". ================== started: 2020-03-27 13:40:57 ================== SQL> select 'susemanager-schema-4.1.3-to-susemanager-schema-4.1.4/004-drop-mgr-register-task.sql.postgresql' from dual; DELETE FROM rhnTaskoTemplate WHERE bunch_id = (SELECT id FROM rhnTaskoBunch WHERE name='mgr-register-bunch') AND task_id = (SELECT id FROM rhnTaskoTask WHERE name='mgr-register'); DELETE FROM rhnTaskoTask WHERE name = 'mgr-register'; DELETE FROM rhnTaskoSchedule WHERE job_label = 'mgr-register-default'; DELETE FROM rhnTaskoBunch WHERE name = 'mgr-register-bunch'; commit; ?column? ------------------------------------------------------------------------------------------------ susemanager-schema-4.1.3-to-susemanager-schema-4.1.4/004-drop-mgr-register-task.sql.postgresql (1 row) psql:<stdin>:4: ERROR: update or delete on table "rhntaskotemplate" violates foreign key constraint "rhn_tasko_run_template_fk" on table "rhntaskorun" DETAIL: Key (id)=(18) is still referenced from table "rhntaskorun". Did I made a mistake or is there a solution for the problem? Greets Torsten -- To unsubscribe, e-mail: uyuni-users+unsubscribe@opensuse.org To contact the owner, e-mail: uyuni-users+owner@opensuse.org