License_usage web api gets timout

[asupraja (Senthilbabu)]

We are currently using SonarQube Enterprise Edition Version 9.9.2 (build 77730) in our office to monitor Lines of Code (LOC). To achieve this, we utilize the license_usage API. Initially, the API was functioning sporadically, but for the past month, we have been experiencing persistent timeouts with the API call, and it has not been operational. Could you please assist us in resolving this issue?

[Colin]

Hey there.

A timeout in this case would normally indicate some issues with the database (CPU, memory, disk space, regular reindexing).

What database provider are you using (Postgres, Oracle, SQL Server)?

[asupraja (Senthilbabu)]

@Colin

Postgres

we are using Postgres database

[Colin]

I would suggest you start by making sure you have run a VACUUM FULL ANALYZE and see if the performance issue persists.

SonarQube becomes slow after PostgreSQL upgrade

Hello SonarQube Operators! It’s common that after performing an upgrade of PostgreSQL, a SonarQube instance connected to a PostgreSQL database can become painfully slow. Thankfully, we know how the issue can usually be addressed (it works almost every time!): by executing the following command against your Postgres database. VACUUM FULL ANALYZE For a PostgreSQL database, a VACUUM FULL command reclaims unused storage, while the ANALYZE command updates statistics used by the planner to determi…