Hi Jan, thank you very much for your debugging and the fix!! It works now.
Kind regards, Gerald -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Jan Pazdziora Gesendet: Mittwoch, 02. November 2011 14:59 An: [email protected] 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 [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
