Description of problem: sat-sync of custom channels from master satellite throws an integrity constraint if parent key is missing.. # satellite-sync -c iss-test-channel 23:36:01 Red Hat Network Satellite - live synchronization 23:36:01 url: https://rlx-0-16.rhndev.redhat.com 23:36:01 debug/output level: 1 23:36:05 db: spacewalk/<password>@xe 23:36:05 23:36:05 Retrieving / parsing channel-families data 23:36:07 channel-families data complete 23:36:07 23:36:07 Retrieving / parsing arches data 23:36:11 arches data complete 23:36:11 23:36:11 Retrieving / parsing additional arches data 23:36:11 additional arches data complete 23:36:11 23:36:11 Retrieving / parsing channel data 23:36:11 p = previously imported/synced channel 23:36:11 . = channel not yet imported/synced 23:36:11 base-channels: 23:36:11 . iss-test-channel 0 23:36:11 AAAAAAAAAAAAAAAAAAAAAAAAAAAA [<server.importlib.importLib.Channel instance; attributes={'source_packages': [], 'product_version': None, 'all-packages': None, 'channel_product_id': None, 'parent_channel': None, 'channel_arch': 'channel-ia32', 'basedir': '/dev/null', 'label': 'iss-test-channel', 'product_name': None, 'families': [[<server.importlib.importLib.ChannelFamily instance; attributes={'product_url': None, 'channels': ['iss-test-channel'], 'label': 'private-channel-family-22', 'channel-family-id': 'rhn-channel-family-1020', 'name': None}]], 'description': None, 'product_beta': None, 'product_name_id': None, 'errata_timestamps': [], 'last_modified': '2008-11-19 11:06:11', 'receiving_updates': 'Y', 'packages': [], 'name': 'iss-test-channel', 'string_channel_id': 'rhn-channel-121', 'gpg_key_url': None, 'kickstartable_trees': [], 'org_id': 22, 'summary': 'iss-test-channel', 'dists': [], 'release': None, 'errata': []}] CCCCCCCCCCCCCCCCCCCCCC [[<server.importlib.importLib.Channel instance; attributes={'source_packages': [], 'product_version': None, 'all-packages': None, 'channel_product_id': None, 'parent_channel': None, 'channel_arch': 'channel-ia32', 'basedir': '/dev/null', 'label': 'iss-test-channel', 'product_name': None, 'channel_arch_id': 500, 'families': [{'channel_family_id': 1013}], 'description': None, 'product_beta': None, 'product_name_id': None, 'errata_timestamps': [], 'last_modified': '2008-11-19 11:06:11', 'receiving_updates': 'Y', 'packages': [], 'name': 'iss-test-channel', 'string_channel_id': 'rhn-channel-121', 'gpg_key_url': None, 'kickstartable_trees': [], 'org_id': 22, 'summary': 'iss-test-channel', 'dists': [], 'release': None, 'errata': []}]] +++ sending log as an email +++ SYNC ERROR: unhandled exception occurred: (Check logs/email for potentially more detail) <rhnFault class (code = 54, text = 'ORA-02291: integrity constraint (SPACEWALK.RHN_CHANNEL_ORG_FK) violated - parent key not found ')> (54, 'ORA-02291: integrity constraint (SPACEWALK.RHN_CHANNEL_ORG_FK) violated - parent key not found\n', '\n Package Upload Failed due to uniqueness constraint violation.\n Make sure the package does not have any duplicate dependencies or\n does not already exists on the server\n ')
Reassigned to me as qa_contact. Similar to bug 509187, I can verify them at the same time.
master has more the one org, syncing to slave with just one org. did a sat sync on the base and it looks good.
RELEASE_PENDING from 7/24 ISO.
An advisory has been issued which should help the problem described in this bug report. This report is therefore being closed with a resolution of ERRATA. For more information on therefore solution and/or where to find the updated files, please follow the link below. You may reopen this bug report if the solution does not work for you. http://rhn.redhat.com/errata/RHEA-2009-1434.html