SQLite Error Prevents Starting

zuel

The last week 1Password for Windows has not been able to start even after logging out/in and rebooting the system. The log files just contain lines such as 24312 2021-06-13 00:14:38 0.000s ERR opw_app::app_services:26 > opw-sqlite\src\lib.rs:221 The database returned an error

Going back a few days the logs leading up to the error are
7840 2021-06-03 23:36:11 4000.475s INFO opw_app::managers::cloud_sync_manager:450 > account ******************************************** synced in 3250ms 7840 2021-06-03 23:36:57 4048.750s INFO opw_app::browser_listener:134 > b5x/29 disconnected 7840 2021-06-03 23:36:57 4049.377s INFO opw_app::browser_listener:134 > b5x/28 disconnected 7840 2021-06-03 23:37:09 4049.377s ERR opw_app::managers::item_manager:249 > fn on_disable_mfa_complete() error: opw-network\src\network_error.rs:63 HTTP request could not be sent 7840 2021-06-03 23:37:09 4061.738s WRN opw_app::managers::item_manager:249 > message handler on_disable_mfa_complete took 60037ms to work 7840 2021-06-03 23:37:09 4061.738s WRN opw_app::managers::network_manager:220 > HTTP request could not be sent due to a network error. 7840 2021-06-03 23:37:09 4061.757s INFO opw_app::browsers::b5x:136 > b5x/29 received NmRequestAccounts (version: 1) 7840 2021-06-03 23:37:09 4061.758s INFO opw_app::browsers::b5x:136 > b5x/28 received NmRequestAccounts (version: 1) 7840 2021-06-03 23:37:09 4061.758s ERR opw_ipc:315 > failed to output message from port 28: opw-ipc\src\lib.rs:472 WriteFile (error code 6: The handle is invalid.) 7840 2021-06-03 23:37:09 4061.758s ERR opw_app::browsers::b5x:32 > opw-ipc\src\lib.rs:472 WriteFile (error code 6: The handle is invalid.) 7840 2021-06-03 23:37:09 4061.758s ERR opw_app::managers::item_manager:249 > fn on_refresh_from_database() error: opw-sqlite\src\lib.rs:221 The database returned an error 7840 2021-06-03 23:37:09 4061.762s ERR opw_app::managers::item_manager:249 > fn on_hibp_result_ready() error: opw-sqlite\src\lib.rs:221 The database returned an error 7840 2021-06-03 23:37:09 4061.762s INFO opw_app::browsers::b5x:202 > b5x/29 received NmLockState 7840 2021-06-03 23:37:09 4061.762s INFO opw_app::browsers::b5x:202 > b5x/28 received NmLockState 7840 2021-06-03 23:37:09 4061.762s ERR opw_ipc:315 > failed to output message from port 28: opw-ipc\src\lib.rs:472 WriteFile (error code 6: The handle is invalid.) 7840 2021-06-03 23:37:09 4061.762s ERR opw_app::browsers::b5x:32 > opw-ipc\src\lib.rs:472 WriteFile (error code 6: The handle is invalid.) 7840 2021-06-03 23:37:09 4061.762s INFO opw_app::browsers::b5x:202 > b5x/28 received NmLockState 7840 2021-06-03 23:37:09 4061.762s ERR opw_ipc:315 > failed to output message from port 28: opw-ipc\src\lib.rs:472 WriteFile (error code 6: The handle is invalid.) 7840 2021-06-03 23:37:09 4061.762s ERR opw_app::browsers::b5x:32 > opw-ipc\src\lib.rs:472 WriteFile (error code 6: The handle is invalid.) 7840 2021-06-03 23:37:09 4061.762s INFO opw_app::browsers::b5x:202 > b5x/29 received NmLockState 7840 2021-06-03 23:37:09 4061.762s INFO opw_app::browsers::b5x:202 > b5x/28 received NmLockState 7840 2021-06-03 23:37:09 4061.762s ERR opw_ipc:315 > failed to output message from port 28: opw-ipc\src\lib.rs:472 WriteFile (error code 6: The handle is invalid.) 7840 2021-06-03 23:37:09 4061.762s ERR opw_app::browsers::b5x:32 > opw-ipc\src\lib.rs:472 WriteFile (error code 6: The handle is invalid.) 7840 2021-06-03 23:37:09 4061.762s INFO opw_app::browsers::b5x:202 > b5x/29 received NmLockState 7840 2021-06-03 23:37:09 4061.762s WRN opw_network::proxy_config:81 > proxy could not be set 7840 2021-06-03 23:37:09 4061.768s ERR opw_app::managers::network_manager:110 > fn on_http_request_failed() error: opw-sqlite\src\lib.rs:221 The database returned an error 7840 2021-06-03 23:37:14 4061.768s ERR opw_app::managers::security_manager:75 > could not get auto-lock seconds: opw-sqlite\src\lib.rs:221 The database returned an error

What do I do now to once again use 1Password?

---

1Password Version: 7.7.805
Extension Version: 2.0.2
OS Version: WIN 10.0.19042
Sync Type: 1Password Cloud

ag_ana

Hi @zuel!

I would like to ask you to generate a diagnostics report from your PC and email it to us to support+forum@agilebits.com, so we can take a closer look at why this is happening to you.

After you have sent the email, please feel free to post the ticket number you received so we can locate your message and connect it with this forum discussion.

Looking forward to your message!

zuel

Maybe I am missing something but how am I going to generate a report via the 1Password menu if the application itself crashes and wont start?

Blake

That's a pretty good point @zuel 😬

Instead, can you zip up the logs found in C:\Users\%username%\AppData\Local\1Password\logs and send those into us at the same email Ana provided earlier?

zuel

Linking ticket id is [#UVF-36153-567]

Dayton_ag

Thanks a bunch, @zuel! We'll link up with you there. :smile:

ref: UVF-36153-567

mgorman

I too am having the same exact problem. I have sent an email to support+forum@agilebits.com including the logs directory zipped.

Support ticket # is #IZL-14197-972

Regards,
Michael

ag_ana

@mgorman:

Thank you! I confirm that I have managed to locate your diagnostics report in our system :+1: We will take a look and someone will get back to your email as soon as possible.

Thank you for your patience!

ref: IZL-14197-972

sushidad

Is there a solution? Mine doesn't work as well with the same symptoms

sushidad

Fixed by [removed - see post below]

Dayton_ag

@sushidad I'm glad to hear that you were able to find a solution that worked for you!

I hope you don't mind, but I edited your original message to remove the step you used to resolve this issue. The reason I did so is that in some situations, that particular action can cause loss of 1Password data for the user. Since other users may come across this thread and try that solution, we'd prefer that these users write us so we can give them the personal help they need to get 1Password running again while minimizing any potential risks.

For anyone who needs assistance with this issue, please shoot us an email at support+windows@1password.com, and we'll be glad to help. :smile: