hello i updated airflow (0.56.6) and now im getting this error on the server container when i try to access the connections tab in the ui:

2023-07-18 15:04:26 ERROR i.a.s.e.UncaughtExceptionHandler(handle):31 - Uncaught exception
org.jooq.exception.DataAccessException: SQL [select "public"."connection".*, string_agg(cast("public"."connection_operation"."operation_id" as varchar), ',') as "operation_ids_agg", "public"."schema_management"."auto_propagation_status" from "public"."connection" left outer join "public"."connection_operation" on "public"."connection_operation"."connection_id" = "public"."connection"."id" left outer join "public"."schema_management" on "public"."schema_management"."connection_id" = "public"."connection"."id" join "public"."actor" on "public"."connection"."source_id" = "public"."actor"."id" where ("public"."actor"."workspace_id" = cast(? as uuid) and "public"."connection"."status" <> cast(? as "public"."status_type")) group by "public"."connection"."id", "public"."schema_management"."auto_propagation_status"]; Error while reading field: "public"."connection"."unsupported_protocol_version", at JDBC index: 21
	at org.jooq_3.17.8.POSTGRES.debug(Unknown Source) ~[?:?]
	at org.jooq_3.17.8.POSTGRES.debug(Unknown Source) ~[?:?]
	at org.jooq.impl.Tools.translate(Tools.java:3313) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:678) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1404) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator.hasNext(CursorImpl.java:1365) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl.fetchNext(CursorImpl.java:173) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.AbstractCursor.fetch(AbstractCursor.java:177) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.AbstractCursor.fetch(AbstractCursor.java:88) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:265) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:341) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:290) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2837) ~[jooq-3.17.8.jar:?]
	at io.airbyte.config.persistence.ConfigRepository.listWorkspaceStandardSyncs(ConfigRepository.java:1605) ~[io.airbyte.airbyte-config-config-persistence-0.50.6.jar:?]
	at io.airbyte.commons.server.handlers.WebBackendConnectionsHandler.webBackendListConnectionsForWorkspace(WebBackendConnectionsHandler.java:153) ~[io.airbyte-airbyte-commons-server-0.50.6.jar:?]
	at io.airbyte.server.apis.WebBackendApiController.lambda$webBackendListConnectionsForWorkspace$4(WebBackendApiController.java:118) ~[io.airbyte-airbyte-server-0.50.6.jar:?]
	at io.airbyte.server.apis.ApiHelper.execute(ApiHelper.java:26) ~[io.airbyte-airbyte-server-0.50.6.jar:?]
	at io.airbyte.server.apis.WebBackendApiController.webBackendListConnectionsForWorkspace(WebBackendApiController.java:116) ~[io.airbyte-airbyte-server-0.50.6.jar:?]
	at io.airbyte.server.apis.$WebBackendApiController$Definition$Exec.dispatch(Unknown Source) ~[io.airbyte-airbyte-server-0.50.6.jar:?]
	at io.micronaut.context.AbstractExecutableMethodsDefinition$DispatchedExecutableMethod.invoke(AbstractExecutableMethodsDefinition.java:371) ~[micronaut-inject-3.9.4.jar:3.9.4]
	at io.micronaut.context.DefaultBeanContext$4.invoke(DefaultBeanContext.java:594) ~[micronaut-inject-3.9.4.jar:3.9.4]
	at io.micronaut.web.router.AbstractRouteMatch.execute(AbstractRouteMatch.java:303) ~[micronaut-router-3.9.4.jar:3.9.4]
	at io.micronaut.web.router.RouteMatch.execute(RouteMatch.java:111) ~[micronaut-router-3.9.4.jar:3.9.4]
	at io.micronaut.http.context.ServerRequestContext.with(ServerRequestContext.java:103) ~[micronaut-http-3.9.4.jar:3.9.4]
	at io.micronaut.http.server.RouteExecutor.lambda$executeRoute$14(RouteExecutor.java:659) ~[micronaut-http-server-3.9.4.jar:3.9.4]
	at reactor.core.publisher.FluxDeferContextual.subscribe(FluxDeferContextual.java:49) ~[reactor-core-3.5.0.jar:3.5.0]
	at reactor.core.publisher.InternalFluxOperator.subscribe(InternalFluxOperator.java:62) ~[reactor-core-3.5.0.jar:3.5.0]
	at reactor.core.publisher.FluxSubscribeOn$SubscribeOnSubscriber.run(FluxSubscribeOn.java:194) ~[reactor-core-3.5.0.jar:3.5.0]
	at io.micronaut.reactive.reactor.instrument.ReactorInstrumentation.lambda$init$0(ReactorInstrumentation.java:62) ~[micronaut-runtime-3.9.4.jar:3.9.4]
	at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:84) ~[reactor-core-3.5.0.jar:3.5.0]
	at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:37) ~[reactor-core-3.5.0.jar:3.5.0]
	at io.micronaut.scheduling.instrument.InvocationInstrumenterWrappedCallable.call(InvocationInstrumenterWrappedCallable.java:53) ~[micronaut-context-3.9.4.jar:3.9.4]
	at java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
	at java.lang.Thread.run(Thread.java:1589) ~[?:?]
