[Spacewalk-list] Snapshot rollback broken?
Mike McArthur
mmcarthur at rackforce.com
Tue Sep 14 16:10:46 UTC 2010
Hello;
Just a quick question here to the spacewalk list, has anyone encountered this oracle error when doing a rollback:
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
')
The error seems to be caused by this line:
<*>CR.delim_end,
Checking forums people seem to suggest to check the oracle schema. Sadly my oracle foo is weak and while I was able to login oracle and create the spacewalk user, I have no idea to check to make sure the schema is populated.
Would anyone be able to assist?
Thank you
Mike M
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of David VanDyk
Sent: September-13-10 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/20100914/ee8cf16b/attachment.htm>
More information about the Spacewalk-list
mailing list