[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