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

[John Hodrien]

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.

Thanks,

jh