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.

statscheck

Discussion in 'General Discussion' started by bou3lam, Jun 25, 2010.

  1. bou3lam

    bou3lam Active Member

    Joined:
    Sep 29, 2009
    Messages:
    36
    Likes Received:
    1
    Trophy Points:
    8
    please someone advice , im getting this message several time by day : 5-10 times :
    IMPORTANT: Do not ignore this email.
    This is cPanel stats runner on plaf.layeredtech.com!
    While processing the log files for user magic, the cpu has been
    maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of
    this email is
    04:22:15 up 35 days, 23:15, 0 users, load average: 8.76, 9.36, 10.14
    You should check the server to see why the load is so high and take
    steps to lower the load. If you want stats to continue to run even with a high load; Edit
    /var/cpanel/cpanel.config and change extracpus to a number larger then 0 (run
    /usr/local/cpanel/startup afterwards to pickup the changes).


    i did what this email said and changed the extracpus to 5 than restarted then i got this :


    root@plaf[/var/cpanel]# pico cpanel.config
    root@plaf [/var/cpanel]# /usr/local/cpanel/startup
    Waiting for cpaneld to shutdown ... ...Done
    Waiting for webmaild to shutdown ... ...Done
    Waiting for cphulkd.pl to shutdown ... ...Done
    Waiting for cPhulkd to shutdown ... ...Done
    Waiting for cphulkd to shutdown ... ...Done
    [Fri Jun 25 05:26:09 2010] Current process '27510' stopped
    Waiting for cpdavd to shutdown ... ...Done
    Waiting for cpdavd-ssl to shutdown ... ...Done
    Waiting for cpdavd-ssl to shutdown ... ...Done
    Waiting for cpldapd to shutdown ... ...Done
    Waiting for cppop to shutdown ... ...Done
    Waiting for cppop-ssl to shutdown ... ...Done
    Waiting for cpanellogd to shutdown ... ....Done
    Waiting for entropychat to shutdown ... ...Done
    Waiting for eximstats to shutdown ... ...Done
    Waiting for melange to shutdown ... ...Done
    Waiting for startmelange to shutdown ... ...Done
    Shutting down Mailman's master qrunner
    No child with pid: 20574
    [Errno 3] No such process
    Stale pid file removed.
    mailmanctl: no process killed
    Waiting for antirelayd to shutdown ... ...Done
    Waiting for eximstats to shutdown ... ...Done
    Waiting for cpbandwd to shutdown ... ...Done

    !!
    ATTENTION ATTENTION ATTENTION ATTENTION

    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.

    When mysql is unable to execute a query they are logged for processing later.

    Eventually these SQL files may be handled automatically and this message will not appear.

    In the meantime you can execute the queries as root with something like this:

    mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
    /usr/local/cpanel/libexec/tailwatchd --restart
    mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy

    Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_working_copy


    ATTENTION ATTENTION ATTENTION ATTENTION
    !!

    [2010-06-25 05:26:42 -0500] [main] Current process '27460' stopped
    Waiting for tailwatchd to shutdown ... ...Done
    Graceful shutdown of cPanel TaskQueue Daemon requested.
    Waiting for cpsrvd to shutdown ... ....Done
    Waiting for cpsrvd-ssl to shutdown ... ...Done
    Waiting for whostmgrd to shutdown ... ...Done
    Waiting for cppop to shutdown ... ...Done
    Waiting for cppop-ssl to shutdown ... ...Done

    !!
    ATTENTION ATTENTION ATTENTION ATTENTION

    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.

    When mysql is unable to execute a query they are logged for processing later.

    Eventually these SQL files may be handled automatically and this message will not appear.

    In the meantime you can execute the queries as root with something like this:

    mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
    /usr/local/cpanel/bin/tailwatchd --restart
    mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy

    Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_w orking_copy


    ATTENTION ATTENTION ATTENTION ATTENTION
    !!


    !!
    ATTENTION ATTENTION ATTENTION ATTENTION

    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/ eximstats.sql.

    When mysql is unable to execute a query they are logged for processing later.

    Eventually these SQL files may be handled automatically and this message will no t appear.

    In the meantime you can execute the queries as root with something like this:

    mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_cop y
    /usr/local/cpanel/libexec/tailwatch/tailwatchd --restart
    mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy

    Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_working_copy


    ATTENTION ATTENTION ATTENTION ATTENTION
    !!

    [Fri Jun 25 05:26:58 2010] Starting /usr/local/cpanel/libexec/tailwatch/tailwatc hd daemon
    Log is at /usr/local/cpanel/logs/tailwatchd_log
    Starting PID 14927: cpdavd - accepting connections on 2077 and 2078
    cPanel TaskQueue Processing Daemon already running, exiting.
    ==> cPanel Log Daemon version 24.0

    everything is working fine now , what i should do now please , there are many suggestions after the : ATTENTION ATTENTION ATTENTION ATTENTION :eek:
    also after this i got two emails :
    1 : cpanellogd failed @ Fri Jun 25 05:27:06 2010. A restart was attempted automagically.
    Service Check Method: [check command]

    Cmd Service Check Raw Output: cpanellogd is not running


    2 : queueprocd failed @ Fri Jun 25 05:27:06 2010. A restart was attempted automagically.
    Service Check Method: [check command]

    Cmd Service Check Raw Output: queueprocd is not running

    thanks in advance
     
    #1 bou3lam, Jun 25, 2010
    Last edited: Jun 26, 2010

Share This Page