Bug 851033
Summary: | when rolling back a package "'500 Error - Internal Server Error"" | ||
---|---|---|---|
Product: | [Community] Spacewalk | Reporter: | Sebastian <rhendricks1> |
Component: | WebUI | Assignee: | Tomas Lestach <tlestach> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Red Hat Satellite QA List <satqe-list> |
Severity: | urgent | Docs Contact: | |
Priority: | unspecified | ||
Version: | 1.7 | CC: | jason, tkasparek |
Target Milestone: | --- | ||
Target Release: | --- | ||
Hardware: | x86_64 | ||
OS: | Linux | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2012-11-01 16:21:19 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: | 871344 |
Description
Sebastian
2012-08-23 06:41:22 UTC
This has already been fixed by TomasK ... spacewalk.git: a10f88192e6564a594087ca1fc182779e0da9612 Hi Tomas After update RHN/DB/Scheduler.pm @@ -1250,7 +1250,7 @@ EOS INSERT INTO rhnPackageDelta (id, label) VALUES - (:id, 'delta-' || :id) + (cast(:id as numeric), 'delta-' || :id) EOS $sth->execute_h(id => $delta_id); I'm getting the following error [error] Execution of /var/www/html/network/systems/details/history/snapshots/rollback.pxt failed at Thu Aug 23 11:24:22 2012: RHN::Exception: DBD::Pg::db do failed: ERROR: no such savepoint\n RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 121 RHN::Exception::DB::throw\n RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 185 RHN::DB::handle_error\n RHN::DB::SystemSnapshot /usr/share/perl5/vendor_perl/RHN/DB/SystemSnapshot.pm 458 RHN::DB::db::rollback\n Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 301 RHN::DB::SystemSnapshot::rollback_to_snapshot\n Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 300 (eval)\n PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 482 Sniglets::Snapshot::system_snapshot_rollback_cb\n PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 PXT::ApacheHandler::pxt_parse_data\n PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 (eval)\n main -e 0 PXT::ApacheHandler::handler\n main -e 0 (eval) [Thu Aug 23 11:24:22 2012] [error] Traceback sent to MidrangeLinux.za at /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm line 563. (In reply to comment #1) > This has already been fixed by TomasK ... > > spacewalk.git: a10f88192e6564a594087ca1fc182779e0da9612 Hi Tomas After update RHN/DB/Scheduler.pm @@ -1250,7 +1250,7 @@ EOS INSERT INTO rhnPackageDelta (id, label) VALUES - (:id, 'delta-' || :id) + (cast(:id as numeric), 'delta-' || :id) EOS $sth->execute_h(id => $delta_id); I'm getting the following error [error] Execution of /var/www/html/network/systems/details/history/snapshots/rollback.pxt failed at Thu Aug 23 11:24:22 2012: RHN::Exception: DBD::Pg::db do failed: ERROR: no such savepoint\n RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 121 RHN::Exception::DB::throw\n RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 185 RHN::DB::handle_error\n RHN::DB::SystemSnapshot /usr/share/perl5/vendor_perl/RHN/DB/SystemSnapshot.pm 458 RHN::DB::db::rollback\n Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 301 RHN::DB::SystemSnapshot::rollback_to_snapshot\n Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 300 (eval)\n PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 482 Sniglets::Snapshot::system_snapshot_rollback_cb\n PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 PXT::ApacheHandler::pxt_parse_data\n PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 (eval)\n main -e 0 PXT::ApacheHandler::handler\n main -e 0 (eval) [Thu Aug 23 11:24:22 2012] [error] Traceback sent to MidrangeLinux.za at /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm line 563. Hello Sebastian I haven't managed to reproduce problem you've encountered in Spacewalk 1.8 nightly, so it has been fixed in Spacewalk 1.8 nightly and we won't be probably putting this bugfix into Spacewalk 1.7. Tomas, I am getting the very same results as Sebastian. I would get the same error when doing rollbacks. Traceback showed the error in Scheduler.pm. I updated it per suggestions. Now i get the very same error. I understand this does not seem to be an issue with Spacewalk 1.8; however, as this is a production server I cannot use nightly builds. Do you have any suggestions? Form variables: pxt:trap => rhn:system_snapshot_rollback_cb sid => 1000010002 ss_id => 70 User Information: User satadmin (id 1, org_id 1) Error notes: (none) Initial Request: Yes Error message: RHN::Exception: DBD::Pg::db do failed: ERROR: no such savepoint RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 121 RHN::Exception::DB::throw RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 185 RHN::DB::handle_error RHN::DB::SystemSnapshot /usr/share/perl5/vendor_perl/RHN/DB/SystemSnapshot.pm 458 RHN::DB::db::rollback Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 301 RHN::DB::SystemSnapshot::rollback_to_snapshot Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 300 (eval) PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 482 Sniglets::Snapshot::system_snapshot_rollback_cb PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 PXT::ApacheHandler::pxt_parse_data PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 (eval) main -e 0 PXT::ApacheHandler::handler main -e 0 (eval) Moving ON_QA. Packages that address this bugzilla should now be available in yum repos at http://yum.spacewalkproject.org/nightly/ Spacewalk 1.8 has been released: https://fedorahosted.org/spacewalk/wiki/ReleaseNotes18 |