Knowledge Base

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

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

Resolution

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: