I have sync problems with “Direct Connection” and verification doesn’t help
(DTPO 2.7):
I tried to sync a database to another Mac via “Direct Connection”.
Got error “Verification failed. Please repair the database using the menu
command Tools > Verify & Repair.”
I’ve done a verify/repair with the result of 1 remaining error. IIRC it was
missing file or something like that.
I’ve done a “Rebuild Database” which took a long time
Re-tried to sync and got the same error as above
Again verify & repair: No feedback (so no need to repair, I guess).
Tried to sync ==> same error.
I can successfully sync some of my other databases. Others have the same
problem as described above.
(BTW: It is confusing that – even successful – syncing doesn’t give any
feedback / progress indicator. Also Verify & Repair should give some feedback
if everything is ok.)
Rebuild probably will not fix a missing file. To fix, run V&R. You’ll get the error. Open the Log. Look for the entry that says “missing”. Navigate to that document. Delete it. Empty the trash. Run V&R again and you should be good to go.
(This process should be simple. It is not. Another feature request, perhaps? )
No, V&R is fine now, but the sync log still tells me to V&R. Another database also was successfully repaired (w/o need to rebuild), and there also the sync log tells me to do it again.
If the database is corrupt, why V&R (from the menu) doesn’t report it? (and hopefully repair it.)
If the database is OK, why V&R (internally called by the sync) does report it as corrupt?
There have been inconsistencies also in the sync target’s databases. I repaired these and now all databases sync without problems.
So V&R from the menu only checked the local database while V&R called by the sync also checked the remote (target) database. Hence the different results. (It would be useful if the error log tells me which database has the issues.)
Sorry for the noise. Anyway, it is good to know that also the target database has to be issue-free. I didn’t consider this at first because I assumed that (unidirectional) syncing would – by nature – overwrite any faults in the target database (provided that the source is faultfree).
Yes, but does it make sense?
I’m no database expert, but if the source database is verified a one-way sync could/should just overwrite any potential issues in the target database, no?
Does this mean that files in the “target” database that have a more recent modification date or that don’t exist in the “source” database are backsynced to the source?