Determining source(s) of opvault size, also looking for a compacting feature

I went ahead and inspected my Win10 parents’ 1password vault, synced via Dropbox to my Mac OSX 10.14.6 as follows. In 1password7 for Mac, created a SmartFilter to search through all items where number of file attachments is greater than zero. Inside 1PW, for each file attachment, clicked the drop down box to select “show in finder”, then did Command + I on the attachment to inspect file size. These are the results:

• Total number of items in vault: 490 items
• Items with attachments: 30 items
• Total number of attachments: 50 files
• Max, Min, and Ave file size: 4.2 MB, 711 bytes, 1.81 MB
• Sum of file attachments : 90.7 MB

In Finder, I dropped down under “1Password.opvault” to “show package contents”. Under that file, under \default\, there are 2,245 items, no individual file larger than 4.4 MB, all adding up to 5.22 GB. A subset of those files include 2,226 *.attachment files. In this type of file, I see a lot of conflicted copy files named like this:

32D8A8B3B3F343D2898F95CEE7A064BA_BC88D4BA-F72F-4CEB-BF71-30D61560A716 (parent’s conflicted copy 2020-01-20 1).attachment

My parents’ vault has 2,161 of these conflicted copy *.attachment files. In comparison, my vault has 5. Could these conflict copies be a source of vault size inflation?

@Greg thanks.... onto the next step:

If you have access to this vault in 1Password 7 on your Mac, please try to create a new vault in your Dropbox, copy your data from this old vault to a new one, and check how much space this new vault uses on your computer.

Yes, I have access. I am super confused at the moment about what 1PW is doing. On my Mac, I only have the option of creating a new vault "ON MY MAC". The File > new vault function does not permit creating a vault directly in Dropbox in one step. I created a new vault, and now have a "testvault". I populated "testvault" with the records from the parents' conflicted opvault. My problem is that I can't find testvault.opvault on my Mac hard drive anywhere. I tried my SmartFolder trick to find file attachments in this testvault, then did a "show in finder" on the attachment. That let me to a bizarre location on the Mac's harddrive:

MacHD⁩ ▸ ⁨private⁩ ▸ ⁨var⁩ ▸ ⁨folders⁩ ▸ ⁨w_⁩ ▸ ⁨qb9xct650wvfymk48d7qb0r40000gn⁩ ▸ ⁨T⁩ ▸ ⁨com.agilebits.onepassword7⁩ ▸ ⁨com.agilebits.Attachments.noindex⁩ ▸ ⁨EFDB8B2DB2D24645B058AA8C6AE038A4⁩ ▸ ⁨DDDCEEA8E34D447888F7B41216D74DDB⁩

Nothing in this location looks like a vault file. Since I can't find where testvault is, I can't inspect it for size. Mac version of 1PW does not appear to have the same functionality of the Windows version, where you can click the 3 dot icon next to the vault name to located it in Explorer. My usual Mac trick of Command + comma > sync tab does not show a file pathway because "testvault" is not in Dropbox. Using Finder search, name:.opvault returns my 2 production vaults. Does not show the testvault. Also rebooted just to see if that helped, no dice.

Help!

I want "testvault" deleted off my hard drive eventually, after we figure out the conflict file issue.

P.S. Yes, I want the parents on 1password.com for families. Dad is refusing. I will be able to make this change for them at some point, but now isn't that time.

@Greg why oh why did I not figure this out yesterday! Thanks again. I completed this, testvault.opvault in Dropbox is 92.5 MB with the original 490 items, 30 items, same attachment numbers. So definitely something wrong in the parents' real vault.

Two more questions:

1) Do I need to do this for real, and swap out the parents' corrupt .opvault file with a "fixed" one? Or is there another way to repair their vault? If this is the way to fix their vault, is the preferred way for them using 1Password for Windows to create the new vault? Or can I safely do it for them using my Mac version of 1Password? I'll likely be remote desktoping into their PCs either way, to finish off the 1pw app config, so having to create a new vault in their Windows app is no issue for me.

2) On my Mac, when I delete testvault.opvault in 1Password (click 3 dot icon > Delete vault), will that completely delete this test vault off my Mac hard drive both in the Dropbox and outside of the Dropbox directory? The way the Sync tab worded moving testvault to Dropbox is that the syncing would create two copies of testvault, one in Dropbox and the original testvault that resided in a mystery location.

@Greg

1) Create a new vault in 1Password on your Mac.

perfect, know exactly what I need to do. thank you for working through this issue with me.

As for your second question, when you delete your vault via 1Password for Mac, it should delete it from everywhere. Let us know if that is not the case.

you never answered my question about figuring out where testvault resides when not sync'd into Dropbox so I don't really have a way to measure if the delete behaves as expected. So going back to my Feb. 6 question, before copying a vault into Dropbox, where on a Mac hard drive does the testvault data exist? I never could figure this out...

still recommend you to upgrade to 1Password account

I will definitely raise this idea and explain the why behind this issue, but even if the parents agree to the change today, we won't be making this change for the family until I visit them in person. Wildly hugely bigly bad idea to do this without in-person assistance right now. First need to a) fix my NAS - disk failure, b) rebuild my Mac - OS corruption, c) fix Dad's new computer - repeat blue screen of death + other broken stuff, d) resurface fiberglass bathtub - cracked, then e) set up 1password subscription for the family assuming nothing else breaks. In positive news, my phone isn't broken, so I've got that going for me.

please note that this is Dropbox creating those conflicts, not 1Password

not assigning blame towards AgileBits. I suspected as much given the creation dates on the conflict copies. If you look at other recent threads from me, you'll note that recently my Dad updated his PC Win7 -> Win10. We had other problems with Dropbox during the migration that affected data & applications beyond 1password. Not happy with Dropbox at all atm.

Thanks again... let me know about my Feb 6 question, and I'm good to go~

@Greg perfect, let the repair commence.

If something goes sideways, I'll report back. Thank you for working through this with me.

As for your second question, when you delete your vault via 1Password for Mac, it should delete it from everywhere. Let us know if that is not the case.

So I deleted testvault using Mac version of 1Password v7.4.2, and the delete did not perform as expected.

• OnePassword.sqlite file size pre-delete 246.3 MB, post 246.3 MB, so unchanged
• testvault.opvault still remains in Dropbox.

Just to confirm my method > open 1Password > under "ON DROPBOX" section > click the 3 dot icon next to testvault > select "Delete vault..." > retyped testvault to confirm the delete > observed file size and files remained.

Normal or not?

Afternoon @Greg ~

Got things cleaned up today, switched over all the PCs and phones, new vault size for M&D is <100mb. Thanks again.