Unable to write to or delete from the source due to a data integrity violation.
Error Details: (conn=141783) Duplicate entry '3' for key 'SURVEY_PROPERTY_ID'

Question

Hi, 
 
 I see below error while creating a record,

Unable to write to or delete from the source due to a data integrity violation. Error Details: (conn=141783) Duplicate entry '3' for key 'SURVEY_PROPERTY_ID'

There is no key ""SURVEY_PROPERTY_ID" available in either DB or Record 
 The counter seems to increase every time I try to write to record. But always shows the same error. 
 
 Thanks in advance

Shubham Aware · Accepted Answer

There might be a unique index named SURVEY_PROPERTY_ID on your table (likely leftover from a dropped column or relationship).

Run SHOW INDEX FROM <table>; You might see it. Drop that index, sync the record.

Harsha Sharma · Answer

Check if you have any triggers configured in the table that might be affecting this column in another table and causing this error

Stefan Helzle · Answer

Depending on the data model and relations, you might have to also check other tables. 
 If you implemented additional DB-logic like triggers, constraints or foreign keys, you will have to investigate these as well.

Unable to write to or delete from the source due to a data integrity violation. Error Details: (conn=141783) Duplicate entry '3' for key 'SURVEY_PROPERTY_ID'

Top Replies