Data disappeared in 1P Mac

chucksense

Today when I went to fire up 1P6 and entered my master password, two of my vaults were completely empty.

I quit 1P and 1P Mini, restored the ~/Library/Application Support/1Password 4/ folder from a Time Machine backup and when I fired up 1P6, the vault still showed as empty. I quit both again and read the sqlite database which was showing over 2000 records in the items table.

I then launched 1P6 and did File->Restore from a backup (which unfortunately means I lost a few records as it was prior to creating some new passwords).

So, the good news is I'm back up and running (albeit missing a couple of things), but I'd like to understand what happened here so I can avoid this going forward! What do you need from me? Console doesn't show anything that seems valuable here.

Thank you,
-Chuck

---

1Password Version: 6.2.1
Extension Version: Not Provided
OS Version: 10.10.5
Sync Type: WiFi

chucksense

Found a few things that might be interesting in the logs:

Mon May 2 09:02:04 2016| 621002 [DATABASE:(Main Thread):<OP4Database: 0x7fc4da20bf70>] S openDatabaseWithError: | SQLite Version: 3.8.5 Mon May 2 09:02:04 2016| 621002 [DATABASE:(Secondary Thread 0x7fc4d8745ba0):<B5Database: 0x7fc4da20c140>] S openDatabaseWithError: | SQLite Version: 3.8.5

Mon May 2 09:02:46 2016| 621002 [SQLITE:(Secondary Thread 0x7fc4d85f7130):<SQLite: 0x7fc4d840a850>] E update:error:applyBindings: | Update failed 'INSERT INTO items (profile_id, category_id, category_uuid, fave_index, section_name, folder_id, folder_uuid, uuid, updated_at, created_at, tx_timestamp, trashed, scope, title, key_data, overview_data,id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)': database disk image is malformed

A bunch of things that look like this:

Mon May 2 09:02:47 2016| 621002 [SYNC:(Secondary Thread 0x7fc4dd2243b0):<OPSyncAnalysis: 0x7fc4dd14ad30>] S addNote: | Conflict detected, local object <OPSecureNote-20E9C447B1374C3C8E0F6B29D1533433-2012 0x7fc4dd12b400> the winner, merging with <OPSecureNote-20E9C447B1374C3C8E0F6B29D1533433-0 0x7fc4dd1504a0>

nathanvf

Hi there @chucksense,

I'm sorry you experienced this issue.

Assuming this was not you accidentally installing the App Store and AgileBits webstore versions of the app something may indeed have gone wrong with your data.

I'd wonder if you recently changed syncing methods recently? You didn't seem to mention recovering from syncing however, so I wonder if you sync at all.

I'd love to take a closer look at your system to see if we can determine why this happened (and to give you better instructions to get back up and running).

I'd like to ask you to create a Diagnostics Report from your Mac:

https://support.1password.com/diagnostics/mac.html

Attach the Diagnostics Report to an email message addressed to support+forum@agilebits.com.

Please do not post your Diagnostics Report in the forums, but please do include a link to this thread in your email, along with your forum handle so that we can "connect the dots" when we see your Diagnostics Report in our inbox.

You should receive an automated reply from our BitBot assistant with a Support ID number. Please post that number here so we can track down the report and ensure that it is dealt with quickly. :)

chucksense

Sent. #WUG-82978-863

nathanvf

Great @chucksense,

We'll take a look at your data and correspond through email from here.