Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

bug: Flyway and Postgres 16 version mismatch #1524

Closed
DerekRoberts opened this issue Oct 25, 2023 · 0 comments · Fixed by #1525
Closed

bug: Flyway and Postgres 16 version mismatch #1524

DerekRoberts opened this issue Oct 25, 2023 · 0 comments · Fixed by #1525
Assignees
Labels
bug Something isn't working

Comments

@DerekRoberts
Copy link
Member

DerekRoberts commented Oct 25, 2023

Causing an init crash loop.

quickstart-openshift: oc logs quickstart-openshift-1523-backend-84c88846f5-ftnmc -c database-migrations
/.config/Redgate/feature_usage_data (No such file or directory)
Flyway Community Edition 9.22.3 by Redgate
See release notes here: https://rd.gt/416ObMi

Database: jdbc:postgresql://quickstart-openshift-1523-bitnami-pg:5432/quickstart (PostgreSQL 16.0)
WARNING: Flyway upgrade recommended: PostgreSQL 16.0 is newer than this version of Flyway and support has not been tested. The latest supported version of PostgreSQL is 15.
Schema version: 1.0.1

+-----------+---------+------------------------------+--------+---------------------+---------+----------+
| Category  | Version | Description                  | Type   | Installed On        | State   | Undoable |
+-----------+---------+------------------------------+--------+---------------------+---------+----------+
|           |         | << Flyway Schema Creation >> | SCHEMA | 2023-10-25 05:55:44 | Success |          |
| Versioned | 1.0.0   | init                         | SQL    | 2023-10-25 05:55:44 | Success | No       |
| Versioned | 1.0.1   | alter user seq               | SQL    | 2023-10-25 05:55:45 | Success | No       |
+-----------+---------+------------------------------+--------+---------------------+---------+----------+

WARNING: Flyway upgrade recommended: PostgreSQL 16.0 is newer than this version of Flyway and support has not been tested. The latest supported version of PostgreSQL is 15.
ERROR: Validate failed: Migrations have failed validation
Migration checksum mismatch for migration version 1.0.0
-> Applied to database : -1157776793
-> Resolved locally    : 415321655
Either revert the changes to the migration, or run repair to update the schema history.
Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE
@DerekRoberts DerekRoberts added the bug Something isn't working label Oct 25, 2023
@DerekRoberts DerekRoberts changed the title bug: Flyway and Postgres version mismatch bug: Flyway and Postgres 16 version mismatch Oct 25, 2023
@DerekRoberts DerekRoberts moved this from New to Active in DevOps (NR) Oct 25, 2023
@DerekRoberts DerekRoberts linked a pull request Oct 25, 2023 that will close this issue
@github-project-automation github-project-automation bot moved this from Active to Done in DevOps (NR) Oct 25, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
Archived in project
Development

Successfully merging a pull request may close this issue.

2 participants