Hi everyone,
We are trying to update SonarQube from 7.9LTS to 8.0, we are at the DB migration step and it has been running for more than 34 hours.
The following step has been running for 33 hrs and is still running.
‘Add primary key on ‘uuid’ column of ‘LIVE_MEASURES’ table’…
The number of rows in that table is 145 million, we already performed a clean-up of the projects that haven’t been used in a year and run vacuum full, we started over the migration procedure and we are still facing the same issue.
Is there something we can do to speed up the process?
This is part of web.log
2021.01.20 20:31:43 INFO web[DbMigrations] #3538 ‘Populate ‘metric_uuid’ for ‘QUALITY_GATE_CONDITIONS’’: success | time=1577ms
2021.01.20 20:31:43 INFO web[DbMigrations] #3539 ‘Make ‘metric_uuid’ column not nullable for ‘QUALITY_GATE_CONDITIONS’’…
2021.01.20 20:31:43 INFO web[DbMigrations] #3539 ‘Make ‘metric_uuid’ column not nullable for ‘QUALITY_GATE_CONDITIONS’’: success | time=5ms
2021.01.20 20:31:43 INFO web[DbMigrations] #3540 ‘Copy ‘LIVE_MEASURES’ table to ‘LIVE_MEASURES_COPY’’…
2021.01.20 20:37:06 INFO web[DbMigrations] #3540 ‘Copy ‘LIVE_MEASURES’ table to ‘LIVE_MEASURES_COPY’’: success | time=323012ms
2021.01.20 20:37:06 INFO web[DbMigrations] #3541 ‘Drop ‘LIVE_MEASURES’ table’…
2021.01.20 20:37:06 INFO web[DbMigrations] #3541 ‘Drop ‘LIVE_MEASURES’ table’: success | time=196ms
2021.01.20 20:37:06 INFO web[DbMigrations] #3542 ‘Rename table ‘LIVE_MEASURES_COPY’ to ‘LIVE_MEASURES’’…
2021.01.20 20:37:06 INFO web[DbMigrations] #3542 ‘Rename table ‘LIVE_MEASURES_COPY’ to ‘LIVE_MEASURES’’: success | time=3ms
2021.01.20 20:37:06 INFO web[DbMigrations] #3543 ‘Add primary key on ‘uuid’ column of ‘LIVE_MEASURES’ table’…
We also noticed some projects with a large history in the front page Activity list “filtered by version” ( 2 or 3 years ago ). Is there a way to remove ( bulk deletion ) history?
I hope you can help me.