Host disabled service: because of COMMAND: Sleep queries?

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Jobertim
Registered User
Posts: 258
Joined: Wed Dec 28, 2011 2:25 pm

Host disabled service: because of COMMAND: Sleep queries?

Post by Jobertim » Thu Nov 07, 2019 12:37 pm

Hello,

My host just disabled my board saying it was overusing CPU resources. They are sending me the following info which I'm not sure how to decipher? Is the issue with all those "sleep" queries?

Thanks!

Code: Select all

CPU Seconds used in the past hour: 4277.4, 119% CPU
Thu Nov  7 05:01:21 CST 2019
Running Processes:
canva5q  325477  0.0  0.0  41984  3708 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325478  0.0  0.0  42120  3876 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325493  0.0  0.0  42576  4084 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325494  0.0  0.0  41848  3464 ?        S    04:14  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325548  0.0  0.0  41652  3212 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14]
canva5q  325623  0.0  0.0  41872  3428 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325634  0.0  0.0  41852  3464 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  338631  0.0  0.0  41652  3208 ?        S    04:19  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14]
canva5q  464173  4.9  0.0 283640 57892 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  464565  5.3  0.0 297668 60100 ?        SN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  464930  3.8  0.0 260432 34352 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  465778  3.9  0.0 257868 32124 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  465922  3.8  0.0 257212 31272 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  466221  3.7  0.0 256080 29412 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  466717  5.4  0.0 259956 34020 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  466728  5.0  0.0 260972 34520 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467063  5.1  0.0 256992 31268 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467106  4.5  0.0 257360 31120 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467125  6.0  0.0 259888 33756 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467590  5.8  0.0 255588 29272 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467594  6.4  0.0 261484 35456 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467611  6.2  0.0 255672 29976 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467718  5.2  0.0 248952 22684 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  467826  9.6  0.0 253752 27716 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467851  9.5  0.0 246096 19024 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/faq.php
canva5q  467856  9.0  0.0 246772 19704 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467911  9.0  0.0 245972 18708 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467915  9.5  0.0 246876 20208 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468002 21.0  0.0 248684 21820 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468014 12.0  0.0 128212  836 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  468017  0.0  0.0  15880  1468 ?        R    05:01  0:00 /usr/sbin/suphp

Running Queries:
*************************** 1. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 0
COMMAND: Sleep
  INFO: NULL
*************************** 2. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 0
COMMAND: Sleep
  INFO: NULL
*************************** 3. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 0
COMMAND: Sleep
  INFO: NULL
*************************** 4. row ***************************
  USER: canva5q_kickin
    DB: canva5q_wp
  STATE: 
  TIME: 0
COMMAND: Sleep
  INFO: NULL
*************************** 5. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 0
COMMAND: Sleep
  INFO: NULL
*************************** 6. row ***************************
  USER: canva5q_kickin
    DB: canva5q_wp
  STATE: 
  TIME: 4
COMMAND: Sleep
  INFO: NULL
*************************** 7. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 1
COMMAND: Sleep
  INFO: NULL
*************************** 8. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 0
COMMAND: Sleep
  INFO: NULL
*************************** 9. row ***************************
  USER: canva5q_kickin
    DB: canva5q_wp
  STATE: 
  TIME: 3
COMMAND: Sleep
  INFO: NULL
*************************** 10. row ***************************
  USER: canva5q_kickin
    DB: canva5q_wp
  STATE: 
  TIME: 1
COMMAND: Sleep
  INFO: NULL
*************************** 11. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 1
COMMAND: Sleep
  INFO: NULL
*************************** 12. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 0
COMMAND: Sleep
  INFO: NULL
*************************** 13. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 0
COMMAND: Sleep
  INFO: NULL
*************************** 14. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 1
COMMAND: Sleep
  INFO: NULL
*************************** 15. row ***************************
  USER: canva5q_kickin
    DB: canva5q_newphpBB
  STATE: 
  TIME: 0
COMMAND: Sleep
  INFO: NULL

Open connections

Current Site Requests:

Reference: ui
  Server: gator4217.hostgator.com
    Brand: hostgator
Srv. Type: cpanel
  Created: Thu Apr 21 21:54:46 2016
