Airbyte wont start after updating to 0.40.30

aschmidt · February 8, 2023, 9:47am

Is this your first time deploying Airbyte?: No
OS Version / Instance: Ubuntu
Memory / Disk: 100 GB
Deployment: Docker
Airbyte Version: 0.40.30
Source name/version: Amazon Selling Partner v. 0.2.31
Destination name/version: MySQL v. 0.1.20
Step: The issue is happening during startup
Description:
Hi, i wanted to update from version 0.40.27 to 0.40.30 but after updating i get this error from the server:

2023-02-08T09:17:37.519303286Z 2023-02-08 09:17:37 ERROR i.a.s.a.ApiHelper(execute):28 - Unexpected Exception
2023-02-08T09:17:37.519335086Z org.jooq.exception.DataAccessException: SQL [select "public"."actor_definition".* from "public"."actor_definition" where ("public"."actor_definition"."actor_type" = ?::"public"."actor_type" and "public"."actor_definition"."tombstone" <> ?)]; Error while reading field: "public"."actor_definition"."allowed_hosts", at JDBC index: 23
2023-02-08T09:17:37.519350287Z 	at org.jooq_3.15.11.POSTGRES.debug(Unknown Source) ~[?:?]
2023-02-08T09:17:37.519352987Z 	at org.jooq_3.15.11.POSTGRES.debug(Unknown Source) ~[?:?]
2023-02-08T09:17:37.519355587Z 	at org.jooq.impl.Tools.translate(Tools.java:2997) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519357987Z 	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:639) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519360687Z 	at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1447) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519363187Z 	at org.jooq.impl.CursorImpl$CursorIterator.hasNext(CursorImpl.java:1408) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519365887Z 	at org.jooq.impl.CursorImpl.fetchNext(CursorImpl.java:221) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519368587Z 	at org.jooq.impl.AbstractCursor.fetch(AbstractCursor.java:177) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519371087Z 	at org.jooq.impl.AbstractCursor.fetch(AbstractCursor.java:88) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519373787Z 	at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:259) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519376287Z 	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:340) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519378687Z 	at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:284) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519381487Z 	at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2842) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.519383987Z 	at io.airbyte.config.persistence.ConfigRepository.lambda$destDefQuery$14(ConfigRepository.java:363) ~[io.airbyte.airbyte-config-config-persistence-0.40.30.jar:?]
2023-02-08T09:17:37.519386787Z 	at io.airbyte.db.Database.query(Database.java:23) ~[io.airbyte.airbyte-db-db-lib-0.40.30.jar:?]
2023-02-08T09:17:37.519389287Z 	at io.airbyte.db.ExceptionWrappingDatabase.query(ExceptionWrappingDatabase.java:23) ~[io.airbyte.airbyte-db-db-lib-0.40.30.jar:?]
2023-02-08T09:17:37.519393587Z 	at io.airbyte.config.persistence.ConfigRepository.destDefQuery(ConfigRepository.java:358) ~[io.airbyte.airbyte-config-config-persistence-0.40.30.jar:?]
2023-02-08T09:17:37.519396287Z 	at io.airbyte.config.persistence.ConfigRepository.listStandardDestinationDefinitions(ConfigRepository.java:396) ~[io.airbyte.airbyte-config-config-persistence-0.40.30.jar:?]
2023-02-08T09:17:37.519398787Z 	at io.airbyte.commons.server.handlers.WebBackendCheckUpdatesHandler.getDestinationDiffCount(WebBackendCheckUpdatesHandler.java:50) ~[io.airbyte-airbyte-commons-server-0.40.30.jar:?]
2023-02-08T09:17:37.519401587Z 	at io.airbyte.commons.server.handlers.WebBackendCheckUpdatesHandler.checkUpdates(WebBackendCheckUpdatesHandler.java:37) ~[io.airbyte-airbyte-commons-server-0.40.30.jar:?]
2023-02-08T09:17:37.519404287Z 	at io.airbyte.server.apis.ApiHelper.execute(ApiHelper.java:18) ~[io.airbyte-airbyte-server-0.40.30.jar:?]
2023-02-08T09:17:37.519409887Z 	at io.airbyte.server.apis.WebBackendApiController.webBackendCheckUpdates(WebBackendApiController.java:62) ~[io.airbyte-airbyte-server-0.40.30.jar:?]
2023-02-08T09:17:37.519412587Z 	at io.airbyte.server.apis.$WebBackendApiController$Definition$Exec.dispatch(Unknown Source) ~[io.airbyte-airbyte-server-0.40.30.jar:?]
2023-02-08T09:17:37.519415487Z 	at io.micronaut.context.AbstractExecutableMethodsDefinition$DispatchedExecutableMethod.invoke(AbstractExecutableMethodsDefinition.java:378) ~[micronaut-inject-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519418087Z 	at io.micronaut.context.DefaultBeanContext$4.invoke(DefaultBeanContext.java:594) ~[micronaut-inject-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519420887Z 	at io.micronaut.web.router.AbstractRouteMatch.execute(AbstractRouteMatch.java:246) ~[micronaut-router-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519423587Z 	at io.micronaut.web.router.RouteMatch.execute(RouteMatch.java:111) ~[micronaut-router-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519426287Z 	at io.micronaut.http.context.ServerRequestContext.with(ServerRequestContext.java:103) ~[micronaut-http-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519429387Z 	at io.micronaut.http.server.RouteExecutor.lambda$executeRoute$14(RouteExecutor.java:659) ~[micronaut-http-server-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519432187Z 	at reactor.core.publisher.FluxDeferContextual.subscribe(FluxDeferContextual.java:49) ~[reactor-core-3.5.0.jar:3.5.0]
2023-02-08T09:17:37.519434887Z 	at reactor.core.publisher.Flux.subscribe(Flux.java:8660) ~[reactor-core-3.5.0.jar:3.5.0]
2023-02-08T09:17:37.519437287Z 	at reactor.core.publisher.FluxFlatMap$FlatMapMain.onNext(FluxFlatMap.java:426) ~[reactor-core-3.5.0.jar:3.5.0]
2023-02-08T09:17:37.519440187Z 	at io.micronaut.reactive.reactor.instrument.ReactorSubscriber.onNext(ReactorSubscriber.java:57) ~[micronaut-runtime-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519442887Z 	at reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2508) ~[reactor-core-3.5.0.jar:3.5.0]
2023-02-08T09:17:37.519445387Z 	at reactor.core.publisher.FluxFlatMap$FlatMapMain.onSubscribe(FluxFlatMap.java:371) ~[reactor-core-3.5.0.jar:3.5.0]
2023-02-08T09:17:37.519447887Z 	at io.micronaut.reactive.reactor.instrument.ReactorSubscriber.onSubscribe(ReactorSubscriber.java:50) ~[micronaut-runtime-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519450387Z 	at reactor.core.publisher.FluxJust.subscribe(FluxJust.java:68) ~[reactor-core-3.5.0.jar:3.5.0]
2023-02-08T09:17:37.519453287Z 	at reactor.core.publisher.Flux.subscribe(Flux.java:8660) ~[reactor-core-3.5.0.jar:3.5.0]
2023-02-08T09:17:37.519455787Z 	at io.micronaut.core.async.publisher.Publishers.lambda$then$5(Publishers.java:324) ~[micronaut-core-reactive-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519458287Z 	at reactor.core.publisher.FluxSource.subscribe(FluxSource.java:67) ~[reactor-core-3.5.0.jar:3.5.0]
2023-02-08T09:17:37.519460987Z 	at reactor.core.publisher.Flux.subscribe(Flux.java:8660) ~[reactor-core-3.5.0.jar:3.5.0]
2023-02-08T09:17:37.519463387Z 	at io.micronaut.http.server.netty.RoutingInBoundHandler.handleRouteMatch(RoutingInBoundHandler.java:601) ~[micronaut-http-server-netty-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519469287Z 	at io.micronaut.http.server.netty.RoutingInBoundHandler.channelRead0(RoutingInBoundHandler.java:457) ~[micronaut-http-server-netty-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519472287Z 	at io.micronaut.http.server.netty.RoutingInBoundHandler.channelRead0(RoutingInBoundHandler.java:147) ~[micronaut-http-server-netty-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519475087Z 	at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:99) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519477987Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519480987Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519485188Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519488188Z 	at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:102) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519491188Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519494188Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519497288Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519500488Z 	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) ~[netty-codec-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519503488Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519506488Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519509088Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519511788Z 	at io.micronaut.http.netty.stream.HttpStreamsHandler.channelRead(HttpStreamsHandler.java:224) ~[micronaut-http-netty-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519514388Z 	at io.micronaut.http.netty.stream.HttpStreamsServerHandler.channelRead(HttpStreamsServerHandler.java:134) ~[micronaut-http-netty-3.8.2.jar:3.8.2]
2023-02-08T09:17:37.519517188Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519519988Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519525488Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519969191Z 	at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:93) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519979091Z 	at io.netty.handler.codec.http.websocketx.extensions.WebSocketServerExtensionHandler.channelRead(WebSocketServerExtensionHandler.java:99) ~[netty-codec-http-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519982191Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519985091Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519987791Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519990691Z 	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) ~[netty-codec-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519993991Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519996791Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.519999491Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520002591Z 	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) ~[netty-codec-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520005491Z 	at io.netty.handler.codec.MessageToMessageCodec.channelRead(MessageToMessageCodec.java:111) ~[netty-codec-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520008291Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520011691Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520015391Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520018091Z 	at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:93) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520020691Z 	at io.netty.handler.codec.http.HttpServerKeepAliveHandler.channelRead(HttpServerKeepAliveHandler.java:64) ~[netty-codec-http-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520023391Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520031891Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520034891Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520037792Z 	at io.netty.handler.flow.FlowControlHandler.dequeue(FlowControlHandler.java:200) ~[netty-handler-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520040792Z 	at io.netty.handler.flow.FlowControlHandler.channelRead(FlowControlHandler.java:162) ~[netty-handler-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520043692Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520046892Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520049992Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520053092Z 	at io.netty.channel.CombinedChannelDuplexHandler$DelegatingChannelHandlerContext.fireChannelRead(CombinedChannelDuplexHandler.java:436) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520056292Z 	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346) ~[netty-codec-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520059192Z 	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318) ~[netty-codec-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520062092Z 	at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520065092Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520068492Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520071592Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520074492Z 	at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286) ~[netty-handler-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520077692Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520080692Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520083292Z 	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520088492Z 	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520091392Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520094092Z 	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520096792Z 	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520099492Z 	at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520102892Z 	at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520105392Z 	at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520107992Z 	at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520110692Z 	at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562) ~[netty-transport-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520113192Z 	at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997) ~[netty-common-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520115692Z 	at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520118492Z 	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.1.86.Final.jar:4.1.86.Final]
2023-02-08T09:17:37.520121092Z 	at java.lang.Thread.run(Thread.java:1589) ~[?:?]
2023-02-08T09:17:37.520123492Z Caused by: java.sql.SQLException: Error while reading field: "public"."actor_definition"."allowed_hosts", at JDBC index: 23
2023-02-08T09:17:37.520126392Z 	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.setValue(CursorImpl.java:1569) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520129092Z 	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.apply(CursorImpl.java:1508) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520131692Z 	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.apply(CursorImpl.java:1467) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520134392Z 	at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:143) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520137092Z 	at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1432) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520139792Z 	... 104 more
2023-02-08T09:17:37.520142392Z Caused by: org.postgresql.util.PSQLException: The column index is out of range: 23, number of columns: 22.
2023-02-08T09:17:37.520148492Z 	at org.postgresql.jdbc.PgResultSet.checkColumnIndex(PgResultSet.java:3130) ~[postgresql-42.5.0.jar:42.5.0]
2023-02-08T09:17:37.520151492Z 	at org.postgresql.jdbc.PgResultSet.getRawValue(PgResultSet.java:3152) ~[postgresql-42.5.0.jar:42.5.0]
2023-02-08T09:17:37.520154292Z 	at org.postgresql.jdbc.PgResultSet.getString(PgResultSet.java:2225) ~[postgresql-42.5.0.jar:42.5.0]
2023-02-08T09:17:37.520320594Z 	at com.zaxxer.hikari.pool.HikariProxyResultSet.getString(HikariProxyResultSet.java) ~[HikariCP-5.0.1.jar:?]
2023-02-08T09:17:37.520328794Z 	at org.jooq.tools.jdbc.DefaultResultSet.getString(DefaultResultSet.java:124) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520331894Z 	at org.jooq.impl.CursorImpl$CursorResultSet.getString(CursorImpl.java:710) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520334594Z 	at org.jooq.impl.DefaultBinding$DefaultJSONBBinding.get0(DefaultBinding.java:4632) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520337494Z 	at org.jooq.impl.DefaultBinding$DefaultJSONBBinding.get0(DefaultBinding.java:4573) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520340294Z 	at org.jooq.impl.DefaultBinding$InternalBinding.get(DefaultBinding.java:969) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520343294Z 	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.setValue(CursorImpl.java:1559) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520346094Z 	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.apply(CursorImpl.java:1508) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520348794Z 	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.apply(CursorImpl.java:1467) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520351794Z 	at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:143) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520354694Z 	at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1432) ~[jooq-3.15.11.jar:?]
2023-02-08T09:17:37.520357594Z 	... 104 more

Logs:
_msz-airbyte-updatetest_airbyte-server.1.janlkwk6krojx2ksvctjsxoy8_logs.txt (48.1 KB)

So i deleted the volumes and tried starting again, which lead to a different error message, Error starting Micronaut server:

023-02-08 09:33:54 ERROR i.m.r.Micronaut(handleStartupException):338 - Error starting Micronaut server: Bean definition [io.airbyte.server.apis.SourceDefinitionApiController] could not be loaded: Error instantiating bean of type  [io.airbyte.persistence.job.tracker.JobTracker]
Message: No value present
Path Taken: new SourceDefinitionApiController(SourceDefinitionsHandler sourceDefinitionsHandler) --> new SourceDefinitionApiController([SourceDefinitionsHandler sourceDefinitionsHandler]) --> new SourceDefinitionsHandler(ConfigRepository configRepository,Supplier uuidSupplier,[SynchronousSchedulerClient schedulerSynchronousClient],AirbyteGithubStore githubStore,SourceHandler sourceHandler,AirbyteProtocolVersionRange protocolVersionRange) --> SynchronousSchedulerClient.synchronousSchedulerClient(TemporalClient temporalClient,[JobTracker jobTracker],JobErrorReporter jobErrorReporter,OAuthConfigSupplier oAuthConfigSupplier) --> JobTracker.jobTracker(ConfigRepository configRepository,JobPersistence jobPersistence,[TrackingClient trackingClient])
io.micronaut.context.exceptions.BeanInstantiationException: Bean definition [io.airbyte.server.apis.SourceDefinitionApiController] could not be loaded: Error instantiating bean of type  [io.airbyte.persistence.job.tracker.JobTracker]
Message: No value present
Path Taken: new SourceDefinitionApiController(SourceDefinitionsHandler sourceDefinitionsHandler) --> new SourceDefinitionApiController([SourceDefinitionsHandler sourceDefinitionsHandler]) --> new SourceDefinitionsHandler(ConfigRepository configRepository,Supplier uuidSupplier,[SynchronousSchedulerClient schedulerSynchronousClient],AirbyteGithubStore githubStore,SourceHandler sourceHandler,AirbyteProtocolVersionRange protocolVersionRange) --> SynchronousSchedulerClient.synchronousSchedulerClient(TemporalClient temporalClient,[JobTracker jobTracker],JobErrorReporter jobErrorReporter,OAuthConfigSupplier oAuthConfigSupplier) --> JobTracker.jobTracker(ConfigRepository configRepository,JobPersistence jobPersistence,[TrackingClient trackingClient])
	at io.micronaut.context.DefaultBeanContext.initializeContext(DefaultBeanContext.java:1921) ~[micronaut-inject-3.8.2.jar:3.8.2]
	at io.micronaut.context.DefaultApplicationContext.initializeContext(DefaultApplicationContext.java:249) ~[micronaut-inject-3.8.2.jar:3.8.2]
	at io.micronaut.context.DefaultBeanContext.readAllBeanDefinitionClasses(DefaultBeanContext.java:3326) ~[micronaut-inject-3.8.2.jar:3.8.2]
	at io.micronaut.context.DefaultBeanContext.finalizeConfiguration(DefaultBeanContext.java:3684) ~[micronaut-inject-3.8.2.jar:3.8.2]
	at io.micronaut.context.DefaultBeanContext.start(DefaultBeanContext.java:341) ~[micronaut-inject-3.8.2.jar:3.8.2]
	at io.micronaut.context.DefaultApplicationContext.start(DefaultApplicationContext.java:194) ~[micronaut-inject-3.8.2.jar:3.8.2]
	at io.micronaut.runtime.Micronaut.start(Micronaut.java:75) ~[micronaut-context-3.8.2.jar:3.8.2]
	at io.micronaut.runtime.Micronaut.run(Micronaut.java:323) ~[micronaut-context-3.8.2.jar:3.8.2]
	at io.micronaut.runtime.Micronaut.run(Micronaut.java:309) ~[micronaut-context-3.8.2.jar:3.8.2]
	at io.airbyte.server.Application.main(Application.java:12) ~[io.airbyte-airbyte-server-0.40.30.jar:?]
Caused by: io.micronaut.context.exceptions.BeanInstantiationException: Error instantiating bean of type  [io.airbyte.persistence.job.tracker.JobTracker]

Logs:
_msz-airbyte-updatetest_airbyte-server.1.kbpd2zhxt4qnr8meih8gc3yg3_logs.txt (21.7 KB)

marcosmarxm · February 8, 2023, 4:02pm

Hello there! You are receiving this message because none of your fellow community members has stepped in to respond to your topic post. (If you are a community member and you are reading this response, feel free to jump in if you have the answer!) As a result, the Community Assistance Team has been made aware of this topic and will be investigating and responding as quickly as possible.
Some important considerations that will help your to get your issue solved faster:

It is best to use our topic creation template; if you haven’t yet, we recommend posting a followup with the requested information. With that information the team will be able to more quickly search for similar issues with connectors and the platform and troubleshoot more quickly your specific question or problem.
Make sure to upload the complete log file; a common investigation roadblock is that sometimes the error for the issue happens well before the problem is surfaced to the user, and so having the tail of the log is less useful than having the whole log to scan through.
Be as descriptive and specific as possible; when investigating it is extremely valuable to know what steps were taken to encounter the issue, what version of connector / platform / Java / Python / docker / k8s was used, etc. The more context supplied, the quicker the investigation can start on your topic and the faster we can drive towards an answer.
We in the Community Assistance Team are glad you’ve made yourself part of our community, and we’ll do our best to answer your questions and resolve the problems as quickly as possible. Expect to hear from a specific team member as soon as possible.

Thank you for your time and attention.
Best,
The Community Assistance Team

marcosmarxm · February 10, 2023, 12:00pm

Hello alexander, it’s been a while without an update from us. Are you still having problems or did you find a solution?

aschmidt · February 13, 2023, 9:14am

Hey, we still have the problem. But instead of updating we decided to try to fix this issue our self since we’re on a deadline.

A possible solution to fix this update error would still be appreciated.

(As a clean new installation 0.40.30 works, but thats not what we want)

marcosmarxm · February 27, 2023, 8:03pm

Hello alexander, it’s been a while without an update from us. Are you still having problems or did you find a solution?

marcosmarxm · March 3, 2023, 10:15am

Can you try to upgrade to 0.41.0 version this is the new version fix some bugs.

aschmidt · May 11, 2023, 1:56pm

Hey, i just tried to update to 0.41.0 and 0.42.1 but i get a different error (from 0.40.27):

Edit: i also tried it with using new volumes but no difference

2023-05-11 13:44:21 ERROR i.a.b.Application(main):25 - Unable to bootstrap Airbyte environment.
org.jooq.exception.DataAccessException: SQL [select * from "public"."actor_definition" where ("public"."actor_definition"."release_stage" is null or "public"."actor_definition"."release_stage" <> ?::"public"."release_stage" or "public"."actor_definition"."custom")]; Error while reading field: "public"."actor_definition"."allowed_hosts", at JDBC index: 23
	at org.jooq_3.13.4.POSTGRES.debug(Unknown Source) ~[?:?]
	at org.jooq_3.13.4.POSTGRES.debug(Unknown Source) ~[?:?]
	at org.jooq.impl.Tools.translate(Tools.java:2753) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:755) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1630) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator.hasNext(CursorImpl.java:1581) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl.fetchNext(CursorImpl.java:353) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl.fetch(CursorImpl.java:339) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl.fetch(CursorImpl.java:246) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:324) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:371) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:354) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2690) ~[jooq-3.13.4.jar:?]
	at io.airbyte.config.persistence.ActorDefinitionMigrator.getConnectorRepositoryToInfoMap(ActorDefinitionMigrator.java:108) ~[io.airbyte.airbyte-config-config-persistence-0.41.0.jar:?]
	at io.airbyte.config.persistence.ActorDefinitionMigrator.updateConfigsFromSeed(ActorDefinitionMigrator.java:77) ~[io.airbyte.airbyte-config-config-persistence-0.41.0.jar:?]
	at io.airbyte.config.persistence.ActorDefinitionMigrator.lambda$migrate$0(ActorDefinitionMigrator.java:59) ~[io.airbyte.airbyte-config-config-persistence-0.41.0.jar:?]
	at io.airbyte.db.Database.lambda$transaction$0(Database.java:27) ~[io.airbyte.airbyte-db-db-lib-0.41.0.jar:?]
	at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:564) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.Tools$12$1.block(Tools.java:4926) ~[jooq-3.13.4.jar:?]
	at java.util.concurrent.ForkJoinPool.unmanagedBlock(ForkJoinPool.java:3744) ~[?:?]
	at java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3689) ~[?:?]
	at org.jooq.impl.Tools$12.get(Tools.java:4923) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533) ~[jooq-3.13.4.jar:?]
	at io.airbyte.db.Database.transaction(Database.java:27) ~[io.airbyte.airbyte-db-db-lib-0.41.0.jar:?]
	at io.airbyte.db.ExceptionWrappingDatabase.transaction(ExceptionWrappingDatabase.java:31) ~[io.airbyte.airbyte-db-db-lib-0.41.0.jar:?]
	at io.airbyte.config.persistence.ActorDefinitionMigrator.migrate(ActorDefinitionMigrator.java:57) ~[io.airbyte.airbyte-config-config-persistence-0.41.0.jar:?]
	at io.airbyte.config.persistence.ConfigRepository.seedActorDefinitions(ConfigRepository.java:1230) ~[io.airbyte.airbyte-config-config-persistence-0.41.0.jar:?]
	at io.airbyte.config.init.ApplyDefinitionsHelper.apply(ApplyDefinitionsHelper.java:70) ~[io.airbyte.airbyte-config-init-0.41.0.jar:?]
	at io.airbyte.config.init.ApplyDefinitionsHelper.apply(ApplyDefinitionsHelper.java:44) ~[io.airbyte.airbyte-config-init-0.41.0.jar:?]
	at io.airbyte.bootloader.DefaultPostLoadExecutor.execute(DefaultPostLoadExecutor.java:46) ~[io.airbyte-airbyte-bootloader-0.41.0.jar:?]
	at io.airbyte.bootloader.Bootloader.load(Bootloader.java:124) ~[io.airbyte-airbyte-bootloader-0.41.0.jar:?]
	at io.airbyte.bootloader.Application.main(Application.java:22) ~[io.airbyte-airbyte-bootloader-0.41.0.jar:?]
