CloudLinux LVE Manager doesn't show anything on statistics tab, lveinfo utility displays errors.
If you see errors when running lveinfo command-line tool and the last lines looks like these:
File "/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DatabaseError: (DatabaseError) database disk image is malformed u'SELECT lve_stats2_servers.lve_version \nFROM lve_stats2_servers \nWHERE lve_stats2_servers.server_id = ?' ('0195404a-a',)
Sentry is attempting to send 1 pending error messages
Waiting up to 10 seconds
Press Ctrl-C to quit
It means that LVE stats database is corrupted.
Solution:
Please follow these steps to backup and rebuild database and restore LVE statistics functionality:
# 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
