Log browser database keeps growing to a large size and is never cleaned

[mahesh]

Symptoms

• Diskspace Usage extension shows large size for log-browser.sqlite3 file:

• Log browser database file /opt/psa/var/modules/log-browser/log-browser.sqlite3 grows constantly, reaching a large size:

Code Select Expand

#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