[Spacewalk-list] Bugs in Spacewalk/PostgreSQL

[Wojtak, Greg]

I don't believe so.  I was strictly targeting the three scheduling related
functions.

On 2011-11-09 4:16 AM, "Gerald" <redhat at jerry.at> wrote:

>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(0x2b131b1fb7
>40
>)') 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
>
>
>
>_______________________________________________
>Spacewalk-list mailing list
>Spacewalk-list at redhat.com
>https://www.redhat.com/mailman/listinfo/spacewalk-list