Duplicate key ignore

SonarQube Server / Community Build
1

Hello, community
I am trying to move our old setup from cloud to On-prem.
We have this version of Sonar:
SonarQube Server / 8.9.0.43852
and this Postgresql - server 10.23
I’ve made a copy of database and uploaded it into new server.
But when I am trying to start the server it fails with:

2024.01.29 18:28:45 ERROR web[][o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
java.lang.IllegalArgumentException: Duplicate key ignore
	at org.sonar.core.util.stream.MoreCollectors.putAndFailOnDuplicateKey(MoreCollectors.java:299)
	at org.sonar.core.util.stream.MoreCollectors.lambda$uniqueIndex$9(MoreCollectors.java:260)
	at java.base/java.util.stream.ReduceOps$3ReducingSink.accept(ReduceOps.java:169)
	at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
	at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
	at org.sonar.server.qualityprofile.RuleActivationContext$ActiveRuleWrapper.<init>(RuleActivationContext.java:346)
	at org.sonar.server.qualityprofile.RuleActivationContext$ActiveRuleWrapper.<init>(RuleActivationContext.java:340)
	at org.sonar.server.qualityprofile.RuleActivationContext.register(RuleActivationContext.java:107)
	at org.sonar.server.qualityprofile.RuleActivationContext.<init>(RuleActivationContext.java:92)
	at org.sonar.server.qualityprofile.RuleActivationContext.<init>(RuleActivationContext.java:53)
	at org.sonar.server.qualityprofile.RuleActivationContext$Builder.build(RuleActivationContext.java:307)
	at org.sonar.server.qualityprofile.RuleActivator.createContextForBuiltInProfile(RuleActivator.java:375)
	at org.sonar.server.qualityprofile.BuiltInQProfileUpdateImpl.update(BuiltInQProfileUpdateImpl.java:70)
	at org.sonar.server.qualityprofile.RegisterQualityProfiles.update(RegisterQualityProfiles.java:132)
	at org.sonar.server.qualityprofile.RegisterQualityProfiles.lambda$start$1(RegisterQualityProfiles.java:93)
	at com.google.common.collect.ImmutableList.forEach(ImmutableList.java:405)
	at org.sonar.server.qualityprofile.RegisterQualityProfiles.start(RegisterQualityProfiles.java:88)
	at org.sonar.core.platform.StartableCloseableSafeLifecyleStrategy.start(StartableCloseableSafeLifecyleStrategy.java:40)
	at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84)
	at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169)
	at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132)
	at org.picocontainer.behaviors.Stored.start(Stored.java:110)
	at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1016)
	at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1009)
	at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:767)
	at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:136)
	at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:90)
	at org.sonar.server.platform.platformlevel.PlatformLevelStartup.access$001(PlatformLevelStartup.java:49)
	at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1.doPrivileged(PlatformLevelStartup.java:87)
	at org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:45)
	at org.sonar.server.platform.platformlevel.PlatformLevelStartup.start(PlatformLevelStartup.java:84)
	at org.sonar.server.platform.PlatformImpl.executeStartupTasks(PlatformImpl.java:198)
	at org.sonar.server.platform.PlatformImpl.access$400(PlatformImpl.java:46)
	at org.sonar.server.platform.PlatformImpl$1.lambda$doRun$1(PlatformImpl.java:122)
	at org.sonar.server.platform.PlatformImpl$AutoStarterRunnable.runIfNotAborted(PlatformImpl.java:370)
	at org.sonar.server.platform.PlatformImpl$1.doRun(PlatformImpl.java:122)
	at org.sonar.server.platform.PlatformImpl$AutoStarterRunnable.run(PlatformImpl.java:354)
	at java.base/java.lang.Thread.run(Thread.java:829)

I’ve searched, and found in one answer here, that the reason could be the duplicates in table rules_profiles, but there are no duplicates, table reads:

         name          | language |     rules_updated_at     |       created_at        |       updated_at        | is_built_in |         uuid         
