V
Valeriy Bashkatov
Guest
Hi Dmitri, [quote user="Dmitri Levin"] All those 4 threads are processing the same one table "inv-balance". [/quote] I think the problem is here. You are using four threads for one table, but as I can see from the logs filename, you have not used split replication threads. Right? Also, do you use compression triggers? Probably the problem is that all four threads are trying to write changes to the same target records. Try to enable advanced logging for replbatch processes (Verbose). This writes additional information into logs for each individual replqueue record processed, including the ROWID of the record. I suppose this way you can see that replication processes are trying to process the same record. So in addition to Mike's advice, make sure you are using Replication Triggers with Splitting Replication Threads and Compression to process that table. Hope this helps. Regards, Valeriy
Continue reading...
Continue reading...