iOS App - Showing "Some" passwords - "Database Statement Execution Failed" errors

Installation Issues
1

Passbolt Community Edition: 5.6.0
Server: Ubuntu 22.04 LTS running VirtualMin (LAMP Stack)
Passbolt iOS App 2.3.1

I am having a strange issue where only some passwords are visible on the iOS app (Approximately 5% of all passwords). When I try to refresh the list of password I receive the error message “Database Statement Execution Failed”. I only see this error when I refresh the list of password on the app.

All password are accessible through the web browser and desktop apps and I’ve tried to run

pwhtsi@ubuntu1:~/public_html$ ./bin/cake passbolt cleanup

     ____                  __          ____
    / __ \____  _____ ____/ /_  ____  / / /_
   / /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
  / ____/ /_/ (__  |__  ) /_/ / /_/ / / /
 /_/    \__,_/____/____/_.___/\____/_/\__/

 Open source password manager for teams
-------------------------------------------------------------------------------
 Cleanup shell (fix mode)
-------------------------------------------------------------------------------
No issue found, data looks squeaky clean!

And have run

pwhtsi@ubuntu1:~/public_html$ ./bin/cake cache clear_all
Clearing default
Cleared default cache
Clearing _cake_translations_
Cleared _cake_translations_ cache
Clearing _cake_model_
Cleared _cake_model_ cache

I also tried to run this command in this article which was a big mistake:

DELETE FROM resource_types WHERE slug IN ('v5-default', 'v5-totp-standalone', 'v5-password-string', 'v5-default-with-totp');

That command seemed to wipe all my passwords from my database and I had to restore from backup.

After I restored the Passbolt database and basically performed a fresh install and restore, the status is exactly the same.

Thank you!

2

Hi @kevinhayashi!

Can you share logs from your iOS app?
You can get them on Settings → Debug, logs → Access the debug logs.
Also, you mentioned that approximately 5% of passwords is available - can you share rough number of passwords you have?

Thanks!

1 Like
3

@mdziennik , thanks for taking the time to look into my issue.

I have a total of 1631 passwords in my database total. I was looking over the passwords that are visible in the app, and while I didnt count them all, its more like 10% are in the app. If I change the view from all passwords folder view, it appears that all the folders are listed, but when comparing the passwords in each folder with what is through a desktop web browser, I’m missing 90% of the passwords.

Below is my log file:

