Then it is a mystery why the sync problems are happening sometimes but not always.
Not necessarily always a mystery. See…
In fact…
Well this morning on my two home Macs the databases do verify and the syncing works fine.
Would be more likely to indicate some of the aforementioned possiblities at play.