firebird - Data Pass Through in SymmetricDS -


i'm feeling little stupid, , searches answers haven't yielded else having problem.

imagine have nodehq, node1 , node2. have created triggers synchronize tablea between 3 so:

node1 <---> nodehq <---> node2 

node1 , node2 have different subsets of data each other. nodehq has administrative information both nodes (subsets of both). each of 3 nodes in different node_group.

right now, triggers , routers have setup, inserting/updating/deleting record @ nodehq works @ node1 , node2. however, if make change @ node1 or node2, makes nodehq. never passes through other.

so far i've tried:

  • setting sync_on_incoming_batch 1 triggers involved, no change
  • creating separate sym_trigger each node_group, no change
  • using transforms alter record innocuously, no change
  • deleting , inserting of rules, no change
  • using symadmin sync-triggers -f force trigger recreation, no change

i've read user guides , down on this, , relatively unspecific this. http://www.symmetricds.org/doc/3.6/user-guide/html/advanced.html#bi-direction-sync

right now, of nodes have sync_enabled=1. of sym_triggers set sync_on_incoming_batch=1. sym_routers set sync=1, , using router_type='default'. i'll honest, i've tried lot of other small things, nothing seems make pass on data next node_group. i'm running out of ideas.

their own documentation indicates sync_on_incoming_batch makes trigger passes data onto other nodes @ each place arrives. far though, changes have yielded nothing. what's left try? or think should do?

i using firebird 2.52 , sql dialect 1.

so in running version 3.7.19 of symmetricds in debug, discovered triggers weren't being regenerated in circumstances changing sym tables. whenever changed rules, logs indicated remaking relating triggers.

the solution: running symadmin sync-triggers -f on every engine. forces every single trigger regenerated, , seems have fixed this. i'll track down developers nip in bud.


Comments

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

multithreading - Exception in Application constructor -

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -