Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wallchanhk
Starting Member
2 Posts |
 Posted - 2010-10-13 : 16:20:27
|
| Hi,We're using 2005 merge replication and we found that some records deletion cannot synchronize from publisher table to other subscriber table. (This table have very small size(<1000 records). we are using SQL Server Enterprise Editions(2005) with SP2 and we have 3 servers and below is our replication topology:Server 1 (Pub) <-> Server 2 (Sub) with merge replicationServer2 (Pub) <-> Server 3 (Sub) with merge replicationServer3 (Pub) <-> Server 1 (Sub) with merge replicationThe above 3 replications settings were designed to cater single point of failure(i.e. when one server is down, the others two can synchronize with each other) and were able to handle and resolve conflicts.The problem occurs on one table(which often have only < 1000 records) and we have batch job that always insert 10 to 20 records then do some select checking and then delete them in several seconds. The 1st insert can always sync from Pub to Sub but the second delete may not sync from Pub to Sub and result in serious replication out-of sync.We can simulate the deletion outsync problem in UAT and please find the atttached merge agent log(-OutputVerboseLevel 4) of our 3 servers. The deletion outsync occurs at 13-Oct 08:15:25 to 08:17:10 where 20 delete transactions occur between this time. Server 1 can delete all 20 records successfully, but server 2 can only delete 14 records successfully and cause 6 records outsync(which is the earliest 6 records to be deleted) and server 3 can delete all 20 records successfully. Does this sympthon also affect batch job insert and update transactions? Since our clients stop to pay because of this deletion outsync, any fast response are appreciated.P.S: We have the log(~1M) but how can we attach this log to your forum? (If we try to post all this log contents directly it would fail to submit) Thanks and regards,Wallace |
|
|
wallchanhk
Starting Member
2 Posts |
Posted - 2010-10-14 : 23:44:52
|
| Hi,I have upload the merge agent log file(-OutputVerboseLevel 4) and here is the web link:http://www.mediafire.com/?g0xzzbdb232sbsfThanks and regards,WallaceP.S: sitnaccdb61 is server 1, uatnacmai51 is server 2, sitnacmai52 is server 3, merge_agent_CDB1.log is server 1 merge agent log, merge_agent_CDB2.log is server 2 merge agent log, merge_agent_CDB3.log is server 3 merge agent log |
 |
|
|
|
|
|
|
|
replication deletion cannot be sync