Hi Phil,
I think the list stripped off the actual patch file, any chance you could
re-send it please ?
I'd certainly be very interested to try it and also try to understand why this
has happened, that way I can raise a bug for it and suggest your patch
(assuming you've not done that already).
thanks,
Matt
________________________________
From: [email protected] [[email protected]] on
behalf of Philip Rhodes [[email protected]]
Sent: 15 June 2011 22:12
To: [email protected]
Subject: Re: [Spacewalk-list] Random Oracle Error Spacewalk 1.4 centos 5.6
x86_64
Michael, Matt,
I believe this patch fixed my problem as well. Just to be clear, I was
getting XMLRPC 500 errors, and the following error in /var/log/httpd/error_log:
SQL Error generated: (1484, 'ORA-01484: arrays can only be bound to PL/SQL
statements\n', 'select ks.id
from rhnKickstartSession ks where ( (ks.old_server_id = :server_id and
ks.new_server_id is NULL) or ks.n
ew_server_id = :server_id or ks.host_server_id = :server_id ) and ks.action_id
= :action_id')
This was raised by
/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py
I thought I'd put this info together to help people searching for a solution to
this problem.
Thanks for your help,
-Phil
--
Dr. Phil Rhodes
Associate Professor
Department of Computer and Information Science
University of Mississippi
On Jun 7, 2011, at 3:57 AM, Michael Mraka wrote:
Matthew Darcy wrote:
% Looking at the problems I've been having recently, this appears to be one of
the core factors in it, and appears to tie into the error message I see in my
apache error_log on a clean boot
%
% Any input as to what is causing Oracle to have a problem would be most
appreciated.
Hi Matt,
it seems the bug is caused by changes in
3fd9dc08327d15d16d4307bfe847cb0878b85ac3.
Could you try if following patch solves your issue?
Regards,
--
Michael Mráka
Satellite Engineering, Red Hat
---------------------------------------------------------
diff --git a/backend/server/rhnAction.py b/backend/server/rhnAction.py
index 7c6cc89..1ac276d 100644
--- a/backend/server/rhnAction.py
+++ b/backend/server/rhnAction.py
@@ -123,7 +123,7 @@ def _invalidate_action_recursive(server_id, action_id, h,
h_child):
if not row:
break
child_ids = _invalidate_action_recursive(server_id, row['id'], h,
h_child)
- a_ids.append(child_ids)
+ a_ids += child_ids
h.execute(server_id=server_id, action_id=action_id)
s_row = h.fetchone_dict()
if s_row and s_row['status'] <> 3:
_______________________________________________
Spacewalk-list mailing list
[email protected]<mailto:[email protected]>
https://www.redhat.com/mailman/listinfo/spacewalk-list
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
_____________________________________________________________________________________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
