[Spacewalk-list] Snapshot rollback broken?

Mon Sep 13 10:15:12 UTC 2010

Just to follow  up - I just hocked version 1.0 into my test lab and rollback seems to work just fine, so this only appears to be an issue with version 1.1 so far. I then took one of my other environments and threw on the nightly-updates repo to bring it up to 1.2, but still hit the same issue, so something strange definitely seems to be going on.

Thanks.

From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of David VanDyk
Sent: Monday, September 13, 2010 1:19 AM
To: 'spacewalk-list at redhat.com'
Subject: [Spacewalk-list] Snapshot rollback broken?

I've recently performed fresh installs of Spacewalk 1.1 using the installation guide on the official Wiki page across three separate environments - in all cases however I've had no luck making use of the rollback functions (performed repetitively as I'm relatively new to Spacewalk and first assumed I had done something wrong). I can select updates for a given server I've registered to Spacewalk, schedule them for install, and install them accordingly. However if I then navigate to Provisioning --> Snapshots, select a rollback point (i.e. a past "Package Profile Changed" snapshot) and click "Rollback to snapshot", Spacewalk spins its wheels forever and then throws me to a "500 Error - Internal Server Error" website.  I'll also get an email reporting what looks like Oracle errors:

========

The following exception occurred while executing this request:

 POST /network/systems/details/history/snapshots/rollback.pxt HTTP/1.1 (from browser)  /network/systems/details/history/snapshots/rollback.pxt (from Apache)

Date:

  Sun Sep 12 23:29:14 2010

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

  Content-Type: application/x-www-form-urlencoded

  Cookie: pxt-session-cookie=43xfe157307f2eba041229540c130912653

  Host: 64.46.38.235

  Keep-Alive: 115

  Referer: https://64.46.38.235/network/systems/details/history/snapshots/rollback.pxt?sid=1000010010&ss_id=45

  User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.9) Gecko/20100824 Firefox/3.6.9 (.NET CLR 3.5.30729)

Form variables:

  pxt:trap => rhn:system_snapshot_rollback_cb

  sid => 1000010010

  ss_id => 45

User Information:

  User spacewalk-admin (id 1, org_id 1)

Error notes:

  (none)

Initial Request:

  Yes

Error message:

  RHN::Exception: DBD::Oracle::db prepare_cached failed: ORA-00904: "CR"."DELIM_END": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 236 in '

SELECT DISTINCT

       CR.id,

       UPPER(Csum.checksum_type) || ': ' || Csum.checksum AS CHECKSUM,

       CFN.id AS CONFIG_FILE_NAME_ID,

       CFN.path,

       CR.revision,

       CR.id AS REVISION_ID,

       CR.delim_start,

       <*>CR.delim_end,

       CF.config_channel_id,

       TO_CHAR(CCon.created, 'YYYY-MM-DD HH24:MI:SS') AS CREATED

  FROM rhnConfigContent CCon,

       rhnConfigFileName CFN,

       rhnConfigFile CF,

       rhnConfigRevision CR,

       rhnSnapshotConfigRevision SCR,

       rhnChecksumView Csum

 WHERE SCR.snapshot_id = :ss_id

   AND SCR.config_revision_id = CR.id

   AND CR.config_content_id = CCon.id

   AND CR.config_file_id = CF.id

   AND CF.config_file_name_id = CFN.id

   AND CCon.checksum_id = Csum.id

ORDER BY CFN.path

  ') [for Statement "

SELECT DISTINCT

       CR.id,

       UPPER(Csum.checksum_type) || ': ' || Csum.checksum AS CHECKSUM,

       CFN.id AS CONFIG_FILE_NAME_ID,

       CFN.path,

       CR.revision,

       CR.id AS REVISION_ID,

       CR.delim_start,

       CR.delim_end,

       CF.config_channel_id,

       TO_CHAR(CCon.created, 'YYYY-MM-DD HH24:MI:SS') AS CREATED

  FROM rhnConfigContent CCon,

       rhnConfigFileName CFN,

       rhnConfigFile CF,

       rhnConfigRevision CR,

       rhnSnapshotConfigRevision SCR,

       rhnChecksumView Csum

 WHERE SCR.snapshot_id = :ss_id

   AND SCR.config_revision_id = CR.id

   AND CR.config_content_id = CCon.id

   AND CR.config_file_id = CF.id

   AND CF.config_file_name_id = CFN.id

   AND CCon.checksum_id = Csum.id

ORDER BY CFN.path

  "]

  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 219 RHN::Exception::DB::throw

  RHN::DB::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm 73 RHN::DB::handle_error

  RHN::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm 108 RHN::DB::DataSource::run_query

  RHN::DB::SystemSnapshot /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/SystemSnapshot.pm 266 RHN::DataSource::execute_query

  RHN::DB::SystemSnapshot /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/SystemSnapshot.pm 429 RHN::DB::SystemSnapshot::snapshot_configfiles_list

  RHN::DB::SystemSnapshot /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/SystemSnapshot.pm 352 (eval)

  Sniglets::Snapshot /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Snapshot.pm 301 RHN::DB::SystemSnapshot::rollback_to_snapshot

  Sniglets::Snapshot /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Snapshot.pm 300 (eval)

  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 515 Sniglets::Snapshot::system_snapshot_rollback_cb

  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 117 PXT::ApacheHandler::pxt_parse_data

  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 117 (eval)

  main -e 0 PXT::ApacheHandler::handler

  main -e 0 (eval)

========

As this has happened across several fresh installs I'm unsure if this is some form of new issue, or some step I'm not following correctly when doing the installation process. Any ideas?

Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100913/52adb6a7/attachment.htm>