Copying live_measure to live_measure_copy took too long(Upgrade 7.9 LTS > 8.9 LTS

Hello,
We are trying to upgrade our sonarqube from 7.9 LTS to 8.9 LTS. The web.log show the process of copying table live_measure to live_measure_copy but it took so long, already almost 2 hour, is this normal?

Thank you

Hi,

That’s going to depend on the size of your instance.

You say it took “too long”. Does this imply that it errored-out or that in your judgement it’s taking longer than it should?

 
Ann

Hi Ann,

No, it is not errored-out, it is just our own judgement that this process taking too long.

Now Ann, it is already 14 hours, but the process is still copy table_measures, is this normal? FYI we stopped the service now.

Thank you

Hi,

Again, that depends entirely on the size of your instance. How big is the live_measures table? What resources are available, DB-side and SonarQube-side to make the move?

 
Ann

Hello Ann,

Sorry for late respond, yes when we check the live_measures table the size is large enough.
After we check again from the database side, the storage is full and that is why the process stuck at copy table_measures.

Now we already scaleup the database and the process running well.

Thank you

2 Likes

Hi,

Thanks for following up. It’s good to know your root cause and that you got past it!

 
Ann