[Spacewalk-list] Rollback failed on Spacewalk-1.7-5

[Michael Mraka]

George Sarantidis wrote:
% I have also noticed the following error in /var/log/httpd/error_log file:
% 
% [Sat Mar 17 09:06:59 2012] [error] Execution of
% /var/www/html/network/systems/de   tails/history/snapshots/rollback.pxt
% failed at Sat Mar 17 09:06:59 2012: RHN::Ex   ception: DBD::Oracle::st
% execute failed: ORA-06550: line 2, column 11:\nPLS-0022   2: no function
% with name 'DELETE_FROM_SERVERGROUP' exists in this scope\nORA-065   50:
% line 2, column 3:\nPL/SQL: Statement ignored (DBD ERROR: error possibly
% near    <*> indicator at char 16 in 'BEGIN\n  :ret :=
% <*>rhn_server.delete_from_serverg   roup(:p1, :p2);\nEND;') [for Statement
% "BEGIN\n  :ret := rhn_server.delete_from_   servergroup(:p1, :p2);\nEND;"
% with ParamValues: :ret=undef, :p1='1000010040', :p   2="3"]\n  RHN::DB
% /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 121 RHN::Exception:
% :DB::throw\n  RHN::DB::db /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 373
% RHN::DB   ::handle_error\n  RHN::DB::Server
% /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Server   .pm 1730
% RHN::DB::db::call_function\n  RHN::DB::SystemSnapshot /usr/lib/perl5/ve
% ndor_perl/5.8.8/RHN/DB/SystemSnapshot.pm 385
% RHN::DB::Server::remove_servers_fro   m_groups\n  RHN::DB::SystemSnapshot
% /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Syst   emSnapshot.pm 352 (eval)\n
%  Sniglets::Snapshot /usr/lib/perl5/vendor_perl/5.8.8/
% Sniglets/Snapshot.pm 301 RHN::DB::SystemSnapshot::rollback_to_snapshot\n
%  Snigle   ts::Snapshot
% /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Snapshot.pm 300 (eval)\n
% PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm
% 482 Sn   iglets::Snapshot::system_snapshot_rollback_cb\n
%  PXT::ApacheHandler /usr/lib/per
% l5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 103
% PXT::ApacheHandler::pxt_parse_data   \n  PXT::ApacheHandler
% /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 103    (eval)\n  main
% -e 0 PXT::ApacheHandler::handler\n  main -e 0 (eval)

Hello George,

I've fixed this issue in spacewalk master (commit
e5b731b5e1f6f0d580b73d2cd45e20a6bd83d879). It's a simple fix you can
apply manually to your Spacewalk 1.7.

Regards,

% 2012/3/16 George Sarantidis <george.sarantidis at gmail.com>
% 
% > Hi all,
% >
% > I'm trying to configure a rollback plan for testing purposes. My problem
% > is that when I press the "Rollback to Snapshot" button I get
% > the following error:
% >
% > *500 Error - Internal Server Error*
% > *
% > *
% > *You may have reached this page in one of the following ways:*
% > *
% > *
% > *You've found an error in the site. Please report this error to your
% > local administrator with details of how you received this message.*
% >
% > OS Version: Centos 5.8 i386
% > Spacewalk version: 1.7-5
% >
% > Can you assist?
% >
% > Thank you
% >



--
Michael Mráka
Satellite Engineering, Red Hat