Bug 678550 - ISE when adding packages to a custom channel
Summary: ISE when adding packages to a custom channel
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Network
Classification: Retired
Component: RHN/Web Site
Version: RHN Stable
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
Assignee: Sebastian Skracic
QA Contact: Red Hat Network Quality Assurance
URL:
Whiteboard: US=7680
: 548084 617345 (view as bug list)
Depends On:
Blocks: rhn-sprint62
TreeView+ depends on / blocked
 
Reported: 2011-02-18 11:47 UTC by Sebastian Skracic
Modified: 2011-03-23 20:23 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-03-23 20:23:45 UTC
Embargoed:


Attachments (Terms of Use)

Description Sebastian Skracic 2011-02-18 11:47:35 UTC
Steps to reproduce:

1. login to rhn.webdev.redhat.com
2. click on channels tab
3. under Software Channel Management - click "create new channel"
4. enter channel name, channel label and channel summary, click "Create Channel" button
5. click packages
6. click add packages
7. in the view select "All managed packages" and click view
8. select all the packages that are listed and click "Add Packages" button


actual result: 500 Error - Internal Server Error
expected result: should be able to add packages to custom channel.

Comment 1 Sebastian Skracic 2011-02-18 11:55:18 UTC
*** Bug 617345 has been marked as a duplicate of this bug. ***

Comment 2 Sebastian Skracic 2011-02-18 12:21:33 UTC
This is very likely caused by race condition between Java and Perl tiers, who all want to insert the same row into rhnSet.  In "normal" environments, usually the Java layer processes the AJAX requests (spawned by clicking on the checkboxes) fast enough to have rhnSet populated before user has clicked on the 'Add' button.  In that case, Perl tier sees those entries populated and decides not to do any more work on them.  However, if Java processing is stuck or simply slow, there is a fair amount of chance that not all AJAX requests will be processed at the time Perl has started the processing of the form submission.  In that situation, Perl will see only part of the user selected checkbox values actually inserted into rhnSet table and it will helpfully try to insert the missing values.  At the same time, Java is trying to insert the same rows on its own.  Most of the time it works without error, given the db and the Java layer is responsive enough.

Comment 3 Sebastian Skracic 2011-02-18 13:55:09 UTC
Fix provided in d12ce181a12c9901163e706f72420548f6d9231c.

Comment 4 Sebastian Skracic 2011-02-18 13:55:21 UTC
And available on WEBDEV.

Comment 5 venkat 2011-02-18 15:51:02 UTC
verified in webdev.

Comment 6 Sebastian Skracic 2011-02-24 10:04:24 UTC
*** Bug 548084 has been marked as a duplicate of this bug. ***

Comment 7 venkat 2011-03-15 15:11:36 UTC
verified in webqa


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