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

 

Was this answer helpful? 0 Users Found This Useful (0 Votes)