[Spacewalk-list] Error 500 Spacewalk 1.5

Robert Hernandez herna175 at mail.chapman.edu
Thu Jul 28 17:45:51 UTC 2011 

Hi,

I upgraded from Spacewalk 1.4 Postgres to 1.5 Postgres.  I am getting
a web 500 errors when trying to do various actions in spacewalk.
These actions include SSM, re-activation keys, and viewing failed
schedule actions.  The failed action results in a Fatal error in
Python code occured [[6]] when I try to add file => import a file to
one of my systems.  It schedules the action but fails when the client
picks it up.  Ive included three tracebacks.  Any help would be
greatly appreciated.

When I try to use a Group in SSM I get the following traceback:

The following exception occurred while executing this request:
 GET /network/systems/ssm/system_list.pxt HTTP/1.1 (from browser)
 /network/systems/ssm/system_list.pxt (from Apache)

Date:
 Thu Jul 28 10:14:40 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: en-us,en;q=0.5
 Connection: keep-alive
 Cookie: __utma=224265929.55040022.1285266800.1308933712.1311100466.20;
__utmz=224265929.1311100466.20.17.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=xxx%20xxx%20direct%20deposit;
pxt-session-cookie=121xc329806d994312ad3c01c5cfcead2733
 Host: spacewalk.xxx.xxx
 Keep-Alive: 115
 Referer: https://spacewalk.xxx.xxx/rhn/systems/SystemGroupList.do
 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US;
rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18

Form variables:

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.

When I try to use re-activation I get:

The following exception occurred while executing this request:
 POST /network/systems/details/activation.pxt HTTP/1.1 (from browser)
 /network/systems/details/activation.pxt (from Apache)

Date:
 Thu Jul 28 10:26:40 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: en-us,en;q=0.5
 Connection: keep-alive
 Content-Length: 144
 Content-Type: application/x-www-form-urlencoded
 Cookie: __utma=224265929.55040022.1285266800.1308933712.1311100466.20;
__utmz=224265929.1311100466.20.17.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=xxx%20xxx%20direct%20deposit;
pxt-session-cookie=121xc329806d994312ad3c01c5cfcead2733
 Host: spacewalk.xxx.xxx
 Keep-Alive: 115
 Referer: https://spacewalk.xxx.xxx/network/systems/details/activation.pxt?sid=1000010007
 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US;
rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18

Form variables:
 formvar_hmac => 9ca45cd38d16a5e911bbf683f16db0f1f758474b
 generate_new_key => Generate New Key
 pxt:trap => rhn:system-activation-key-cb
 sid => 1000010007

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

Error notes:
 (none)

Initial Request:
 Yes

Error message:
 RHN::Exception: DBD::Pg::st execute failed: ERROR:  missing
FROM-clause entry for table "rhn_reg_token_seq" at character 8

 RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228
RHN::Exception::DB::throw
 RHN::DB::Token /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Token.pm 430
RHN::DB::handle_error
 Sniglets::Servers
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Servers.pm 1120
RHN::DB::Token::commit
 PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 503
Sniglets::Servers::system_activation_key_cb
 PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 113
PXT::ApacheHandler::pxt_parse_data
 PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 113 (eval)
 main -e 0 PXT::ApacheHandler::handler
 main -e 0 (eval)

Traceback for Failed System Scheduling:

The following exception occurred while executing this request:
 GET /network/systems/details/history/event.pxt?sid=1000010007&hid=262
HTTP/1.1 (from browser)
 /network/systems/details/history/event.pxt (from Apache)

Date:
 Thu Jul 28 10:34:45 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: en-us,en;q=0.5
 Connection: keep-alive
 Cookie: __utma=224265929.55040022.1285266800.1308933712.1311100466.20;
__utmz=224265929.1311100466.20.17.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=xxx%20xxx%20direct%20deposit;
pxt-session-cookie=121xc329806d994312ad3c01c5cfcead2733
 Host: spacewalk.xxx.xxx
 Keep-Alive: 115
 Referer: https://spacewalk.xxx.xxx/rhn/schedule/FailedSystems.do?aid=262
 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US;
rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18

Form variables:
 hid => 262
 sid => 1000010007

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

Error notes:
 (none)

Initial Request:
 Yes

Error message:
 RHN::Exception: DBD::Pg::st execute failed: ERROR:  prepared
statement "dbdpg_13" does not exist

 RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228
RHN::Exception::DB::throw
 RHN::DB::st /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 564
RHN::DB::handle_error
 RHN::DB::DataSource
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm 75
RHN::DB::st::execute_h
 RHN::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm
108 RHN::DB::DataSource::run_query
 RHN::DB::Server /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Server.pm
1170 RHN::DataSource::execute_query
 RHN::DB::Server /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Server.pm
1217 RHN::DB::Server::server_event_config_upload
 RHN::Server /usr/lib/perl5/vendor_perl/5.8.8/RHN/Server.pm 49
RHN::DB::Server::server_event_details
 Sniglets::Servers
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Servers.pm 593
RHN::Server::lookup_server_event
 PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 160
Sniglets::Servers::server_history_event_details
 PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 72
PXT::Parser::expand_tag
 PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 510
PXT::Parser::expand_tags
 PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 113
PXT::ApacheHandler::pxt_parse_data
 PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 113 (eval)
 main -e 0 PXT::ApacheHandler::handler
 main -e 0 (eval)

More information about the Spacewalk-list mailing list