replicationddlsymmetricds

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:


Solution

  • 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