[Spacewalk-list] Random Oracle Error Spacewalk 1.4 centos 5.6 x86_64
Philip Rhodes
rhodes at me.com
Wed Jun 15 21:12:41 UTC 2011
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
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110615/9616a554/attachment.htm>
More information about the Spacewalk-list
mailing list