Symptoms
- The following events keep being logged to Event Viewer repeatedly:
[Warning] Aborted connection 7192 to db: 'unconnected' user: 'admin' host: 'localhost' (Got timeout reading communication packets)
- There is no resource overuse shown on Advanced Monitoring extension.
Cause
Product issue:
-
#PPPM-12737 "MariaDB error logs no longer contain misleading “Aborted connection” warnings related to the plesksrv service. (PPPM-12737"
Fixed in:- Plesk Obsidian 20 July 2021 (Windows)
- Plesk Obsidian 08 June 2021 (Windows)
Resolution
Please consider updating your server:
Workaround
If update is not possible for some reason, the following can be done:
workaround
As a workaround, increase the max_allowed_packet value.
- Connect to the server via RDP.
- Open %plesk_dir%MySQLmy.ini file in a text editor.
- Set
max_allowed_packetvalue to10M, save the changes and then close the file.max_allowed_packet=10M
- Restart the Plesk SQL Server via Plesk Services Monitor (Plesk icon in the tray menu).
Note: If similar warnings are shown for website(s) it's required to optimize the website code.
with