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(a)opensuse.org
To contact the owner, e-mail: uyuni-users+owner(a)opensuse.org