Caused by: java.sql.SQLException: Error while reading field: "public"."actor_definition"."allowed_hosts", at JDBC index: 23
	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.setValue(CursorImpl.java:1735) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1685) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1650) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:130) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1614) ~[jooq-3.13.4.jar:?]

	... 28 more
Caused by: org.postgresql.util.PSQLException: The column index is out of range: 23, number of columns: 22.
	at org.postgresql.jdbc.PgResultSet.checkColumnIndex(PgResultSet.java:3130) ~[postgresql-42.5.0.jar:42.5.0]
	at org.postgresql.jdbc.PgResultSet.getRawValue(PgResultSet.java:3152) ~[postgresql-42.5.0.jar:42.5.0]
	at org.postgresql.jdbc.PgResultSet.getString(PgResultSet.java:2225) ~[postgresql-42.5.0.jar:42.5.0]
	at com.zaxxer.hikari.pool.HikariProxyResultSet.getString(HikariProxyResultSet.java) ~[HikariCP-5.0.1.jar:?]
	at org.jooq.tools.jdbc.DefaultResultSet.getString(DefaultResultSet.java:114) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl$CursorResultSet.getString(CursorImpl.java:883) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.DefaultBinding$DefaultJSONBBinding.get0(DefaultBinding.java:4382) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.DefaultBinding$DefaultJSONBBinding.get0(DefaultBinding.java:4308) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.DefaultBinding$AbstractBinding.get(DefaultBinding.java:837) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.setValue(CursorImpl.java:1725) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1685) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1650) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:130) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1614) ~[jooq-3.13.4.jar:?]

	... 28 more
