jazz1611

Well-Known Member
Jun 5, 2012
82
0
56
cPanel Access Level
Root Administrator
Hi,

I am provider Hosting. I get error when website of customer have 500 current connection (500 online or more).

First error: 500 Internal Server Error
continue to Second error: 508 Resource Limit Is Reached

My VPS specifications:
10vCPU (12Ghz) Intel(R) Xeon(R) CPU L5640 @ 2.27GHz
6GB RAM
CloudLinux 6

I checked see:
Server load 5.56 (10 CPUs) alert!

Then website of my customer error.

P/s: But website of other customer on same VPS loading normal.

Ex: domainA.com (123.123.1.1) have 500 online or more - get error.
Ex: domainB.com (123.123.1.1) other customer have 800 online or more - still normal loading.

Regards,

I from Vietnam then i speak English not well. Hope you understand.

---------------------------------------------------------------------------------------

Error logs of website when 500 online or more:
Code:
[30-Jul-2013 15:09:13 UTC] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY RAND() DESC LIMIT 0, 8 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/index.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[30-Jul-2013 15:09:31 UTC] WordPress database error MySQL server has gone away for query SELECT DISTINCT ID,post_title,post_date,post_content,MATCH(post_title,post_content) AGAINST ('Yêu nhầm chị hai… được nhầm em gái [Full]') AS score FROM wp_posts WHERE MATCH (post_title,post_content) AGAINST ('Yêu nhầm chị hai… được nhầm em gái [Full]') AND post_date <= '2013-07-30 22:09:31' AND post_status = 'publish' AND id != 9 AND post_type = 'post' ORDER BY score DESC  made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/single.php'), the_content, apply_filters('the_content'), call_user_func_array, ald_crp_content, ald_crp
[30-Jul-2013 15:09:31 UTC] WordPress database error MySQL server has gone away for query 
					SELECT term_taxonomy_id
					FROM wp_term_taxonomy
					WHERE taxonomy = 'category'
					AND term_id IN (1)
				 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/single.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts, WP_Tax_Query->get_sql, WP_Tax_Query->clean_query, WP_Tax_Query->transform_query
[30-Jul-2013 15:09:32 UTC] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.ID NOT IN (9) AND 0 = 1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 12 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/single.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[30-Jul-2013 15:09:38 UTC] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY RAND() DESC LIMIT 0, 8 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/index.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[30-Jul-2013 15:15:47 UTC] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY RAND() DESC LIMIT 0, 8 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/index.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[30-Jul-2013 15:23:26 UTC] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY RAND() DESC LIMIT 0, 8 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mobiletheme/index.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
 
Last edited:

jazz1611

Well-Known Member
Jun 5, 2012
82
0
56
cPanel Access Level
Root Administrator
Hi,

I checked on hosting this website have error. See alway CPU load high.

CPU Usage 80 / 100 % on table Stats (cPanel)

Ảnh chụp màn hình_2013-07-31_230049.png

3 week ago. Website have 800 online or more still normal. But now just 500 online or more will get error 500 then to 508.

I really dont know why that? Can give me suggest about that?

Regards,
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,261
463
Could you let us know the specific 500 error message that appears in the /usr/local/apache/logs/error_log file? Also, it looks like you are using Cloud Linux, and the account is reaching it's resource usage threshold. Have you considered increasing the Cloud Linux resource limit for this account?

Thank you.
 

jazz1611

Well-Known Member
Jun 5, 2012
82
0
56
cPanel Access Level
Root Administrator
Yes, i increase the Cloud Linux resource limit for this account. Now all website running on same server get error 508 too. It just make server loading to high.

Can i open ticket for us check it?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,261
463
Per the Cloud Linux documentation:

Each LVE limits amount of entry processes (Apache processes entering into LVE) to prevent single site exhausting all Apache processes. If the limit is reached -- mod_hostinglimits will not be able to place Apache process into LVE, and will return error code 508. This way very heavy site would slow down and start returning 508 errors, without affecting other users.

The full document is available at:

Understanding LVE

Have you tried disabling the limits completely? You may want to consult with a qualified system administrator to troubleshoot the load issue on your system. You can find a list of third-party system administration companies at:

cPanel Application Catalog - SysAdmin Services

Thank you.