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

33 views
Skip to first unread message

George Sarantidis

unread,
Mar 16, 2012, 8:42:32 AM3/16/12
to Spacewalk List
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

George Sarantidis

unread,
Mar 17, 2012, 5:14:12 AM3/17/12
to Spacewalk List
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)


2012/3/16 George Sarantidis <george.s...@gmail.com>

Michael Mraka

unread,
Mar 20, 2012, 5:51:04 AM3/20/12
to spacewa...@redhat.com
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.s...@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

_______________________________________________
Spacewalk-list mailing list
Spacewa...@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

George Sarantidis

unread,
Mar 20, 2012, 6:06:42 AM3/20/12
to spacewa...@redhat.com
Hi Michael, 

Thank you for your reply.
I'm new on spacewalk. So, how can I found the fix? What is the Spacewalk Master?

Regads, 

George Sarantidis
RHCE SCSA SCNA MCITP

2012/3/20 Michael Mraka <michae...@redhat.com>

Michael Mraka

unread,
Mar 20, 2012, 6:46:13 AM3/20/12
to spacewa...@redhat.com
George Sarantidis wrote:
% Hi Michael,
%
% Thank you for your reply.
% I'm new on spacewalk. So, how can I found the fix? What is the Spacewalk
% Master?

Hi George,

you can browse our git on http://git.fedorahosted.org/git/spacewalk.git/.
The commit is http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=e5b731b5e1f6f0d580b73d2cd45e20a6bd83d879.
Spacewalk master means the main git branch which Spacewalk nightly repo
is built from.

So there will be fixed package in Spacewalk nightly today afternoon/night,
however we don't plan Spacewalk 1.7 update soon so you have to patch it
yourself if necessary (fortunately it's a simple one line fix).

% Regads,
%
% George Sarantidis
% RHCE SCSA SCNA MCITP
%
% 2012/3/20 Michael Mraka <michae...@redhat.com>
...
% > 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,

--

Reply all
Reply to author
Forward
0 new messages