[Spacewalk-list] Bugs in Spacewalk/PostgreSQL

[Wojtak, Greg]

What is the appropriate method to take to report bugs (in this case 500 messages) in a Spacealk/PostgreSQL setup?  Through this group, via a Bugzilla…?

When I try to cancel a scheduled action on a server (Systems -> <server_name> -> Events -> select environments and cancel events) I get a 500 with an accompanying message in the httpd error log:


[Wed Oct 26 10:36:47 2011] [error] Execution of /var/www/html/network/systems/details/history/cancel_events_confirm.pxt failed at Wed Oct 26 10:36:47 2011: RHN::Exception: DBD::Pg::st execute failed: ERROR:  syntax error at or near "selected_actions"\nLINE 3: cursor selected_actions is\n               ^\n  RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 228 RHN::Exception::DB::throw\n  RHN::DB::st /usr/share/perl5/vendor_perl/RHN/DB.pm 564 RHN::DB::handle_error\n  RHN::DB::Action /usr/share/perl5/vendor_perl/RHN/DB/Action.pm 264 RHN::DB::st::execute_h\n  Sniglets::ListView::ActionList /usr/share/perl5/vendor_perl/Sniglets/ListView/ActionList.pm 168 RHN::DB::Action::delete_system_from_action_set\n  Sniglets::ListView::List /usr/share/perl5/vendor_perl/Sniglets/ListView/List.pm 374 Sniglets::ListView::ActionList::events_in_set_cb\n  Sniglets::Lists /usr/share/perl5/vendor_perl/Sniglets/Lists.pm 135 Sniglets::ListView::List::callback\n  PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 499 Sniglets::Lists::listview_cb\n  PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 113 PXT::ApacheHandler::pxt_parse_data\n  PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 113 (eval)\n  main -e 0 PXT::ApacheHandler::handler\n  main -e 0 (eval)

[Wed Oct 26 10:36:48 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/share/perl5/vendor_perl/RHN/DB.pm 228 RHN::Exception::DB::throw\n  RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 411 RHN::DB::handle_error\n  RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 397 (eval)\n  RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 156 RHN::DB::db::ping\n  RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 124 RHN::DB::connect\n  RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 124 (eval)\n  RHN::Session /usr/share/perl5/vendor_perl/RHN/Session.pm 113 RHN::DB::soft_connect\n  PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 381 RHN::Session::load\n  PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 380 (eval)\n  PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 63 PXT::ApacheHandler::initialize_pxt\n  main -e 0 PXT::ApacheHandler::handler\n  main -e 0 (eval)\n) at /usr/share/perl5/vendor_perl/RHN/DB.pm line 156\n\tRHN::DB::connect('RHN::DB', undef) called at /usr/share/perl5/vendor_perl/RHN/DB.pm line 124\n\teval {...} called at /usr/share/perl5/vendor_perl/RHN/DB.pm line 124\n\tRHN::DB::soft_connect('RHN::DB') called at /usr/share/perl5/vendor_perl/RHN/Session.pm line 113\n\tRHN::Session::load('RHN::Session', '40465xbb7346231167fe743dfb041e2465b564') called at /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm line 381\n\teval {...} called at /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm line 380\n\tPXT::ApacheHandler::initialize_pxt('PXT::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x7f2b4a1930c0)') called at /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm line 63\n\tPXT::ApacheHandler::handler('Apache2::RequestRec=SCALAR(0x7f2b4a1930c0)') called at -e line 0\n\teval {...} called at -e line 0
[Wed Oct 26 10:36:48 2011] [error] Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=spaceschema at /usr/share/perl5/vendor_perl/RHN/DB.pm line 193.



If I should post this information elsewhere, please let me know.

Thanks!

Greg