Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 841453

Summary:	"Rollback to snapshot" produces '500 Error - Internal Server Error"
Product:	[Community] Spacewalk	Reporter:	Willard Rathjen <rathjen.willard>
Component:	WebUI	Assignee:	Tomáš Kašpárek <tkasparek>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	1.7	CC:	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:18:41 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 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 (Red Hat) 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 (Red Hat) 2012-11-01 16:18:41 UTC

Spacewalk 1.8 has been released: https://fedorahosted.org/spacewalk/wiki/ReleaseNotes18