PB: Latest-CE (4.10.0)
Device: iPhone
OS: 18.0.1
App: 1.20.0
Issue:
After upgrading to 4.10.0 from 4.9.1 Passbolt-CE on Debian, I now receive the error “Database statement execution failed” (actually, it’s “Database statemenet execution failed”) when using the Passbolt iOS app. The app showed cached items and would not refresh new items. The error appears on refresh.
Web and Edge extension all work fine. Under 4.9.1 - the same app and version worked beautifully.
Debian Passbolt was upgraded via debian package, too.
Troubleshooting:
I followed a similar post: https://community.passbolt.com/t/ios-app-not-showing-passwords-database-execution-statement-failed/10594 but the solution didn’t resolve my issue.
sudo -H -u www-data bash -c "/usr/share/php/passbolt/bin/cake cache clear_all" ran with no errors but didn't help.
sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/status-report" www-data also revealed no issues.
____ __ ____
/ __ \____ _____ ____/ /_ ____ / / /_
/ /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
/ ____/ /_/ (__ |__ ) /_/ / /_/ / / /
/_/ \__,_/____/____/_.___/\____/_/\__/
Open source password manager for teams
-------------------------------------------------------------------------------
Cleanup shell (dry-run)
-------------------------------------------------------------------------------
No issue found, data looks squeaky clean!
____ __ ____
/ __ \____ _____ ____/ /_ ____ / / /_
/ /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
/ ____/ /_/ (__ |__ ) /_/ / /_/ / / /
/_/ \__,_/____/____/_.___/\____/_/\__/
Open source password manager for teams
-------------------------------------------------------------------------------
Data check shell
[PASS] Data integrity for AuthenticationTokens.
[PASS] Can validate: 1819/1819
[PASS] Data integrity for Comments.
[PASS] Can validate: 1/1
[PASS] Data integrity for Favorites.
[PASS] Can validate: 11/11
[PASS] Data integrity for Gpgkeys.
[PASS] Can encrypt: 2/2
[PASS] Pass validation service checks: 2/2
[PASS] Entity data and armored key data matches: 2/2
[PASS] Is not expired: 2/2
[PASS] Is armored key format valid: 2/2
[PASS] Data integrity for Groups.
[PASS] Can validate: 1/1
[PASS] Data integrity for Profiles.
[PASS] Can validate: 2/2
[PASS] Data integrity for Resources.
[PASS] Can validate: 1612/1612
[PASS] Data integrity for Secrets.
[PASS] Can validate: 1115/1115
[PASS] Data integrity for Users.
[PASS] Can validate: 2/2
I signed out of the iOS app and signed back in (which worked), however there are no items listed.
Phone app log:
Passbolt:
Device: iPhone
OS: 18.0.1
App: 1.20.0
----------
[2024-11-21 06:58:38] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:38] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:44] [8DF241CE-D464-4F68-9359-5BDC08594CF5] HTTPUnauthorized
DiagnosticsContext:
•HTTPUnauthorized OSFeatures/NetworkRequestExecutor.swift:465
⮑ "path": 465
⮑ "file": OSFeatures/NetworkRequestExecutor.Passbolt:
Device: iPhone
OS: 18.0.1
App: 1.20.0
----------
[2024-11-21 06:58:38] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:38] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:44] [8DF241CE-D464-4F68-9359-5BDC08594CF5] HTTPUnauthorized
DiagnosticsContext:
•HTTPUnauthorized OSFeatures/NetworkRequestExecutor.swift:465
⮑ "path": 465
⮑ "file": OSFeatures/NetworkRequestExecutor.swift
[2024-11-21 06:58:44] ⚠️ HTTPUnauthorized
DiagnosticsContext:
•HTTPUnauthorized OSFeatures/NetworkRequestExecutor.swift:465
⮑ "path": 465
⮑ "file": OSFeatures/NetworkRequestExecutor.swift
[2024-11-21 06:58:47] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:47] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
Passbolt:
Device: iPhone
OS: 18.0.1
App: 1.20.0
----------
[2024-11-21 06:58:38] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:38] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:44] [8DF241CE-D464-4F68-9359-5BDC08594CF5] HTTPUnauthorized
DiagnosticsContext:
•HTTPUnauthorized OSFeatures/NetworkRequestExecutor.swift:465
⮑ "path": 465
⮑ "file": OSFeatures/NetworkRequestExecutor.swift
[2024-11-21 06:58:44] ⚠️ HTTPUnauthorized
DiagnosticsContext:
•HTTPUnauthorized OSFeatures/NetworkRequestExecutor.swift:465
⮑ "path": 465
⮑ "file": OSFeatures/NetworkRequestExecutor.swift
[2024-11-21 06:58:47] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:47] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 07:08:07] [785CB19C-D436-478B-A787-24A5580F6FE5] HTTP GET /resource-types.json
[2024-11-21 07:08:07] [785CB19C-D436-478B-A787-24A5580F6FE5] HTTP 200 /resource-types.json
[2024-11-21 07:08:07] ...resources data refresh failed!
[2024-11-21 07:08:10] Refreshing users data...
[2024-11-21 07:08:10] [B4EA7F85-FE58-4804-BE40-66F4D012A753] HTTP GET /users.json
[2024-11-21 07:08:10] [B4EA7F85-FE58-4804-BE40-66F4D012A753] HTTP 200 /users.json
[2024-11-21 07:08:10] ...users data refresh finished!
[2024-11-21 07:08:10] Refreshing user groups data...swift
[2024-11-21 06:58:44] ⚠️ HTTPUnauthorized
DiagnosticsContext:
•HTTPUnauthorized OSFeatures/NetworkRequestExecutor.swift:465
⮑ "path": 465
⮑ "file": OSFeatures/NetworkRequestExecutor.swift
[2024-11-21 06:58:47] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:47] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
Passbolt:
Device: iPhone
OS: 18.0.1
App: 1.20.0
----------
[2024-11-21 06:58:38] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:38] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:44] [8DF241CE-D464-4F68-9359-5BDC08594CF5] HTTPUnauthorized
DiagnosticsContext:
•HTTPUnauthorized OSFeatures/NetworkRequestExecutor.swift:465
⮑ "path": 465
⮑ "file": OSFeatures/NetworkRequestExecutor.swift
[2024-11-21 06:58:44] ⚠️ HTTPUnauthorized
DiagnosticsContext:
•HTTPUnauthorized OSFeatures/NetworkRequestExecutor.swift:465
⮑ "path": 465
⮑ "file": OSFeatures/NetworkRequestExecutor.swift
[2024-11-21 06:58:47] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 06:58:47] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift
[2024-11-21 07:08:07] [785CB19C-D436-478B-A787-24A5580F6FE5] HTTP GET /resource-types.json
[2024-11-21 07:08:07] [785CB19C-D436-478B-A787-24A5580F6FE5] HTTP 200 /resource-types.json
[2024-11-21 07:08:07] ...resources data refresh failed!
[2024-11-21 07:08:10] Refreshing users data...
[2024-11-21 07:08:10] [B4EA7F85-FE58-4804-BE40-66F4D012A753] HTTP GET /users.json
[2024-11-21 07:08:10] [B4EA7F85-FE58-4804-BE40-66F4D012A753] HTTP 200 /users.json
[2024-11-21 07:08:10] ...users data refresh finished!
[2024-11-21 07:08:10] Refreshing user groups data...
Any help would be appreciated.
Pete
