Caused by: org.jooq.exception.DataAccessException:...
# replication-troubleshooting
c
Caused by: org.jooq.exception.DataAccessException: SQL [insert into "public"."actor_catalog_fetch_event" ("id", "actor_id", "actor_catalog_id", "config_hash", "actor_version", "modified_at", "created_at") values (cast(? as uuid), cast(? as uuid), cast(? as uuid), ?, ?, cast(? as timestamp with time zone), cast(? as timestamp with time zone))]; ERROR: null value in column "actor_id" of relation "actor_catalog_fetch_event" violates not-null constraint Detail: Failing row contains (f8d15d30-8df9-42ae-a424-e2063a341212, 29b27343-639b-48f7-90bf-07f83593f804, null, null, null, 2022-10-08 182729.247629+00, 2022-10-08 182729.247629+00).
✍️ 1
🙏 1
e
Hi. The error is that actor_id is null and it cannot be a primary key since null != null in memory i.e. the address is different for each null (though i did find dbs that make it so that it`s 1 null address to all) are you saying that you are 100% sure that actor_id is not null?
c
it is an assumption I don't know why I get that error, my source is postgres in cloud sql
u
@[DEPRECATED] Marcos Marx turned this thread into Zendesk ticket 2682 to ensure timely resolution!
m
What version of Airbyte are you using? In what step this happen? Can you share the complete log?