Steps to Reproduce
- Run Jakarta upgrade, or just TPP migration, against an instance with a CMDB hierarchy that takes longer to copy than the connection pool interval.
- Observe after 24 hours the database connection running the migration is recycled
2017-09-16 04:24:08 (356) glide.tpp.conversion.data:u_cmdb_ci_windows_account -> z_cmdb SYSTEM Consuming table queue size: 0 2017-09-16 04:24:08 (557) worker.1 worker.1 Connection is closed ... 2017-09-16 04:24:09 (056) worker.1 worker.1 Connection has been closed, reconnecting ... 2017-09-16 04:24:19 (065) worker.1 worker.1 Creating transient database pool 2017-09-16 04:24:19 (080) worker.1 worker.1 Destroying transient database pool ... 2017-09-16 04:24:19 (099) worker.1 worker.1 WARNING *** WARNING *** Pool: glide: Database connections exhausted! Retries exhausted, cancelling transaction 2017-09-16 04:24:19 (099) worker.1 worker.1 WARNING *** WARNING *** Cancelling transaction Check Upgrade Script - system (Failed to get database connection): Thread glide.scheduler.worker.1 (system, glide.scheduler.worker.1), after 37701873ms 2017-09-16 04:24:19 (099) worker.1 worker.1 Cancelled 0 child transactions 2017-09-16 04:24:19 (099) worker.1 worker.1 WARNING *** WARNING *** Ignoring event because transaction has experienced impaired DB access 2017-09-16 04:24:19 (099) worker.1 worker.1 SEVERE *** ERROR *** DBI has been unable to acquire a new database connection
- Observe the migration fails
2017-09-16 09:23:33 (752) worker.3 worker.3 Loading fix: WEB-INF/update/fixes/z_z_migrate_cmdb_tpp.xml 2017-09-16 09:23:33 (761) worker.3 worker.3 TPPMigrater: Starting TPP conversion for hierarchy root: cmdb ... 2017-09-16 09:28:13 (323) worker.3 worker.3 Assigning column [a_int_15] to partition [cmdb$par2] 2017-09-16 09:28:13 (337) worker.3 worker.3 Partition create statement(s): CREATE TABLE z_cmdb ( `a_str_18` VARCHAR(255) ,`a_str_17` VARCHAR(255) ,`a_str_16` VARCHAR(255) ... 2017-09-16 09:28:13 (340) worker.3 worker.3 WARNING *** WARNING *** GlideTime - unparseable date: 279553
2017-09-16 09:28:13 (344) worker.3 worker.3 SEVERE *** ERROR *** TPP Migration Exception, Aborting: cmdb
2017-09-16 09:28:13 (344) worker.3 worker.3 SEVERE *** ERROR *** Exception encountered during TPP conversion
) CHARACTER SET 'utf8' ROW_FORMAT=COMPACT /* siemens029, gs:glide.scheduler.worker.3, tx:710e40300f1103006d20b47ce1050ec2 */
This issue is under review. If you are able to upgrade, check the Fixed In field below to determine the versions that have a permanent fix. You can also subscribe to this known error article (click Subscribe button at the top of the article) to receive notifications when more information is available about this issue.
Related Problem: PRB1179246