Bug 636442 - Exception while removing package '62' detected ('redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ORA-00001: unique constraint (XXXX.RHN_PFDQUEUE_PATH_UQ) violated
Summary: Exception while removing package '62' detected ('redstone.xmlrpc.XmlRpcFault:...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 540
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Justin Sherrill
QA Contact: Jiri Kastner
URL:
Whiteboard: Fixed in the 5.4.0 Release - GA'd 201...
Depends On:
Blocks: sat540-blockers
TreeView+ depends on / blocked
 
Reported: 2010-09-22 09:05 UTC by Jiri Kastner
Modified: 2010-10-28 15:03 UTC (History)
3 users (show)

Fixed In Version: spacewalk-java-1.2.39-21-sat
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-10-28 15:03:40 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Jiri Kastner 2010-09-22 09:05:53 UTC
Description of problem:
during removing packages from channel, gettting exception:
redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ORA-00001: unique constraint (XXXX.RHN_PFDQUEUE_PATH_UQ) violated.


Version-Release number of selected component (if applicable):
satellite 5.4.0 + remote oracle 11g

How reproducible:
always

Steps to Reproduce:
1. install satellite against remote 11g oracle
2. run test /CoreOS/RHN-Satellite/Inter-Satellite-Sync/Sanity/general
3. check catalina.out
  
Actual results:
com.redhat.rhn.common.db.ConstraintViolationException: ORA-00001: unique constraint (XXXX.RHN_PFDQUEUE_PATH_UQ) violated

Expected results:
no unique constraint violation messages 

Additional info:

Comment 1 Jiri Kastner 2010-09-22 12:44:55 UTC
also with oracle 10g

Comment 2 Clifford Perry 2010-09-22 15:17:11 UTC
I'm not certain this is a true blocker. If we cannot easily replicate the bug and confirm regression compared to 5.3, we will punt it off tomorrow. 

Cliff

Comment 3 Justin Sherrill 2010-09-23 22:16:53 UTC
Here's the fix:

spacewalk master: c56940f907dfde312181da56d0345d641a3ce06d
satellite master: 5edd9106a07bf5fbc1d30597f777c969d19c0078


Test seems to run fine now with this change.

Comment 4 Jiri Kastner 2010-09-27 10:32:26 UTC
verified on all platforms with embedded/remote db with latest satellite-5.4 iso

Comment 5 Clifford Perry 2010-10-28 15:03:40 UTC
The 5.4.0 RHN Satellite and RHN Proxy release has occurred. This issue has been resolved with this release. 


RHEA-2010:0801 - RHN Satellite Server 5.4.0 Upgrade
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10332

RHEA-2010:0803 - RHN Tools enhancement update
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10333

RHEA-2010:0802 - RHN Proxy Server 5.4.0 bug fix update
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10334

RHEA-2010:0800 - RHN Satellite Server 5.4.0
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10335

Docs are available:

http://docs.redhat.com/docs/en-US/Red_Hat_Network_Satellite/index.html 

Regards,
Clifford


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