Bug 841453 - "Rollback to snapshot" produces '500 Error - Internal Server Error"
Summary: "Rollback to snapshot" produces '500 Error - Internal Server Error"
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: WebUI
Version: 1.7
Hardware: x86_64
OS: Linux
unspecified
high
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space18
TreeView+ depends on / blocked
 
Reported: 2012-07-19 04:22 UTC by Willard Rathjen
Modified: 2012-11-01 16:18 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-11-01 16:18:41 UTC
Embargoed:


Attachments (Terms of Use)

Description Willard Rathjen 2012-07-19 04:22:28 UTC
Description of problem:
"Rollback to snapshot" produces '500 Error - Internal Server Error"

Version-Release number of selected component (if applicable):
spacewalk-postgresql.noarch        1.7.3-1.el6                 @spacewalk 
postgresql-server.x86_64           8.4.12-1.el6_2              @updates

How reproducible:
Everythie, without fail.


Steps to Reproduce:
1.Fresh CentOS 6.3 install. (Minimal)
2.Fresh PostgreSQL/WpaceWalk install (YUM) 
3.Push new packages to test host via SpaceWalk WebGUI.
4. Attempt to roll back.
  
Actual results:
I would assume the system to roll back I have never had it work.

Expected results:

Page updates with "'500 Error - Internal Server Error""

Additional info:

/var/log/httpd/error_log:

[Wed Jul 18 18:12:52 2012] [error] Execution of /var/www/html/network/systems/details/history/snapshots/rollback.pxt failed at Wed Jul 18 18:12:52 2012: RHN::Exception: DBD::Pg::st execute failed: ERROR:  syntax error at or near "SCC"\nLINE 1: INSERT INTO rhnServerConfigChannel SCC\n                                           ^\n  RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 121 RHN::Exception::DB::throw\n  RHN::DB::st /usr/share/perl5/vendor_perl/RHN/DB.pm 452 RHN::DB::handle_error\n  RHN::DB::Server /usr/share/perl5/vendor_perl/RHN/DB/Server.pm 2016 RHN::DB::st::execute_h\n  RHN::DB::SystemSnapshot /usr/share/perl5/vendor_perl/RHN/DB/SystemSnapshot.pm 424 RHN::DB::Server::set_normal_config_channels\n  RHN::DB::SystemSnapshot /usr/share/perl5/vendor_perl/RHN/DB/SystemSnapshot.pm 352 (eval)\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)
[Wed Jul 18 18:12:52 2012] [error] Traceback sent to wrathjen at /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm line 563.

Comment 1 Tomáš Kašpárek 2012-07-20 11:22:42 UTC
fixed in spacewalk master 3379c0ba58589ecb7b480a1e1672807d0bfaa0cc

Comment 2 Jan Pazdziora 2012-10-30 19:23:31 UTC
Moving ON_QA. Packages that address this bugzilla should now be available in yum repos at http://yum.spacewalkproject.org/nightly/

Comment 3 Jan Pazdziora 2012-11-01 16:18:41 UTC
Spacewalk 1.8 has been released: https://fedorahosted.org/spacewalk/wiki/ReleaseNotes18


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