Summary
Failed to upgrade Airbyte with error related to schema migration failure and PostgreSQL operator issue.
Question
Hi everyone, I failed to upgrade Airbyte from 0.44.3 to 0.62.3 and got the error below:
airbyte-bootloader | 2024-07-09 18:06:08 ERROR o.f.c.i.l.s.Slf4jLog(error):45 - Migration of schema "public" to version "0.44.4.002 - MigrateNonBreakingChangeToEnum" failed! Changes successfully rolled back.
airbyte-bootloader | 2024-07-09 18:06:08 ERROR i.a.b.Application(main):25 - Unable to bootstrap Airbyte environment.
airbyte-bootloader | Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = non_breaking_change_preference_type
airbyte-bootloader | Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
airbyte-bootloader | Position: 64
airbyte-bootloader | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725) ~[postgresql-42.7.3.jar:42.7.3]
airbyte-bootloader | Caused by: org.jooq.exception.DataAccessException: SQL [select id from connection where non_breaking_change_preference = cast(? as "non_breaking_change_preference_type")]; ERROR: operator does not exist: character varying = non_breaking_change_preference_type
airbyte-bootloader | Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
airbyte-bootloader | Position: 64
airbyte-bootloader | at org.jooq_3.19.7.POSTGRES.debug(Unknown Source) ~[?:?]
airbyte-bootloader | Caused by: org.flywaydb.core.api.FlywayException: Migration failed !
Can anyone help me out? Many thanks.
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.