I have received error i DB after update from 5.4 to 5.12

Installation Issues
1

Checklist
I have read intro post: https://community.passbolt.com/t/about-the-installation-issues-category/12
I have read the tutorials, help and searched for similar issues
I provide relevant information about my server (component names and versions, etc.)
I provide a copy of my logs and healthcheck
I describe the steps I have taken to trouble shoot the problem
I describe the steps on how to reproduce the issue

I have update from 5.4 to 5.11 and I used to run som chack commands,

su -c “source /etc/environment; bin/cake passbolt datacheck --hide-success-details” -s /bin/bash www-data

this command gives alot of fails

[FAIL] Validation failed for secret ff60be09-8ea6-4cc8-83c5-7f0524c7fa16. {"secret_revision_id":{"_empty":"The secret revision identifier should not be empty."}}
[FAIL] Validation failed for secret ff67365c-4609-4126-ab06-70303a93cf69. {"secret_revision_id":{"_empty":"The secret revision identifier should not be empty."}}
[FAIL] Validation failed for secret ff9b485f-e33b-4fd9-a4ab-b806cecbda6e. {"secret_revision_id":{"_empty":"The secret revision identifier should not be empty."}}
[FAIL] Validation failed for secret ff9ee646-3d76-4658-8dbb-78a6de705d9e. {"secret_revision_id":{"_empty":"The secret revision identifier should not be empty."}}
[FAIL] Validation failed for secret ffae40e6-1de0-4be1-916d-72cf9fe41f07. {"secret_revision_id":{"_empty":"The secret revision identifier should not be empty."}}
[FAIL] Validation failed for secret ffe69931-9ee4-4dd9-b278-8a1ced0b2813. {"secret_revision_id":{"_empty":"The secret revision identifier should not be empty."}}

Is it something new in version 5.12?
2

Hello,

you might have run across a memory issue when the database migrations were run.
Any information in the error logs?

What is the state of the `phinxlog` table? This command might help diagnose:

SELECT* FROMphinxlog WHERE version >= '20251027060835';

Accordingly we can run some commands to re-run the migrations.

Best!

3

I have no memory issue on the server when I update the passbolt version.

select * from phinxlog WHERE version >= ‘20251027060835’;
±---------------±-------------------------------------------------±--------------------±--------------------±-----------+
| version | migration_name | start_time | end_time | breakpoint |
±---------------±-------------------------------------------------±--------------------±--------------------±-----------+
| 20251027060835 | V570AddCreatedByAndModifiedByToSecrets | 2025-11-24 14:49:06 | 2025-11-24 14:49:06 | 0 |
| 20251027102352 | V570AddDeletedToSecrets | 2025-11-24 14:49:06 | 2025-11-24 14:49:06 | 0 |
| 20251028213926 | V570CreateSecretRevisions | 2025-11-24 14:49:06 | 2025-11-24 14:49:06 | 0 |
| 20251028223602 | V570AddSecretRevisionIdToSecrets | 2025-11-24 14:49:06 | 2025-11-24 14:49:06 | 0 |
| 20251029053757 | V570PopulateCreatedByAndModifiedByInSecretsTable | 2025-11-24 14:49:06 | 2025-11-24 14:49:15 | 0 |
| 20251105054212 | V570PopulateSecretRevisionsForExistingSecrets | 2025-11-24 14:49:15 | 2025-11-24 14:49:21 | 0 |
| 20251127112629 | V580AddDeletedToRoles | 2026-01-14 14:30:17 | 2026-01-14 14:30:17 | 0 |
| 20251127142638 | V580InsertRbacsControlledActions | 2026-01-14 14:30:17 | 2026-01-14 14:30:17 | 0 |
| 20251128071117 | V580AddByFieldsToRoles | 2026-01-14 14:30:17 | 2026-01-14 14:30:17 | 0 |
| 20251203112523 | V580InsertRbacsForActions | 2026-01-14 14:30:17 | 2026-01-14 14:30:17 | 0 |
| 20251215190450 | V580RemoveUniqueIndexOnRolesName | 2026-01-14 14:30:18 | 2026-01-14 14:30:18 | 0 |
±---------------±-------------------------------------------------±--------------------±--------------------±-----------+

4

Thank you for that!

It looks like the migrations did run properly. We have two commands that might help fixing the validation fail:

This one is to re-run the V570PopulateCreatedByAndModifiedByInSecretsTable migration:

bin/cake passbolt populate_created_by_and_modified_by_in_secrets

And this one to fix the integrity issue you have on secrets:

bin/cake passbolt populate_secret_revisions_for_existing_secrets

Let me know if this fixed your issue.

5

Works like charm! Thank you