Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

ORA-03827

deadlock detected between Barrier DDL statement on table string.string and a concurrently running DML statement on the same table (root cause is string, string)

Cause

While a sharding replication unit Barrier DDL statement was in progress there was a concurrently running DML statement referencing the same table as that referenced in the Barrier DDL statement. Both the DDL and the DML deadlocked while trying to access the same resources and same locks.


Action

To avoid resource contention try to run one statement followed by the other statement.