Acct Type: Shared
    Plan: Business
    User: canva5q
U. Domain: logicprohelp.com
    Email: kickindaspeaker@yahoo.com
      IP: 216.172.184.136 (shared)

Doc Root: /home4/canva5q/public_html
    Shell: /usr/local/cpanel/bin/jailshell

  Malware: Most recent quarantined content: Mon Jul 30 05:06:56 2018
CPU Usage: 154.6% (warning)
Processes: 31 (warning)
LimitPHP: Limit file exists. (warning)
  Varnish: logicprohelp.com is cached. (warning)


Snapshot 1
canva5q  325477  0.0  0.0  41984  3708 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325478  0.0  0.0  42120  3876 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325493  0.0  0.0  42576  4084 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325494  0.0  0.0  41848  3464 ?        S    04:14  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325548  0.0  0.0  41652  3212 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14]
canva5q  325623  0.0  0.0  41872  3428 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325634  0.0  0.0  41852  3464 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  338631  0.0  0.0  41652  3208 ?        S    04:19  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14]
canva5q  464173  4.9  0.0 283640 57892 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  464565  5.3  0.0 297668 60100 ?        SN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  464930  3.8  0.0 260432 34352 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  465778  3.9  0.0 257868 32124 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  465922  3.8  0.0 257212 31272 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  466221  3.7  0.0 256080 29412 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  466717  5.4  0.0 259956 34020 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  466728  5.0  0.0 260972 34520 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467063  5.1  0.0 256992 31268 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467106  4.5  0.0 257360 31120 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467125  6.0  0.0 259888 33756 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467590  5.8  0.0 255588 29272 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467594  6.4  0.0 261484 35456 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467611  6.2  0.0 255672 29976 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467718  5.2  0.0 248952 22684 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  467826  9.6  0.0 253752 27716 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467851  9.5  0.0 246096 19024 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/faq.php
canva5q  467856  9.0  0.0 246772 19704 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467911  9.0  0.0 245972 18708 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467915  9.5  0.0 246876 20208 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468002 21.0  0.0 248684 21820 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468014 12.0  0.0 128212  836 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  468017  0.0  0.0  15880  1468 ?        R    05:01  0:00 /usr/sbin/suphp
canva5q  468084  0.0  0.0  15880  1656 ?        RN  05:01  0:00 /usr/sbin/suphp

Snapshot 2
canva5q  325477  0.0  0.0  41984  3708 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325478  0.0  0.0  42120  3876 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325493  0.0  0.0  42576  4084 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325494  0.0  0.0  41848  3464 ?        S    04:14  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325548  0.0  0.0  41652  3212 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14]
canva5q  325623  0.0  0.0  41872  3428 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325634  0.0  0.0  41852  3464 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  338631  0.0  0.0  41652  3208 ?        S    04:19  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14]
canva5q  464173  4.9  0.0 283640 57892 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  464565  5.3  0.0 297668 60100 ?        SN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  464930  3.8  0.0 260432 34352 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  465778  3.9  0.0 257868 32124 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  465922  3.8  0.0 257212 31272 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  466221  3.7  0.0 256080 29412 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  466717  5.4  0.0 259956 34020 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  466728  5.0  0.0 260972 34520 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467063  5.1  0.0 256992 31268 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467106  4.5  0.0 257360 31120 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467125  6.0  0.0 259888 33756 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467590  5.8  0.0 255588 29272 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467594  6.4  0.0 261484 35456 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467611  6.2  0.0 255672 29976 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467718  5.2  0.0 248952 22684 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  467826  9.6  0.0 253752 27716 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467851  9.5  0.0 246096 19024 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/faq.php
canva5q  467856  9.0  0.0 246772 19704 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467911  9.0  0.0 245972 18708 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467915  9.5  0.0 246876 20208 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468002 21.0  0.0 248684 21820 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468014 12.0  0.0 128212  836 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  468017  0.0  0.0  15880  1468 ?        R    05:01  0:00 /usr/sbin/suphp
canva5q  468084  0.0  0.0  15880  1656 ?        RN  05:01  0:00 /usr/sbin/suphp

