Duplicate key ignore

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

anybody?

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

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