[api] 500 NullPointerException error when listing resources

[LouisAuneau]

Hello!

I upgrade our OSS k8s install of Airbyte to the latest version (chart 0.53.120 and containers in 0.50.48, and all source/destinations in their respective latest versions). After setting a port-forward to the API server, I manage to get a 200 when reaching GET http://localhost:8006/health or retrieving a specific resource (GET http://localhost:8006/v1/workspaces/<workspace_id>). However, for other endpoint that list resources (workspaces, connections, sources), I get a 500 error. Looking at the log, I get a NullPointerException that is not really explicit.

Here is an example log for GET http://localhost:8006/v1/connections:

ERROR i.m.h.s.RouteExecutor(logException):444 - Unexpected error occurred: null
java.lang.NullPointerException: null
	at io.airbyte.api.server.services.ConnectionServiceImpl.listConnectionsForWorkspaces(ConnectionService.kt:251) ~[io.airbyte-airbyte-api-server-0.50.48.jar:?]
	at io.airbyte.api.server.controllers.ConnectionsController.listConnections$lambda$9(ConnectionsController.kt:232) ~[io.airbyte-airbyte-api-server-0.50.48.jar:?]
	at io.airbyte.api.server.apiTracking.TrackingHelper.callWithTracker(TrackingHelper.kt:107) ~[io.airbyte-airbyte-api-server-0.50.48.jar:?]
	at io.airbyte.api.server.controllers.ConnectionsController.listConnections(ConnectionsController.kt:231) ~[io.airbyte-airbyte-api-server-0.50.48.jar:?]
	at io.airbyte.api.server.controllers.$ConnectionsController$Definition$Exec.dispatch(Unknown Source) ~[io.airbyte-airbyte-api-server-0.50.48.jar:?]
	at io.micronaut.context.AbstractExecutableMethodsDefinition$DispatchedExecutableMethod.invoke(AbstractExecutableMethodsDefinition.java:371) ~[micronaut-inject-3.10.1.jar:3.10.1]
	at io.micronaut.context.DefaultBeanContext$4.invoke(DefaultBeanContext.java:594) ~[micronaut-inject-3.10.1.jar:3.10.1]
	at io.micronaut.web.router.AbstractRouteMatch.execute(AbstractRouteMatch.java:303) ~[micronaut-router-3.10.1.jar:3.10.1]
	at io.micronaut.web.router.RouteMatch.execute(RouteMatch.java:111) ~[micronaut-router-3.10.1.jar:3.10.1]
	at io.micronaut.http.context.ServerRequestContext.with(ServerRequestContext.java:103) ~[micronaut-http-3.10.1.jar:3.10.1]
	at io.micronaut.http.server.RouteExecutor.lambda$executeRoute$14(RouteExecutor.java:659) ~[micronaut-http-server-3.10.1.jar:3.10.1]
	at reactor.core.publisher.FluxDeferContextual.subscribe(FluxDeferContextual.java:49) ~[reactor-core-3.5.5.jar:3.5.5]
	at reactor.core.publisher.InternalFluxOperator.subscribe(InternalFluxOperator.java:62) ~[reactor-core-3.5.5.jar:3.5.5]
	at reactor.core.publisher.FluxSubscribeOn$SubscribeOnSubscriber.run(FluxSubscribeOn.java:194) ~[reactor-core-3.5.5.jar:3.5.5]
	at io.micronaut.reactive.reactor.instrument.ReactorInstrumentation.lambda$init$0(ReactorInstrumentation.java:62) ~[micronaut-runtime-3.10.1.jar:3.10.1]
	at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:84) ~[reactor-core-3.5.5.jar:3.5.5]
	at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:37) ~[reactor-core-3.5.5.jar:3.5.5]
	at io.micronaut.scheduling.instrument.InvocationInstrumenterWrappedCallable.call(InvocationInstrumenterWrappedCallable.java:53) ~[micronaut-context-3.10.1.jar:3.10.1]
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[?:?]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
	at java.base/java.lang.Thread.run(Thread.java:1583) [?:?]

Would you know what could be the issue here ?

Thank you by advance,
Louis

[LouisAuneau]

FYI, I manage to understand the issue. Listing items requires to find WorkspaceIds which used to work even if you weren't authenticated (it returned all workspaces). However it now returns an empty list of workspaces, which results in a 500 error in later calls.

To work around this issue you need to either:

• Provide an explicit list of workspaceIds as HTTP parameter,
• Provide Authorization HTTP header.