Synchronizing Databases
Page 6 of 11

Concurrency During a Refresh

Cloudsync permits multiple connections to a target database. When refreshing, you may want to suspend (commit) all work in any connections other than the connection issuing the refresh statement, because active statements in other connections will block the refresh attempt, which will abort and receive an error of SQLState of 40XU1. The target application will have to issue the refresh command later, when no other connections are active, in order for the refresh to succeed.

If you permit open work in other connections during a refresh, the transactions that commit after a refresh request was initiated will not be applied at the source until the next refresh.