SCA-239 purge sca issues releases changes tableHEADmaster

2 files changed, 11 insertions, 2 deletions

diff --git a/server/sonar-db-dao/src/main/java/org/sonar/db/purge/PurgeCommands.java b/server/sonar-db-dao/src/main/java/org/sonar/db/purge/PurgeCommands.java
index d818e2361cf..fca991f9f28 100644
--- a/server/sonar-db-dao/src/main/java/org/sonar/db/purge/PurgeCommands.java
+++ b/server/sonar-db-dao/src/main/java/org/sonar/db/purge/PurgeCommands.java
@@ -543,6 +543,13 @@ class PurgeCommands {
     session.commit();
     profiler.stop();
 
+    // this must be done before deleting sca_issues_releases or we won't
+    // be able to find the rows
+    profiler.start("deleteScaIssuesReleasesChanges (sca_issue_rels_changes)");
+    purgeMapper.deleteScaIssuesReleasesChangesByComponentUuid(componentUuid);
+    session.commit();
+    profiler.stop();
+
     profiler.start("deleteScaIssuesReleases (sca_issues_releases)");
     purgeMapper.deleteScaIssuesReleasesByComponentUuid(componentUuid);
     session.commit();
diff --git a/server/sonar-db-dao/src/main/java/org/sonar/db/purge/PurgeMapper.java b/server/sonar-db-dao/src/main/java/org/sonar/db/purge/PurgeMapper.java
index 2502ac8e5d8..ab4b369aef6 100644
--- a/server/sonar-db-dao/src/main/java/org/sonar/db/purge/PurgeMapper.java
+++ b/server/sonar-db-dao/src/main/java/org/sonar/db/purge/PurgeMapper.java
@@ -201,9 +201,11 @@ public interface PurgeMapper {
 
   void deleteScaIssuesReleasesByComponentUuid(@Param("componentUuid") String componentUuid);
 
-  void deleteScaReleasesByComponentUuid(@Param("componentUuid") String componentUuid);
+  void deleteScaIssuesReleasesChangesByComponentUuid(@Param("componentUuid") String componentUuid);
 
-  void deleteArchitectureGraphsByBranchUuid(@Param("branchUuid") String branchUuid);
+  void deleteScaReleasesByComponentUuid(@Param("componentUuid") String componentUuid);
 
   void deleteScaLicenseProfileProjectsByProjectUuid(@Param("projectUuid") String projectUuid);
+
+  void deleteArchitectureGraphsByBranchUuid(@Param("branchUuid") String branchUuid);
 }