Hi Partha, I think it's broken by commit
592b5c8619abd9094fd7cd9f8b7b10e5ceca608a Config Management schema update + ui + symlinks where delim_start/delim_end moved from rhnConfigRevision to rhnConfigContent table. The query below is "configfiles_for_snapshot" from web/modules/rhn/RHN/DB/DataSource/xml/config_queries.xml which probably was not changed properly. I'm not sure if there aren't some others left. Could you please fix it and send a word about it to spacewalk-list? Thanks, Michael ----- Forwarded message from Mike McArthur <mmcart...@rackforce.com> ----- % Date: Tue, 14 Sep 2010 09:10:46 -0700 % From: Mike McArthur <mmcart...@rackforce.com> % To: "'spacewalk-l...@redhat.com'" <spacewalk-l...@redhat.com> % Subject: Re: [Spacewalk-list] Snapshot rollback broken? % X-Spam-Level: % Reply-To: spacewalk-l...@redhat.com % % 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-boun...@redhat.com [mailto:spacewalk-list-boun...@redhat.com] On Behalf Of David VanDyk % Sent: September-13-10 1:19 AM % To: 'spacewalk-l...@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! % _______________________________________________ % Spacewalk-list mailing list % spacewalk-l...@redhat.com % https://www.redhat.com/mailman/listinfo/spacewalk-list ----- End forwarded message ----- -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
