Hi,
our database structure has some tables with classic master-detail structure. What we have noticed is that sometimes replication of detail table fails because the master record isn't replicated before (Foreign key constraint exception). Looking at sym_data and sym_data_event we can see that master row has a correct data_id (minor than the detail's one) so it should be replicated before the detail row and everything should work as expected. Reloading master tables or inserting missing rows fix the problem and everything runs as expected.
How is possible to "lose" some rows? Shouldn't symmetric follow insert/update order?
Thanks,
Marco
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, today we encountered the same issue... master data is not routed and detail data insert throws a foregin key exception. Any idea?
What's strange is that master data not inserted/routed for which an exception in thrown was created on master node on 14/11/2015 but all data created in 13/11/2015 are missing too.
Thanks,
Marco
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
our database structure has some tables with classic master-detail structure. What we have noticed is that sometimes replication of detail table fails because the master record isn't replicated before (Foreign key constraint exception). Looking at sym_data and sym_data_event we can see that master row has a correct data_id (minor than the detail's one) so it should be replicated before the detail row and everything should work as expected. Reloading master tables or inserting missing rows fix the problem and everything runs as expected.
How is possible to "lose" some rows? Shouldn't symmetric follow insert/update order?
Thanks,
Marco
Hi, today we encountered the same issue... master data is not routed and detail data insert throws a foregin key exception. Any idea?
What's strange is that master data not inserted/routed for which an exception in thrown was created on master node on 14/11/2015 but all data created in 13/11/2015 are missing too.
Thanks,
Marco
are u using master-master or master-slave approach?
Master-slave