Why background tasks are taking too much time

amy · March 14, 2023, 11:00pm

Hello,
I’m using SonarQube 9.9 Developer Edition on kubernetes with sonar-helm-chart on the Stateful settings.
Most of the values in my helm chart are using default values except ingress, liveness,readness, database(I’m using external high performance mssql) settings.
Also I increased resources like 4CPU-8Ram which is double of the default.

My question is when I restart or change a configuration in my values.yaml it is stucking on below screen for a looong time(4hrs or more). It’s trying to fetch all the data from nothing…

How can I improve that side, I dont even know should I use a cache mechanism or volumes for making faster that reindexing…

the logs during that indexing:

2023-03-14 23:55:39	2023.03.14 22:55:39 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Persist measures | inserts=59 | status=SUCCESS | time=30ms
2023-03-14 23:55:39	2023.03.14 22:55:39 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Persist analysis properties | status=SUCCESS | time=18ms
2023-03-14 23:55:39	2023.03.14 22:55:39 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Persist analysis | status=SUCCESS | time=22ms
2023-03-14 23:55:39	2023.03.14 22:55:39 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Persist components | status=SUCCESS | time=287ms
2023-03-14 23:55:39	2023.03.14 22:55:39 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Persist scanner analysis cache | status=SUCCESS | time=33169ms
2023-03-14 23:55:06	2023.03.14 22:55:06 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Check upgrade possibility for not analyzed code files. | status=SUCCESS | time=1ms
2023-03-14 23:55:06	2023.03.14 22:55:06 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Generate Quality gate events | status=SUCCESS | time=17ms
2023-03-14 23:55:06	2023.03.14 22:55:06 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Generate Quality profile events | status=SUCCESS | time=14ms
2023-03-14 23:55:06	2023.03.14 22:55:06 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute Quality profile measures | status=SUCCESS | time=4ms
2023-03-14 23:55:06	2023.03.14 22:55:06 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute Quality Gate measures | status=SUCCESS | time=9ms
2023-03-14 23:55:06	2023.03.14 22:55:06 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Checks executed after computation of measures | status=SUCCESS | time=18ms
2023-03-14 23:55:06	2023.03.14 22:55:06 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Execute component visitors | status=SUCCESS | time=332245ms
2023-03-14 23:49:34	2023.03.14 22:49:34 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute Quality Profile status | status=SUCCESS | time=710ms
2023-03-14 23:49:33	2023.03.14 22:49:33 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Load measure computers | status=SUCCESS | time=0ms
2023-03-14 23:49:33	2023.03.14 22:49:33 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute complexity measures | status=SUCCESS | time=30ms
2023-03-14 23:49:33	2023.03.14 22:49:33 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute test measures | status=SUCCESS | time=16ms
2023-03-14 23:49:33	2023.03.14 22:49:33 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute language distribution | status=SUCCESS | time=38ms
2023-03-14 23:49:33	2023.03.14 22:49:33 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute size measures on new code | status=SUCCESS | time=14159ms
2023-03-14 23:49:19	2023.03.14 22:49:19 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute duplication measures | status=SUCCESS | time=416ms
2023-03-14 23:49:18	2023.03.14 22:49:18 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute comment measures | status=SUCCESS | time=24ms
2023-03-14 23:49:18	2023.03.14 22:49:18 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute coverage measures | status=SUCCESS | time=103ms
2023-03-14 23:49:18	2023.03.14 22:49:18 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute new coverage | status=SUCCESS | time=414374ms
2023-03-14 23:42:24	2023.03.14 22:42:24 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute size measures | status=SUCCESS | time=238ms
2023-03-14 23:42:23	2023.03.14 22:42:23 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Compute cross project duplications | status=SUCCESS | time=0ms
2023-03-14 23:42:23	2023.03.14 22:42:23 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Load duplications | duplications=67136 | status=SUCCESS | time=4427ms
2023-03-14 23:42:19	2023.03.14 22:42:19 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Detect file moves in Pull Request scope | status=SUCCESS | time=0ms
2023-03-14 23:42:19	2023.03.14 22:42:19 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Detect file moves | reportFiles=3555 | dbFiles=3555 | addedFiles=0 | status=SUCCESS | time=302ms
2023-03-14 23:42:19	2023.03.14 22:42:19 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Load new code period | status=SUCCESS | time=24ms
2023-03-14 23:42:19	2023.03.14 22:42:19 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Load Quality gate | status=SUCCESS | time=23ms
2023-03-14 23:42:19	2023.03.14 22:42:19 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Load file hashes and statuses | status=SUCCESS | time=543ms
2023-03-14 23:42:18	2023.03.14 22:42:18 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Load quality profiles | status=SUCCESS | time=891ms
2023-03-14 23:42:17	2023.03.14 22:42:17 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Validate project | status=SUCCESS | time=23ms
2023-03-14 23:42:17	2023.03.14 22:42:17 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Build tree of components | components=4720 | status=SUCCESS | time=365ms
2023-03-14 23:42:17	2023.03.14 22:42:17 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Initialize | status=SUCCESS | time=30ms
2023-03-14 23:42:17	2023.03.14 22:42:17 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Load analysis metadata | status=SUCCESS | time=31ms
2023-03-14 23:42:17	2023.03.14 22:42:17 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Generate analysis UUID | status=SUCCESS | time=0ms
2023-03-14 23:42:17	2023.03.14 22:42:17 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Propagate analysis warnings from scanner report | status=SUCCESS | time=21ms
2023-03-14 23:42:17	2023.03.14 22:42:17 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Persist scanner context | status=SUCCESS | time=23ms
2023-03-14 23:42:17	2023.03.14 22:42:17 INFO  ce[AYbhq4yKRqp1qREUPb3u][o.s.c.t.s.ComputationStepExecutor] Extract report | status=SUCCESS | time=52649ms
2023-03-14 23:41:24	2023.03.14 22:41:24 INFO  ce[][o.s.c.t.CeWorkerImpl] Execute task | project=cloud_frontend_horizon | type=REPORT | branch=develop | branchType=BRANCH | id=AYbhq4yKRqp1qREUPb3u | submitter=admin
2023-03-14 23:41:24	2023.03.14 22:41:24 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.CeWorkerImpl] Executed task | project=cloud_frontend_horizon | type=REPORT | pullRequest=2233 | id=AYbhlix-Rqp1qREUPb3o | submitter=admin | status=SUCCESS | time=11255ms
2023-03-14 23:41:24	2023.03.14 22:41:24 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.p.a.p.PostProjectAnalysisTasksExecutor] Pull Request decoration | status=SUCCESS | time=511ms
2023-03-14 23:41:24	2023.03.14 22:41:24 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.p.a.p.PostProjectAnalysisTasksExecutor] Report branch Quality Gate status to devops platforms | status=SUCCESS | time=0ms
2023-03-14 23:41:23	2023.03.14 22:41:23 INFO  ce[AYbhlix-Rqp1qREUPb3o][c.s.F.D.F.B] GitLab's instance URL from the scanner ('https://gitlab.lelyonline.com/api/v4') is overridden by the settings ('https://gitlab.lelyonline.com/api/v4')
2023-03-14 23:41:23	2023.03.14 22:41:23 INFO  ce[AYbhlix-Rqp1qREUPb3o][c.s.F.D.F.B] GitLab's project ID from the scanner ('2444') is overridden by the settings ('2444')
2023-03-14 23:41:23	2023.03.14 22:41:23 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.p.a.p.PostProjectAnalysisTasksExecutor] Webhooks | globalWebhooks=0 | projectWebhooks=0 | status=SUCCESS | time=14ms
2023-03-14 23:41:23	2023.03.14 22:41:23 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Trigger refresh of Portfolios and Applications | status=SUCCESS | time=0ms
2023-03-14 23:41:23	2023.03.14 22:41:23 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Publish task results | status=SUCCESS | time=0ms
2023-03-14 23:41:23	2023.03.14 22:41:23 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Send issue notifications | status=SUCCESS | time=0ms
2023-03-14 23:41:23	2023.03.14 22:41:23 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Publishing taint vulnerabilities events | status=SUCCESS | time=10ms
2023-03-14 23:41:23	2023.03.14 22:41:23 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Update need issue sync for branch | status=SUCCESS | time=18ms
2023-03-14 23:41:23	2023.03.14 22:41:23 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Index analysis | status=SUCCESS | time=1990ms
2023-03-14 23:41:21	2023.03.14 22:41:21 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Purge db | status=SUCCESS | time=1288ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Update last usage date of quality profiles | status=SUCCESS | time=18ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Enable analysis | status=SUCCESS | time=41ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist sources | status=SUCCESS | time=59ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist cross project duplications | status=SUCCESS | time=0ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist events | status=SUCCESS | time=24ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist project links | status=SUCCESS | time=0ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist issues | cacheSize=484 bytes | inserts=1 | updates=0 | merged=0 | status=SUCCESS | time=41ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Delete issue changes | changes=0 | status=SUCCESS | time=0ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist new ad hoc Rules | status=SUCCESS | time=0ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist duplication data | insertsOrUpdates=0 | status=SUCCESS | time=0ms
2023-03-14 23:41:20	2023.03.14 22:41:20 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist live measures | insertsOrUpdates=410 | status=SUCCESS | time=313ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist measures | inserts=58 | status=SUCCESS | time=38ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist analysis properties | status=SUCCESS | time=36ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist analysis | status=SUCCESS | time=16ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist components | status=SUCCESS | time=112ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Check upgrade possibility for not analyzed code files. | status=SUCCESS | time=0ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Persist scanner analysis cache | status=SUCCESS | time=0ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Generate Quality profile events | status=SUCCESS | time=10ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Generate Quality gate events | status=SUCCESS | time=0ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute Quality Gate measures | status=SUCCESS | time=11ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute Quality profile measures | status=SUCCESS | time=0ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Checks executed after computation of measures | status=SUCCESS | time=24ms
2023-03-14 23:41:19	2023.03.14 22:41:19 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Execute component visitors | status=SUCCESS | time=2743ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute Quality Profile status | status=SUCCESS | time=11ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Load measure computers | status=SUCCESS | time=0ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute complexity measures | status=SUCCESS | time=1ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute test measures | status=SUCCESS | time=0ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute size measures on new code | status=SUCCESS | time=0ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute language distribution | status=SUCCESS | time=0ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute duplication measures | status=SUCCESS | time=110ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute comment measures | status=SUCCESS | time=1ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute coverage measures | status=SUCCESS | time=170ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute new coverage | status=SUCCESS | time=2ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute size measures | status=SUCCESS | time=3ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Compute cross project duplications | status=SUCCESS | time=0ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Load duplications | duplications=1739 | status=SUCCESS | time=218ms
2023-03-14 23:41:16	2023.03.14 22:41:16 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Detect file moves in Pull Request scope | reportFiles=3 | dbFiles=3555 | movedFiles=0 | addedFiles=3 | status=SUCCESS | time=298ms
2023-03-14 23:41:15	2023.03.14 22:41:15 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Detect file moves | status=SUCCESS | time=0ms
2023-03-14 23:41:15	2023.03.14 22:41:15 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Load new code period | status=SUCCESS | time=0ms
2023-03-14 23:41:15	2023.03.14 22:41:15 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Load Quality gate | status=SUCCESS | time=34ms
2023-03-14 23:41:15	2023.03.14 22:41:15 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Load file hashes and statuses | status=SUCCESS | time=10ms
2023-03-14 23:41:15	2023.03.14 22:41:15 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Load quality profiles | status=SUCCESS | time=897ms
2023-03-14 23:41:14	2023.03.14 22:41:14 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Validate project | status=SUCCESS | time=29ms
2023-03-14 23:41:14	2023.03.14 22:41:14 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Build tree of components | components=7 | status=SUCCESS | time=303ms
2023-03-14 23:41:14	2023.03.14 22:41:14 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Initialize | status=SUCCESS | time=31ms
2023-03-14 23:41:14	2023.03.14 22:41:14 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Load analysis metadata | status=SUCCESS | time=19ms
2023-03-14 23:41:14	2023.03.14 22:41:14 INFO  ce[AYbhlix-Rqp1qREUPb3o][o.s.c.t.s.ComputationStepExecutor] Generate analysis UUID | status=SUCCESS | time=0ms

