[BUG] run-migrations fails with RDS Postgres 14.8

[davidmirror-ops]

Describe the bug

Trying to deploy flyte-core to an EKS cluster and using an RDS DB with the following configuration:

• Aurora engine (Postgres compatible)
• Postgres 14.8
• Single master
• Password authentication

Renders an unusable deployment. flyteadmin pods remain on CrashLoopBackOff

Logs from the run-migrations init container show the following:

Error: database migration failed: ERROR: relation "description_entities" does not exist (SQLSTATE 42P01)

The same behavior has been reported previously (see here)

Expected behavior

DB version, especially under the same major release, should not matter. Otherwise, supported DB versions should be clearly documented

Additional context to reproduce

No response

Screenshots

No response

Are you sure this issue hasn't been raised already?

• Yes

Have you read the Code of Conduct?

• Yes

[eapolinario]

Let's try to repro this, first on a sandbox and only then on an EKS cluster. David mentioned that this doesn't happen on version 14.6.

[github-actions]

Hello 👋, this issue has been inactive for over 9 months. To help maintain a clean and focused backlog, we'll be marking this issue as stale and will engage on it to decide if it is still applicable.
Thank you for your contribution and understanding! 🙏

[eapolinario]

fixed by #5157.