Bug 476207

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     ')