Troubleshoot ZCenter Flyway database migration failures

Issue/Introduction

Use this article to troubleshoot Flyway database migration failures during ZCenter startup or upgrade.

Symptoms

• Database migration fails when ZCenter starts or is upgraded.
• Errors such as checksum mismatch, an error indicating that a table already exists, or a version number conflict occur during migration.

Environment

• Product line: ZVF
• Component: ZCenter
• Version: 5.1.0

Possible causes

• A previously executed migration script was modified, causing a checksum mismatch.
• A table remains after the previous migration was interrupted, and the retry reports that the table already exists.