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

[Jan Pazdziora]

On Wed, Nov 02, 2011 at 02:38:30PM +0000, John Hodrien wrote:
> On Wed, 2 Nov 2011, Jan Pazdziora wrote:
> 
> >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)?
> 
> This appears to have fixed a very similar problem I was seeing.

Thank you for the confirmation -- I've now pushed the change to
Spacewalk master and it will land in the nightly yum repos eventually.

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