Snapshot 3
canva5q  325477  0.0  0.0  41984  3708 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325478  0.0  0.0  42120  3876 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325493  0.0  0.0  42576  4084 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325494  0.0  0.0  41848  3464 ?        S    04:14  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325548  0.0  0.0  41652  3212 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14]
canva5q  325623  0.0  0.0  41872  3428 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325634  0.0  0.0  41852  3464 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  338631  0.0  0.0  41652  3208 ?        S    04:19  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14]
canva5q  464173  4.9  0.0 283640 57892 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  464565  5.3  0.0 297668 60100 ?        SN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  464930  3.8  0.0 260432 34352 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  465778  3.9  0.0 257868 32124 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  465922  3.8  0.0 257212 31272 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  466221  3.7  0.0 256080 29412 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  466717  5.4  0.0 259956 34020 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  466728  5.0  0.0 260972 34520 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467063  5.1  0.0 256992 31268 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467106  4.5  0.0 257360 31120 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467125  6.0  0.0 259888 33756 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467590  5.8  0.0 255588 29272 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467594  6.4  0.0 261484 35456 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467611  6.2  0.0 255672 29976 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467718  5.2  0.0 248952 22684 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  467826  9.6  0.0 253752 27716 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467851  9.5  0.0 246096 19024 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/faq.php
canva5q  467856  9.0  0.0 246772 19704 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467911  9.0  0.0 245972 18708 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467915  9.5  0.0 246876 20208 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468002 21.0  0.0 248684 21820 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468014 12.0  0.0 128212  836 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  468017  0.0  0.0  15880  1468 ?        R    05:01  0:00 /usr/sbin/suphp
canva5q  468084  0.0  0.0  15880  1656 ?        RN  05:01  0:00 /usr/sbin/suphp

Snapshot 4
canva5q  325477  0.0  0.0  41984  3708 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325478  0.0  0.0  42120  3876 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325493  0.0  0.0  42576  4084 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325494  0.0  0.0  41848  3464 ?        S    04:14  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325548  0.0  0.0  41652  3212 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14]
canva5q  325623  0.0  0.0  41872  3428 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325634  0.0  0.0  41852  3464 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  338631  0.0  0.0  41652  3208 ?        S    04:19  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14]
canva5q  464173  4.7  0.0 283640 57908 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  464565  5.0  0.0 297668 60360 ?        DN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  465778  3.6  0.0 257868 32124 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  465922  3.7  0.0 259004 32752 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  466221  3.5  0.0 257360 31184 ?        SN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  466728  4.6  0.0 262544 35996 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467063  4.5  0.0 257248 31268 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467106  4.5  0.0 259152 33160 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467125  5.4  0.0 259888 33924 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467590  5.3  0.0 257100 31064 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467594  5.5  0.0 262528 36276 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467611  5.5  0.0 256452 30700 ?        SN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467718  4.6  0.0 250784 24568 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  467826  7.2  0.0 253752 27716 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467851  6.6  0.0 246916 20008 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/faq.php
canva5q  467856  6.6  0.0 249180 22576 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467911  6.6  0.0 247748 20744 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467915  7.0  0.0 248172 21568 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468002 11.5  0.0 249992 23872 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468014  8.0  0.0 245792 17392 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  468017 11.0  0.0  15880  1468 ?        RN  05:01  0:00 /usr/sbin/suphp
canva5q  468084 14.0  0.0 178240  4620 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php

