Huge SQL Backup file

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.)

* Debian 12 Installation - no Docker
* Native Installation as descripbed in Howto above
* less than 100 Passwords stored

[-] I provide a copy of my logs and healthcheck

I describe the steps I have taken to trouble shoot the problem
Run of following command, produces huge MySQL Backup File

/var/opt/passbolt/backup.sh

I describe the steps on how to reproduce the issue
MySQL Backup File is huge

/var/opt/passbolt/backup/backup-2024-11-18--07-48-51/backup_1731912531.sql

What can be the reason for such a huge mysql file?
We connected Passbolt to kubernetes? Are there maybe Logs written?

Thank you for your Answers!
BR

Seems to be tons of action logs!
In one day we got 5310385 logs to purge?

$ sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt action_logs_purge --dry-run -r 1" www-data

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

 Open source password manager for teams
-------------------------------------------------------------------------------
+------------------------------------+---------+
| Action                             | Count   |
+------------------------------------+---------+
| ResourcesView.view                 | 2282843 |
| ResourceTypesView.view             | 2281099 |
| UsersView.view                     | 683438  |
| ResourcesIndex.index               | 58007   |
| SettingsIndex.index                | 3105    |
| GroupsIndex.index                  | 364     |
| FoldersIndex.index                 | 315     |
| AccountSettingsIndex.index         | 239     |
| UsersIndex.index                   | 200     |
| Home.apiExtApp                     | 165     |
| FoldersView.view                   | 163     |
| GpgkeysIndex.index                 | 54      |
| RolesIndex.index                   | 54      |
| Home.apiApp                        | 52      |
| Share.dryRun                       | 46      |
| PermissionsView.viewAcoPermissions | 44      |
| ResourceTypesIndex.index           | 44      |
| MfaOrgSettingsGet.get              | 40      |
| CommentsView.view                  | 20      |
| ShareSearch.searchArosToShareWith  | 19      |
| AuthVerify.verifyGet               | 15      |
| TotpVerifyGet.get                  | 12      |
| NotificationOrgSettingsGet.get     | 12      |
| HealthcheckIndex.index             | 11      |
| MfaSetupSelectProvider.get         | 9       |
| ThemesIndex.index                  | 9       |
| MfaVerifyAjaxError.get             | 3       |
| TotpSetupGet.get                   | 3       |
| Total                              | 5310385 |
+------------------------------------+---------+

Seems no debug is activated:

'debug' => filter_var(env('DEBUG', false), FILTER_VALIDATE_BOOLEAN),
'debugKit' => false,


Hey @cadirol, you can use action_logs_purge command to delete unnecessary action logs.

See: https://www.passbolt.com/docs/hosting/troubleshooting/purge-action-logs/

Hy @ishan
Thank you very much to get in touch with me!
i did the cleanup with action_logs_purge, but i discovered 5310385 in 4 Days! See my last post
I think the solution must be, to reduce the log amount.
What can be done, to get less Logs?

Hey @cadirol,

Could you please contact support at support@passbolt.com? We would like to investigate the issue with you. Ask for Cédric.

1 Like

Good day Cédric
Thank you very much for your Time and Support!
We found the reason for the Huge amount of Logs in the 3rd Party Plugin [1]
In the Documentation, the refresh Interval is set to 15s - which produces tons of Logs if you have a couple of connecting Pods running!

After set refreshInterval: "0" the passwords are only synced on a manual way. No POST Requests on the passbolt API are made anymore.

Thanks again for this outstanding Community Support!
Best regards
Adrian

[1] https://external-secrets.io/latest/provider/passbolt/

2 Likes