[Spacewalk-list] Installed Systems/Target Systems - 500 error

[Gerald]

Hi Jan,

thank you very much for your debugging and the fix!!
It works now.


Kind regards,
Gerald

-----Ursprüngliche Nachricht-----
Von: spacewalk-list-bounces at redhat.com
[mailto:spacewalk-list-bounces at redhat.com] Im Auftrag von Jan Pazdziora
Gesendet: Mittwoch, 02. November 2011 14:59
An: spacewalk-list at redhat.com
Betreff: Re: [Spacewalk-list] Installed Systems/Target Systems - 500 error

On Fri, Oct 14, 2011 at 09:42:30AM +0200, Gerald wrote:
> Sure, afterwards the whole error-output for System_List:
> 
> --
> [Fri Oct 14 09:36:07 2011] [error] p1 1000010070 HASH(0x2ad7ef0ce6b0) 
> at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 
> 562\n\tRHN::DB::st::execute_h('RHN::DB::st=HASH(0x2ad7ef082ef0)', 
> 'p5', 1000010075, 'p17', 1000010088, 'p0', 1000010073, 'p7', 
> 1000010077, ...) called at 
> /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm line

[...]

>   Cannot bind unknown placeholder ':p1' at 
> /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 560.

I believe you are hitting bug in DBD::Pg

	https://rt.cpan.org/Ticket/Display.html?id=70953

Can you please try to patch your installation with

--- RHN/DB/DataSource.pm.orig	2011-11-02 09:57:28.000000000 -0400
+++ RHN/DB/DataSource.pm	2011-11-02 09:57:35.000000000 -0400
@@ -44,7 +44,7 @@
 
   while (my @values = splice @all_values, 0, MAX_BIND_PARAMS, ()) {
     my %param_map = map { ("p$_", $values[$_]) } 0 .. $#values;
-    my $query_body = sprintf $original_body, join(", ", map { ":$_" } keys
%param_map);
+    my $query_body = sprintf $original_body, join(", ", map { ":$_" } 
+ sort keys %param_map);
 
     my %query_params = %{$original_params};
     @query_params{keys %param_map} = values %param_map;

as a workaround (restart httpd after patching)?

--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat

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