The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Show resource usage error

Discussion in 'CloudLinux' started by Hunter_Albo, Dec 4, 2014.

  1. Hunter_Albo

    Hunter_Albo Member

    Joined:
    Apr 19, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Santiago de Chile
    Hello,

    There is some fault with "Resource Usage Overview" function in cPanel, it doesn't work and gives:

    There has been no activity on your site within the past 24 hours
    And in WHM > CloudLinux LVE Manager everything is showing up correctly.

    LOG: grep lvestat /var/log/messages

    Dec 4 12:23:30 zeta lvestats-server[533629]: <class 'sqlite3.OperationalError'>: no such table: history
    Dec 4 12:24:31 zeta lvestats-server[533629]: <class 'sqlite3.OperationalError'>: no such table: history
    Dec 4 12:25:31 zeta lvestats-server[533629]: <class 'sqlite3.OperationalError'>: no such table: history
    Dec 4 12:26:31 zeta lvestats-server[533629]: <class 'sqlite3.OperationalError'>: no such table: history
    Dec 4 12:27:31 zeta lvestats-server[533629]: <class 'sqlite3.OperationalError'>: no such table: history
    Dec 4 12:28:43 zeta lvestats-server[876260]: <class 'sqlite3.OperationalError'>: no such table: history
    Dec 4 12:29:43 zeta lvestats-server[876260]: <class 'sqlite3.OperationalError'>: no such table: history


    Please suggest how to fix this.

    - - - Updated - - -

    I try :

    service lvestats stop
    killall -9 lvestats-server
    rm -rf /var/log/lveinfo.db
    service lvestats start

    Still not working
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Try running "yum update" to see if any packages are available for update on your system. Also, do you notice any difference if you rebuild Apache via EasyApache?

    Thank you.
     
  3. Hunter_Albo

    Hunter_Albo Member

    Joined:
    Apr 19, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Santiago de Chile


    i tried to compile apache, but still not working.

    - - - Updated - - -

    yum update :

    Loaded plugins: fastestmirror, rhnplugin
    Setting up Update Process
    Loading mirror speeds from cached hostfile
    * cloudlinux-x86_64-server-6: xmlrpc.cln.cloudlinux.com
    cloudlinux-x86_64-server-6 | 1.0 kB 00:00
    No Packages marked for Update

    Still not working.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
  5. Hunter_Albo

    Hunter_Albo Member

    Joined:
    Apr 19, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Santiago de Chile
    Ticket Number: 5788721.
     
  6. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    569
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I reviewed the ticket and our analyst stopped lvestats, moved the /var/lve/lveinfo.db file out of the way and restarted lvestats which recreated the missing table.
     
Loading...

Share This Page