Must-share information (formatted with Markdown):
- which versions are you using : 8.9.6 LTS
- how is SonarQube deployed: zip
- what are you trying to achieve: Upgrading our lower environment of SonarQube Enterprise version from From 8.9.6 LTS to 9.9.1 LTS. Upgrade setup is asking to migrate the DB, but it is running for more than 58Hrs and still goin on. Please let us know do we need to do any configuration changes to expedite the process. Since we will not have more than 4hrs down time in production.
- what have you tried so far to achieve this : We have scaled the DB infra and re-index the DB.
Database: Oracle 19C installed on Linux RHEL 7
Log:
2023.08.01 08:45:35 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - keepalive: connection oracle.jdbc.driver.T4CConnection@4aee6249 is alive
2023.08.01 08:45:37 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - keepalive: connection oracle.jdbc.driver.T4CConnection@33be8d8a is alive
2023.08.01 08:45:38 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - keepalive: connection oracle.jdbc.driver.T4CConnection@2ee3a084 is alive
2023.08.01 08:45:54 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - Before cleanup stats (total=12, active=2, idle=10, waiting=0)
2023.08.01 08:45:54 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - After cleanup stats (total=12, active=2, idle=10, waiting=0)
2023.08.01 08:45:54 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - Fill pool skipped, pool has sufficient level or currently being filled (queueDepth=0).
2023.08.01 08:46:05 DEBUG web[][c.z.h.pool.PoolBase] HikariPool-1 - Closing connection oracle.jdbc.driver.T4CConnection@779bc179: (connection has passed maxLifetime)
2023.08.01 08:46:05 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@15ad2a01
2023.08.01 08:46:07 DEBUG web[][c.z.h.pool.PoolBase] HikariPool-1 - Closing connection oracle.jdbc.driver.T4CConnection@375af1ea: (connection has passed maxLifetime)
2023.08.01 08:46:07 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@190f5f93
2023.08.01 08:46:15 DEBUG web[][c.z.h.pool.PoolBase] HikariPool-1 - Closing connection oracle.jdbc.driver.T4CConnection@5675095a: (connection has passed maxLifetime)
2023.08.01 08:46:15 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@68b8d974
2023.08.01 08:46:21 DEBUG web[][c.z.h.pool.PoolBase] HikariPool-1 - Closing connection oracle.jdbc.driver.T4CConnection@2568e56d: (connection has passed maxLifetime)
2023.08.01 08:46:21 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@fe280e6
2023.08.01 08:46:24 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - Before cleanup stats (total=12, active=2, idle=10, waiting=0)
2023.08.01 08:46:24 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - After cleanup stats (total=12, active=2, idle=10, waiting=0)
2023.08.01 08:46:24 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - Fill pool skipped, pool has sufficient level or currently being filled (queueDepth=0).
2023.08.01 08:46:24 DEBUG web[][c.z.h.pool.PoolBase] HikariPool-1 - Closing connection oracle.jdbc.driver.T4CConnection@2ee3a084: (connection has passed maxLifetime)
2023.08.01 08:46:24 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@6425ad5a
2023.08.01 08:46:24 INFO web[][o.s.s.p.d.m.s.MassUpdate] 999 rows processed (0 items/sec)
2023.08.01 08:46:29 DEBUG web[][c.z.h.p.HikariPool] HikariPool-1 - keepalive: connection oracle.jdbc.driver.T4CConnection@60f04116 is alive