Ops Manager Upgrade Failure: BOSH Director CredHub Service Crash Due to 'SPRING_JDBC' Migration Error

Products

• VMware Tanzu Kubernetes Grid Integrated Edition

Issue/Introduction

During an upgrade to Ops Manager 3.2.6, the BOSH Director deployment may fail with the following error:

Unknown migration type 'SPRING_JDBC' found in schema history. You might be missing a required extension JAR on the classpath.

This failure prevents the CredHub service from initializing, which in turn causes the Director deployment to fail with a non-running job state: 'failing'. This issue typically occurs in environments that have been upgraded through multiple previous versions of Ops Manager where legacy migration metadata remains in the database.

Environment

• Product: VMware Tanzu Operations Manager
• Version: 3.2.6
• Component: CredHub (version 2.15.4) when used with a long-running Postgres server.
• Infrastructure: Any

Cause

A regression was introduced in CredHub 2.15.4 (bundled with recent Ops Manager releases) related to Flyway schema migrations. When CredHub attempts to start, it encounters an unknown migration type SPRING_JDBC in the flyway_schema_history table. This occurs because newer versions of the migration tool do not recognize the legacy categorization used in previous database versions, causing the service to crash and the BOSH Director deployment to fail.

Resolution

The permanent fix is available in CredHub 2.15.5 and is scheduled to be included in a furture patched release of Ops Manager.

Until the patched version is available, you must manually update the metadata in the CredHub database to allow migrations to proceed. Use the method highlighted in the Workaround and retry the deployment. 

Additional Information

• CredHub Release 2.15.4 Notes
• This issue specifically impacts environments utilizing a PostgreSQL backend for the BOSH Director.