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.
fixed in spacewalk master 3379c0ba58589ecb7b480a1e1672807d0bfaa0cc
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