Application error 504

Installation Issues
1

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

Hello,

I have Passbolt (4.10.1) installed on a Debian 12 VM with PHP-FPM 8.2.26. I followed the tutorial available for the installation.

Since upgrading to version 4.10.1, there has been a strange slowdown in the application when I go to the Administration tab after first navigating to the Users tab.

I checked the error logs, and this message appears each time:

[error] 2048317#2048317: *18358 upstream timed out (110: Connection timed out) while reading response header from upstream, client: xx.xxx.xxx.xxx, server: _, request: "GET /app/administration/mfa HTTP/2.0", upstream:

I have reviewed the Nginx configuration, but it seems unlikely that it’s the cause since everything was working fine before this update.

This issue slows down the entire VM. If I perform this action and it causes a slowdown, it also impacts all other users at the same time.

I’m out of ideas on how to resolve this. HEALTHCHECK is all green

Thank you.

2

Hello, what is the size of the action_logs table?

3

Hello, 1.5Gib :scream: It’s way too much, right?

Edit: I made this command:

sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt action_logs_purge -r 90" www-data

But it is limited to 100000 deletions maximum, right?

Edit 2 :
The issue was indeed with my action_logs table. With over 3 million entries, it was causing the application to lag every time someone accessed it.

I truncated the table all at once.