ganncamp · March 15, 2023, 6:46pm

Hi,

Your log excerpt seems mainly to reflect project analysis. I suppose reindexing is prioritized below that.

In terms of how you can avoid long startup / reindexing times, the answer is to point your Elasticsearch indices to external, persistent volumes. Then they won’t need to be rebuilt with each restart.

Per the docs

as Elasticsearch is stateful, so is SonarQube. There is an option to persist the Elasticsearch indexes in a Persistent Volume, but with regular killing operations by the Kubernetes Cluster, these indexes can be corrupted. By default, persistency is disabled in the Helm chart.

Enabling persistency decreases the startup time of the SonarQube Pod significantly, but you are risking corrupting your Elasticsearch index.

HTH,
Ann

amy · March 16, 2023, 11:01am

Hi,

Thanks for answering. After your response I realized there is some errors on elasticsearch stateful set. it couldnt start the initsysctl because of the sysctl -w vm.max_map_count=262144 command.

I think that is the problem.

As far as I understand this elsaticsearch statefulset should be up an healthy right ? it is directly affecting the startup of the application… Because I’ve ignored it because of some securityContext issues.

ganncamp · March 16, 2023, 12:46pm

Hi,

I don’t have a background in kubernetes, but yes all three processes need to be up and running.

Ann

system · March 23, 2023, 12:46pm

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Slow background tasks process - Persist issues SonarQube Server / Community Build	2	1349	June 18, 2021
Background task time different with same project but different instances SonarQube Server / Community Build java	5	143	May 29, 2024
SonarQube Background Tasks are taking long SonarQube Server / Community Build background_task	3	614	January 18, 2024
100x slower background task after upgrade to 9.9 SonarQube Server / Community Build sonarqube , background_task	7	513	August 9, 2023
SonarQube Background Tasks Que SonarQube Server / Community Build	6	808	November 1, 2021

Why background tasks are taking too much time

Related topics