Error: Serialization Isolation Violation on Tablelink
Issuelink
While scheduling a transformation, the following error appears:
There may be errors that need to be addressed before the transformation can successfully run: java.sql.SQL.Exception: \[Amazon\](500310) Invalid operation: 1023 Details: Serializable isolation violation on table.
Environmentlink
Transformation on Redshift
Resolutionlink
This error appears when you schedule the transformation during a time that interferes with Fivetran sync queries on that table.
To solve this issue, schedule the transformation queries after the Fivetran sync or when Fivetran is not due to sync this table.
Causelink
We receive this error from Redshift when we try to access and run a query against a table while another query runs on the same table. Concurrent transactions are invisible to each other. They cannot detect each other's changes. As a result, Redshift doesn't allow such transactions.