Internal Server Error when inserting data into actor table


The error message indicates a null value in the column ‘default_version_id’ of the ‘actor’ table is violating a not-null constraint.


"event": "response content is:
b'{\"message\":\"Internal Server Error: SQL [insert into \\\\\"public\\\\\".\\\\\"actor\\\\\"
(\\\\\"id\\\\\", \\\\\"workspace_id\\\\\", \\\\\"actor_definition_id\\\\\",
\\\\\"name\\\\\", \\\\\"configuration\\\\\", \\\\\"actor_type\\\\\", \\\\\"tombstone\\\\\", \\\\\"created_at\\\\\", \\\\\"updated_at\\\\\") values
(cast(? as uuid), cast(? as uuid), cast(? as uuid), ?, cast(? as jsonb), cast(?
as \\\\\"public\\\\\".\\\\\"actor_type\\\\\"),
?, cast(? as timestamp(6) with time zone), cast(? as timestamp(6) with time
zone))]; ERROR: null value in column \\\\\"default_version_id\\\\\"
of relation \\\\\"actor\\\\\" violates
not-null constraint\\\\n Detail: Failing row contain

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["internal-server-error", "insert-error", "sql-error", "not-null-constraint", "actor-table"]

Based on the information provided in the extracts, it seems like you’re encountering an “Internal Server Error” due to a null value in the “default_version_id” column of the “actor” relation, which violates a not-null constraint. This error typically occurs when you’re trying to insert a null value into a column that has been set to not accept null values. In this case, the “default_version_id” column in the “actor” table is not accepting null values. Unfortunately, the extracts do not provide a direct solution to this issue. However, you might want to check the data you’re trying to insert to ensure that there are no null values for the “default_version_id” column. If the “default_version_id” is supposed to accept null values, you might need to alter your table schema to allow this. For more specific help, you might want to post your question on the Airbyte discussion forum or check out the Airbyte documentation for more information on handling data with Airbyte.