I got Sync Failed when I added retention tag

I add TEMPORAL_HISTORY_RETENTION_IN_DAYS=7 to .env on Airbyte version 0.43.0
However, all my working connection stop sync, it show below error. I was only able to get successful sync after I removed the tag TEMPORAL_HISTORY_RETENTION_IN_DAYS=7.

Please, I need insight why the version of Airbyte is not allow this tag to be set in env file


Sync Failed

0 Bytesno recordsno records36s

Failure Origin: source, Message: State code: 08001; Message: The connection attempt failed.

12:53PM 04/08

2023-04-08 11:54:23 - Additional Failure Information: io.airbyte.commons.exceptions.ConnectionErrorException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 10009ms.

/tmp/workspace/42857/0/logs.log

2023-04-08 11:53:49 INFO i.a.a.c.AirbyteApiClient(retryWithJitter):179 - Attempt 0 to get state

2023-04-08 11:53:49 INFO i.a.a.c.AirbyteApiClient(retryWithJitter):179 - Attempt 0 to set attempt sync config

2023-04-08 11:53:49 INFO i.a.v.j.JsonSchemaValidator(test):129 - JSON schema validation failed.

errors: $.method: must be a constant value Standard

2023-04-08 11:53:49 WARN c.n.s.JsonMetaSchema(newValidator):278 - Unknown keyword max - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword

2023-04-08 11:53:49 WARN c.n.s.JsonMetaSchema(newValidator):278 - Unknown keyword min - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword

2023-04-08 11:53:49 INFO i.a.v.j.JsonSchemaValidator(test):129 - JSON schema validation failed.

errors: $.hmac_key_secret: object found, string expected, $.hmac_key_access_id: object found, string expected

2023-04-08 11:53:49 INFO i.a.v.j.JsonSchemaValidator(test):129 - JSON schema validation failed.

errors: $.format_type: does not have a value in the enumeration [Avro], $.compression_codec: is missing but it is required

2023-04-08 11:53:49 INFO i.a.v.j.JsonSchemaValidator(test):129 - JSON schema validation failed.

errors: $.format_type: does not have a value in the enumeration [CSV]

2023-04-08 11:53:50 INFO i.a.c.t.s.DefaultTaskQueueMapper(getTaskQueue):31 - Called DefaultTaskQueueMapper getTaskQueue for geography auto

2023-04-08 11:53:56 INFO i.a.w.t.s.a.JobCreationAndStatusUpdateActivityImpl(createNewJob):181 - Found the following streams to reset for connection 9c12b53a-de37-4c4f-b1e5-524739241402:

2023-04-08 11:53:57 INFO i.a.p.j.DefaultJobPersistence(enqueueJob):188 - enqueuing pending job for scope: 9c12b53a-de37-4c4f-b1e5-524739241402

2023-04-08 11:53:57 INFO i.a.w.t.s.a.JobCreationAndStatusUpdateActivityImpl(createNewJob):218 - New job created, with id: 42858

2023-04-08 11:54:06 INFO i.a.w.t.TemporalAttemptExecution(get):142 - Docker volume job log path: /tmp/workspace/42857/0/logs.log

2023-04-08 11:54:06 INFO i.a.w.t.TemporalAttemptExecution(get):147 - Executing worker wrapper. Airbyte version: 0.43.0

2023-04-08 11:54:06 INFO i.a.a.c.AirbyteApiClient(retryWithJitter):179 - Attempt 0 to save workflow id for cancellation

2023-04-08 11:54:07 INFO i.a.c.EnvConfigs(getEnvOrDefault):1222 - Using default value for environment variable METRIC_CLIENT: ‘’

2023-04-08 11:54:07 WARN i.a.m.l.MetricClientFactory(initialize):60 - Metric client is already initialized to

2023-04-08 11:54:07 INFO i.a.w.g.DefaultReplicationWorker(run):158 - start sync worker. job id: 42857 attempt id: 0