[Spacewalk-list] Error 500 on snapshots pages

[Pierre Casenove]

Here is the SQL statement executed:ERROR:  syntax error at or near "MINUS" at character 869STATEMENT:        SELECT PN.id AS NAME_ID,               PE.id AS EVR_ID,               PN.name AS NAME,               PE.version AS VERSION,               PE.release AS RELEASE,               PE.epoch AS EPOCH,               PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS NVRE,               UPPER(PN.name || '-' || evr_t_as_vre_simple(PE.evr)) AS U_NVRE          FROM rhnPackageName PN,               rhnPackageEVR PE,               rhnPackageNEVRA PNEVRA,               rhnSnapshotPackage SP,               rhnSnapshot S         WHERE S.id = $1           AND S.server_id = $2           AND S.id = SP.snapshot_id           AND SP.nevra_id = PNEVRA.id           AND PNEVRA.name_id = PN.id           AND NOT EXISTS (SELECT 1 FROM rhnPackageSyncBlacklist PSB WHERE                             PSB.package_name_id = PN.id AND org_id is NULL OR org_id = $3)           AND PNEVRA.evr_id = PE.id           AND NOT EXISTS (        SELECT 1 FROM rhnServerPackage SP         WHERE SP.server_id = $2           AND SP.name_id = PN.id           AND SP.evr_id = PE.id        )        MINUS        SELECT PN.id AS NAME_ID,               PE.id AS EVR_ID,               PN.name AS NAME,               PE.version AS VERSION,               PE.release AS RELEASE,               PE.epoch AS EPOCH,               PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS NVRE,               UPPER(PN.name || '-' || evr_t_as_vre_simple(PE.evr)) AS U_NVRE          FROM rhnPackageName PN,               rhnPackageEVR PE,               rhnPackage P,               rhnChannelPackage CP,               rhnSnapshotChannel SC         WHERE SC.snapshot_id = $1           AND SC.channel_id = CP.channel_id           AND CP.package_id = P.id           AND P.name_id = PN.id           AND P.evr_id = PE.id        ORDER BY 8
From: pedro109 at hotmail.com
To: spacewalk-list at redhat.com
Date: Fri, 22 Jul 2011 05:55:53 +0000
Subject: [Spacewalk-list] Error 500 on snapshots pages








Hello,On spacewalk 1.5 and postgresql 8.4 installation, when I go to Systems --> "SystemName" --> Provisionning --> Snapshots and the I click on any entry, I get the following traceback:
Error message:  RHN::Exception: DBD::Pg::st execute failed: ERROR:  syntax error at or near "MINUS" at character 869
  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::SystemSnapshot /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/SystemSnapshot.pm 164 RHN::DataSource::execute_query  Sniglets::Snapshot /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Snapshot.pm 119 RHN::DB::SystemSnapshot::package_list_is_servable  PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 160 Sniglets::Snapshot::snapshot_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)

I can modify whatever source you want to do some tests, it's just a test box, not a production one!
Thanks 		 	   		  

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110722/8baa14cf/attachment.htm>