Hello support,
I try to migrate the sonarqube v10.6 from centos7 with current projects to rocky8,
I copied the sonarqube folder from centos7 to rocky8 with same version of java, postgressql, sonar version and settings, and I can start the sonarqube on rocky8, but there is no projects showing, there is no errors showing on sonar logs,
I dump/imported the database to new postgressql, not working,
I replaced with the data folder of postgressql from centos7, not working,
please help,
Thanks,
Simon
Hi Simon,
You copied SonarQube over (it might have been better to re-explode the zip file, but okay). Does that mean you also copied the $SONARQUBE-HOME/conf/sonar.properties file so that the rocky8 instance points to the same DB the centos7 instance did?
If so you may need to force an ElasticSearch reindex.
HTH,
Ann
Thanks, Ann,
how to force the elasticsearch to reindex,
Thanks,
Simon
Hi Simon,
Did you check the link I posted?
Ann
Thanks, Ann,
here is I did, it’s stll shows no project list,
[root@rocky8-sonarqube ~]# systemctl stop sonar
[root@rocky8-sonarqube ~]# cd /opt/sonarqube/
bin/ data/ extensions/ lib/ temp/
conf/ elasticsearch/ jres/ logs/ web/
[root@rocky8-sonarqube ~]# cd /opt/sonarqube/data/
[root@rocky8-sonarqube data]# ll
total 135008
drwxr-xr-x. 4 sonar sonar 65 Sep 16 11:55 es8
-rw-r--r--. 1 sonar sonar 115 Jun 21 06:19 README.txt
-rw-r--r--. 1 sonar sonar 138244096 Sep 16 11:55 sonar.mv.db
drwxr-xr-x. 3 sonar sonar 20 Sep 13 11:14 web
[root@rocky8-sonarqube data]# cd es8
[root@rocky8-sonarqube es8]# ls
indices node.lock nodes _state
[root@rocky8-sonarqube es8]# ll
total 8
drwxr-xr-x. 8 sonar sonar 186 Sep 13 13:09 indices
-rw-r--r--. 1 sonar sonar 0 Sep 13 11:14 node.lock
-rw-r--r--. 1 sonar sonar 115 Sep 13 11:14 nodes
drwxr-xr-x. 2 sonar sonar 4096 Sep 13 14:39 _state
[root@rocky8-sonarqube es8]# mkdir /root/es8
[root@rocky8-sonarqube es8]# mv * /root/es8/
[root@rocky8-sonarqube es8]# ls
[root@rocky8-sonarqube es8]# systemctl start sonar
Hi Simon,
It’s time to back up and look at your DB.
First, can you verify that SonarQube is pointing at the right DB? Can you verify that your projects still exist in it?
Ann
I can access the db,
here is the project list:
sonar=# select * from projects;
uuid | kee | qualifier | name | descript
ion | private | tags | created_at | updated_at | ncloc | creation_method
----------------------+---------------------------------+-----------+---------------------+---------
----+---------+------+---------------+---------------+--------+-----------------
AXbYCV2qc2nwPHkupMUn | kulapix_us | TRK | Kulapix_3.2 |
| f | | 1609942261162 | 1717440503991 | 379053 | UNKNOWN
AXdkz-fT6QleRp3sbxJb | fin_cms | TRK | Fin_cms_2.6.1 |
| f | | 1612304082899 | 1717506955937 | 145711 | UNKNOWN
AYl5GM-5lJcL8wrO6Kfz | gam_videoconverter | TRK | video_converter 1.0 |
| f | | 1689953816505 | 1689954315232 | 347 | UNKNOWN
AXavZUaeLAFB8F01KJHm | phnx_walmart_digital_splashpage | TRK | WD_splash_page |
| f | | 1609260418718 | 1632336420576 | 598 | UNKNOWN
AXUs7t8kTlaNvcefcW6R | CodeIgniter_test | TRK | CodeIgniter_test |
| f | | 1602776653604 | 1602776653604 | 33967 | UNKNOWN
AXWZSJt8TlaNvcefcW6k | gam_vendor | TRK | gam_vendor |
| f | | 1604594473852 | 1604594473852 | 33321 | UNKNOWN
AXe2xKNQGNpLeWnoPSoG | fin_vendor | TRK | Fin Vendor 1.8 |
| f | | 1613679076176 | 1721305772443 | 39187 | UNKNOWN
AXWyuhioPWhF954bezKJ | phnx_walmart_digital | TRK | WD_3.8.1 |
| f | | 1605021341864 | 1721163132031 | 426077 | UNKNOWN
(8 rows)
sonar=#
and I stop the sonar and uncomment this line to point to the right db, start the sonar,
conf/sonar.properties.original:#sonar.jdbc.url=jdbc:sqlserver://localhost;databaseName=sonar
but after a few seconds, the sonar service went down,
ce.log:
2024.09.16 12:52:05 INFO ce[][o.s.p.ProcessEntryPoint] Gracefully stopping process
2024.09.16 12:52:05 INFO ce[][o.s.ce.app.CeServer] Compute Engine is stopping...
2024.09.16 12:52:05 INFO ce[][o.s.c.t.CeProcessingSchedulerImpl] Gracefully stopping workers
2024.09.16 12:52:05 INFO ce[][c.z.h.HikariDataSource] HikariPool-1 - Shutdown initiated...
2024.09.16 12:52:05 INFO ce[][c.z.h.HikariDataSource] HikariPool-1 - Shutdown completed.
2024.09.16 12:52:05 INFO ce[][o.s.ce.app.CeServer] Compute Engine is stopped
here is nohup.log:
[root@rocky8-sonarqube logs]# cat nohup.log
2024.09.16 12:59:11 INFO app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp
2024.09.16 12:59:11 INFO app[][o.s.a.es.EsSettings] Elasticsearch listening on [HTTP: 127.0.0.1:9001, TCP: 127.0.0.1:34247]
2024.09.16 12:59:12 INFO app[][o.s.a.ProcessLauncherImpl] Launch process[ELASTICSEARCH] from [/opt/sonarqube/elasticsearch]: /usr/lib/jvm/java-17-openjdk-17.0.12.0.7-2.el8.x86_64/bin/java -Xms4m -Xmx64m -XX:+UseSerialGC -Dcli.name=server -Dcli.script=./bin/elasticsearch -Dcli.libs=lib/tools/server-cli -Des.path.home=/opt/sonarqube/elasticsearch -Des.path.conf=/opt/sonarqube/temp/conf/es -Des.distribution.type=tar -cp /opt/sonarqube/elasticsearch/lib/*:/opt/sonarqube/elasticsearch/lib/cli-launcher/* org.elasticsearch.launcher.CliToolLauncher
2024.09.16 12:59:12 INFO app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2024.09.16 12:59:33 INFO app[][o.s.a.SchedulerImpl] Process[es] is up
2024.09.16 12:59:33 INFO app[][o.s.a.ProcessLauncherImpl] Launch process[WEB_SERVER] from [/opt/sonarqube]: /usr/lib/jvm/java-17-openjdk-17.0.12.0.7-2.el8.x86_64/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube/temp -XX:-OmitStackTraceInFastThrow --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED --add-exports=java.base/jdk.internal.ref=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/sun.nio.ch=ALL-UNNAMED --add-opens=java.management/sun.management=ALL-UNNAMED --add-opens=jdk.management/com.sun.management.internal=ALL-UNNAMED -server -Xms512m -Xmx512m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-10.6.0.92116.jar:/opt/sonarqube/lib/jdbc/postgresql/postgresql-42.7.3.jar org.sonar.server.app.WebServer /opt/sonarqube/temp/sq-process6535301574333666742properties
WARNING: A terminally deprecated method in java.lang.System has been called
WARNING: System::setSecurityManager has been called by org.sonar.process.PluginSecurityManager (file:/opt/sonarqube/lib/sonar-application-10.6.0.92116.jar)
WARNING: Please consider reporting this to the maintainers of org.sonar.process.PluginSecurityManager
WARNING: System::setSecurityManager will be removed in a future release
2024.09.16 13:00:08 INFO app[][o.s.a.SchedulerImpl] Process[Web Server] is stopped
2024.09.16 13:00:08 WARN app[][o.s.a.p.AbstractManagedProcess] Process exited with exit value [ElasticSearch]: 143
2024.09.16 13:00:08 INFO app[][o.s.a.SchedulerImpl] Process[ElasticSearch] is stopped
2024.09.16 13:00:08 INFO app[][o.s.a.SchedulerImpl] SonarQube is stopped
[root@rocky8-sonarqube logs]#
Hi,
What does web.log say?
Ann
Here is the web.log:
2024.09.16 12:59:55 INFO web[][o.s.s.p.UpdateCenterClient] Update center: https://downloads.sonarsource.com/sonarqube/update/update-center.properties
2024.09.16 12:59:57 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action saml/validation_init
2024.09.16 12:59:57 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/system/liveness
2024.09.16 12:59:57 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2024.09.16 12:59:57 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/analysis_cache/get
2024.09.16 12:59:57 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/check_pat
2024.09.16 12:59:57 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/push/sonarlint_events
2024.09.16 12:59:57 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/dismiss_message/check
2024.09.16 12:59:57 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/support/info
2024.09.16 12:59:57 WARN web[][o.s.s.p.d.CheckAnyonePermissionsAtStartup] Authentication is not enforced, and permissions assigned to the 'Anyone' group globally expose the instance to security risks. Unauthenticated visitors may unintentionally have permissions on projects.
2024.09.16 12:59:57 INFO web[][o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
2024.09.16 12:59:58 INFO web[][o.s.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
2024.09.16 12:59:59 INFO web[][o.s.s.s.RegisterMetrics] Register metrics
2024.09.16 12:59:59 INFO web[][o.s.s.q.RegisterQualityGates] Sonar way legacy Gate: org.sonar.db.qualitygate.QualityGateDto@46613b90
2024.09.16 12:59:59 INFO web[][o.s.s.r.r.RulesRegistrant] Register rules
2024.09.16 13:00:07 WARN web[][o.s.c.a.AnnotationConfigApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.server.rule.registration.RulesRegistrant': Initialization of bean failed; nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: mergejoin input data is out of order\n### The error may exist in org.sonar.db.rule.RuleMapper\n### The error may involve defaultParameterMap\n### The error occurred while setting parameters\n### SQL: select rdi.rule_uuid as "rdi_ruleUuid", rdi.software_quality as "rdi_softwareQuality", rdi.severity as "rdi_severity", CASE WHEN rt.is_system_tag = true THEN rt.value ELSE NULL END as rt_systemTags, CASE WHEN rt.is_system_tag = false THEN rt.value ELSE NULL END as rt_tags, rt.is_system_tag as "rt_isSystemTag", rt.value as "rt_value", rds.content as "rds_content", rds.uuid as "rds_uuid", rds.kee as "rds_kee", rds.context_key as "rds_contextKey", rds.context_display_name as "rds_contextDisplayName", r.uuid as "r_uuid", r.plugin_rule_key as "ruleKey", r.plugin_name as "repositoryKey", r.description_format as "descriptionFormat", r.status, r.name, r.plugin_config_key as "configKey", r.priority as "severity", r.is_template as "isTemplate", r.is_external as "isExternal", r.is_ad_hoc as "isAdHoc", r.language as "language", r.template_uuid as "templateUuid", r.def_remediation_function as "defRemediationFunction", r.def_remediation_gap_mult as "defRemediationGapMultiplier", r.def_remediation_base_effort as "defRemediationBaseEffort", r.gap_description as "gapDescription", r.security_standards as "securityStandardsField", r.rule_type as "type", r.plugin_key as "pluginKey", r.scope, r.created_at as "createdAt", r.updated_at as "updatedAt", r.note_data as "noteData", r.note_user_uuid as "noteUserUuid", r.note_created_at as "noteCreatedAt", r.note_updated_at as "noteUpdatedAt", r.remediation_function as "remediationFunction", r.remediation_gap_mult as "remediationGapMultiplier", r.remediation_base_effort as "remediationBaseEffort", r.ad_hoc_name as "adHocName", r.ad_hoc_description as "adHocDescription", r.ad_hoc_severity as "adHocSeverity", r.ad_hoc_type as "adHocType", r.education_principles as "educationPrinciplesField", r.clean_code_attribute as "cleanCodeAttribute" from rules r left outer join rule_desc_sections rds on rds.rule_uuid = r.uuid left outer join rules_default_impacts rdi on rdi.rule_uuid = r.uuid left outer join rule_tags rt on rt.rule_uuid = r.uuid order by r.uuid\n### Cause: org.postgresql.util.PSQLException: ERROR: mergejoin input data is out of order
2024.09.16 13:00:07 ERROR web[][o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.server.rule.registration.RulesRegistrant': Initialization of bean failed; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: mergejoin input data is out of order
### The error may exist in org.sonar.db.rule.RuleMapper
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select rdi.rule_uuid as "rdi_ruleUuid", rdi.software_quality as "rdi_softwareQuality", rdi.severity as "rdi_severity", CASE WHEN rt.is_system_tag = true THEN rt.value ELSE NULL END as rt_systemTags, CASE WHEN rt.is_system_tag = false THEN rt.value ELSE NULL END as rt_tags, rt.is_system_tag as "rt_isSystemTag", rt.value as "rt_value", rds.content as "rds_content", rds.uuid as "rds_uuid", rds.kee as "rds_kee", rds.context_key as "rds_contextKey", rds.context_display_name as "rds_contextDisplayName", r.uuid as "r_uuid", r.plugin_rule_key as "ruleKey", r.plugin_name as "repositoryKey", r.description_format as "descriptionFormat", r.status, r.name, r.plugin_config_key as "configKey", r.priority as "severity", r.is_template as "isTemplate", r.is_external as "isExternal", r.is_ad_hoc as "isAdHoc", r.language as "language", r.template_uuid as "templateUuid", r.def_remediation_function as "defRemediationFunction", r.def_remediation_gap_mult as "defRemediationGapMultiplier", r.def_remediation_base_effort as "defRemediationBaseEffort", r.gap_description as "gapDescription", r.security_standards as "securityStandardsField", r.rule_type as "type", r.plugin_key as "pluginKey", r.scope, r.created_at as "createdAt", r.updated_at as "updatedAt", r.note_data as "noteData", r.note_user_uuid as "noteUserUuid", r.note_created_at as "noteCreatedAt", r.note_updated_at as "noteUpdatedAt", r.remediation_function as "remediationFunction", r.remediation_gap_mult as "remediationGapMultiplier", r.remediation_base_effort as "remediationBaseEffort", r.ad_hoc_name as "adHocName", r.ad_hoc_description as "adHocDescription", r.ad_hoc_severity as "adHocSeverity", r.ad_hoc_type as "adHocType", r.education_principles as "educationPrinciplesField", r.clean_code_attribute as "cleanCodeAttribute" from rules r left outer join rule_desc_sections rds on rds.rule_uuid = r.uuid left outer join rules_default_impacts rdi on rdi.rule_uuid = r.uuid left outer join rule_tags rt on rt.rule_uuid = r.uuid order by r.uuid
### Cause: org.postgresql.util.PSQLException: ERROR: mergejoin input data is out of order
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:628)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:929)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:591)
at org.sonar.core.platform.SpringComponentContainer.startComponents(SpringComponentContainer.java:225)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:80)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup.access$001(PlatformLevelStartup.java:57)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1.doPrivileged(PlatformLevelStartup.java:132)
at org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:46)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup.start(PlatformLevelStartup.java:129)
at org.sonar.server.platform.PlatformImpl.executeStartupTasks(PlatformImpl.java:201)
at org.sonar.server.platform.PlatformImpl$AutoStarterRunnable.runIfNotAborted(PlatformImpl.java:362)
at org.sonar.server.platform.PlatformImpl$1.doRun(PlatformImpl.java:116)
at org.sonar.server.platform.PlatformImpl$AutoStarterRunnable.run(PlatformImpl.java:346)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: mergejoin input data is out of order
### The error may exist in org.sonar.db.rule.RuleMapper
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select rdi.rule_uuid as "rdi_ruleUuid", rdi.software_quality as "rdi_softwareQuality", rdi.severity as "rdi_severity", CASE WHEN rt.is_system_tag = true THEN rt.value ELSE NULL END as rt_systemTags, CASE WHEN rt.is_system_tag = false THEN rt.value ELSE NULL END as rt_tags, rt.is_system_tag as "rt_isSystemTag", rt.value as "rt_value", rds.content as "rds_content", rds.uuid as "rds_uuid", rds.kee as "rds_kee", rds.context_key as "rds_contextKey", rds.context_display_name as "rds_contextDisplayName", r.uuid as "r_uuid", r.plugin_rule_key as "ruleKey", r.plugin_name as "repositoryKey", r.description_format as "descriptionFormat", r.status, r.name, r.plugin_config_key as "configKey", r.priority as "severity", r.is_template as "isTemplate", r.is_external as "isExternal", r.is_ad_hoc as "isAdHoc", r.language as "language", r.template_uuid as "templateUuid", r.def_remediation_function as "defRemediationFunction", r.def_remediation_gap_mult as "defRemediationGapMultiplier", r.def_remediation_base_effort as "defRemediationBaseEffort", r.gap_description as "gapDescription", r.security_standards as "securityStandardsField", r.rule_type as "type", r.plugin_key as "pluginKey", r.scope, r.created_at as "createdAt", r.updated_at as "updatedAt", r.note_data as "noteData", r.note_user_uuid as "noteUserUuid", r.note_created_at as "noteCreatedAt", r.note_updated_at as "noteUpdatedAt", r.remediation_function as "remediationFunction", r.remediation_gap_mult as "remediationGapMultiplier", r.remediation_base_effort as "remediationBaseEffort", r.ad_hoc_name as "adHocName", r.ad_hoc_description as "adHocDescription", r.ad_hoc_severity as "adHocSeverity", r.ad_hoc_type as "adHocType", r.education_principles as "educationPrinciplesField", r.clean_code_attribute as "cleanCodeAttribute" from rules r left outer join rule_desc_sections rds on rds.rule_uuid = r.uuid left outer join rules_default_impacts rdi on rdi.rule_uuid = r.uuid left outer join rule_tags rt on rt.rule_uuid = r.uuid order by r.uuid
### Cause: org.postgresql.util.PSQLException: ERROR: mergejoin input data is out of order
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:156)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
at org.sonar.db.DbSessionImpl.selectList(DbSessionImpl.java:87)
at org.sonar.db.BatchSession.selectList(BatchSession.java:82)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
at jdk.proxy2/jdk.proxy2.$Proxy130.selectAll(Unknown Source)
at org.sonar.db.rule.RuleDao.selectAll(RuleDao.java:92)
at org.sonar.server.rule.registration.RulesRegistrationContext.create(RulesRegistrationContext.java:195)
at org.sonar.server.rule.registration.RulesRegistrant.start(RulesRegistrant.java:112)
at org.sonar.core.platform.StartableBeanPostProcessor.postProcessBeforeInitialization(StartableBeanPostProcessor.java:33)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
... 19 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: mergejoin input data is out of order
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:180)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80)
at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:94)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
... 35 common frames omitted
2024.09.16 13:00:07 INFO web[][o.s.p.ProcessEntryPoint] Hard stopping process
2024.09.16 13:00:07 INFO web[][o.s.s.n.NotificationDaemon] Notification service stopped
2024.09.16 13:00:08 INFO web[][c.z.h.HikariDataSource] HikariPool-1 - Shutdown initiated...
2024.09.16 13:00:08 INFO web[][c.z.h.HikariDataSource] HikariPool-1 - Shutdown completed.
[root@rocky8-sonarqube logs]#
Hi Simon,
There’s something strange going on with your DB. It’s time to start over on your centos7, 10.6 instance. Where does the database for that instance live? Hopefully on a different host. You should be able to do a fresh install - re-explode the zip and configure it by hand - and point it at your original DB.
HTH,
Ann
Here is the current working sonar VM:
[root@sonarqube sonarqube]# cat conf/sonar.properties | grep -v ‘#’ | grep sonar.jdbc.url
sonar.jdbc.url=jdbc:postgresql://localhost/sonar
[root@sonarqube sonarqube]# cat /etc/os-release | grep -i redhat
REDHAT_SUPPORT_PRODUCT=“centos”
REDHAT_SUPPORT_PRODUCT_VERSION=“7”
[root@sonarqube sonarqube]#
it is on a differetn host,
please guide me how to do a fresh install,
Thanks,
Simon
Thanks, Ann,
I will follow this url, and let you if any issues come up,
Thanks,
Simon
Hi Ann,
I started with new version v10.6.0, replaced with the working sonarqube folder and imported the database to postgresql, there were the projects showing, but the details are missing - such as Bugs, Vulnerabilities,
please help.
here is the web.log error:
2024.09.20 16:16:01 ERROR web[418fc640-8958-4b31-a27b-177cf8ed6531][o.s.s.w.WebServiceEngine] Fail to process request http://192.168.1.167/api/qualitygates/show?name=Sonar%20way
org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:81)
no other errors showing in other logs - ce. sonar, nohup or es
Thanks,
Simon
Hi Simon,
Let’s back up.
How is your CentOS7 instance running?
Ann
yes, the centos7 instance still running,
please guide me how to solve this project details are missing,
Thanks,
Simon
Hi,
Did you shut down the CentOS7 instance when you took the DB backup?
Ann
I turn off the sonar service, keep the postgresql running when I dump the database,