which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
v5.6.6
what are you trying to achieve
We are trying to upgrade to the Sonarqube version from v5.6.6 to v6.7.6.
what have you tried so far to achieve this
Steps followed:
We tried to upgrade sonarqube from version v5.6.6 --> v6.7.6 but ran into below mentioned error after 30 - 45 mins when I start the upgrade activity.
Sonar.log:
2019.04.23 23:02:07 DEBUG app[o.e.c.t.TransportClientNodesService] failed to connect to node [{#transport#-1}{OLD6OD2iSES5EnwzAsberA}{127.0.0.1}{127.0.0.1:9001}], ignoring…
org.elasticsearch.transport.ConnectTransportException: [127.0.0.1:9001] connect_timeout[30s]
at org.elasticsearch.transport.netty4.Netty4Transport.connectToChannels(Netty4Transport.java:362)
at org.elasticsearch.transport.TcpTransport.openConnection(TcpTransport.java:570)
at org.elasticsearch.transport.TcpTransport.openConnection(TcpTransport.java:117)
at org.elasticsearch.transport.TransportService.openConnection(TransportService.java:351)
at org.elasticsearch.client.transport.TransportClientNodesService$SimpleNodeSampler.doSample(TransportClientNodesService.java:407)
at org.elasticsearch.client.transport.TransportClientNodesService$NodeSampler.sample(TransportClientNodesService.java:357)
at org.elasticsearch.client.transport.TransportClientNodesService.addTransportAddresses(TransportClientNodesService.java:198)
at org.elasticsearch.client.transport.TransportClient.addTransportAddress(TransportClient.java:319)
at org.sonar.application.process.EsProcessMonitor.addHostToClient(EsProcessMonitor.java:186)
at org.sonar.application.process.EsProcessMonitor.buildTransportClient(EsProcessMonitor.java:177)
at org.sonar.application.process.EsProcessMonitor.getTransportClient(EsProcessMonitor.java:160)
at org.sonar.application.process.EsProcessMonitor.checkStatus(EsProcessMonitor.java:134)
at org.sonar.application.process.EsProcessMonitor.checkOperational(EsProcessMonitor.java:93)
at org.sonar.application.process.EsProcessMonitor.isOperational(EsProcessMonitor.java:78)
at org.sonar.application.process.SQProcess.refreshState(SQProcess.java:161)
at org.sonar.application.process.SQProcess$EventWatcher.run(SQProcess.java:220)
Caused by: io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: /127.0.0.1:9001
Web.log:
2019.04.23 23:06:41 INFO web[DbMigrations] #1207 ‘Drop unused columns on PROJECT_MEASURES’…
2019.04.23 23:23:16 WARN web[o.s.p.ProcessEntryPoint] Fail to start web
java.lang.IllegalArgumentException: Unable to create shared memory :
at org.sonar.process.sharedmemoryfile.AllProcessesCommands.(AllProcessesCommands.java:100)
at org.sonar.process.sharedmemoryfile.DefaultProcessCommands.(DefaultProcessCommands.java:34)
at org.sonar.process.sharedmemoryfile.DefaultProcessCommands.secondary(DefaultProcessCommands.java:52)
at org.sonar.server.app.WebServer.isOperational(WebServer.java:68)
at org.sonar.server.app.WebServer.getStatus(WebServer.java:60)
at org.sonar.process.ProcessEntryPoint.waitForOperational(ProcessEntryPoint.java:145)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:120)
at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:100)
at org.sonar.server.app.WebServer.main(WebServer.java:91)
Caused by: java.io.FileNotFoundException: /data/sonarqube-6.7.6/temp/sharedmemory (Too many open files in system)
at java.io.RandomAccessFile.open0(Native Method)
at java.io.RandomAccessFile.open(RandomAccessFile.java:316)
at java.io.RandomAccessFile.(RandomAccessFile.java:243)
at org.sonar.process.sharedmemoryfile.AllProcessesCommands.(AllProcessesCommands.java:97)
… 8 common frames omitted
Thanks for including both log errors in your first post!
Here’s your problem:
You should look at upping your file handle limit. The error in the ES log is in this case a red herring; the nodes keep up with each other, and when one (in this case the web node) shuts down the others follow to not leave you with a zombie instance.
Even we tried to set ulimit -u value as 4096 and unlimit but we ran with same error and please find the es.log detail as i dont see any errors
Worst case, we need to populate the sonar dump each time its getting failed otherwise if we tried to reinitiate we ran with db errors as “Caused by: java.lang.IllegalStateException: Fail to execute ALTER TABLE project_measures DROP COLUMN rules_category_id, DROP COLUMN tendency, DROP COLUMN measure_date, DROP COLUMN url, DROP COLUMN rule_priority, DROP COLUMN characteristic_id, DROP COLUMN rule_id”
Thank you Ann for your response! Just in curios of asking is there any chance of supporting Oracle database for community version post 6.7.6 version as MySQL is no longer supported post 7.9 version