[Spacewalk-list] Bugs in Spacewalk/PostgreSQL

[Gerald]

Hi Greg,

does your patch fix this problem as well?

Select a package -> Target Systems ->(Select a few of
them)->Install->Confirm->Error 500

--
[Wed Nov 09 10:11:58 2011] [error] Execution of
/var/www/html/network/software/packages/install_confirm.pxt failed at Wed
Nov  9 10:11:58 2011: RHN::Exception: DBD::Pg::st execute failed: ERROR:
function evr_t(unknown, integer, integer) does not exist at character
871\nHINT:  No function matches the given name and argument types. You might
need to add explicit type casts.\n  RHN::DB
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228 RHN::Exception::DB::throw\n
RHN::DB::Scheduler /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Scheduler.pm 676
RHN::DB::handle_error\n  Sniglets::ListView::SystemList
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/SystemList.pm 1356
RHN::DB::Scheduler::schedule_package_install\n
Sniglets::ListView::SystemList
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/SystemList.pm 918
Sniglets::ListView::SystemList::install_package\n  Sniglets::ListView::List
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm 374
Sniglets::ListView::SystemList::in_set_cb\n  Sniglets::Lists
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Lists.pm 135
Sniglets::ListView::List::callback\n  PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 499
Sniglets::Lists::listview_cb\n  PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 113
PXT::ApacheHandler::pxt_parse_data\n  PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 113 (eval)\n  main -e
0 PXT::ApacheHandler::handler\n  main -e 0 (eval)

 [Wed Nov 09 10:11:58 2011] [error] Cannot ping database handle for
dbi:Pg:dbname=spaceschema: ERROR:  current transaction is aborted, commands
ignored until end of transaction block (RHN::Exception: DBD::Pg::st execute
failed: ERROR:  current transaction is aborted, commands ignored until end
of transaction block\n  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm
228 RHN::Exception::DB::throw\n  RHN::DB::db
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 411 RHN::DB::handle_error\n
RHN::DB::db /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 397 (eval)\n  RHN::DB
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 156 RHN::DB::db::ping\n  RHN::DB
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 124 RHN::DB::connect\n  RHN::DB
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 124 (eval)\n  RHN::Session
/usr/lib/perl5/vendor_perl/5.8.8/RHN/Session.pm 113 RHN::DB::soft_connect\n
PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 381
RHN::Session::load\n  PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 380 (eval)\n
PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 63
PXT::ApacheHandler::initialize_pxt\n  main -e 0
PXT::ApacheHandler::handler\n  main -e 0 (eval)\n) at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line
156\n\tRHN::DB::connect('RHN::DB', 'undef') called at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 124\n\teval {...} called at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line
124\n\tRHN::DB::soft_connect('RHN::DB') called at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/Session.pm line
113\n\tRHN::Session::load('RHN::Session',
'376xb0d7538e6ea6feaef721807bf9276193') called at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line 381\n\teval {...}
called at /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line
380\n\tPXT::ApacheHandler::initialize_pxt('PXT::ApacheHandler',
'Apache2::RequestRec=SCALAR(0x2b131b1fb740)') called at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line
63\n\tPXT::ApacheHandler::handler('Apache2::RequestRec=SCALAR(0x2b131b1fb740
)') called at -e line 0\n\teval {...} called at -e line 0
[Wed Nov 09 10:11:58 2011] [error] Issuing rollback() due to DESTROY without
explicit disconnect() of DBD::Pg::db handle dbname=spaceschema at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 193.
--

Kind regards,
Gerald

-----Ursprüngliche Nachricht-----
Von: spacewalk-list-bounces at redhat.com
[mailto:spacewalk-list-bounces at redhat.com] Im Auftrag von Wojtak, Greg
Gesendet: Freitag, 04. November 2011 17:41
An: spacewalk-list at redhat.com
Betreff: Re: [Spacewalk-list] Bugs in Spacewalk/PostgreSQL

I've attached a patch for /usr/share/perl5/RHN/DB/Action.pm.

Thanks!

Greg Wojtak

On 2011-11-04 11:26 AM, "Jan Pazdziora" <jpazdziora at redhat.com> wrote:

>On Thu, Nov 03, 2011 at 06:52:27PM +0000, Wojtak, Greg wrote:
>> I think I have something working.  What is the best method to get 
>>this to  you?  Would you like a diff or the whole file (it was all in 
>>Action.pm).
>
>A diff (patch) would be the best.
>
>--
>Jan Pazdziora
>Principal Software Engineer, Satellite Engineering, Red Hat
>
>_______________________________________________
>Spacewalk-list mailing list
>Spacewalk-list at redhat.com
>https://www.redhat.com/mailman/listinfo/spacewalk-list