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

Gerald redhat at jerry.at
Thu Sep 8 07:57:44 UTC 2011


Hi,

I upgraded from 1.4 (with oracle) to 1.5 (with postgres) and now 
package overview "Installed Systems" and "Target Systems" fails with a
500 error. I already tried the nightly builds, without any success.
I also tried debugging on my own, but get stuck in the middle of the perl
source.
Maybe someone can get me a hint, which statement (and where) causes this
error.

--
The following exception occurred while executing this request:
 GET /network/software/packages/system_list.pxt?pid=53443 HTTP/1.1 (from
browser)  /network/software/packages/system_list.pxt (from Apache)

Date:
  Thu Sep  8 09:41:12 2011

Headers:
  Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
  Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  Accept-Encoding: gzip, deflate
  Accept-Language: de-at,de-de;q=0.8,de;q=0.6,en-us;q=0.4,en;q=0.2
  Connection: keep-alive
  Cookie:
__utma=70382358.2449802660350597600.1246260133.1314611116.1314619336.158;
__utmz=70382358.1314619336.158.20.utmcsr=robert-schume.at|utmccn=(referral)|
utmcmd=referral|utmcct=/index.php; __utmc=70382358;
pxt-session-cookie=30328x35603221525195f4b971d8e1de7edffd
  DNT: 1
  Host: spacewalk.******
  Referer:
https://spacewalk.******/rhn/software/packages/Details.do?pid=53443
  User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0.1) Gecko/20100101
Firefox/6.0.1

Form variables:
  pid => 53443

User Information:
  User admin (id 1, org_id 1)

Error notes:
  (none)

Initial Request:
  Yes

Error message:
  Cannot bind unknown placeholder ':p1' at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 560.

--

The following exception occurred while executing this request:
 GET /network/software/packages/target_system_list.pxt?pid=53443 HTTP/1.1
(from browser)  /network/software/packages/target_system_list.pxt (from
Apache)

Date:
  Thu Sep  8 09:44:18 2011

Headers:
  Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
  Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  Accept-Encoding: gzip, deflate
  Accept-Language: de-at,de-de;q=0.8,de;q=0.6,en-us;q=0.4,en;q=0.2
  Connection: keep-alive
  Cookie:
__utma=70382358.2449802660350597600.1246260133.1314611116.1314619336.158;
__utmz=70382358.1314619336.158.20.utmcsr=robert-schume.at|utmccn=(referral)|
utmcmd=referral|utmcct=/index.php; __utmc=70382358;
pxt-session-cookie=30328x35603221525195f4b971d8e1de7edffd
  DNT: 1
  Host: spacewalk.******
  Referer:
https://spacewalk.******/rhn/software/packages/Details.do?pid=53443
  User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0.1) Gecko/20100101
Firefox/6.0.1

Form variables:
  pid => 53443

User Information:
  User admin (id 1, org_id 1)

Error notes:
  (none)

Initial Request:
  Yes

Error message:
  Cannot bind unknown placeholder ':p1' at
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 560.
--

As I see on the mailing list this seems related to postgres only, otherwise
more
people would have reported this (there was one posting mentioning postgres
and this bug too, but without a fix).

Regards,
Gerald




More information about the Spacewalk-list mailing list