Handling record locking and interrupted sync

[Andreas T.]

How does Mirrorsync deal with potential record locking (due to record being in use by another user) during sync?

 

Also, how are any interruptions handled during sync, say a network disconnect?

 

Thanks,

Andreas

[Jesse Barnum]

If the connection is dropped during a sync, MirrorSync keeps track of which records have been written and which ones have not, and it will resume from where it was on the next sync and complete everything as if the first sync had finished. If a record on the server cannot be written because it is being edited, the offline user will get a warning error message telling them this. MirrorSync will continue to retry that edit operation each time the sync script is run.

The best way to see this happen is to try our live demo. Download an offline file from this URL:

 

http://sync.360works.com/MirrorSync/dbDownload/1aae5f3c-b4d0-4a2b-98f1-448f84fb51f7

 

First test out the syncing a bit to see how it works. Then open the server version of the file, edit a record without committing it, modify the same record on the offline file, and try to sync.