2023-05-11 13:44:21 INFO i.m.r.Micronaut(lambda$start$0):115 - Embedded Application shutting down

aschmidt · May 22, 2023, 2:48pm

Using a new Database also just ends in a different error message:

2023-05-22 12:53:29,942 main INFO Loading mask data from '/seed/specs_secrets_mask.yaml
    ___    _      __          __
   /   |  (_)____/ /_  __  __/ /____
  / /| | / / ___/ __ \/ / / / __/ _ \
 / ___ |/ / /  / /_/ / /_/ / /_/  __/
/_/  |_/_/_/  /_.___/\__, /\__/\___/
                    /____/
        : airbyte-bootloader :
  Micronaut (v3.8.7)
2023-05-22 12:53:33 INFO i.m.r.Micronaut(lambda$start$2):98 - Startup completed in 2425ms. Server Running: http://88782d9f1d8d:9002
2023-05-22 12:53:34 INFO i.a.c.EnvConfigs(getEnvOrDefault):1222 - Using default value for environment variable LOCAL_CONNECTOR_CATALOG_PATH: 'seed/oss_catalog.json'
2023-05-22 12:53:34 INFO i.a.b.Bootloader(load):100 - Initializing databases...
2023-05-22 12:53:34 INFO i.a.b.Bootloader(initializeDatabases):199 - Initializing databases...
2023-05-22 12:53:34 WARN i.a.d.c.DatabaseAvailabilityCheck(check):38 - Waiting for database to become available...
2023-05-22 12:53:34 INFO i.a.d.c.DatabaseAvailabilityCheck(lambda$isDatabaseConnected$1):75 - Testing airbyte configs database connection...
2023-05-22 12:53:34 INFO i.a.d.c.DatabaseAvailabilityCheck(check):57 - Database available.
2023-05-22 12:53:35 INFO i.a.d.i.DatabaseInitializer(initializeSchema):90 - The airbyte configs database is initialized
2023-05-22 12:53:35 WARN i.a.d.c.DatabaseAvailabilityCheck(check):38 - Waiting for database to become available...
2023-05-22 12:53:35 INFO i.a.d.c.DatabaseAvailabilityCheck(lambda$isDatabaseConnected$1):75 - Testing airbyte jobs database connection...
2023-05-22 12:53:35 INFO i.a.d.c.DatabaseAvailabilityCheck(check):57 - Database available.
2023-05-22 12:53:35 INFO i.a.d.i.DatabaseInitializer(initializeSchema):90 - The airbyte jobs database is initialized
2023-05-22 12:53:35 INFO i.a.b.Bootloader(initializeDatabases):202 - Databases initialized.
2023-05-22 12:53:35 INFO i.a.b.Bootloader(load):103 - Checking migration compatibility...
2023-05-22 12:53:35 INFO i.a.b.Bootloader(assertNonBreakingMigration):135 - Checking for illegal upgrade...
2023-05-22 12:53:35 INFO i.a.b.Bootloader(isLegalUpgrade):209 - No previous Airbyte Version set.
2023-05-22 12:53:35 INFO i.a.b.Bootloader(load):106 - Checking protocol version constraints...
2023-05-22 12:53:35 INFO i.a.b.ProtocolVersionChecker(validate):82 - No previous version of Airbyte detected, assuming this is a fresh deploy.
2023-05-22 12:53:35 INFO i.a.b.Bootloader(trackProtocolVersion):242 - AirbyteProtocol version support range: [0.0.0:0.3.0]
2023-05-22 12:53:35 INFO i.a.b.Bootloader(load):109 - Running database migrations...
2023-05-22 12:53:35 INFO i.a.b.Bootloader(runFlywayMigration):223 - Creating baseline for config database...
2023-05-22 12:53:35 INFO o.f.c.i.l.s.Slf4jLog(info):49 - Flyway Community Edition 7.14.0 by Redgate
2023-05-22 12:53:35 INFO o.f.c.i.l.s.Slf4jLog(info):49 - Database: jdbc:postgresql://airbyte-db:5432/airbyte2 (PostgreSQL 13.10)
2023-05-22 12:53:35 INFO o.f.c.i.l.s.Slf4jLog(info):49 - Schema history table "public"."airbyte_configs_migrations" already initialized with (0.29.0.001,Baseline from file-based migration v1). Skipping.
2023-05-22 12:53:35 INFO i.a.b.Bootloader(runFlywayMigration):225 - Creating baseline for job database...
2023-05-22 12:53:35 INFO o.f.c.i.l.s.Slf4jLog(info):49 - Flyway Community Edition 7.14.0 by Redgate
2023-05-22 12:53:35 INFO o.f.c.i.l.s.Slf4jLog(info):49 - Database: jdbc:postgresql://airbyte-db:5432/airbyte2 (PostgreSQL 13.10)
2023-05-22 12:53:35 INFO o.f.c.i.l.s.Slf4jLog(info):49 - Schema history table "public"."airbyte_jobs_migrations" already initialized with (0.29.0.001,Baseline from file-based migration v1). Skipping.
2023-05-22 12:53:35 INFO i.a.b.Bootloader(runFlywayMigration):234 - Auto database migration has been skipped.
2023-05-22 12:53:35 INFO i.a.b.Bootloader(load):112 - Creating workspace (if none exists)...
2023-05-22 12:53:35 ERROR i.a.b.Application(main):25 - Unable to bootstrap Airbyte environment.
org.jooq.exception.DataAccessException: SQL [select "public"."workspace".* from "public"."workspace"]; ERROR: relation "public.workspace" does not exist
  Position: 36
	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.AbstractQuery.execute(AbstractQuery.java:355) ~[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.lambda$listWorkspaceQuery$5(ConfigRepository.java:282) ~[io.airbyte.airbyte-config-config-persistence-0.42.1.jar:?]
	at io.airbyte.db.Database.query(Database.java:23) ~[io.airbyte.airbyte-db-db-lib-0.42.1.jar:?]
	at io.airbyte.db.ExceptionWrappingDatabase.query(ExceptionWrappingDatabase.java:31) ~[io.airbyte.airbyte-db-db-lib-0.42.1.jar:?]
	at io.airbyte.config.persistence.ConfigRepository.listWorkspaceQuery(ConfigRepository.java:278) ~[io.airbyte.airbyte-config-config-persistence-0.42.1.jar:?]
	at io.airbyte.config.persistence.ConfigRepository.listStandardWorkspaces(ConfigRepository.java:274) ~[io.airbyte.airbyte-config-config-persistence-0.42.1.jar:?]
	at io.airbyte.bootloader.Bootloader.createWorkspaceIfNoneExists(Bootloader.java:178) ~[io.airbyte-airbyte-bootloader-0.42.1.jar:?]
	at io.airbyte.bootloader.Bootloader.load(Bootloader.java:113) ~[io.airbyte-airbyte-bootloader-0.42.1.jar:?]
	at io.airbyte.bootloader.Application.main(Application.java:22) ~[io.airbyte-airbyte-bootloader-0.42.1.jar:?]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "public.workspace" does not exist
  Position: 36
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) ~[postgresql-42.5.0.jar:42.5.0]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) ~[postgresql-42.5.0.jar:42.5.0]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) ~[postgresql-42.5.0.jar:42.5.0]
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496) ~[postgresql-42.5.0.jar:42.5.0]
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413) ~[postgresql-42.5.0.jar:42.5.0]
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190) ~[postgresql-42.5.0.jar:42.5.0]
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:177) ~[postgresql-42.5.0.jar:42.5.0]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-5.0.1.jar:?]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-5.0.1.jar:?]
	at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:219) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4571) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:236) ~[jooq-3.17.8.jar:?]
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:341) ~[jooq-3.17.8.jar:?]

	... 10 more
