[Spacewalk-list] Installed Systems/Target Systems - 500 error
Gerald
redhat at jerry.at
Tue Sep 20 15:28:12 UTC 2011
Hi,
with your GIT patch, I now get for both functions the same
"Cannot bind unknown placeholder ':p1'" error.
I've changed the code according to your advice:
--
--- /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm.orig 2011-09-20
17:11:35.000000000 +0200
+++ /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 2011-09-20
17:18:28.000000000 +0200
@@ -557,7 +557,9 @@
$self->bind_param_inout(":$k" => $v, 4096, $attr);
}
else {
- $self->bind_param(":$k" => $v, $attr);
+ eval {$self->bind_param(":$k" => $v, $attr)};
+ if($@) { use Carp; Carp::confess("$k $v $attr") }
}
}
--
And this are the error-results for both functions (List Systems, Target
Systems):
--
[Tue Sep 20 17:18:48 2011] [error] Execution of
/var/www/html/network/software/packages/system_list.pxt failed at Tue Sep 20
17:18:48 2011: p1 1000010007 HASH(0x2b4f54669770) at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line
562\n\tRHN::DB::st::execute_h('RHN::DB::st=HASH(0x2b4f54614420)', 'p5',
1000010012, 'p17', 1000010038, 'p0', 1000010031, 'p7', 1000010037, ...)
called at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm line
75\n\tRHN::DB::DataSource::run_query('RHN::DataSource::System=HASH(0x2b4f542
2ee50)', '-body', '\n SELECT SERVER_ID AS ID, SECURITY_ERRATA, BUG_ERRATA,
ENHA...', '-params', 'HASH(0x2b4f4e3aca50)', '-transaction', 'undef') called
at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm line
52\n\tRHN::DB::DataSource::run_complex_query('RHN::DataSource::System=HASH(0
x2b4f5422ee50)', '-body', '\n SELECT SERVER_ID AS ID, SECURITY_ERRATA,
BUG_ERRATA, ENHA...', '-params', 'HASH(0x2b4f4dfd9740)') called at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm line
144\n\tRHN::DataSource::elaborate('RHN::DataSource::System=HASH(0x2b4f5422ee
50)', 'ARRAY(0x2b4f546697e0)', '-pid', 34, '-user_id', 1) called at
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm line
1220\n\tSniglets::ListView::List::default_provider('Sniglets::ListView::Syst
emList=HASH(0x2b4f545537a0)', 'PXT::Request=HASH(0x2b4f52b72b40)') called at
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm line
908\n\tSniglets::ListView::List::render('Sniglets::ListView::SystemList=HASH
(0x2b4f545537a0)', 'PXT::Request=HASH(0x2b4f52b72b40)') called at
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Lists.pm line
119\n\tSniglets::Lists::listview('PXT::Request=HASH(0x2b4f52b72b40)',
'mode', 'systems_with_package', 'class', 'Sniglets::ListView::SystemList',
'__block__', '\\x{a} <formvars><var name="pid" /></formvars>\\x{a} <set
name="users...') called at /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm
line 160\n\tPXT::Parser::expand_tag('PXT::Parser=HASH(0x2b4f3bc83d40)',
'rhn-listview', 'CODE(0x2b4f5441e670)', 'SCALAR(0x2b4f4c980b50)',
'PXT::Request=HASH(0x2b4f52b72b40)') called at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm line
72\n\tPXT::Parser::expand_tags('PXT::Parser=HASH(0x2b4f3bc83d40)',
'SCALAR(0x2b4f4c980b50)', 'PXT::Request=HASH(0x2b4f52b72b40)') called at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line
510\n\tPXT::ApacheHandler::pxt_parse_data('PXT::ApacheHandler',
'PXT::Request=HASH(0x2b4f52b72b40)', 'SCALAR(0x2b4f4c980b50)') called at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line 113\n\teval {...}
called at /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line
113\n\tPXT::ApacheHandler::handler('Apache2::RequestRec=SCALAR(0x2b4f3bc0cc7
0)') called at -e line 0\n\teval {...} called at -e line 0
--
[Tue Sep 20 17:19:26 2011] [error] Execution of
/var/www/html/network/software/packages/target_system_list.pxt failed at Tue
Sep 20 17:19:26 2011: p1 1000010003 HASH(0x2b4f59990a20) at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line
562\n\tRHN::DB::st::execute_h('RHN::DB::st=HASH(0x2b4f59923590)', 'p5',
1000010008, 'p17', 1000010030, 'p0', 1000010002, 'p7', 1000010011, ...)
called at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm line
75\n\tRHN::DB::DataSource::run_query('RHN::DataSource::System=HASH(0x2b4f595
10f30)', '-body', '\n SELECT SERVER_ID AS ID, SECURITY_ERRATA, BUG_ERRATA,
ENHA...', '-params', 'HASH(0x2b4f4e3aca50)', '-transaction', 'undef') called
at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm line
52\n\tRHN::DB::DataSource::run_complex_query('RHN::DataSource::System=HASH(0
x2b4f59510f30)', '-body', '\n SELECT SERVER_ID AS ID, SECURITY_ERRATA,
BUG_ERRATA, ENHA...', '-params', 'HASH(0x2b4f4dfd9740)') called at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm line
144\n\tRHN::DataSource::elaborate('RHN::DataSource::System=HASH(0x2b4f59510f
30)', 'ARRAY(0x2b4f59990130)', '-org_id', 1, '-pid', 34, '-user_id', 1)
called at /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm line
1220\n\tSniglets::ListView::List::default_provider('Sniglets::ListView::Syst
emList=HASH(0x2b4f59883960)', 'PXT::Request=HASH(0x2b4f53268850)') called at
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm line
908\n\tSniglets::ListView::List::render('Sniglets::ListView::SystemList=HASH
(0x2b4f59883960)', 'PXT::Request=HASH(0x2b4f53268850)') called at
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Lists.pm line
119\n\tSniglets::Lists::listview('PXT::Request=HASH(0x2b4f53268850)',
'mode', 'potential_systems_for_package', 'class',
'Sniglets::ListView::SystemList', '__block__', '\\x{a} <formvars>\\x{a}
<var name="pid" />\\x{a} <var name="set_label...') called at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm line
160\n\tPXT::Parser::expand_tag('PXT::Parser=HASH(0x2b4f58958ac0)',
'rhn-listview', 'CODE(0x2b4f59809a30)', 'SCALAR(0x2b4f4c980b50)',
'PXT::Request=HASH(0x2b4f53268850)') called at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm line
72\n\tPXT::Parser::expand_tags('PXT::Parser=HASH(0x2b4f58958ac0)',
'SCALAR(0x2b4f4c980b50)', 'PXT::Request=HASH(0x2b4f53268850)') called at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line
510\n\tPXT::ApacheHandler::pxt_parse_data('PXT::ApacheHandler',
'PXT::Request=HASH(0x2b4f53268850)', 'SCALAR(0x2b4f4c980b50)') called at
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line 113\n\teval {...}
called at /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm line
113\n\tPXT::ApacheHandler::handler('Apache2::RequestRec=SCALAR(0x2b4f4c7f5e3
0)') called at -e line 0\n\teval {...} called at -e line 0
Kind regards,
Gerald
-----Ursprüngliche Nachricht-----
Von: spacewalk-list-bounces at redhat.com
[mailto:spacewalk-list-bounces at redhat.com] Im Auftrag von Jan Pazdziora
Gesendet: Dienstag, 20. September 2011 10:57
An: spacewalk-list at redhat.com
Betreff: Re: [Spacewalk-list] Installed Systems/Target Systems - 500 error
On Fri, Sep 16, 2011 at 02:38:20PM +0200, Gerald wrote:
> 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
[...]
> I guess the latter is a small fix, could you just point me to the
> right SQL for the missing NVL function?
You don't want that. Instead, you probably want to apply patch
http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=cab6342be786
e25f9ce2cae6665e26c1e99940a8
to your installation.
> I already tried debugging before with carp, but I'll try again for the "
> Cannot bind unknown placeholder".
Great.
--
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
More information about the Spacewalk-list
mailing list