java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
New commits:
commit febf23ac8a70de3168596092f0ce61669dc70824
Author: Jason Dobies <jason.dobies(a)redhat.com>
Date: Sun Aug 9 15:20:08 2009 -0400
Reapplying accidentally reverted commit: "Revert "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)""
This reverts commit b99539879ea94524505ffcfa912d2d6de7d23352.
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..7d94edf 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