Kevin Lin
12/05/2022, 5:44 PMCamilo Atencio
12/05/2022, 7:29 PMGraeme Morrell
12/05/2022, 8:03 PMJordan Fox
12/05/2022, 8:13 PMAabi
12/05/2022, 8:39 PMChen Huang
12/05/2022, 11:49 PMJonathan Cachat PhD (JC)
12/06/2022, 5:02 AMTmac Han
12/06/2022, 6:28 AMTmac Han
12/06/2022, 6:39 AMSheshan
12/06/2022, 6:44 AMHunterZhang
12/06/2022, 7:12 AMHunterZhang
12/06/2022, 7:14 AMPhuc Dinh Minh
12/06/2022, 7:37 AMInternal Server Error: SQL [insert into "public"."operation" ("id", "workspace_id", "name", "operator_type", "operator_normalization", "operator_dbt", "operator_webhook", "tombstone", "created_at", "updated_at") values (cast(? as uuid), cast(? as uuid), ?, ?::"public"."operator_type", cast(? as jsonb), cast(? as jsonb), cast(? as jsonb), ?, cast(? as timestamp with time zone), cast(? as timestamp with time zone))]; ERROR: insert or update on table "operation" violates foreign key constraint "operation_workspace_id_fkey" Detail: Key (workspace_id)=(xxxxxxxxxxxxxx) is not present in table "workspace".
I tried to
• docker-compose down
• delete airbyte-workspace volume
But it doesn't work
I check airbyte log, and the airbyte-cron show: DefinitionsUpdater(updateDefinitions):54 - Connector definitions update disabled.
How can I fix thiss!!!Dheeraj Pranav
12/06/2022, 8:14 AMMihály Dombi
12/06/2022, 8:45 AMAvi Sagal
12/06/2022, 10:06 AMBhavya Verma
12/06/2022, 11:09 AMAlfred Johnson
12/06/2022, 11:23 AMFlorent
12/06/2022, 11:34 AMBeeshal Rizal
12/06/2022, 12:05 PMAayush Sharma
12/06/2022, 12:13 PMStephan Mitterer
12/06/2022, 12:38 PMFaris
12/06/2022, 2:06 PM2022-12-05 21:45:37 normalization > Completed with 2 errors and 0 warnings:
2022-12-05 21:45:37 normalization > Database Error in model employees_stg (models/generated/airbyte_incremental/jisr_rr/employees_stg.sql)
2022-12-05 21:45:37 normalization > time zone displacement out of range: "+105454-01-01"
2022-12-05 21:45:37 normalization > Database Error in model payruns_stg (models/generated/airbyte_incremental/jisr_rr/payruns_stg.sql)
2022-12-05 21:45:37 normalization > time zone displacement out of range: "+20225-08-25T09:18:47.000000"
2022-12-05 21:45:37 normalization > CONTEXT: parallel worker
2022-12-05 21:45:37 normalization > Done. PASS=39 WARN=0 ERROR=2 SKIP=4 TOTAL=45
2022-12-05 21:45:37 INFO i.a.w.g.DefaultNormalizationWorker(run):93 - Normalization executed in 47 seconds.
2022-12-05 21:45:37 ERROR i.a.w.g.DefaultNormalizationWorker(run):101 - Normalization Failed.
2022-12-05 21:45:37 INFO i.a.w.g.DefaultNormalizationWorker(run):106 - Normalization summary: io.airbyte.config.NormalizationSummary@7552a195[startTime=1670276689822,endTime=1670276737454,failures=[io.airbyte.config.FailureReason@50b1ff7[failureOrigin=normalization,failureType=system_error,internalMessage=time zone displacement out of range: "+105454-01-01",externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@552949c2[additionalProperties={attemptNumber=2, jobId=79, from_trace_message=true}],stacktrace=AirbyteDbtError:
9 of 45 ERROR creating incremental model _airbyte_jisr_rr.employees_stg................................................. [ERROR in 1.08s]
Upon working to produce the error from the source tables (aws postgres), none of the date/timestamp columns could through this error. Did anyone face this issue?Will Callaghan
12/06/2022, 3:01 PMKalaSai
12/06/2022, 4:18 PMMessage: Index 1 out of bounds for length 1
Path Taken: new ApplicationInitializer() --> ApplicationInitializer.checkConnectionActivities --> List.checkConnectionActivities([CheckConnectionActivity checkConnectionActivity]) --> new CheckConnectionActivityImpl(WorkerConfigs workerConfigs,ProcessFactory processFactory,SecretsHydrator secretsHydrator,Path workspaceRoot,WorkerEnvironment workerEnvironment,LogConfigs logConfigs,[AirbyteApiClient airbyteApiClient],String airbyteVersion,AirbyteMessageSerDeProvider serDeProvider,AirbyteMessageVersionedMigratorFactory migratorFactory)
io.micronaut.context.exceptions.BeanInstantiationException: Error instantiating bean of type [io.airbyte.workers.temporal.check.connection.CheckConnectionActivityImpl]
Ethan Brouwer
12/06/2022, 5:03 PMGopinath Sekar
12/06/2022, 5:41 PMKrishna Elangovan
12/06/2022, 6:47 PMKevin Peters
12/06/2022, 8:09 PMv0.40.23
and now all of my connections have begun to fail after the normalization stage.Maksym Humeniuk
12/06/2022, 8:31 PMFailure Origin: normalization, Message: Normalization failed during the dbt run. This may indicate a problem with the data itself.
I found the same issue on Airbyte forum but there is no solution. Anyone faced issue like this?