How to fix lveinfo database error: database disk image is malformed

Problem:

CloudLinux LVE Manager doesn't show anything on the statistics tab, lveinfo utility displays errors.

Synopsis:

If you see errors when running the lveinfo command-line tool and the last lines look 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 the LVE stats database is corrupted.

Solution:

!!! This solution can be used only for the aforementioned error output !!!

Please follow these steps to backup and rebuild the 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