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

Fri Sep 16 12:38:20 UTC 2011

Hi Jan,

thanks for your reply. In the meantime I did a fresh install of the whole
server with spacewalk v1.5.

Both errors persists, for system_list I still get:

--
[Fri Sep 16 14:29:11 2011] [error] Execution of
/var/www/html/network/software/packages/system_list.pxt failed at Fri Sep 16
14:29:11 2011: Cannot bind unknown placeholder ':p1' at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 560.
--

but for target_systems I now get this error-log:

--
[Fri Sep 16 14:27:46 2011] [error] Execution of
/var/www/html/network/software/packages/target_system_list.pxt failed at Fri
Sep 16 14:27:46 2011: RHN::Exception: DBD::Pg::st execute failed: ERROR:
function nvl(evr_t, evr_t) does not exist at character 243\nHINT:  No
function matches the given name and argument types. You might need to add
explicit type casts.\n\n  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm
228 RHN::Exception::DB::throw\n  RHN::DB::st
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 564 RHN::DB::handle_error\n
RHN::DB::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm 75
RHN::DB::st::execute_h\n  RHN::DataSource
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm 108
RHN::DB::DataSource::run_query\n  Sniglets::ListView::List
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm 1211
RHN::DataSource::execute_query\n  Sniglets::ListView::List
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm 908
Sniglets::ListView::List::default_provider\n  Sniglets::Lists
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Lists.pm 119
Sniglets::ListView::List::render\n  PXT::Parser
/usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 160
Sniglets::Lists::listview\n  PXT::Parser
/usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 72 PXT::Parser::expand_tag\n
PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 510
PXT::Parser::expand_tags\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)
[Fri Sep 16 14:27:46 2011] [error] Traceback sent to xxx at xxx at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line 584.
[Fri Sep 16 14:27:46 2011] [error] Cannot ping database handle for
dbi:Pg:dbname=spaceschema: ERROR:  current transaction is aborted, commands
ignored until end of transaction block\n (RHN::Exception: DBD::Pg::st
execute failed: ERROR:  current transaction is aborted, commands ignored
until end of transaction block\n\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',
'49xddf4d38987813c662917b2319db6472d') 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(0x2b206a4d2da0)') called at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line
63\n\tPXT::ApacheHandler::handler('Apache2::RequestRec=SCALAR(0x2b206a4d2da0
)') called at -e line 0\n\teval {...} called at -e line 0
[Fri Sep 16 14:27:46 2011] [error] Issuing rollback() for database handle
being DESTROY'd without explicit disconnect() at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 193.
--

I guess the latter is a small fix, could you just point me to the right SQL
for the missing NVL function?

I already tried debugging before with carp, but I'll try again for the "
Cannot bind unknown placeholder". 

Thanks for your help,
Gerald

-----Ursprüngliche Nachricht-----
Von: spacewalk-list-bounces at redhat.com
[mailto:spacewalk-list-bounces at redhat.com] Im Auftrag von Jan Pazdziora
Gesendet: Donnerstag, 15. September 2011 13:32
An: spacewalk-list at redhat.com
Betreff: Re: [Spacewalk-list] Installed Systems/Target Systems - 500 error

On Thu, Sep 08, 2011 at 01:19:28PM +0200, Gerald wrote:
> Hi Michael,
> 
> here is the requested error-log:
> --
> [Thu Sep 08 13:16:53 2011] [error] Execution of
/var/www/html/network/software/packages/system_list.pxt failed at Thu Sep  8
13:16:53 2011: Cannot bind unknown placeholder ':p1' at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 560.
> --
>  [Thu Sep 08 13:17:11 2011] [error] Execution of
/var/www/html/network/software/packages/target_system_list.pxt failed at Thu
Sep  8 13:17:11 2011: Cannot bind unknown placeholder ':p1' at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 560.

I was not able to reproduce, fresh nightly install on RHEL 5.

You might want to wrap that

	$self->bind_param(":$k" => $v, $attr)

with eval, catch $@, use Carp, and call Carp::confess so that we get the
backtrace to see which code produced that :p1 parameter for which SQL.

I suspect there is something wrong with the elaborators for the
potential_systems_for_package and systems_with_package queries but I don't
see what exactly might be wrong.

--
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