-----------------------+----------+--------------------------+-------------------------+-------------------------+-------------+----------------------
 Sonar way             | ruby     | 2021-05-24T09:29:03+0000 | 2020-01-23 14:37:38.941 | 2021-05-24 12:29:03.639 | t           | AXmdtBh5IEzKYhSbGkTC
 Sonar way recommended | ts       | 2021-05-24T09:06:30+0000 | 2020-01-23 14:37:40.278 | 2021-05-24 12:06:30.741 | t           | AXmdtBh5IEzKYhSbGkTP
 Sonar way             | web      | 2021-05-24T09:29:04+0000 | 2020-01-23 14:37:39.603 | 2021-05-24 12:29:04.247 | t           | AXmdtBh5IEzKYhSbGkTR
 Sonar way             | flex     | 2021-05-24T09:29:04+0000 | 2020-01-23 14:37:39.785 | 2021-05-24 12:29:04.309 | t           | AXmdtBh5IEzKYhSbGkTE
 Sonar way             | css      | 2021-05-24T09:29:02+0000 | 2020-01-23 14:37:38.063 | 2021-05-24 12:29:02.916 | t           | AXmdtBh5IEzKYhSbGkTK
 Sonar way             | scala    | 2021-05-24T09:29:03+0000 | 2020-01-23 14:37:38.268 | 2021-05-24 12:29:03.018 | t           | AXmdtBh5IEzKYhSbGkS_
 Sonar way             | kotlin   | 2021-05-24T09:29:03+0000 | 2020-01-23 14:37:38.372 | 2021-05-24 12:29:03.096 | t           | AXmdtBh5IEzKYhSbGkTB
 Sonar way             | xml      | 2021-05-24T09:29:04+0000 | 2020-01-23 14:37:39.713 | 2021-05-24 12:29:04.364 | t           | AXmdtBh5IEzKYhSbGkTD
 Sonar way             | jsp      | 2020-01-23T12:37:38+0000 | 2020-01-23 14:37:38.368 | 2020-01-23 14:37:38.368 | t           | AXmdtBh5IEzKYhSbGkTA
 Sonar way             | go       | 2021-05-24T09:29:03+0000 | 2020-01-23 14:37:38.454 | 2021-05-24 12:29:03.147 | t           | AXmdtBh5IEzKYhSbGkTO
 Drupal                | php      | 2020-01-23T12:37:40+0000 | 2020-01-23 14:37:40.047 | 2020-01-23 14:37:40.047 | t           | AXmdtBh5IEzKYhSbGkTG
 Sonar way             | vbnet    | 2021-05-24T09:29:04+0000 | 2020-01-23 14:37:40.112 | 2021-05-24 12:29:04.614 | t           | AXmdtBh5IEzKYhSbGkTJ
 Sonar way             | cs       | 2021-05-24T09:29:03+0000 | 2020-01-23 14:37:39.012 | 2021-05-24 12:29:03.796 | t           | AXmdtBh5IEzKYhSbGkTS
 Sonar way             | js       | 2021-05-24T09:29:03+0000 | 2020-01-23 14:37:38.726 | 2021-05-24 12:29:03.339 | t           | AXmdtBh5IEzKYhSbGkTL
 Sonar way             | py       | 2021-05-24T09:29:03+0000 | 2020-01-23 14:37:38.857 | 2021-05-24 12:29:03.555 | t           | AXmdtBh5IEzKYhSbGkTN
 Sonar way             | java     | 2021-05-24T09:29:03+0000 | 2020-01-23 14:37:39.198 | 2021-05-24 12:29:04.12  | t           | AXmdtBh5IEzKYhSbGkTQ

could you please give me an advice on what am I missing?
I don’t know much about sonar, sorry
thank you

2

anybody?

3

Hi,

Your version is past EOL. You should upgrade to either the latest version or the current LTS at your earliest convenience. Your upgrade path is:

8.9.0 → 9.9.3 → 10.3 (last step optional)

You may find these resources helpful:

If you have questions about upgrading, feel free to open a new thread for that here.

Regarding your question, start by making sure to match version numbers on the source and destination SonarQube instances, then if there’s still a problem, I’d start with a fresh DB backup. Once you get your new instance up and running, proceed with your upgrade to a supported version.

 
HTH,
Ann

4

well, it’s ok, but I don’t really want to upgrade it now. all i want is to move my current installation to a new server