View Issue Details

IDProjectCategoryView StatusLast Update
0003755SymmetricDSBugpublic2018-10-17 13:08
ReporterYuntianAssigned To 
Prioritynormal 
Status feedbackResolutionopen 
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

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?

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