Show resource usage error cloudlinux cpanel

Ada beberapa kesalahan dengan “Resource Usage Overview” fungsi dalam cPanel, tidak bekerja dan memberikan:

Belum ada aktivitas di situs Anda dalam 24 jam terakhir
Dan di WHM> CloudLinux LVE Manajer semuanya muncul dengan benar. tetapi untuk di Resource Usage Overview tidak muncul silahkan untu grep log errornya dengan perintah

 grep lvestat /var/log/messages

1	grep lvestat /var/log/messages

jika hasilnya errornya begini

Sep 20 09:20:27 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:20:42 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:20:42 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:20:57 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:20:57 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:21:12 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:21:12 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:21:27 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:21:27 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:21:42 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:21:42 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:21:57 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:21:57 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:22:12 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:22:12 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:22:46 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:23:01 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:23:16 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:23:31 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:23:46 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:24:01 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:24:16 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run
Sep 20 09:24:32 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:20:27 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:20:42 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:20:42 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:20:57 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:20:57 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:21:12 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:21:12 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:21:27 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:21:27 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:21:42 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:21:42 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:21:57 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:21:57 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:22:12 email lvestats-server[1905]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:22:12 email lvestats-server[17741]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:22:46 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:23:01 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:23:16 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:23:31 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:23:46 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:24:01 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:24:16 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run

Sep 20 09:24:32 email lvestats-server[191494]: <class 'sqlite3.OperationalError'>: no such table: last_run

berikut langkah-langkan untuk mengatasinya ,

matika service lvestats :

service lvestats stop

1	service lvestats stop

lalu rename db lvestats yang lama

mv /var/lve/lveinfo.db /var/lve/lveinfobackup.db

1	mv /var/lve/lveinfo.db /var/lve/lveinfobackup.db

setelah itu jalankan kembali servicenya otomatais db lvestats akan membuat yang baru

service lvestats start

1	service lvestats start