java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
New commits:
commit cfbce1140e14455b2f2a4ff74015b5136774fbb7
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Fri Aug 7 17:03:26 2009 -0400
478397 - fixing issue where rhnpush would schedule a taskomatic task to regenerate
needed cache and was using a query that didnt generate for all channels (even though it
was deleting from all channels)
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml
index c8efb65..19b6464 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml
@@ -124,7 +124,8 @@ INSERT INTO rhnServerNeededCache
(server_id, package_id, errata_id)
(SELECT DISTINCT SNV.server_id, SNV.package_id, SNV.errata_id
FROM rhnServerNeededView SNV
- WHERE SNV.channel_id = :channel_id)
+ WHERE SNV.server_id in (select SC.server_id from rhnServerChannel SC
+ where SC.channel_id = :channel_id ))
</query>
</write-mode>
Show replies by date