Skip to main content

DELTA_CONCURRENT_DELETE_READ error condition

SQLSTATE: 2D521

Transaction conflict detected, a concurrent <operation> deleted data from table <tableName> (committed at version <version>) that this transaction read.

ALLOTTED_TIME_EXCEEDED​

Row-level conflict resolution timed out, so a conflict could not be ruled out. Retry the operation. Refer to <docLink> for more information.

CHANGE_TYPE_COLUMN​

Column '_change_type' conflicts with CDC metadata columns, preventing row-level conflict detection. Rename this column or disable CDC. Refer to <docLink> for more information.

EMPTY_READ_PREDICATES​

This transaction did not include any filters and read the entire table, conflicting with the concurrent deletion. Add filters to your query to narrow the data scope and retry the operation. Refer to <docLink> for more information.

METADATA_CHANGE​

The concurrent operation changed the table metadata (for example, schema or partitioning). Retry the operation. Refer to <docLink> for more information.

PARTITIONED_TABLE_WITHOUT_MERGE_SOURCE​

Row-level conflict detection could not be performed on this partitioned table. Retry the operation. Refer to <docLink> for more information.

PREDICATES_NEED_REWRITE​

The filter predicates used by this transaction could not be applied for row-level conflict detection. Retry the operation. Refer to <docLink> for more information.

PROTOCOL_CHANGE​

The concurrent operation upgraded the table protocol. Retry the operation. Refer to <docLink> for more information.

ROW_LEVEL_CHANGES​

The concurrent operation deleted rows that this transaction attempted to read. Retry the operation. Refer to <docLink> for more information.

WHOLE_TABLE_READ​

This transaction attempted to read the entire table, conflicting with the concurrent deletion. Add filters to your query to narrow the data scope and retry the operation. Refer to <docLink> for more information.

WHOLE_TABLE_REPLACE​

The concurrent operation replaced all data in the table. Retry the operation. Refer to <docLink> for more information.

WITHOUT_HINT​

The concurrent operation deleted data that was read by this operation. Retry the operation. Refer to <docLink> for more information.

WITH_PARTITION_HINT​

The concurrent operation deleted data in the partition <partitionValues> that was read by this operation. Retry the operation. Refer to <docLink> for more information.