Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    151
    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:
    43,711
    Likes Received:
    1,791
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Hunter_Albo

    Hunter_Albo Member

    Joined:
    Apr 19, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    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:
    43,711
    Likes Received:
    1,791
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Hunter_Albo

    Hunter_Albo Member

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

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    575
    Likes Received:
    20
    Trophy Points:
    93
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice