How to fix the lvestats database on CloudLinux

Introduction

If the lvestats database for CloudLinux appears to be corrupt, you can move it aside and recreate it.

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

NO STATISTICS FOUND FOR SELECTED PERIOD

Procedure

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