Symptoms
- Diskspace Usage extension shows large size for log-browser.sqlite3 file:
(https://pix.cobrasoft.org/images/2024/10/22/mceclip1.png)
- Log browser database file /opt/psa/var/modules/log-browser/log-browser.sqlite3 grows constantly, reaching a large size:
#du -sh /opt/psa/var/modules/log-browser/log-browser.sqlite3
26G /opt/psa/var/modules/log-browser/log-browser.sqlite3
Cause
Log Browser extension bug EXTPLESK-5717
Resolution
Until the bug is fixed, apply the following workaround:
1.Log into Plesk
2.Go to Tools & Settings > Scheduled Tasks (Cron jobs)
3.Press Add Task
4.Enter the following values:
- Task type: Run a command
- Command: sqlite3 /usr/local/psa/var/modules/log-browser/log-browser.sqlite3 'VACUUM';
- Run: Weekly on Sunday at 00:00
- System user: root
- Description: Log Browser Vacuum
- Notify: Do not notify
- Note: The task should be run on a weekly interval, but any value can be used for the specific day and time
5.Press Run now to vacuum the database
6.Press OK
(https://pix.cobrasoft.org/images/2024/10/22/mceclip1-1.png)