View Issue Details

IDProjectCategoryView StatusLast Update
0003755SymmetricDSBugpublic2019-08-26 08:45
ReporterYuntianAssigned To 
Prioritynormal 
Status closedResolutionopen 
Product Version3.9.14 
Target VersionFixed in Version 
Summary0003755: Cannot update row when primary key data type is char/nchar(n)
DescriptionWhen the primary key is char/nchar the initial load is fine but any update on source node cannot be populated to destination node with following error:

Detected conflict while executing UPDATE on SyncTest.Test. The primary key data was: {id=1 }. Failed to fallback. The original error message was: Duplicate entry '1' for key 'PRIMARY'

When primary key in the set up script is changed to int, the update can complete successfully. I'm trying to stick to minimum configuration on my set up script so it is easy for me to see what's wrong though. Maybe there is a setting to enable support for char/nchar but that's not on by default unlike int which works out of box.

Please see attachments for set up script and full log.
Steps To Reproduce1. Set up Debian 9 for SDS, MSSQL 2014 for src and MySQL 8 for dest
2. Run sds.sh on Debian to set up and check MySQL for initial load
3. Run "update Test set Value = 'Test2'" on MSSQL
4. Detected conflict while executing UPDATE
Tagsdata sync, dialect: sql-server

Activities

Yuntian

2018-10-12 12:35

reporter  

sds.sh (3,331 bytes)
symmetric.log (223,383 bytes)

Yuntian

2018-10-12 12:37

reporter   ~0001271

Error message in Description is not exactly how it is in the log file. The trailing space on primary key was removed.

hanes

2018-10-17 13:08

developer   ~0001281

I am unable to recreate this issue after trying a few different approaches. Is there something additional about the database table that you didn't mention? Could you make use of varchar(10) as a work around perhaps?

admin

2019-08-26 08:45

administrator   ~0001577

Auto closing all issues waiting for feedback after 4 months. We don't have enough information to take any action.

Issue History

Date Modified Username Field Change
2018-10-12 12:35 Yuntian New Issue
2018-10-12 12:35 Yuntian File Added: sds.sh
2018-10-12 12:35 Yuntian File Added: symmetric.log
2018-10-12 12:37 Yuntian Note Added: 0001271
2018-10-17 13:08 hanes Status new => feedback
2018-10-17 13:08 hanes Note Added: 0001281
2019-04-25 10:32 elong Tag Attached: data sync
2019-04-25 10:32 elong Tag Attached: dialect: sql-server
2019-08-26 08:45 admin Note Added: 0001577
2019-08-26 08:45 admin Status feedback => closed