Micky
04/17/2023, 9:57 PMThiago Chiliatto
04/17/2023, 10:16 PMBenen Cahill
04/18/2023, 12:06 AMgod830
04/18/2023, 3:04 AMAman Kesharwani
04/18/2023, 8:32 AMError: sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: pq: relation "schema_version" does not exist
please note that I had to request to create temporal db manually and grant all permission due to limited access to RDS InstanceRachel RIZK
04/18/2023, 9:05 AMSlackbot
04/18/2023, 10:20 AMDavid Shpilfoygel
04/18/2023, 10:26 AMPhil Killarney
04/18/2023, 11:03 AMState code: 08S01; Error code: 500593; Message: [Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 403, Error message: Unknown.
Akash
04/18/2023, 11:26 AMAhmed Marzouk
04/18/2023, 12:00 PMJoe Beebee
04/18/2023, 12:52 PMAhmed Marzouk
04/18/2023, 1:45 PMMarcos Marx (Airbyte)
04/18/2023, 1:51 PMAnanya Singh
04/18/2023, 2:12 PMBas Beelen
04/18/2023, 2:50 PMairbyte-webapp | /docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
airbyte-webapp | /docker-entrypoint.sh: Configuration complete; ready for start up
airbyte-webapp | 2023/04/18 14:47:11 [emerg] 1#1: unknown "airbyte_version" variable
airbyte-webapp | nginx: [emerg] unknown "airbyte_version" variable
airbyte-webapp exited with code 0
Apurv Jain
04/18/2023, 2:52 PM2023-04-18 14:52:23 INFO i.a.v.j.JsonSchemaValidator(test):130 - JSON schema validation failed.
errors: $: null found, string expected
2023-04-18 14:52:23 INFO i.a.v.j.JsonSchemaValidator(test):130 - JSON schema validation failed.
errors: $: null found, string expected
Reza Rahim
04/18/2023, 3:08 PM2023-04-18 14:42:18 ERROR i.a.w.i.VersionedAirbyteStreamFactory(internalLog):313 - ERROR i.a.i.d.s.BaseS3Destination(check):52 Exception attempting to access the S3 bucket: com.amazonaws.SdkClientException: Unable to execute HTTP request: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at com.amazonaws.http.AmazonHttpClient$RequestExecutor.handleRetryableException(AmazonHttpClient.java:1207) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeHelper(AmazonHttpClient.java:1153) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.AmazonHttpClient$RequestExecutor.doExecute(AmazonHttpClient.java:802) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeWithTimer(AmazonHttpClient.java:770) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.AmazonHttpClient$RequestExecutor.execute(AmazonHttpClient.java:744) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.AmazonHttpClient$RequestExecutor.access$500(AmazonHttpClient.java:704) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.AmazonHttpClient$RequestExecutionBuilderImpl.execute(AmazonHttpClient.java:686) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:550) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:530) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.services.s3.AmazonS3Client.invoke(AmazonS3Client.java:5437) ~[aws-java-sdk-s3-1.12.6.jar:?]
at com.amazonaws.services.s3.AmazonS3Client.invoke(AmazonS3Client.java:5384) ~[aws-java-sdk-s3-1.12.6.jar:?]
at com.amazonaws.services.s3.AmazonS3Client.invoke(AmazonS3Client.java:5378) ~[aws-java-sdk-s3-1.12.6.jar:?]
at com.amazonaws.services.s3.AmazonS3Client.listObjects(AmazonS3Client.java:927) ~[aws-java-sdk-s3-1.12.6.jar:?]
at io.airbyte.integrations.destination.s3.S3BaseChecks.testIAMUserHasListObjectPermission(S3BaseChecks.java:133) ~[io.airbyte.airbyte-integrations.bases-base-java-s3-0.42.0.jar:?]
at io.airbyte.integrations.destination.s3.BaseS3Destination.check(BaseS3Destination.java:46) ~[io.airbyte.airbyte-integrations.bases-base-java-s3-0.42.0.jar:?]
at io.airbyte.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:126) ~[io.airbyte.airbyte-integrations.bases-base-java-0.42.0.jar:?]
at io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:101) ~[io.airbyte.airbyte-integrations.bases-base-java-0.42.0.jar:?]
at io.airbyte.integrations.base.adaptive.AdaptiveDestinationRunner$Runner.run(AdaptiveDestinationRunner.java:87) ~[io.airbyte.airbyte-integrations.bases-base-java-0.42.0.jar:?]
at io.airbyte.integrations.destination.s3.S3DestinationRunner.main(S3DestinationRunner.java:15) ~[io.airbyte.airbyte-integrations.connectors-destination-s3-0.42.0.jar:?]
Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.ssl.Alert.createSSLException(Alert.java:131) ~[?:?]
at sun.security.ssl.TransportContext.fatal(TransportContext.java:371) ~[?:?]
at sun.security.ssl.TransportContext.fatal(TransportContext.java:314) ~[?:?]
at sun.security.ssl.TransportContext.fatal(TransportContext.java:309) ~[?:?]
at sun.security.ssl.CertificateMessage$T13CertificateConsumer.checkServerCerts(CertificateMessage.java:1357) ~[?:?]
at sun.security.ssl.CertificateMessage$T13CertificateConsumer.onConsumeCertificate(CertificateMessage.java:1232) ~[?:?]
at sun.security.ssl.CertificateMessage$T13CertificateConsumer.consume(CertificateMessage.java:1175) ~[?:?]
at sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:396) ~[?:?]
at sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:480) ~[?:?]
at sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:458) ~[?:?]
at sun.security.ssl.TransportContext.dispatch(TransportContext.java:201) ~[?:?]
at sun.security.ssl.SSLTransport.decode(SSLTransport.java:172) ~[?:?]
at sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1505) ~[?:?]
at sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1420) ~[?:?]
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:455) ~[?:?]
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:426) ~[?:?]
at org.apache.http.conn.ssl.SSLConnectionSocketFactory.createLayeredSocket(SSLConnectionSocketFactory.java:436) ~[httpclient-4.5.14.jar:4.5.14]
at org.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:384) ~[httpclient-4.5.14.jar:4.5.14]
at com.amazonaws.http.conn.ssl.SdkTLSSocketFactory.connectSocket(SdkTLSSocketFactory.java:142) ~[aws-java-sdk-core-1.12.6.jar:?]
at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:142) ~[httpclient-4.5.14.jar:4.5.14]
at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:376) ~[httpclient-4.5.14.jar:4.5.14]
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 com.amazonaws.http.conn.ClientConnectionManagerFactory$Handler.invoke(ClientConnectionManagerFactory.java:76) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.conn.$Proxy28.connect(Unknown Source) ~[?:?]
at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:393) ~[httpclient-4.5.14.jar:4.5.14]
at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:236) ~[httpclient-4.5.14.jar:4.5.14]
at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186) ~[httpclient-4.5.14.jar:4.5.14]
at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185) ~[httpclient-4.5.14.jar:4.5.14]
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83) ~[httpclient-4.5.14.jar:4.5.14]
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56) ~[httpclient-4.5.14.jar:4.5.14]
at com.amazonaws.http.apache.client.impl.SdkHttpClient.execute(SdkHttpClient.java:72) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeOneRequest(AmazonHttpClient.java:1331) ~[aws-java-sdk-core-1.12.6.jar:?]
at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeHelper(AmazonHttpClient.java:1145) ~[aws-java-sdk-core-1.12.6.jar:?]
... 17 more
I have the CA added in the worker container by following commands
keytool -importcert -keystore /usr/lib/jvm/java-19-amazon-corretto/lib/security/cacerts -storepass changeit -file CA_cert.crt -alias "ca-root"
to the with os
update-ca-trust
My curl command is not giving any cert error to minio endpoint from the worker container.
need some help to fix the cert error,Dat Le Tran
04/18/2023, 5:23 PMDan Cook
04/18/2023, 5:45 PM821580693639061174
. Unfortunately the Salesforce connector is fooled into thinking these are bigints or similar, and what ends up in our warehouse is 8.215806936390611e+17
. Not only is it wrong to assume this is a number when the schema explicitly calls out the column as a string (see screenshot), but worse yet some of the characters are truncated from the end when the string is longer than 17 characters, therefore information is lost. This problem happens on both full syncs and incremental/de-dupe syncs.Dandi Qiao
04/18/2023, 8:16 PM2023-04-18 19:59:40 [32mINFO[m i.a.w.n.DefaultNormalizationRunner(close):190 - Terminating normalization process...
2023-04-18 19:59:40 [32mINFO[m i.a.w.n.DefaultNormalizationRunner(close):203 - Normalization process successfully terminated.
2023-04-18 19:59:40 [32mINFO[m i.a.w.t.TemporalAttemptExecution(lambda$getWorkerThread$5):198 - Completing future exceptionally...
io.airbyte.workers.exception.WorkerException: Dbt Transformation Failed.
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:72) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:26) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$5(TemporalAttemptExecution.java:195) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
at java.lang.Thread.run(Thread.java:1589) ~[?:?]
Caused by: io.airbyte.workers.exception.WorkerException: DBT Transformation Failed.
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:68) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
... 3 more
Suppressed: io.airbyte.workers.exception.WorkerException: Dbt transformation process wasn't successful
at io.airbyte.workers.general.DbtTransformationRunner.close(DbtTransformationRunner.java:141) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:57) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:26) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$5(TemporalAttemptExecution.java:195) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
at java.lang.Thread.run(Thread.java:1589) ~[?:?]
2023-04-18 19:59:40 [32mINFO[m i.a.w.t.TemporalAttemptExecution(get):163 - Stopping cancellation check scheduling...
2023-04-18 19:59:40 [33mWARN[m i.a.c.i.LineGobbler(voidCall):119 - generic gobbler IOException: Socket closed. Typically happens when cancelling a job.
2023-04-18 19:59:40 [32mINFO[m i.a.c.t.TemporalUtils(withBackgroundHeartbeat):283 - Stopping temporal heartbeating...
2023-04-18 19:59:40 [33mWARN[m i.t.i.a.ActivityTaskExecutors$BaseActivityTaskExecutor(execute):114 - Activity failure. ActivityId=530ea8b2-c62d-3bce-b73e-66890d2008a1, activityType=Run, attempt=1
java.lang.RuntimeException: io.temporal.serviceclient.CheckedExceptionWrapper: java.util.concurrent.ExecutionException: io.airbyte.workers.exception.WorkerException: Dbt Transformation Failed.
at io.airbyte.commons.temporal.TemporalUtils.withBackgroundHeartbeat(TemporalUtils.java:281) ~[io.airbyte-airbyte-commons-temporal-0.41.0.jar:?]
at io.airbyte.workers.temporal.sync.DbtTransformationActivityImpl.run(DbtTransformationActivityImpl.java:101) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:578) ~[?:?]
at io.temporal.internal.activity.RootActivityInboundCallsInterceptor$POJOActivityInboundCallsInterceptor.executeActivity(RootActivityInboundCallsInterceptor.java:64) ~[temporal-sdk-1.17.0.jar:?]
at io.temporal.internal.activity.RootActivityInboundCallsInterceptor.execute(RootActivityInboundCallsInterceptor.java:43) ~[temporal-sdk-1.17.0.jar:?]
at io.temporal.internal.activity.ActivityTaskExecutors$BaseActivityTaskExecutor.execute(ActivityTaskExecutors.java:95) ~[temporal-sdk-1.17.0.jar:?]
at io.temporal.internal.activity.ActivityTaskHandlerImpl.handle(ActivityTaskHandlerImpl.java:92) ~[temporal-sdk-1.17.0.jar:?]
at io.temporal.internal.worker.ActivityWorker$TaskHandlerImpl.handleActivity(ActivityWorker.java:241) ~[temporal-sdk-1.17.0.jar:?]
at io.temporal.internal.worker.ActivityWorker$TaskHandlerImpl.handle(ActivityWorker.java:206) ~[temporal-sdk-1.17.0.jar:?]
at io.temporal.internal.worker.ActivityWorker$TaskHandlerImpl.handle(ActivityWorker.java:179) ~[temporal-sdk-1.17.0.jar:?]
at io.temporal.internal.worker.PollTaskExecutor.lambda$process$0(PollTaskExecutor.java:93) ~[temporal-sdk-1.17.0.jar:?]
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: io.temporal.serviceclient.CheckedExceptionWrapper: java.util.concurrent.ExecutionException: io.airbyte.workers.exception.WorkerException: Dbt Transformation Failed.
at io.temporal.serviceclient.CheckedExceptionWrapper.wrap(CheckedExceptionWrapper.java:57) ~[temporal-serviceclient-1.17.0.jar:?]
at io.temporal.internal.sync.WorkflowInternal.wrap(WorkflowInternal.java:461) ~[temporal-sdk-1.17.0.jar:?]
at io.temporal.activity.Activity.wrap(Activity.java:52) ~[temporal-sdk-1.17.0.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.get(TemporalAttemptExecution.java:167) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
at io.airbyte.workers.temporal.sync.DbtTransformationActivityImpl.lambda$run$3(DbtTransformationActivityImpl.java:132) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
at io.airbyte.commons.temporal.TemporalUtils.withBackgroundHeartbeat(TemporalUtils.java:276) ~[io.airbyte-airbyte-commons-temporal-0.41.0.jar:?]
... 14 more
Caused by: java.util.concurrent.ExecutionException: io.airbyte.workers.exception.WorkerException: Dbt Transformation Failed.
at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396) ~[?:?]
at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073) ~[?:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.get(TemporalAttemptExecution.java:161) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
at io.airbyte.workers.temporal.sync.DbtTransformationActivityImpl.lambda$run$3(DbtTransformationActivityImpl.java:132) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
at io.airbyte.commons.temporal.TemporalUtils.withBackgroundHeartbeat(TemporalUtils.java:276) ~[io.airbyte-airbyte-commons-temporal-0.41.0.jar:?]
... 14 more
Caused by: io.airbyte.workers.exception.WorkerException: Dbt Transformation Failed.
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:72) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:26) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$5(TemporalAttemptExecution.java:195) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
... 1 more
Caused by: io.airbyte.workers.exception.WorkerException: DBT Transformation Failed.
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:68) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:26) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$5(TemporalAttemptExecution.java:195) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
... 1 more
Suppressed: io.airbyte.workers.exception.WorkerException: Dbt transformation process wasn't successful
at io.airbyte.workers.general.DbtTransformationRunner.close(DbtTransformationRunner.java:141) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:57) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.general.DbtTransformationWorker.run(DbtTransformationWorker.java:26) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$5(TemporalAttemptExecution.java:195) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
at java.lang.Thread.run(Thread.java:1589) ~[?:?]
2023-04-18 19:59:42 [32mINFO[m i.a.a.c.AirbyteApiClient(retryWithJitter):172 - Attempt 0 to get state
Micky
04/18/2023, 9:13 PMYifei Yin
04/18/2023, 9:53 PMfolder1_xxx/**
folder1_yyy/**
folder2_xxx/**
I set airbyte to read prefix folder1_
, and pattern of files to replicate to **
I was hoping it will pick up table xxx
and yyy
as two separate namespaces with different schema. It only picked up xxx
How can I make it discover all tables with different schema in different folders with the same prefix?Bob Zarkoob
04/18/2023, 10:54 PMNipuna Prashan
04/18/2023, 11:51 PMwith DAG(dag_id='airflow_airbyte_integration',
default_args=default_args,
schedule_interval=None,
) as dag:
trigger_airbyte_sync = AirbyteTriggerSyncOperator(
task_id='airbyte_trigger_sync',
airbyte_conn_id='airflow-airbyte-integration',
connection_id=AIRBYTE_CONNECTION_ID,
asynchronous=True,
wait_seconds=5
)
wait_for_sync_completion = AirbyteJobSensor(
task_id='airbyte_check_sync',
airbyte_conn_id='airflow-airbyte-integration',
airbyte_job_id=trigger_airbyte_sync.output
)
trigger_airbyte_sync >> wait_for_sync_completion
My airbyte deployment running in kubernetes pods, and the pods gets restart sometimes due to DB connection timeouts.
However, Airbyte sync completed successfully, but Airflow mentioned it failed because Airflow found the connection issue while the pod get restarted.
The failure occurs at wait_for_sync_completion
task.
Is there a way to add a retry for AirbyteJobSensor
without failing at the first instance?Slackbot
04/19/2023, 2:38 AMVaradharaj
04/19/2023, 2:41 AMRajesh Koilpillai
04/19/2023, 5:12 AMSlackbot
04/19/2023, 6:02 AMSlackbot
04/19/2023, 6:03 AM