Snapshot 5
canva5q  325477  0.0  0.0  41984  3708 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325478  0.0  0.0  42120  3876 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325493  0.0  0.0  42576  4084 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325494  0.0  0.0  41848  3464 ?        S    04:14  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325548  0.0  0.0  41652  3212 ?        S    04:14  0:00 dovecot/imap [billing@logicprohelp.com 78.201.94.14]
canva5q  325623  0.0  0.0  41872  3428 ?        S    04:14  0:00 dovecot/imap [info@logicprohelp.com 78.201.94.14 IDLE]
canva5q  325634  0.0  0.0  41852  3464 ?        S    04:14  0:00 dovecot/imap [david@logicprohelp.com 78.201.94.14 IDLE]
canva5q  338631  0.0  0.0  41652  3208 ?        S    04:19  0:00 dovecot/imap [admin@logicprohelp.com 78.201.94.14]
canva5q  464173  4.9  0.0 284408 58708 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  464565  5.1  0.0 297676 60384 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  465778  3.6  0.0 257868 32124 ?        SN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  465922  4.0  0.0 258740 33068 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  466221  3.7  0.0 257872 31676 ?        SN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  466728  4.6  0.0 262544 35996 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467063  4.6  0.0 258020 32144 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467106  4.8  0.0 201868 22488 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467590  5.3  0.0 257100 31176 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467594  6.0  0.0 264756 38432 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/index.php
canva5q  467611  5.5  0.0 256452 30700 ?        SN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467718  5.2  0.0 253240 27408 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/search.php
canva5q  467826  7.2  0.0 253752 27872 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  467851  6.6  0.0 246916 20008 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/faq.php
canva5q  467856  7.3  0.0 250644 24164 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467911  7.0  0.0 249552 22976 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  467915  7.3  0.0 248680 22276 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468002 13.0  0.0 253036 26796 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewforum.php
canva5q  468014  9.5  0.0 247888 21056 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php
canva5q  468017 14.0  0.0 220392  9284 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/wp-cron.php
canva5q  468084 14.0  0.0 228884 10552 ?        RN  05:01  0:00 /opt/php56/bin/php-cgi /home4/canva5q/public_html/forum/viewtopic.php

Current load:  05:01:22 up 533 days, 11:37,  0 users,  load average: 0.04, 0.01, 0.00

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21681
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by Mick » Thu Nov 07, 2019 12:51 pm

You board appears to be version 3.1.9, is that correct? Please fill out the Support Request Template and post it back here to enable us to assist you better. Be specific about the PHP version.
"The more connected we get the more alone we become" - Kyle Broflovski

Jobertim
Registered User
Posts: 258
Joined: Wed Dec 28, 2011 2:25 pm

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by Jobertim » Thu Nov 07, 2019 1:25 pm

Mick wrote:
Thu Nov 07, 2019 12:51 pm
You board appears to be version 3.1.9, is that correct? Please fill out the Support Request Template and post it back here to enable us to assist you better. Be specific about the PHP version.
Yes that's correct. PHP version is 5.6.

Support Request Template
What version of phpBB are you using? phpBB 3.1.9
What is your board's URL? https://www.logicprohelp.com/forum/
Who do you host your board with? Host Gator
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.1.9
What extensions do you have installed? Slickthemes Slickpanel
Topicsolved
Elonw (External Links Open in New Window)
EnableRegEmailNotify-Master
Lastpostavatar
Adsense
What styles do you currently have installed? Slickthemes Canvas
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? None
Please describe your problem. Host disabled board for CPU overuse
Generated by SRT Generator

User avatar
WelshPaul
Registered User
Posts: 353
Joined: Tue Aug 19, 2014 2:09 pm

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by WelshPaul » Thu Nov 07, 2019 1:37 pm

Mick wrote:
Thu Nov 07, 2019 12:51 pm
You board appears to be version 3.1.9, is that correct? Please fill out the Support Request Template and post it back here to enable us to assist you better. Be specific about the PHP version.
Logs show they are using php 5.6

This is your problem:
Who do you host your board with? Host Gator
Get a decent host!

Jobertim
Registered User
Posts: 258
Joined: Wed Dec 28, 2011 2:25 pm

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by Jobertim » Thu Nov 07, 2019 1:47 pm

Huh... they've been decent except for this kind of issue once every 3 years or so... then I have to beg them to put my site back up again.

Where can I find recommendations for a decent host?

User avatar
WelshPaul
Registered User
Posts: 353
Joined: Tue Aug 19, 2014 2:09 pm

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by WelshPaul » Thu Nov 07, 2019 1:51 pm

It's shared hosting, how do they expect you to fix anything server side? That's their job! All you can do is reduce traffic in order to reduce server load but who builds a public accessible website only then to limit public access to it? :shock:

How many topics/posts does your forum have?
How many users?
How much traffic is your site getting?

