7 Azure Sync Groups Stuck at "Processing" status
hi,
another round of "processing" stuck has come again, time, 7 sync groups affected. issue appear more 9 month , still waiting ms find root cause.
ew_sync_a116sync group id
0c3d051a-8175-4f65-96e4-b57dd366ed24_east asia
location
east asia
subscription id
3913aa5e-85f9-4af4-8c64-a887c8e6d0f8
conflict resolution
client wins
ew_sync_a106
sync group id
649a784a-7d4e-4ac2-92cb-332b54b05e46_east asia
location
east asia
subscription id
43051d1f-7dc4-4e4f-81f4-3e027983733c
conflict resolution
client wins
ew_sync_a103
sync group id
6bb865e0-e5a6-49e7-b396-5dafe7734291_east asia
location
east asia
subscription id
3913aa5e-85f9-4af4-8c64-a887c8e6d0f8
ew_sync_a089
sync group id
687c7810-5235-43f7-b47a-914997ff9de0_east asia
location
east asia
subscription id
43051d1f-7dc4-4e4f-81f4-3e027983733c
conflict resolution
client wins
ew_sync_a080
sync group id
f67398fc-4358-4469-aa66-43ea48281bba_east asia
location
east asia
subscription id
43051d1f-7dc4-4e4f-81f4-3e027983733c
ew_sync_a059
sync group id
a4020aa0-4e12-4523-8d4e-56cc3302370e_east asia
location
east asia
subscription id
cda925fa-16c4-44b6-b3dc-8fc0cb82ad07
ew_sync_a003
sync group id
f6d51362-7a47-47fb-84b3-9c23445626e3_east asia
location
east asia
subscription id
f979186d-23f7-45e3-8d5e-c14c89c56a7f
is there can in front end in order prevent happened? 7 sync groups across different locations, each of them stable internet connection, across different db server, different subscriptions, frustrated issue each day need check across 150 sync groups our clients see if there's "processing" stuck. :(
thanks help.
best regards,
michael yung
hi michael,
for first sync stuck problem, root cause agent in unreachable stage sync cannot complete.
for second sync problem, not stuck, doing conflict resolution time-consuming. please follow http://msdn.microsoft.com/en-us/library/azure/hh667328.aspx#initialsync avoid conflict resolving process.
regards,
bowen
Microsoft Azure > Azure SQL Database
Comments
Post a Comment