LTS upgrade to v2025.1.2 failed with elastic search bulk index

SonarQube Server / Community Build
1

Hi Sonar community,
I am upgrading 9.9 LTS to 2025.1.2 LTS. The upgrade went well when I tested in staging environment. I have faced issue during prod upgrade. The issue was elastic search bulk index getting timed out with error below.

2025.06.03 07:37:09 ERROR web[o.s.s.es.BulkIndexer] Fail to execute bulk index request: org.elasticsearch.action.bulk.BulkRequest/unset
java.net.SocketTimeoutException: 60,000 milliseconds timeout on connection http-outgoing-2 [ACTIVE

When I compared the DB upgrade logs for staging and prod, found the below step of Drop Elasticsearch indeices missing in prod upgrade logs
2025.06.05 08:41:22 INFO web[o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2025.06.05 08:41:22 INFO web[o.s.s.e.MigrationEsClientImpl] Drop Elasticsearch indices [projectmeasures]

Is there a relation with this step missing in prod upgrade causing the elastic search to timeout. My both hosts are in same network. Wondering why this timeout only happened for production instance. Does it needs any elastic serach timeout config or is purely DB related. Please let me know.

Thanks
Jiju

2

Hi Jiju,

You shouldn’t need to configure Elasticsearch.

For why you saw a problem in one environment and not the other, I can guess that either there’s a difference in DB size or perhaps network latency.

Could you provide the production logs from server startup?

 
Thx,
Ann

3

Whenever I upgrade (did it countless of times), i don’t configure anything in elastic search. It might be a network latency as previously mentioned by our friend here - G Ann.

2 Likes
4

Hi Ann,
Thanks for your reply. Even I have never done any configuration in elastic search in previous upgrade. So got wondered when I hit with this issue. Like you mentioned the network latency can be a reason. Certainly I will look into that. I am attaching the web.log for your review.
sonarqube-LTS-2025-log.txt (56.6 KB)

Kind regards
Jiju

5

Hi Jiju,

Can we also have the es.log?

 
Thx,
Ann

6

Hi Ann,
I am attaching the es.log.
es.log (106.1 KB)

Kind regards
Jiju