CODEWITHSUNDEEP
symmetricds
CSL
CSL

Reputation: 75

[SymmetricDS]: Missing changes in SYM_DATA

I have new records insert into source database but some records are not synced to target database. When I look into SYM_DATA, between 2 consecutive insert there are some update event triggered to the same table but different row. Log file has deadlocks error but after retry becomes OK.

My question is can SymmetricDS trigger update and insert if both event type happen together ? How to avoid deadlocks and make sure no missing records to sync from source to target ?

Upvotes: 0

Views: 312

Answers (1)

Boris Pavlović
Boris Pavlović

Reputation: 64632

Data can not be synced only if it hasn't been inserted or editing data updated in the database. SymmetricDs extraction of data happens in the same transaction as the application uses. Check if there data has been successfully inserted or updates. Maybe some transactions have been rolled back. If they have been successfully committed order the table sym_data by its primary key data_id description to be sure you haven't missed a row.

Upvotes: 0

Related Questions