Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.
Bug 232473 - deleting 20 inactive systems at once on does not work
Summary: deleting 20 inactive systems at once on does not work
Alias: None
Product: Red Hat Network
Classification: Red Hat
Component: RHN/Web Site
Version: RHN Stable
Hardware: All
OS: Linux
Target Milestone: ---
Assignee: Grant Gainey
QA Contact: Red Hat Satellite QA List
Depends On:
TreeView+ depends on / blocked
Reported: 2007-03-15 18:13 UTC by John Poelstra
Modified: 2007-06-25 19:51 UTC (History)
1 user (show)

Fixed In Version: rhn501
Doc Type: Bug Fix
Doc Text:
Clone Of:
Last Closed: 2007-06-25 19:51:45 UTC
Target Upstream Version:

Attachments (Terms of Use)

Description John Poelstra 2007-03-15 18:13:24 UTC
Description of problem:

Selected 20 inactive systems and then did a systems group delete.  Error message
returned to the screen is:

500 Error - Internal Server Error

You may have reached this page in one of the following ways:

   1. You are using an outdated version of Konqueror 3.0, which may not handle
form variables properly in all cases. Continuing to use this outdated version of
Konqueror may have unexpected results. Please up2date to the latest version of
Konqueror (3.03 or greater), or if this is not possible, please use another browser.
   2. You've found an error in our site. Please help us by filling out this form
with details of how you received this message.
   3. You've done something naughty. Stop it.

I'm running the latest RHEL5 packages and using firefox.

Comment 3 Grant Gainey 2007-04-24 18:19:41 UTC
This looks like another instance of the ORA "deadlock detected" issue we're
trying to track down - all of which seem to center around
delete_systems_conf.pxt or delete_confirm.pxt.  Recreated on WEBDEV, traceback
looks like this:

[Tue Apr 24 14:11:57 2007] [error] [timing] slow rendering of page
'/network/systems/ssm/misc/delete_systems_conf.pxt': 6.1829 seconds (0.6999
user/0.0340 sys)
[Tue Apr 24 14:11:57 2007] [error] Execution of
/var/www/html/network/systems/ssm/misc/delete_systems_conf.pxt failed at Tue Apr
24 14:11:57 2007: RHN::Exception: DBD::Oracle::st execute failed: ORA-00060:
deadlock detected while waiting for resource!ORA-06512: at "RHN.RHN_CHANNEL",
line 769!ORA-06512: at "RHN.RHN_CHANNEL", line 650!ORA-06512: at
"RHN.RHN_CHANNEL", line 528!ORA-06512: at "RHN.DELETE_SERVER_BULK", line
89!ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN! 
delete_server_bulk(?);!END;!" with ParamValues: :p1='1415242']!  RHN::DB
/usr/lib/perl5/site_perl/5.8.5/RHN/ 226 RHN::Exception::DB::throw! 
RHN::DB::Server /usr/lib/perl5/site_perl/5.8.5/RHN/DB/ 1244
RHN::DB::handle_error!  RHN::DB::Server
/usr/lib/perl5/site_perl/5.8.5/RHN/DB/ 1237 (eval)!  Sniglets::Servers
/usr/lib/perl5/site_perl/5.8.5/Sniglets/ 2556
RHN::DB::Server::delete_servers_in_system_list!  PXT::ApacheHandler
/usr/lib/perl5/site_perl/5.8.5/PXT/ 620
Sniglets::Servers::delete_servers_cb!  PXT::ApacheHandler
/usr/lib/perl5/site_perl/5.8.5/PXT/ 110
PXT::ApacheHandler::pxt_parse_data!  PXT::ApacheHandler
/usr/lib/perl5/site_perl/5.8.5/PXT/ 110 (eval)!  main /dev/null
0 PXT::ApacheHandler::handler!  main /dev/null 0 (eval)
[Tue Apr 24 14:11:57 2007] [error] Traceback sent to at
/usr/lib/perl5/site_perl/5.8.5/PXT/ line 725.

Comment 4 Grant Gainey 2007-06-25 19:51:45 UTC
I can't reproduce this error any more - appears the prod-fix to add the index
addressed it.

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