"Simply use FCPXML to move from one Mac to the other. AirDrop works great for this."
Thanks for the tip. But doing a full XML export/import/AirDrop every time I want to move from the dining room to the family room or a coffee shop would be a royal chore. Much simpler to make sure I quit FCP on one Mac (and let the sync finish; usually very fast with Dropbox) before starting on the other.
"Dropbox, as stated, causes issues with FCPX and can corrupt Libraries and Projects."
I'm not sure that's clear at all. To answer @terryb's question: yes, for any given file on Dropbox, you don't want to modify the same file in two places at once. This is not a reality unique to FCP; it applies to any file. I also don't think it's unique to Dropbox, but rather applies to any cloud-storage provider. Copying files atomically doesn't help maintain integrity when a "library" is composed of hundreds or thousands of separate databases and config files and data files that function as a unit. If half of those files are synced and the other half have not, then any other user accessing "the library" now has an inconsistent view of the data. And since I think most cloud-storage providers do copy individual files and don't have a concept of a "bundle" of files treated in an "all or nothing" fashion.
So the correct practice would ALWAYS be to 1) close the library on one machine and 2) let it sync to the other before opening it on the other. This is a given.
The precise question here is really:
IF you ACCIDENTALLY open a project in Dropbox on two Macs at once, what will happen? @terryb said it should alert the second "user" that the library is already open elsewhere. I still have to try that to see if it's true. And if it IS true, then I don't see how Dropbox would corrupt the library, since it won't allow it to be open at two places at once in the first place. The type of issues like "data write ordering", as @joema raised, should only be an issue if you need data consistency while both users DO have the same file open at the same time, which ostensibly FCP won't permit.
What I'm hearing here are two conflicting answers that people are trying to allow to co-exist: that 1) FCP protects you from an attempt at opening a library in two places, but 2) that doing so still risks corrupting your file. And again, I'm not talking about the case of opening a library that is either still open elsewhere, or which is partially-synced: those are definitely problematic (for any file, and for any cloud storage provider).
If I were to go back to my OP and try to answer my own question about apparent data loss based on this discussion, I would speculate that the following happened:
1) FCP Library opened on Mac #1 and changes made
2) Dropbox was not running properly on Mac #1, and so didn't upload the changes <<< I have seen this happen only on my MacBook; some type of odd issue where sometimes the service silently stops
3) FCP Library opened on Mac #2; FCP didn't complain about the opening of the library on Mac #1 since that didn't sync to Mac #2 yet; also I didn't notice the previous edits from Mac #1 were missing, and new changes were made
4) Dropbox on Mac #2 uploaded the new changes to cloud
5) At this point, one of several things could have happened:
a) If the Dropbox service on Mac #1 was still down, then opening it again on Mac #1 would not show the changes from Mac #2. Then, if new changes are made and Dropbox service is restored, the changes from Mac #2 would be overwritten by these newer ones from Mac #1.
b) if Dropbox service on Mac #1 was restored after (3), then now the cloud was presented with two conflicting sets of FCP changes. Whichever one Dropbox picks as "truth", the other Mac's changes will be lost.
So here's my current takeaway for best practices for using an FCP library on Dropbox or other cloud storage:
1) Configure all those storage location settings such that all dependencies on media and backups also be synced to the cloud
2) AFTER making changes on a given Mac, close the FCP Library and make sure the sync up to the cloud completes.
3) BEFORE making changes on a given Mac, make sure Dropbox syncs fully before opening the FCP Library.
If you think I'm missing anything, please let me know and I'll update! And I will try that test tonight....