Etienne GIROT
01/18/2023, 10:33 AMVIEW
in Postgres, and when building views, there are apparently no way to tell PG to consider some column NOT NULL
.
So when airbyte performs the query (here is code):
SELECT (EXISTS (SELECT FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'payment_metrics' AND is_nullable = 'YES' AND column_name = 'trace_start')) AND (EXISTS (SELECT from public."payment_metrics" where "trace_start" IS NULL LIMIT 1)) AS nullValue
(where payment_metrics
is my view and trace_start
is the column used as a cursor)
It takes forever...
I have no way of:
• forcing PG to consider trace_start
as is_nullable = 'NO'
• creating index so that the SELECT ... IS NULL LIMIT 1
is fast
◦ although none of the values are null...
Is there a way that I can tell airbyte to skip that check?toumask
01/18/2023, 11:05 AMAkilesh V
01/18/2023, 11:20 AMhubspot
connection we are enable deals
streams with incremental | deduped history
sync mode, but in deals_properties contains duplicate row, is there any solution get rid of duplicates without modifying DBT script or changing sync mode.Miguel Ángel Torres Font - Valencia C.F.
01/18/2023, 11:25 AMihsan islam
01/18/2023, 11:29 AM2023-01-18 11:25:04 INFO i.a.w.t.TemporalAttemptExecution(get):136 - Docker volume job log path: /tmp/workspace/da20fe77-8a29-4276-9668-4d7e68c3140e/0/logs.log
2023-01-18 11:25:04 INFO i.a.w.t.TemporalAttemptExecution(get):141 - Executing worker wrapper. Airbyte version: 0.40.28
2023-01-18 11:25:04 INFO i.a.a.c.AirbyteApiClient(retryWithJitter):172 - Attempt 0 to save workflow id for cancellation
2023-01-18 11:25:04 INFO i.a.c.i.LineGobbler(voidCall):114 -
2023-01-18 11:25:04 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK -----
2023-01-18 11:25:04 INFO i.a.c.i.LineGobbler(voidCall):114 -
2023-01-18 11:25:04 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-zoho-crm:0.1.0 exists...
2023-01-18 11:25:04 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-zoho-crm:0.1.0 was found locally.
2023-01-18 11:25:04 INFO i.a.w.p.DockerProcessFactory(create):120 - Creating docker container = source-zoho-crm-check-da20fe77-8a29-4276-9668-4d7e68c3140e-0-jhenx with resources io.airbyte.config.ResourceRequirements@6740bbac[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=]
2023-01-18 11:25:04 INFO i.a.w.p.DockerProcessFactory(create):164 - Preparing command: docker run --rm --init -i -w /data/da20fe77-8a29-4276-9668-4d7e68c3140e/0 --log-driver none --name source-zoho-crm-check-da20fe77-8a29-4276-9668-4d7e68c3140e-0-jhenx --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e FIELD_SELECTION_WORKSPACES= -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e APPLY_FIELD_SELECTION=false -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/source-zoho-crm:0.1.0 -e AUTO_DETECT_SCHEMA=false -e AIRBYTE_VERSION=0.40.28 -e WORKER_JOB_ID=da20fe77-8a29-4276-9668-4d7e68c3140e airbyte/source-zoho-crm:0.1.0 check --config source_config.json
2023-01-18 11:25:04 INFO i.a.w.i.VersionedAirbyteStreamFactory(create):100 - Reading messages from protocol version 0.2.0
2023-01-18 11:25:07 ERROR i.a.w.i.DefaultAirbyteStreamFactory(internalLog):116 - Check failed
2023-01-18 11:25:07 INFO i.a.w.g.DefaultCheckConnectionWorker(run):110 - Check connection job received output: io.airbyte.config.StandardCheckConnectionOutput@6a6fef64[status=failed,message=Exception("Error while refreshing access token: 'access_token'")]
2023-01-18 11:25:07 INFO i.a.w.t.TemporalAttemptExecution(get):163 - Stopping cancellation check scheduling...
2023-01-18 11:25:07 INFO i.a.c.i.LineGobbler(voidCall):114 -
2023-01-18 11:25:07 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK -----
2023-01-18 11:25:07 INFO i.a.c.i.LineGobbler(voidCall):114 -
Grember Yohan
01/18/2023, 11:45 AMreact-dom.production.min.js:216 Error: Internal Server Error: Cannot invoke "io.airbyte.config.storage.CloudStorageConfigs.getType()" because the return value of "io.airbyte.config.helpers.LogConfigs.getStorageConfigs()" is null
at apiOverride.ts:107:9
at f (regeneratorRuntime.js:86:17)
at Generator._invoke (regeneratorRuntime.js:66:24)
at Generator.next (regeneratorRuntime.js:117:21)
at r (asyncToGenerator.js:3:20)
at u (asyncToGenerator.js:25:9)
Downgrading from 0.40.28 to 0.40.27 fixes this issue.
Should I share this somewhere specific to document this regression and improve its chances to be fixed?wolfgan dand
01/18/2023, 12:27 PMMcKenna West
01/18/2023, 3:50 PMDanish Raza
01/18/2023, 4:21 PMFrancesco F
01/18/2023, 5:01 PMdocker compose up
command, as it seems like my VSCode keeps loading in a loop.
Any suggestion? I have installed Docker and it seems to be up and running correctly.god830
01/18/2023, 6:56 PMgod830
01/02/2023, 5:18 PMHTTPError('400 Client Error: Bad Request for url: <https://7074563.suitetalk.api.netsuite.com/services/rest/record/v1/contact?limit=1>')
The only post I can find related to this is unsolved: https://discuss.airbyte.io/t/airbyte-netsuite-connector-400-client-error/2948ihsan islam
01/18/2023, 10:16 PMWalker Philips
01/18/2023, 10:45 PMSean Zicari
01/19/2023, 12:10 AMVincent Koc
01/19/2023, 12:44 AMLukas Holdorf
01/04/2023, 2:35 PMTmac Han
01/19/2023, 3:07 AM김건희
01/19/2023, 3:27 AMLihan Li
01/19/2023, 5:33 AMAkilesh V
01/19/2023, 6:40 AM023-01-18 06:42:02 [33mWARN[m i.a.s.s.AirbyteGithubStore(getLatestSources):69 - Unable to retrieve latest Source list from Github. Using the list bundled with Airbyte. This warning is expected if this Airbyte cluster does not have internet access.
java.io.IOException: Connection reset
at jdk.internal.net.http.HttpClientImpl.send(HttpClientImpl.java:857) ~[java.net.http:?]
at jdk.internal.net.http.HttpClientFacade.send(HttpClientFacade.java:123) ~[java.net.http:?]
at io.airbyte.server.services.AirbyteGithubStore.getFile(AirbyteGithubStore.java:83) ~[io.airbyte-airbyte-server-0.40.3.jar:?]
at io.airbyte.server.services.AirbyteGithubStore.getLatestSources(AirbyteGithubStore.java:67) ~[io.airbyte-airbyte-server-0.40.3.jar:?]
at io.airbyte.server.handlers.SourceDefinitionsHandler.getLatestSources(SourceDefinitionsHandler.java:136) ~[io.airbyte-airbyte-server-0.40.3.jar:?]
at io.airbyte.server.handlers.SourceDefinitionsHandler.listLatestSourceDefinitions(SourceDefinitionsHandler.java:131) ~[io.airbyte-airbyte-server-0.40.3.jar:?]
at io.airbyte.server.apis.ConfigurationApi.execute(ConfigurationApi.java:870) ~[io.airbyte-airbyte-server-0.40.3.jar:?]
at io.airbyte.server.apis.ConfigurationApi.listLatestSourceDefinitions(ConfigurationApi.java:326) ~[io.airbyte-airbyte-server-0.40.3.jar:?]
at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:578) ~[?:?]
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:?]
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) ~[jersey-container-servlet-core-2.31.jar:?]
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) ~[jersey-container-servlet-core-2.31.jar:?]
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) ~[jersey-container-servlet-core-2.31.jar:?]
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) ~[jersey-container-servlet-core-2.31.jar:?]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) ~[jetty-servlet-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:569) ~[jetty-servlet-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1377) ~[jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:507) ~[jetty-servlet-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1292) ~[jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.Server.handle(Server.java:501) ~[jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~[jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) [jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) [jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) [jetty-server-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [jetty-io-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [jetty-io-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) [jetty-util-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) [jetty-util-9.4.31.v20200723.jar:9.4.31.v20200723]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [jetty-util-9.4.31.v20200723.jar:9.4.31.v20200723]
at java.lang.Thread.run(Thread.java:1589) [?:?]
Caused by: java.net.SocketException: Connection reset
at sun.nio.ch.SocketChannelImpl.throwConnectionReset(SocketChannelImpl.java:401) ~[?:?]
at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:434) ~[?:?]
at jdk.internal.net.http.SocketTube.readAvailable(SocketTube.java:1178) ~[java.net.http:?]
at jdk.internal.net.http.SocketTube$InternalReadPublisher$InternalReadSubscription.read(SocketTube.java:841) ~[java.net.http:?]
at jdk.internal.net.http.SocketTube$SocketFlowTask.run(SocketTube.java:181) ~[java.net.http:?]
at jdk.internal.net.http.common.SequentialScheduler$SchedulableTask.run(SequentialScheduler.java:230) ~[java.net.http:?]
at jdk.internal.net.http.common.SequentialScheduler.runOrSchedule(SequentialScheduler.java:303) ~[java.net.http:?]
at jdk.internal.net.http.common.SequentialScheduler.runOrSchedule(SequentialScheduler.java:256) ~[java.net.http:?]
at jdk.internal.net.http.SocketTube$InternalReadPublisher$InternalReadSubscription.signalReadable(SocketTube.java:782) ~[java.net.http:?]
at jdk.internal.net.http.SocketTube$InternalReadPublisher$ReadEvent.signalEvent(SocketTube.java:965) ~[java.net.http:?]
at jdk.internal.net.http.SocketTube$SocketFlowEvent.handle(SocketTube.java:253) ~[java.net.http:?]
at jdk.internal.net.http.HttpClientImpl$SelectorManager.handleEvent(HttpClientImpl.java:1337) ~[java.net.http:?]
at jdk.internal.net.http.HttpClientImpl$SelectorManager.lambda$run$3(HttpClientImpl.java:1282) ~[java.net.http:?]
at java.util.ArrayList.forEach(ArrayList.java:1511) ~[?:?]
at jdk.internal.net.http.HttpClientImpl$SelectorManager.run(HttpClientImpl.java:1282) ~[java.net.http:?]
Ben
01/19/2023, 8:00 AMJosé Lúcio Zancan Júnior
01/19/2023, 8:10 AMUnhandled error while executing model.airbyte_utils.norm_ads_insights_stg
Pickling client objects is explicitly not supported.
Clients have non-trivial state that is local and unpickleable.
1 of 50 ERROR creating view model _airbyte_medialake_fb.norm_ads_insights_stg........................................... [ERROR in 1.00s]
Pickling client objects is explicitly not supported.
Clients have non-trivial state that is local and unpickleable.
Thanks.Vincent Koc
01/19/2023, 8:12 AMGiorgos Tzanakis
01/19/2023, 8:18 AMUmar Hussain
01/19/2023, 10:59 AMSrinidhi krishnamurthy
01/19/2023, 11:53 AMJusten Walker
01/19/2023, 12:24 PMNaren Kadiri
01/19/2023, 1:04 PM