Is this your first time deploying Airbyte?: No
Deployment: Kubernetes (GKE)
Airbyte Version: 0.40.17 → 0.50.1
Hello. I’m trying to upgrade Airbyte (deployed on GKE) from v0.40.17 version to 0.50.1 using Helm. The upgrade seems to work well (the webapp starts correctly) but if I open the “Connections” or “Sources” or “Destinations” pages I get a “Oops! Something went wrong… - Unknown error occurred” error. In the airbyte-webapp deployment logs there is a "java.lang.NumberFormatException: For input string: “1000000000000000000000000000000000” error. I tried to ugrade the connectors but it still does not work and I can’t figure out what’s going wrong exactly.
If I rollback & redeploy the 0.40.17 version I still get an error (but another one) and have to rollback the postgres (external) database too to make it work again.
Can someone help me with this issue ? Thanks !
Here is the full stacktrace :
java.lang.NumberFormatException: For input string: “1000000000000000000000000000000000” at java.lang.NumberFormatException.forInputString(NumberFormatException.java:67) ~[?:?] at java.lang.Long.parseLong(Long.java:708) ~[?:?] at java.lang.Long.valueOf(Long.java:1156) ~[?:?] at org.jooq.tools.json.Yylex.yylex(Yylex.java:659) ~[jooq-3.17.8.jar:?] at org.jooq.tools.json.JSONParser.nextToken(JSONParser.java:263) ~[jooq-3.17.8.jar:?] at org.jooq.tools.json.JSONParser.parse(JSONParser.java:112) ~[jooq-3.17.8.jar:?] at org.jooq.tools.json.JSONParser.parse(JSONParser.java:75) ~[jooq-3.17.8.jar:?] at org.jooq.tools.json.JSONParser.parse(JSONParser.java:69) ~[jooq-3.17.8.jar:?] at org.jooq.JSONB.parsed(JSONB.java:104) ~[jooq-3.17.8.jar:?] at org.jooq.JSONB.toString(JSONB.java:131) ~[jooq-3.17.8.jar:?] at org.jooq.impl.Convert$ConvertAll.from(Convert.java:701) ~[jooq-3.17.8.jar:?] at org.jooq.impl.Convert.convert0(Convert.java:433) ~[jooq-3.17.8.jar:?] at org.jooq.impl.Convert.convert(Convert.java:508) ~[jooq-3.17.8.jar:?] at org.jooq.impl.DefaultConverterProvider.lambda$provide$1(DefaultConverterProvider.java:121) ~[jooq-3.17.8.jar:?] at org.jooq.Converter$1.from(Converter.java:178) ~[jooq-3.17.8.jar:?] at org.jooq.impl.AbstractRecord.get(AbstractRecord.java:354) ~[jooq-3.17.8.jar:?] at org.jooq.impl.AbstractRecord.get(AbstractRecord.java:369) ~[jooq-3.17.8.jar:?] at io.airbyte.persistence.job.DefaultJobPersistence.getJobFromRecord(DefaultJobPersistence.java:967) ~[io.airbyte.airbyte-persistence-job-persistence-0.50.1.jar:?] at io.airbyte.persistence.job.DefaultJobPersistence.getJobsFromResult(DefaultJobPersistence.java:1039) ~[io.airbyte.airbyte-persistence-job-persistence-0.50.1.jar:?] at io.airbyte.persistence.job.DefaultJobPersistence.getJobFromResult(DefaultJobPersistence.java:1074) ~[io.airbyte.airbyte-persistence-job-persistence-0.50.1.jar:?] at io.airbyte.persistence.job.DefaultJobPersistence.getJobOptional(DefaultJobPersistence.java:706) ~[io.airbyte.airbyte-persistence-job-persistence-0.50.1.jar:?] at io.airbyte.persistence.job.DefaultJobPersistence.lambda$getLastSyncJobForConnections$42(DefaultJobPersistence.java:874) ~[io.airbyte.airbyte-persistence-job-persistence-0.50.1.jar:?] at java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:273) ~[?:?] at java.util.ArrayList$Itr.forEachRemaining(ArrayList.java:1003) ~[?:?] at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1921) ~[?:?] at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[?:?] at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[?:?] at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921) ~[?:?] at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:?] at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682) ~[?:?] at io.airbyte.persistence.job.DefaultJobPersistence.lambda$getLastSyncJobForConnections$43(DefaultJobPersistence.java:875) ~[io.airbyte.airbyte-persistence-job-persistence-0.50.1.jar:?] at io.airbyte.db.Database.query(Database.java:23) ~[io.airbyte.airbyte-db-db-lib-0.50.1.jar:?] at io.airbyte.db.ExceptionWrappingDatabase.query(ExceptionWrappingDatabase.java:31) ~[io.airbyte.airbyte-db-db-lib-0.50.1.jar:?] at io.airbyte.persistence.job.DefaultJobPersistence.getLastSyncJobForConnections(DefaultJobPersistence.java:867) ~[io.airbyte.airbyte-persistence-job-persistence-0.50.1.jar:?] at io.airbyte.commons.server.handlers.JobHistoryHandler.getLatestSyncJobsForConnections(JobHistoryHandler.java:257) ~[io.airbyte-airbyte-commons-server-0.50.1.jar:?] at io.airbyte.commons.server.handlers.WebBackendConnectionsHandler.getLatestJobByConnectionId(WebBackendConnectionsHandler.java:180) ~[io.airbyte-airbyte-commons-server-0.50.1.jar:?] at io.airbyte.commons.server.handlers.WebBackendConnectionsHandler.webBackendListConnectionsForWorkspace(WebBackendConnectionsHandler.java:156) ~[io.airbyte-airbyte-commons-server-0.50.1.jar:?] at io.airbyte.server.apis.WebBackendApiController.lambda$webBackendListConnectionsForWorkspace$4(WebBackendApiController.java:118) ~[io.airbyte-airbyte-server-0.50.1.jar:?] at io.airbyte.server.apis.ApiHelper.execute(ApiHelper.java:26) ~[io.airbyte-airbyte-server-0.50.1.jar:?] at io.airbyte.server.apis.WebBackendApiController.webBackendListConnectionsForWorkspace(WebBackendApiController.java:116) ~[io.airbyte-airbyte-server-0.50.1.jar:?] at io.airbyte.server.apis.$WebBackendApiController$Definition$Exec.dispatch(Unknown Source) ~[io.airbyte-airbyte-server-0.50.1.jar:?] at io.micronaut.context.AbstractExecutableMethodsDefinition$DispatchedExecutableMethod.invoke(AbstractExecutableMethodsDefinition.java:371) ~[micronaut-inject-3.9.2.jar:3.9.2] at io.micronaut.context.DefaultBeanContext$4.invoke(DefaultBeanContext.java:594) ~[micronaut-inject-3.9.2.jar:3.9.2] at io.micronaut.web.router.AbstractRouteMatch.execute(AbstractRouteMatch.java:303) ~[micronaut-router-3.9.2.jar:3.9.2] at io.micronaut.web.router.RouteMatch.execute(RouteMatch.java:111) ~[micronaut-router-3.9.2.jar:3.9.2] at io.micronaut.http.context.ServerRequestContext.with(ServerRequestContext.java:103) ~[micronaut-http-3.9.2.jar:3.9.2] at io.micronaut.http.server.RouteExecutor.lambda$executeRoute$14(RouteExecutor.java:659) ~[micronaut-http-server-3.9.2.jar:3.9.2] 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.2.jar:3.9.2] 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.2.jar:3.9.2] 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) ~[?:?]
It comes with the following ERROR log line
“POST /api/v1/web_backend/connections/list HTTP/1.0” 500 1329