From 7275c439ba18a33694ea41c97dce40ac0e84fcd5 Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Fri, 23 Mar 2018 09:26:37 +0100 Subject: [PATCH] SONAR-10505 CE processes analysis report slowly when millions of issues --- .../sonar/server/issue/index/IssueIteratorForSingleChunk.java | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/server/sonar-server/src/main/java/org/sonar/server/issue/index/IssueIteratorForSingleChunk.java b/server/sonar-server/src/main/java/org/sonar/server/issue/index/IssueIteratorForSingleChunk.java index ee1ec7950a9..352b347aafe 100644 --- a/server/sonar-server/src/main/java/org/sonar/server/issue/index/IssueIteratorForSingleChunk.java +++ b/server/sonar-server/src/main/java/org/sonar/server/issue/index/IssueIteratorForSingleChunk.java @@ -84,7 +84,7 @@ class IssueIteratorForSingleChunk implements IssueIterator { "inner join rules r on r.id = i.rule_id " + "inner join projects c on c.uuid = i.component_uuid "; - private static final String PROJECT_FILTER = " and c.project_uuid = ?"; + private static final String PROJECT_FILTER = " and c.project_uuid = ? and i.project_uuid = ? "; private static final String ISSUE_KEY_FILTER_PREFIX = " and i.kee in ("; private static final String ISSUE_KEY_FILTER_SUFFIX = ")"; @@ -155,6 +155,8 @@ class IssueIteratorForSingleChunk implements IssueIterator { if (projectUuid != null) { stmt.setString(index, projectUuid); index++; + stmt.setString(index, projectUuid); + index++; } if (issueKeys != null) { for (String key : issueKeys) { -- 2.39.5