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

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 and 8:

# 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