s0rnix
commented
5 months ago https://github.com/uyuni-project/uyuni/issues/8693 helped.
i have performed this steps:
uyuni:~ # spacewalk-sql --select-mode - <<< "select * from rhnChannelSyncFlag where channel_id = 2832;" > query.out uyuni:~ # cat query.out channel_id | no_strict | no_errata | only_latest | create_tree | quit_on_error ------------+-----------+-----------+-------------+-------------+--------------- 2832 | f | f | f | f | f 2832 | f | f | f | f | f (2 rows)
uyuni:/var/spacewalk # spacewalk-sql --select-mode - <<< "
ALTER TABLE rhnChannelSyncFlag DROP CONSTRAINT IF EXISTS rhn_chsf_cid_pk; ALTER TABLE rhnChannelSyncFlag DROP CONSTRAINT IF EXISTS rhn_chsf_cid_fk;
DELETE FROM rhnChannelSyncFlag T1 USING rhnChannelSyncFlag T2 WHERE T1.ctid < T2.ctid -- delete the "older" ones AND T1.channel_id = T2.channel_id; -- list columns that define duplicates
ALTER TABLE rhnChannelSyncFlag ADD CONSTRAINT rhn_chsf_cid_pk PRIMARY KEY (channel_id); ALTER TABLE rhnChannelSyncFlag ADD CONSTRAINT rhn_chsf_cid_fk FOREIGN KEY (channel_id) REFERENCES rhnChannel(id) ON DELETE CASCADE; " ALTER TABLE ALTER TABLE DELETE 83 ALTER TABLE ALTER TABLE
uyuni:/var/spacewalk # spacewalk-sql --select-mode - <<< "select * from rhnChannelSyncFlag where channel_id = 2832;" channel_id | no_strict | no_errata | only_latest | create_tree | quit_on_error ------------+-----------+-----------+-------------+-------------+--------------- 2832 | f | f | f | f | f (1 row)
rjmateus
Problem description
Hallo,
i getting Internal Server Error if i try to run produc migration and if i manually change the channels to the target version as workaround i also get "Server error, please check log files.".
with sles without sap there is no problem. it might be a problem with the channels.
anybody know how to fix?
Steps to reproduce
current Installed Product: SUSE Linux Enterprise Server for SAP Applications 15 SP4 ppc64le When i try to Migrate from SLES 15.4 to 15.5 i click on Software > Product Migration > SUSE Linux Enterprise Server for SAP Applications 15 SP5 ppc64le > Select Channels and get an "Internal Server Error".
Uyuni version
Uyuni proxy version (if used)
No response
Useful logs
Additional information
No response