Issue with db-copy tool

SonarQube Server / Community Build
1
  • SonarQube version 8.9.9-enterprise (We have few application running on Java 1.8 which is the reason of why we haven’t upgraded yet)
  • SonarQube deployed through Helm
  • We are trying to migrate db from oracle to postgres. To achieve this, we are using db-copy tool. But there are discrepancies in number of rows between source and destination like below
    21:46:41 INFO **************** CHECK DISCREPANCIES ****************
    21:46:41 ERROR TABLE file_sources has 1588215 ROWS in SOURCE while 1588216 ROWS in DESTINATION
    21:46:41 ERROR TABLE issues has 6381122 ROWS in SOURCE while 6381126 ROWS in DESTINATION
    21:46:41 ERROR TABLE issue_changes has 3892353 ROWS in SOURCE while 3892336 ROWS in DESTINATION
    21:46:41 ERROR TABLE live_measures has 45478343 ROWS in SOURCE while 45477211 ROWS in DESTINATION
    21:46:41 ERROR TABLE project_branches has 2851 ROWS in SOURCE while 2853 ROWS in DESTINATION
    21:46:41 ERROR TABLE project_measures has 469007 ROWS in SOURCE while 469288 ROWS in DESTINATION
    21:46:41 ERROR TABLE snapshots has 7670 ROWS in SOURCE while 7675 ROWS in DESTINATION
    21:46:41 ERROR TABLE webhook_deliveries has 18696 ROWS in SOURCE while 18693 ROWS in DESTINATION
    21:46:41 INFO ************************************************
    21:46:41 ERROR ** THE COPY HAS FINISHED UNSUCCESSFULLY !!! WATCH OUT THE LOG !!! **

Please assist here to resolve these issues. This is the tool we are using - SonarQube database copy tool

2

Hey there.

Did you do this?

  1. Stop the SonarQube instance connected to your source database. This is to ensure that we don’t have records being inserted/updated while copying.

You can still analyze Java 1.8 code on a SonarQube v9.9 LTA server. It just requires making sure a newer version of Java is available in the Scanner environment.