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_a116
sync 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

Popular posts from this blog

more indexes

ActiveDirectory

Virtual Channel