CODEWITHSUNDEEP
replicationddlsymmetricds
Lucas Ramos
Lucas Ramos

Reputation: 13

DDL Replication Issue with SymmetricDS: New fields do not replicate inserted data

I'm using SymmetricDS to replicate a table structure (DDL), and I ran the following sequence of commands to sync the triggers and send the table schema:

bin\symadmin.bat -e rada-000 --node=001 sync-triggers bin\symadmin.bat -e rada-000 --node=001 send-schema TABLE

After replicating the DDL, the new field in the table appears correctly in the target database. However, when I insert data into this table, the content of the new field is not being replicated to the target node. The other data in the table is replicated without issues.

I have verified that:

Question: What might be preventing the replication of the data in the new field? Is there any additional procedure I should follow after DDL replication to ensure that the data in the new fields is properly replicated?

Environment:

Upvotes: 1

Views: 90

Answers (1)

user27954769
user27954769

Reputation: 36

Here is the command you should run on node 000: bin\symadmin.bat -e rada-000 sync-triggers

If this is not detecting the change in the table you can use :bin\symadmin.bat -e rada-000 sync-triggers -f to force it to rebuild the trigger.

It should automatically sync triggers on the target node when it detects a schema change is loaded. There was a bug related to this issue that was fixed in 3.15.8 https://issues.symmetricds.org/view.php?id=6526

Upvotes: 2

Related Questions