Bug 1092608 - ORA-01400: cannot insert NULL into ("RHNSAT"."RHNERRATAPACKAGE"."PACKAGE_ID"): Package Upload Failed due to uniqueness constraint violation.
Summary: ORA-01400: cannot insert NULL into ("RHNSAT"."RHNERRATAPACKAGE"."PACKAGE_ID")...
Keywords:
Status: CLOSED EOL
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Satellite Synchronization
Version: 541
Hardware: Unspecified
OS: Linux
high
high
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: sat570-triage
TreeView+ depends on / blocked
 
Reported: 2014-04-29 14:41 UTC by Jan Hutař
Modified: 2020-03-11 14:50 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-07-21 14:28:56 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 45736 0 None None None 2016-02-18 10:29:35 UTC

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


Note You need to log in before you can comment on or make changes to this bug.