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

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:

  # 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