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

Jan Pazdziora jpazdziora at redhat.com
Wed Nov 2 13:59:25 UTC 2011


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




More information about the Spacewalk-list mailing list