<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Michael, Matt,<div> 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:</div><div><br></div><div><div>SQL Error generated: (1484, 'ORA-01484: arrays can only be bound to PL/SQL statements\n', 'select ks.id </div><div>from rhnKickstartSession ks where ( (ks.old_server_id = :server_id and ks.new_server_id is NULL) or ks.n</div><div>ew_server_id = :server_id or ks.host_server_id = :server_id ) and ks.action_id = :action_id')</div><div><br></div><div>This was raised by /usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py</div><div><br></div><div>I thought I'd put this info together to help people searching for a solution to this problem. </div><div> Thanks for your help,</div><div> -Phil</div><div><div><span class="Apple-style-span" style="font-size: 12px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; ">--</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; ">Dr. Phil Rhodes</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; ">Associate Professor</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; ">Department of Computer and Information Science</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; ">University of Mississippi</font></div></div><div><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; "><br></font></div></div></div></div></span></div></div><div><div>On Jun 7, 2011, at 3:57 AM, Michael Mraka wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Matthew Darcy wrote:<br>% 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<br>% <br>% Any input as to what is causing Oracle to have a problem would be most appreciated.<br><br>Hi Matt,<br><br>it seems the bug is caused by changes in<br>3fd9dc08327d15d16d4307bfe847cb0878b85ac3.<br>Could you try if following patch solves your issue?<br><br>Regards,<br><br>--<br>Michael Mráka<br>Satellite Engineering, Red Hat<br><br>---------------------------------------------------------<br>diff --git a/backend/server/rhnAction.py b/backend/server/rhnAction.py<br>index 7c6cc89..1ac276d 100644<br>--- a/backend/server/rhnAction.py<br>+++ b/backend/server/rhnAction.py<br>@@ -123,7 +123,7 @@ def _invalidate_action_recursive(server_id, action_id, h, h_child):<br> if not row:<br> break<br> child_ids = _invalidate_action_recursive(server_id, row['id'], h, h_child)<br>- a_ids.append(child_ids)<br>+ a_ids += child_ids<br> h.execute(server_id=server_id, action_id=action_id)<br> s_row = h.fetchone_dict()<br> if s_row and s_row['status'] <> 3:<br><br>_______________________________________________<br>Spacewalk-list mailing list<br><a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a><br>https://www.redhat.com/mailman/listinfo/spacewalk-list</div></blockquote></div><br><div>
<span class="Apple-style-span" style="font-size: 12px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span class="Apple-style-span" style="font-size: medium;"><br></span></div></div></div></div></div></span></div></div></body></html>