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
The following commands will:
- Stop the lvestats service.
- Back up the data (to be safe).
- Rename the database.
- Recreate the database
- Start the lvestats service again.
CloudLinux 6:
# service lvestats stop
# tar -zcvf /root/lveinfo_backup_$(date +%Y-%m-%d).tar.gz /var/lve/
# mv /var/lve/lvestats2.db{,.old}
# lve-create-db --recreate
# service lvestats start
CloudLinux 7:
# systemctl stop lvestats
# tar -zcvf /root/lveinfo_backup_$(date +%Y-%m-%d).tar.gz /var/lve/
# mv /var/lve/lvestats2.db{,.old}
# lve-create-db --recreate
# systemctl start lvestats