EDIT: Maybe your website is being affected by an influx in crawlers, scrapers or bot thats using up all your server resources? Similar to this maybe: viewtopic.php?f=556&t=2528826
Last edited by WelshPaul on Thu Nov 07, 2019 2:01 pm, edited 1 time in total.

Jobertim
Registered User
Posts: 258
Joined: Wed Dec 28, 2011 2:25 pm

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by Jobertim » Thu Nov 07, 2019 2:00 pm

Thank you for your help!
WelshPaul wrote:
Thu Nov 07, 2019 1:51 pm
How many topics/posts does your forum have?
130,000
WelshPaul wrote:
Thu Nov 07, 2019 1:51 pm
How many users?
80,000
WelshPaul wrote:
Thu Nov 07, 2019 1:51 pm
How much traffic is your site getting?
170,000 users/month

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21681
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by Mick » Thu Nov 07, 2019 2:04 pm

Your version of phpBB is no longer supported here but we can help you upgrade. In this particular case the issue is with your host unless you did something to cause the problem? We aren’t server specialists but can try our best to help you but you need to speak to the host and ask them what the problem is with their server first.

We cannot really recommend a host, but we do recommend that you visit WebHostingTalk.
"The more connected we get the more alone we become" - Kyle Broflovski

Jobertim
Registered User
Posts: 258
Joined: Wed Dec 28, 2011 2:25 pm

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by Jobertim » Thu Nov 07, 2019 5:09 pm

Ok thank you for all the help.

User avatar
JoshyPHP
Code Contributor
Posts: 1046
Joined: Mon Jul 11, 2011 12:28 am

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by JoshyPHP » Thu Nov 07, 2019 5:35 pm

Apparently you're getting lots of traffic from anonymous users, probably bots. Adding a new bot configuration for these users could help. Make sure that your database tables use InnoDB too.
I wrote the thing that does BBCodes in 3.2.

Jobertim
Registered User
Posts: 258
Joined: Wed Dec 28, 2011 2:25 pm

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by Jobertim » Thu Nov 07, 2019 9:27 pm

Thanks JoshyPHP for your help with this!!
JoshyPHP wrote:
Thu Nov 07, 2019 5:35 pm
Apparently you're getting lots of traffic from anonymous users, probably bots. Adding a new bot configuration for these users could help.
Great, how do I do that exactly?
JoshyPHP wrote:
Thu Nov 07, 2019 5:35 pm
Make sure that your database tables use InnoDB too.
Ok, thanks a lot for that advice, converting all my tables to use InnoDB in PHPmyAdmin right now.

User avatar
JoshyPHP
Code Contributor
Posts: 1046
Joined: Mon Jul 11, 2011 12:28 am

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by JoshyPHP » Thu Nov 07, 2019 9:54 pm

In the admin panel there's a link that says "Spiders/Robots". You can add new entries there.
I wrote the thing that does BBCodes in 3.2.

Jobertim
Registered User
Posts: 258
Joined: Wed Dec 28, 2011 2:25 pm

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by Jobertim » Thu Nov 07, 2019 10:15 pm

JoshyPHP wrote:
Thu Nov 07, 2019 9:54 pm
In the admin panel there's a link that says "Spiders/Robots". You can add new entries there.
Thanks, unfortunately the site is down so I don't have access to my admin panel. :(

User avatar
Lumpy Burgertushie
Registered User
Posts: 66858
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by Lumpy Burgertushie » Thu Nov 07, 2019 11:20 pm

tell your host to turn it back on so you can work on it.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Jobertim
Registered User
Posts: 258
Joined: Wed Dec 28, 2011 2:25 pm

Re: Host disabled service: because of COMMAND: Sleep queries?

Post by Jobertim » Fri Nov 08, 2019 8:21 am

Site is still down. Now the host is saying:
we are still seeing large surges in CPU usage at this time. It appears that there is stall a large number of requests coming from various IPs to your site leading to these overages. Here is a list of today's traffic that have had 20 or more hits: http://spam.hgfix.net/logicprohelp.com/ ... lp.com.txt
I don't understand how I could get a large number of requests when the site is down? Are those just people trying to see the site? Is there a bot attack on my site? No idea what's going on. :(

Post Reply

Return to “[3.2.x] Support Forum”