2023-05-22 12:53:35 INFO i.m.r.Micronaut(lambda$start$0):115 - Embedded Application shutting down

Allthough the message: “ERROR: relation “public.workspace” does not exist” confuses me a bit.
In the log it states “assuming fresh deploy”, so it should check if a table exist and if not create it.

Which is correctly done for “public”.“airbyte_jobs_migrations” and “public”.“airbyte_configs_migrations” but for “public.workspace” it just crashes.

I deployed a test stack on my local machine to compare the created tables and that works fine.
I dont see the difference in deploying on a new machine and creating a new container. Postgres is bound to that container. So it should be handled as a fresh deploy

aschmidt · May 22, 2023, 4:31pm

Ooooof, it seems like i fixed it.

Oh boy, one should think first…

I forgot to update my compose.yml, which had especially the environment variable “RUN_DATABASE_MIGRATION_ON_STARTUP” and that was a no-no since the field “allowed_hosts” in “actor_definition” was removed with the update.

KMDgit · July 6, 2023, 6:58pm

Please can you guide me about how you fix it ? I’m having the same error :

2023-07-06 18:55:41 ERROR i.a.s.e.UncaughtExceptionMapper(toResponse):22 - Uncaught exception
org.jooq.exception.DataAccessException: SQL [select * from "public"."actor_definition" where "public"."actor_definition"."actor_type" = ?::"public"."actor_type"]; ERROR: could not read block 40 in file "base/16385/16969": read only 0 of 8192 bytes
        at org.jooq_3.13.4.POSTGRES.debug(Unknown Source) ~[?:?]
        at org.jooq.impl.Tools.translate(Tools.java:2753) ~[jooq-3.13.4.jar:?]
        at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:755) ~[jooq-3.13.4.jar:?]
        at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:385) ~[jooq-3.13.4.jar:?]
        at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:354) ~[jooq-3.13.4.jar:?]
        at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2690) ~[jooq-3.13.4.jar:?]
        at io.airbyte.config.persistence.DatabaseConfigPersistence.lambda$listStandardSourceDefinitionWithMetadata$13(DatabaseConfigPersistence.java:341) ~[io.airbyte.airbyte-config-persistence-0.35.11-alpha.jar:?]
        at io.airbyte.db.Database.query(Database.java:27) ~[io.airbyte.airbyte-db-lib-0.35.11-alpha.jar:?]
        at io.airbyte.db.ExceptionWrappingDatabase.query(ExceptionWrappingDatabase.java:23) ~[io.airbyte.airbyte-db-lib-0.35.11-alpha.jar:?]
        at io.airbyte.config.persistence.DatabaseConfigPersistence.listStandardSourceDefinitionWithMetadata(DatabaseConfigPersistence.java:336) ~[io.airbyte.airbyte-config-persistence-0.35.11-alpha.jar:?]
        at io.airbyte.config.persistence.DatabaseConfigPersistence.listStandardSourceDefinitionWithMetadata(DatabaseConfigPersistence.java:331) ~[io.airbyte.airbyte-config-persistence-0.35.11-alpha.jar:?]
        at io.airbyte.config.persistence.DatabaseConfigPersistence.listConfigsWithMetadata(DatabaseConfigPersistence.java:257) ~[io.airbyte.airbyte-config-persistence-0.35.11-alpha.jar:?]
        at io.airbyte.config.persistence.DatabaseConfigPersistence.listConfigs(DatabaseConfigPersistence.java:218) ~[io.airbyte.airbyte-config-persistence-0.35.11-alpha.jar:?]
        at io.airbyte.config.persistence.ValidatingConfigPersistence.listConfigs(ValidatingConfigPersistence.java:44) ~[io.airbyte.airbyte-config-persistence-0.35.11-alpha.jar:?]
        at io.airbyte.config.persistence.ConfigRepository.listStandardSourceDefinitions(ConfigRepository.java:159) ~[io.airbyte.airbyte-config-persistence-0.35.11-alpha.jar:?]
        at io.airbyte.server.handlers.SourceDefinitionsHandler.listSourceDefinitions(SourceDefinitionsHandler.java:80) ~[io.airbyte-airbyte-server-0.35.11-alpha.jar:?]
        at io.airbyte.server.apis.ConfigurationApi.execute(ConfigurationApi.java:733) ~[io.airbyte-airbyte-server-0.35.11-alpha.jar:?]
        at io.airbyte.server.apis.ConfigurationApi.listSourceDefinitions(ConfigurationApi.java:286) ~[io.airbyte-airbyte-server-0.35.11-alpha.jar:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
        at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:469) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:391) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:80) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:253) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) ~[jersey-common-2.31.jar:?]
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) ~[jersey-common-2.31.jar:?]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:292) ~[jersey-common-2.31.jar:?]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:274) ~[jersey-common-2.31.jar:?]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:244) ~[jersey-common-2.31.jar:?]
        at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) ~[jersey-common-2.31.jar:?]
        at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:232) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) ~[jersey-server-2.31.jar:?]
        at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) ~[jersey-container-servlet-core-2.31.jar:?]

aschmidt · July 10, 2023, 7:30am

Hey, its been a while but basically i checked that my docker-compose and environment vars are up to date.
While doing that i recognized the env-variable “RUN_DATABASE_MIGRATION_ON_STARTUP” which Defines if the Bootloader should run migrations on start up. Disabling/removing that fixed the error for me