Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1092608

Summary: ORA-01400: cannot insert NULL into ("RHNSAT"."RHNERRATAPACKAGE"."PACKAGE_ID"): Package Upload Failed due to uniqueness constraint violation.
Product: Red Hat Satellite 5 Reporter: Jan Hutař <jhutar>
Component: Satellite SynchronizationAssignee: Tomáš Kašpárek <tkasparek>
Status: CLOSED EOL QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: high Docs Contact:
Priority: high    
Version: 541CC: jentrena, mtessun, tlestach
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-07-21 14:28:56 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1127217    

Description Jan Hutař 2014-04-29 14:41:59 UTC
Description of problem:
There is an error when syncing from arbitrary dump.


Version-Release number of selected component (if applicable):
spacewalk-backend-tools-1.2.13-82.el5sat.noarch
spacewalk-schema-1.2.21-19.el5sat.noarch
satellite-schema-5.4.0.28-1.el5sat.noarch


How reproducible:
always


Steps to Reproduce:
1. Sync from arbitrary dump


Actual results:
06:37:29 Red Hat Network Satellite - file-system synchronization
06:37:29    mp:  /<somepath>/rhel5-i386-x8664-cloners-300pkgs-200erratas
06:37:29    db:  rhnsat/<password>@rhnsat
[...]
06:42:06 Importing channel errata
06:42:06    Importing *relevant* errata: clone-rhel-i386-server-5 (200)
            ________________________________________
Downloading:########################
SYNC ERROR: unhandled exception occurred:

(Check logs/email for potentially more detail)

<rhnFault class (code = 54, text = 'ORA-01400: cannot insert NULL into ("RHNSAT"."RHNERRATAPACKAGE"."PACKAGE_ID")
')>
(54, 'ORA-01400: cannot insert NULL into ("RHNSAT"."RHNERRATAPACKAGE"."PACKAGE_ID")\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     ')

+++ sending log as an email +++


Expected results:
Sync should succeed.

Comment 7 Tomas Lestach 2016-07-21 14:28:56 UTC
We have re-reviewed this bug, as part of an ongoing effort to improve Satellite/Proxy feature and bug updates, review and backlog.
We're closing this Bugzilla due to the Satellite 5 version this bug was reported against having been EOL (End-of-Life) [1].
Please re-open if the issue still exists in the latest Satellite 5 version.

Tomas and Xixi

[1] Satellite Life Cycle page: https://access.redhat.com/support/policy/updates/satellite