Caused by: java.sql.SQLException: Error while reading field: "public"."connection"."unsupported_protocol_version", at JDBC index: 21
	at org.jooq.impl.CursorImpl$CursorRecordInitialiser.setValue(CursorImpl.java:1591) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl$CursorRecordInitialiser.apply(CursorImpl.java:1517) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl$CursorRecordInitialiser.apply(CursorImpl.java:1432) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:144) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1389) ~[jooq-3.17.8.jar:?]
	... 31 more
Caused by: org.postgresql.util.PSQLException: Cannot cast to boolean: "{"null/forms": false, "null/images": false, "null/themes": false, "null/webhooks": false, "null/responses": false, "null/workspaces": false}"
	at org.postgresql.jdbc.BooleanTypeUtil.cannotCoerceException(BooleanTypeUtil.java:99) ~[postgresql-42.5.4.jar:42.5.4]
	at org.postgresql.jdbc.BooleanTypeUtil.fromString(BooleanTypeUtil.java:67) ~[postgresql-42.5.4.jar:42.5.4]
	at org.postgresql.jdbc.BooleanTypeUtil.castToBoolean(BooleanTypeUtil.java:43) ~[postgresql-42.5.4.jar:42.5.4]
	at org.postgresql.jdbc.PgResultSet.getBoolean(PgResultSet.java:2307) ~[postgresql-42.5.4.jar:42.5.4]
	at com.zaxxer.hikari.pool.HikariProxyResultSet.getBoolean(HikariProxyResultSet.java) ~[HikariCP-5.0.1.jar:?]
	at org.jooq.tools.jdbc.DefaultResultSet.getBoolean(DefaultResultSet.java:129) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl$CursorResultSet.getBoolean(CursorImpl.java:462) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.DefaultBinding$DefaultBooleanBinding.get0(DefaultBinding.java:1882) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.DefaultBinding$DefaultBooleanBinding.get0(DefaultBinding.java:1787) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.DefaultBinding$InternalBinding.get(DefaultBinding.java:1024) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl$CursorRecordInitialiser.setValue(CursorImpl.java:1581) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl$CursorRecordInitialiser.apply(CursorImpl.java:1517) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl$CursorRecordInitialiser.apply(CursorImpl.java:1432) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:144) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1389) ~[jooq-3.17.8.jar:?]
	... 31 more

what information is useful to debug this?

A message from kapa.ai

can you have a human look at my question?

I am not from the airbyte team.

airflow (0.56.6)

Have you meant airbyte 0.50.6? If so, I can see only one scenario how you could encounter such an error - you might copy-paste variables

JOBS_DATABASE_MINIMUM_FLYWAY_MIGRATION_VERSION

or

CONFIGS_DATABASE_MINIMUM_FLYWAY_MIGRATION_VERSION

for airbyte v0.50.7 (this commit) in your deployment and they dropped the column. If your version is 0.50.6 and the env variables ]are 0.50.6.001 or above, then it is the case. I would upgrade to v0.50.7. It will fix the issue. Alternatively (but I am not sure if it would help) you could try to set the env variables to a lower version (0.50.5.005) and re-deploy (perhaps running bootloader will be enough).

hey thanks for your reply i wasn't aware of this db migrations unfortunately before upgrading. thanks for pointing them out im actually going to dump the db and configure the connections again

Hey ! I am facing the same error. Did you find a fix ? I can no longer see the connections list and trigger jobs