Corrupted lvestats database in CloudLinux

Symptoms

A common symptom is the following message displayed on the Statistics tab in the LVE Manager:

CONFIG_TEXT: NO STATISTICS FOUND FOR SELECTED PERIOD

Cause

The lvestats database has become corrupted.

Resolution

1. Access your server using SSH as the root user

2. Stop the lvestats service:

   # systemctl stop lvestats

3. Make an archive of the current data for safety:

   # tar -zcvf /root/lveinfo_backup_$(date +%Y-%m-%d).tar.gz /var/lve/

4. Move the lvestats database to a backup file:

   # mv /var/lve/lvestats2.db{,.$( date +%Y%m%d )} -v

5. Recreate an empty database:

   # lve-create-db --recreate

6. Restart the lvestats service:

   # systemctl start lvestats