Passbolt:
Device: iPhone
OS: 18.7.1
App: 2.3.1
----------
[2025-10-25 15:35:11] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:139
⮑ "path": 139
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:136
⮑ "path": 136
⮑ "file": Database/SQLiteConnectionHandle.swift
[2025-10-25 15:35:11] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:139
⮑ "path": 139
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:136
⮑ "path": 136
⮑ "file": Database/SQLiteConnectionHandle.swift
[2025-10-25 15:37:08] Requesting authorization...
[2025-10-25 15:37:08] [C1085808-EDCF-434A-ABFF-E23E0CB9F81E] HTTP GET /avatars/view/f9dda525-2c82-4a31-be17-9f4f20ad65b3/medium.jpg
[2025-10-25 15:37:08] Beginning authorization...
[2025-10-25 15:37:08] [C1085808-EDCF-434A-ABFF-E23E0CB9F81E] HTTP 200 /avatars/view/f9dda525-2c82-4a31-be17-9f4f20ad65b3/medium.jpg
[2025-10-25 15:37:08] ...reusing access token...
[2025-10-25 15:37:08] Passphrase provided...
[2025-10-25 15:37:08] ...authorization succeeded!
[2025-10-25 15:37:08] Updating account profile data...
[2025-10-25 15:37:09] [8A5741EC-609F-4493-9798-28BC1BE66D62] HTTP GET /users/1e5443bd-c7e9-4e9f-bd2e-896b3f171d05.json
[2025-10-25 15:37:09] [8A5741EC-609F-4493-9798-28BC1BE66D62] HTTP 200 /users/1e5443bd-c7e9-4e9f-bd2e-896b3f171d05.json
[2025-10-25 15:37:09] ...account profile data updated!
[2025-10-25 15:37:11] Refreshing users data...
[2025-10-25 15:37:11] [CD7C7A66-E5FA-42F0-91BE-8648C7AE1B4E] HTTP GET /users.json
[2025-10-25 15:37:11] [CD7C7A66-E5FA-42F0-91BE-8648C7AE1B4E] HTTP 200 /users.json
[2025-10-25 15:37:11] ...users data refresh finished!
[2025-10-25 15:37:11] Refreshing user groups data...
[2025-10-25 15:37:11] [B846BA09-8EC3-4C4B-A5C8-73A458C29629] HTTP GET /groups.json
[2025-10-25 15:37:11] [B846BA09-8EC3-4C4B-A5C8-73A458C29629] HTTP 200 /groups.json
[2025-10-25 15:37:11] ...user groups data refresh finished!
[2025-10-25 15:37:11] [B558FD1D-5350-4906-9947-73EEA42FAE9A] HTTP GET /metadata/keys/settings.json
[2025-10-25 15:37:11] [B558FD1D-5350-4906-9947-73EEA42FAE9A] HTTP 200 /metadata/keys/settings.json
[2025-10-25 15:37:11] [3018110C-3F80-4204-9795-E1E068BFCB47] HTTP GET /metadata/types/settings.json
[2025-10-25 15:37:11] [3018110C-3F80-4204-9795-E1E068BFCB47] HTTP 200 /metadata/types/settings.json
[2025-10-25 15:37:11] [56E5D1C9-5407-48A0-8CE6-E25CA2A1F139] HTTP GET /metadata/keys.json
[2025-10-25 15:37:11] [56E5D1C9-5407-48A0-8CE6-E25CA2A1F139] HTTP 200 /metadata/keys.json
[2025-10-25 15:37:11] [DD1637CE-2D80-42E2-8841-D8993081FDAA] HTTP GET /metadata/session-keys.json
[2025-10-25 15:37:12] [DD1637CE-2D80-42E2-8841-D8993081FDAA] HTTP 200 /metadata/session-keys.json
[2025-10-25 15:37:12] Refreshing folders data...
[2025-10-25 15:37:12] [65A5AE34-3681-47F7-BDEA-114D84A8DE61] HTTP GET /folders.json
[2025-10-25 15:37:12] [65A5AE34-3681-47F7-BDEA-114D84A8DE61] HTTP 200 /folders.json
[2025-10-25 15:37:12] ...folders data refresh finished!
[2025-10-25 15:37:12] Refreshing resources data...
[2025-10-25 15:37:12] [A2AAF0EE-B538-4C7D-A913-365DE0A64247] HTTP GET /resource-types.json
[2025-10-25 15:37:12] [A2AAF0EE-B538-4C7D-A913-365DE0A64247] HTTP 200 /resource-types.json
[2025-10-25 15:37:12] [FCFDE4A3-26DB-400A-864D-EF60AAC24801] HTTP GET /resources.json
[2025-10-25 15:37:12] [FCFDE4A3-26DB-400A-864D-EF60AAC24801] HTTP 200 /resources.json
[2025-10-25 15:37:13] [B122864C-2B5E-4E21-892F-A9A1CCF8CA70] HTTP GET /resources.json
[2025-10-25 15:37:13] [B122864C-2B5E-4E21-892F-A9A1CCF8CA70] HTTP 200 /resources.json
[2025-10-25 15:37:13] ...resources data refresh failed!
[2025-10-25 15:38:00] Wiping passphrase cache...
[2025-10-25 15:38:15] Requesting authorization...
[2025-10-25 15:38:15] [301A95AF-519C-4833-87EE-2EB196BA17B7] HTTP GET /img/avatar/user_medium.png
[2025-10-25 15:38:15] [25356A6B-4DD8-4BFA-A814-10EE2C5CF1DC] HTTP GET /avatars/view/f9dda525-2c82-4a31-be17-9f4f20ad65b3/medium.jpg
[2025-10-25 15:38:15] [58C1B81E-A85F-48AA-9A54-0F6107F6AE85] HTTP GET /avatars/view/f9dda525-2c82-4a31-be17-9f4f20ad65b3/medium.jpg
[2025-10-25 15:38:15] Beginning authorization...
[2025-10-25 15:38:15] [301A95AF-519C-4833-87EE-2EB196BA17B7] HTTP 200 /img/avatar/user_medium.png
[2025-10-25 15:38:15] [58C1B81E-A85F-48AA-9A54-0F6107F6AE85] HTTP 200 /avatars/view/f9dda525-2c82-4a31-be17-9f4f20ad65b3/medium.jpg
[2025-10-25 15:38:15] [25356A6B-4DD8-4BFA-A814-10EE2C5CF1DC] HTTP 200 /avatars/view/f9dda525-2c82-4a31-be17-9f4f20ad65b3/medium.jpg
[2025-10-25 15:38:15] ...reusing access token...
[2025-10-25 15:38:15] Passphrase provided...
[2025-10-25 15:38:15] ...authorization succeeded!
[2025-10-25 15:38:15] Updating account profile data...
[2025-10-25 15:38:15] [51F03157-6754-4B34-8457-495EABD61EEB] HTTP GET /users/1e5443bd-c7e9-4e9f-bd2e-896b3f171d05.json
[2025-10-25 15:38:15] [51F03157-6754-4B34-8457-495EABD61EEB] HTTP 200 /users/1e5443bd-c7e9-4e9f-bd2e-896b3f171d05.json
1 Like
4

A couple of new developments:

  1. Apple iOS App

When I open the Passbolt iOS app directly and search for a password, the results are incomplete. Only a few passwords appear and many expected entries are missing. However, if I access Passbolt through another app that prompts for credentials, for example when logging into the Starlink app, I can search within Passbolt from that interface and successfully locate and use the correct password.

This means the credentials exist and can be used when Passbolt is accessed as a password manager, but they do not appear when searching directly from within the Passbolt app itself.

The experience is the same on the iPadOS as iOS app.

  1. Android App

Opening the database from Android works fine. I’m able to see all passwords in the Android App.

1 Like
5

Hi @kevinhayashi!
Thanks for sharing your findings.
Today, we released iOS 2.4.1 version with some bug fixes - can you give it a try and check if your issues are still present?
If 2.4.1 version is not yet available for you - that would mean App Store needs some time to propagate this new release; it should be available soon.

Thanks!

1 Like
6

That was is! I’m able to see all of my passwords now and no longer getting the “Database Statement Execution Failed” error.

Thank you!

1 Like