On upgrade to Jakarta, the CMDB table goes through a migration called TPP.  This can fail if the migration runs for longer than 24 hours as the database connections are destroyed after being marked obsolete by connection pool sweeper.
What symptoms are experienced?
The upgrade gets stuck on the fix script that is running the TPP migration, z_z_migrate_cmdb_tpp.xml. This is observed in the Upgrade Monitor and requires manual interventions or a rollback of the upgrade.

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

Seen In

Jakarta Patch 1
Jakarta Patch 2

Fixed In

Jakarta Patch 2 Hot Fix 4
Jakarta Patch 3 Hot Fix 1
Jakarta Patch 4

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-10-10 11:03:05