Must-share information (formatted with Markdown):
- which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
- Sonarqube 7.4
Plugins :
- qualinsight-sonarqube-smell-plugin-4.0.0.jar
- sonar-findbugs-plugin-3.9.1.jar
- sonar-java-plugin-4.14.0.11784.jar
- sonar-ldap-plugin-2.2.0.608.jar
- sonar-motion-chart-plugin-1.7.jar
- sonar-php-plugin-2.11.0.2485.jar
- sonar-scm-git-plugin-1.2.jar
- sonar-scm-svn-plugin-1.9.0.1295.jar
- sonar-tab-metrics-plugin-1.4.1.jar
- sonar-timeline-plugin-1.5.jar
jdbc-driver/oracle
- ojdbc8-12.2.0.1.jar
-
what are you trying to achieve
start sonarqube after upgrade from 6.7.6 to 7.4 -
what have you tried so far to achieve this
- update all plugins
- remove all plugins not necessary
The log from sonar.log and web.log
==> /usr/local/apps/sonar/logs/sonar.log <==
2018.12.05 14:48:46 INFO app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /usr/local/apps/sonar/sonarqube-7.4/temp
2018.12.05 14:48:46 INFO app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2018.12.05 14:48:46 INFO app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/usr/local/apps/sonar/sonarqube-7.4/elasticsearch]: /usr/local/apps/sonar/sonarqube-7.4/elasticsearch/bin/elasticsearch -Epath.conf=/usr/local/apps/sonar/sonarqube-7.4/temp/conf/es
2018.12.05 14:48:46 INFO app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2018.12.05 14:48:46 INFO app[][o.e.p.PluginsService] no modules loaded
2018.12.05 14:48:46 INFO app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2018.12.05 14:48:54 INFO app[][o.s.a.SchedulerImpl] Process[es] is up
2018.12.05 14:48:54 INFO app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [/usr/local/apps/sonar/sonarqube-7.4]: /usr/local/apps/java/jdk1.8.0_162/jre/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/usr/local/apps/sonar/sonarqube-7.4/temp -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -cp ./lib/common/*:/usr/local/apps/sonar/sonarqube-7.4/extensions/jdbc-driver/oracle/ojdbc8-12.2.0.1.jar org.sonar.server.app.WebServer /usr/local/apps/sonar/sonarqube-7.4/temp/sq-process985978715529056760properties
==> /usr/local/apps/sonar/logs/web.log <==
2018.12.05 14:48:54 INFO web[][o.s.p.ProcessEntryPoint] Starting web
2018.12.05 14:48:54 INFO web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2018.12.05 14:48:55 INFO web[][o.s.c.e.CoreExtensionsLoader] Loaded core extensions:
2018.12.05 14:48:55 INFO web[][o.e.p.PluginsService] no modules loaded
2018.12.05 14:48:55 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2018.12.05 14:48:55 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2018.12.05 14:48:55 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2018.12.05 14:48:56 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2018.12.05 14:48:56 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.4.0.18908 / a4d0983e8057356b19996995343296311fbcc2ed
2018.12.05 14:48:56 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:oracle:thin:@//dbint_tech:1521/dbint_tech
2018.12.05 14:49:18 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /usr/local/apps/sonar/sonarqube-7.4
2018.12.05 14:49:18 INFO web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2018.12.05 14:49:18 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin LDAP / 2.2.0.608 / 79dc3fa4393a29667673c70182f3016288b548b7
2018.12.05 14:49:18 INFO web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.ws.WebServiceFilter@3909d92a [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, ...], exclusions=[/api/properties*, ...]}]
2018.12.05 14:49:18 INFO web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2018.12.05 14:49:19 INFO web[][o.s.s.p.UpdateCenterClient] Update center: https://update.sonarsource.org/update-center.properties (no proxy)
2018.12.05 14:49:20 INFO web[][o.s.s.s.LogServerId] Server ID: 848B782B-AVvOz9nWNwjc42IGJq2e
2018.12.05 14:49:20 INFO web[][org.sonar.INFO] Security realm: LDAP
2018.12.05 14:49:20 INFO web[][o.s.p.l.LdapSettingsManager] User mapping: LdapUserMapping{baseDn=OU=Utilisateurs,DC=xxx,DC=xxx, request=(&(objectClass=user)(sAMAccountName={0})), realNameAttribute=cn, emailAttribute=mail}
2018.12.05 14:49:20 INFO web[][o.s.p.l.LdapSettingsManager] Groups will not be synchronized, because property 'ldap.group.baseDn' is empty.
2018.12.05 14:49:20 INFO web[][o.s.p.l.LdapContextFactory] Test LDAP connection on ldap://ldap1:389: OK
2018.12.05 14:49:20 INFO web[][org.sonar.INFO] Security realm started
2018.12.05 14:49:20 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2018.12.05 14:49:20 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/permissions/search_templates
2018.12.05 14:49:20 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/security_reports/show
2018.12.05 14:49:20 INFO web[][o.s.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
2018.12.05 14:49:20 INFO web[][o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
2018.12.05 14:49:20 INFO web[][o.s.s.s.GeneratePluginIndex] Generate scanner plugin index
2018.12.05 14:49:20 INFO web[][o.s.s.s.RegisterPlugins] Register plugins
2018.12.05 14:49:20 INFO web[][o.s.s.s.RegisterMetrics] Register metrics
2018.12.05 14:49:20 ERROR web[][o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.sql.SQLException: Invalid argument(s) in call
### SQL: INSERT INTO metrics ( name, description, direction, domain, short_name, qualitative, val_type, user_managed, enabled, worst_value, best_value, optimized_best_value, hidden, delete_historical_data, decimal_scale) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: Invalid argument(s) in call
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy26.insert(Unknown Source)
at org.sonar.db.metric.MetricDao.insert(MetricDao.java:84)
at org.sonar.server.startup.RegisterMetrics.save(RegisterMetrics.java:91)
at org.sonar.server.startup.RegisterMetrics.register(RegisterMetrics.java:69)
at org.sonar.server.startup.RegisterMetrics.start(RegisterMetrics.java:63)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110)
at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89)
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:135)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:90)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup.access$001(PlatformLevelStartup.java:46)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1.doPrivileged(PlatformLevelStartup.java:82)
at org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:46)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup.start(PlatformLevelStartup.java:79)
at org.sonar.server.platform.Platform.executeStartupTasks(Platform.java:196)
at org.sonar.server.platform.Platform.access$400(Platform.java:46)
at org.sonar.server.platform.Platform$1.lambda$doRun$1(Platform.java:121)
at org.sonar.server.platform.Platform$AutoStarterRunnable.runIfNotAborted(Platform.java:371)
at org.sonar.server.platform.Platform$1.doRun(Platform.java:121)
at org.sonar.server.platform.Platform$AutoStarterRunnable.run(Platform.java:355)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Invalid argument(s) in call
at oracle.jdbc.driver.AutoKeyInfo.getNewSql(AutoKeyInfo.java:187)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:4342)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:771)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:771)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:82)
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
at org.apache.ibatis.executor.ReuseExecutor.prepareStatement(ReuseExecutor.java:89)
at org.apache.ibatis.executor.ReuseExecutor.doUpdate(ReuseExecutor.java:51)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
... 34 common frames omitted
2018.12.05 14:49:21 INFO web[][o.s.p.StopWatcher] Stopping process
==> /usr/local/apps/sonar/logs/sonar.log <==
2018.12.05 14:49:24 INFO app[][o.s.a.SchedulerImpl] Process [web] is stopped
2018.12.05 14:49:24 INFO app[][o.s.a.SchedulerImpl] Process [es] is stopped
2018.12.05 14:49:24 WARN app[][o.s.a.p.AbstractProcessMonitor] Process exited with exit value [es]: 143
2018.12.05 14:49:24 INFO app[][o.s.a.SchedulerImpl] SonarQube is stopped
<-- Wrapper Stopped
I had the same problem after upgrade from 6.5 to 6.7.6.
The problem was plugins. I go back to old versions from some plugins and that resolve problem. But nothings works with the version 7.4.
Can you help me please ?
Regards,
Serdar