The Plesk Email Security dashboard keeps loading, or statistics are not updated

Sergey Senko

Updated January 26, 2025 23:23

kb: bug Plesk for Linux ext: pes

Applicable to:

Plesk for Linux

Symptoms

The Plesk Email Security dashboard is loading forever or statistics are not updated for the extension;
In /var/log/plesk/panel.log the following error can be found:

PHP Fatal error: Maximum execution time of 600 seconds exceeded in /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Statement/Pdo.php on line 5
emailsecurity database is more than 50 Mb.

Cause

The Plesk Email Security bug EXTCERT-3176 which was fixed in version 1.1.9-257 of the extension.

Resolution

Update the Plesk Email Security extension

Leaving old solution for troubleshooting similar issues

Workaround:

Log in to Plesk.
2. Navigate to Tools & Settings > Plesk Email Security > Server Settings tab.
3. Go to the Advanced settings and decrease the Days number in the Auto-cleanup section to 7:

4. Scroll down and press the Save button.
5. Navigate to Tools & Settings > Scheduled Tasks (Cron jobs) and click Run Now near the /usr/local/psa/admin/bin/php -dauto_prepend_file=sdk.php '/usr/local/psa/admin/plib/modules/email-security/scripts/update-stats.php' task:

Workaround 2:
Warning: this workaround is based on removing the tables msgs and msgrcpt from PES database. All Plesk Email Security statistics will be lost.

Log in to Plesk.
Navigate to Tools & Settings > Database Servers.
Press on the button which is highlighted on the screenshot below:
Click emailsecurity database to select it:
Click on the SQL button to open the menu below:
Add the following SQL queries to remove the content of the tables "msgs" and "msgrcpt" and click Go:

TRUNCATE TABLE msgs;
TRUNCATE TABLE msgrcpt;
Run the scheduled task /usr/local/psa/admin/bin/php -dauto_prepend_file=sdk.php '/usr/local/psa/admin/plib/modules/email-security/scripts/update-stats.php via Tools & Settings > Scheduled Tasks (Cron jobs) > Run Now and check if the issue persists after the task was executed: