参照教程https://kubesphere.com.cn/docs/devops-user-guide/how-to-integrate/sonarqube/
kubectl get pod -n kubesphere-devops-system
NAME READY STATUS RESTARTS AGE
ks-jenkins-65db765f86-pjnt8 1/1 Running 0 2d22h
s2ioperator-0 1/1 Running 0 2d5h
sonarqube-postgresql-0 0/1 Pending 0 9m19s
sonarqube-sonarqube-544cd95ccd-pcln9 0/1 CrashLoopBackOff 6 9m19s
查看po d信息
kubectl -n kubesphere-devops-system logs -f sonarqube-sonarqube-544cd95ccd-pcln9
2021.07.30 07:26:19 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2021.07.30 07:26:19 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 8.2.0.32929 / ffde725e701a0acdc2bfac653743c4d91063cd45
2021.07.30 07:26:19 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:postgresql://sonarqube-postgresql:5432/sonarDB
2021.07.30 07:26:20 ERROR web[][o.s.s.p.PlatformImpl] Web server startup failed
java.lang.IllegalStateException: Fail to connect to database
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:87)
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:135)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:90)
at org.sonar.server.platform.platformlevel.PlatformLevel1.start(PlatformLevel1.java:164)
at org.sonar.server.platform.PlatformImpl.start(PlatformImpl.java:213)
at org.sonar.server.platform.PlatformImpl.startLevel1Container(PlatformImpl.java:172)
at org.sonar.server.platform.PlatformImpl.init(PlatformImpl.java:86)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4770)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5236)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1423)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1413)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.').
at org.sonar.db.DefaultDatabase.checkConnection(DefaultDatabase.java:119)
at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:84)
... 24 common frames omitted
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (Connection to sonarqube-postgresql:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:669)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:544)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:753)
at org.sonar.db.profiling.NullConnectionInterceptor.getConnection(NullConnectionInterceptor.java:31)
at org.sonar.db.profiling.ProfiledDataSource.getConnection(ProfiledDataSource.java:317)
at org.sonar.db.DefaultDatabase.checkConnection(DefaultDatabase.java:116)
... 25 common frames omitted
Caused by: org.postgresql.util.PSQLException: Connection to sonarqube-postgresql:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:280)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:458)
at org.postgresql.Driver.connect(Driver.java:260)
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:55)
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355)
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:115)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:665)
... 30 common frames omitted
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:75)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:91)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
... 38 common frames omitted
2021.07.30 07:26:20 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[_client_][[timer]]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.7/java.lang.Thread.sleep(Native Method)
app//org.elasticsearch.threadpool.ThreadPool$CachedTimeThread.run(ThreadPool.java:574)
2021.07.30 07:26:20 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[_client_][scheduler][T#1]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.7/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.7/java.util.concurrent.locks.LockSupport.parkNanos(Unknown Source)
java.base@11.0.7/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(Unknown Source)
java.base@11.0.7/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
java.base@11.0.7/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
java.base@11.0.7/java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
java.base@11.0.7/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.base@11.0.7/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.base@11.0.7/java.lang.Thread.run(Unknown Source)
2021.07.30 07:26:20 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[_client_][transport_worker][T#1]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.7/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.7/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.7/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.7/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)
app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)
app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)
app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)
java.base@11.0.7/java.lang.Thread.run(Unknown Source)
2021.07.30 07:26:20 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[_client_][generic][T#1]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.7/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.7/java.util.concurrent.locks.LockSupport.park(Unknown Source)
java.base@11.0.7/java.util.concurrent.LinkedTransferQueue.awaitMatch(Unknown Source)
java.base@11.0.7/java.util.concurrent.LinkedTransferQueue.xfer(Unknown Source)
java.base@11.0.7/java.util.concurrent.LinkedTransferQueue.take(Unknown Source)
java.base@11.0.7/java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
java.base@11.0.7/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.base@11.0.7/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.base@11.0.7/java.lang.Thread.run(Unknown Source)
2021.07.30 07:26:20 WARN web[][o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [elasticsearch[_client_][transport_worker][T#2]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.7/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.7/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.7/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.7/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//io.netty.channel.nio.SelectedSelectionKeySetSelector.select(SelectedSelectionKeySetSelector.java:62)
app//io.netty.channel.nio.NioEventLoop.select(NioEventLoop.java:765)
app//io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:413)
app//io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:909)
java.base@11.0.7/java.lang.Thread.run(Unknown Source)
2021.07.30 07:26:20 INFO web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2021.07.30 07:26:20 INFO web[][o.s.p.ProcessEntryPoint] Hard stopping process
2021.07.30 07:26:21 INFO app[][o.s.a.SchedulerImpl] Process[web] is stopped
2021.07.30 07:26:21 INFO app[][o.s.a.SchedulerImpl] Process[es] is stopped
2021.07.30 07:26:21 WARN app[][o.s.a.p.AbstractManagedProcess] Process exited with exit value [es]: 143
2021.07.30 07:26:21 INFO app[][o.s.a.SchedulerImpl] SonarQube is stopped
另一个po d信息
Events:
Type Reason Age From Message
---- ------ ---- ---- -------
Warning FailedScheduling 6m default-scheduler 0/3 nodes are available: 3 pod has unbound immediate PersistentVolumeClaims.
Warning FailedScheduling 6m default-scheduler 0/3 nodes are available: 3 pod has unbound immediate PersistentVolumeClaims.
卷信息
kubectl get pvc -n kubesphere-devops-system
NAME STATUS VOLUME CAPACITY ACCESS MODES STORAGECLASS AGE
data-sonarqube-postgresql-0 Pending alicloud-disk-efficiency 21m
ks-jenkins Bound d-bp1gua7r58h7bcz7sifm 20Gi RWO alicloud-disk-efficiency 2d23h
kubectl describe pvc data-sonarqube-postgresql-0 -n kubesphere-devops-system
Name: data-sonarqube-postgresql-0
Namespace: kubesphere-devops-system
StorageClass: alicloud-disk-efficiency
Status: Pending
Volume:
Labels: app=postgresql
release=sonarqube
role=master
Annotations: volume.beta.kubernetes.io/storage-provisioner: diskplugin.csi.alibabacloud.com
Finalizers: [kubernetes.io/pvc-protection]
Capacity:
Access Modes:
VolumeMode: Filesystem
Used By: sonarqube-postgresql-0
Events:
Type Reason Age From Message
---- ------ ---- ---- -------
Warning ProvisioningFailed 22m diskplugin.csi.alibabacloud.com_iZbp1iv19sp1mq5wgf03kyZ_35dc31a0-3832-4220-a0aa-ee5e7058aa8a failed to provision volume with StorageClass "alicloud-disk-efficiency": rpc error: code = Internal desc = SDK.ServerError
ErrorCode: InvalidDiskSize.NotSupported
Recommend: https://error-center.aliyun.com/status/search?Keyword=InvalidDiskSize.NotSupported&source=PopGw
RequestId: 54686268-7177-46AF-84DA-ADB959A6F98B
Message: disk size is not supported.
recommand: Please adjust the size of the cloud disk；
reference：https://help.aliyun.com/document_detail/25412.html
