• Hi, I’m reasonably new to WordPress and have created a few sites for friends. The site in question wasn’t created by me but I offered to try and help out, but I’m slowly running out of ideas!

    The site in question is https://mollyandtheprincess.com/

    It has recently started getting 500 errors, they seem to be quite random and occur in the admin panel and on the site itself. I’ve removed the plugins and couldn’t seem to cure the problem, but my knowledge is limited.

    Resource Usage in cPanel is showing.

    [ Moderator Note: Please post code or markup snippets between backticks or use the code button. That includes log data as well. ]

    Your site has been limited within the past 24 hours
    
    CPU resources were limited for your site
    
    Memory resources were limited for your site
    
    The Resource Usage Details show
    
    From	To	aCPU	mCpu	aEP	mEP	lEP	aMEM	mMEM	lMEM	MemF	MepF
    11-05 21:06	11-05 21:07	0	25	0	1	16	4.4M	42.6M	1000.0M	0	0
    11-05 21:05	11-05 21:06	0	16	0	0	16	772K	824K	1000.0M	0	0
    11-05 21:04	11-05 21:05	0	33	0	0	16	1.0M	1.1M	1000.0M	0	0
    11-05 21:00	11-05 21:05	0	66	0	1	16	3.9M	45.5M	1000.0M	0	0
    11-05 20:00	11-05 21:00	0	50	0	2	16	5.1M	1000.0M	1000.0M	4	0
    11-05 19:00	11-05 20:00	0	83	0	4	16	7.9M	1000.0M	1000.0M	6	0
    11-05 18:00	11-05 19:00	0	66	0	7	16	22.8M	1000.0M	1000.0M	14	0
    11-05 17:00	11-05 18:00	0	75	0	2	16	16.3M	1000.0M	1000.0M	18	0
    11-05 16:00	11-05 17:00	0	66	0	2	16	12.8M	1000.0M	1000.0M	16	0
    11-05 15:00	11-05 16:00	0	50	0	2	16	6.9M	1000.0M	1000.0M	8	0
    11-05 14:00	11-05 15:00	0	83	0	3	16	4.5M	1000.0M	1000.0M	2	0
    11-05 13:00	11-05 14:00	0	58	0	3	16	7.0M	1000.0M	1000.0M	6	0
    11-05 12:00	11-05 13:00	0	83	0	2	16	9.9M	1000.0M	1000.0M	12	0
    11-05 11:00	11-05 12:00	0	100	0	13	16	6.0M	1000.0M	1000.0M	4	0
    11-05 10:00	11-05 11:00	0	75	0	5	16	3.1M	91.7M	1000.0M	0	0
    11-05 09:00	11-05 10:00	0	91	0	6	16	2.6M	89.7M	1000.0M	0	0
    11-05 08:00	11-05 09:00	0	41	0	1	16	6.4M	1000.0M	1000.0M	8	0
    
    The latest errors from the cPanel error log are as follows.
    
    [Mon Nov 05 20:02:30 2012] [error] [client 66.249.71.168] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php
    [Mon Nov 05 20:02:30 2012] [error] [client 66.249.71.168] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php
    [Mon Nov 05 20:00:02 2012] [error] [client 54.242.107.5] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php
    [Mon Nov 05 20:00:02 2012] [error] [client 54.242.107.5] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php
    [Mon Nov 05 19:34:03 2012] [error] [client 81.57.115.196] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php, referer: https://www.google.fr/imgres?hl=fr&client=safari&sa=X&rls=en&biw=1365&bih=736&tbs=isz:l&tbm=isch&prmd=imvnso&tbnid=i5D5vKqf1Y0MPM:&imgrefurl=https://www.mollyandtheprincess.com/2010/12/10/wiener-werkstatte-christmas-designs/&docid=C9vt4D8o5vU-5M&imgurl=https://mollyandtheprincess.files.wordpress.com/2010/12/dsc02108.jpg&w=2398&h=2686&ei=xxSYUJmYCYKWhQf6n4DoBw&zoom=1&iact=hc&vpx=183&vpy=163&dur=1003&hovh=238&hovw=212&tx=118&ty=105&sig=112990285247798906621&page=1&tbnh=137&tbnw=137&start=0&ndsp=33&ved=1t:429,r:0,s:0,i:70
    [Mon Nov 05 19:34:03 2012] [error] [client 81.57.115.196] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php, referer: https://www.google.fr/imgres?hl=fr&client=safari&sa=X&rls=en&biw=1365&bih=736&tbs=isz:l&tbm=isch&prmd=imvnso&tbnid=i5D5vKqf1Y0MPM:&imgrefurl=https://www.mollyandtheprincess.com/2010/12/10/wiener-werkstatte-christmas-designs/&docid=C9vt4D8o5vU-5M&imgurl=https://mollyandtheprincess.files.wordpress.com/2010/12/dsc02108.jpg&w=2398&h=2686&ei=xxSYUJmYCYKWhQf6n4DoBw&zoom=1&iact=hc&vpx=183&vpy=163&dur=1003&hovh=238&hovw=212&tx=118&ty=105&sig=112990285247798906621&page=1&tbnh=137&tbnw=137&start=0&ndsp=33&ved=1t:429,r:0,s:0,i:70
    [Mon Nov 05 19:30:21 2012] [error] [client 220.181.51.107] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php
    [Mon Nov 05 19:30:21 2012] [error] [client 220.181.51.107] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php
    [Mon Nov 05 19:29:44 2012] [error] [client 149.241.237.242] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php, referer: https://mollyandtheprincess.com/tag/e-p-n-s/
    [Mon Nov 05 19:29:44 2012] [error] [client 149.241.237.242] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php, referer: https://mollyandtheprincess.com/tag/e-p-n-s/
    [Mon Nov 05 18:20:21 2012] [error] [client 157.55.35.94] (12)Cannot allocate memory: couldn't create child process: /opt/suphp/sbin/suphp for /home/mollyand/public_html/index.php
    
    Here are some lines out of the error_log file from the server
    
    [04-Nov-2012 22:36:50 UTC] WordPress database error Can't open file: './mollyand_wp1/wp_commentmeta.frm' (errno: 24) for query SELECT comment_id, meta_key, meta_value FROM wp_commentmeta WHERE comment_id IN (7358) made by wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_recent_comments, _wp_dashboard_recent_comments_row, apply_filters('comment_row_actions'), call_user_func_array, akismet_comment_row_action, get_comment_meta, get_metadata, update_meta_cache
    [04-Nov-2012 22:36:50 UTC] WordPress database error Can't open file: './mollyand_wp1/wp_commentmeta.frm' (errno: 24) for query SELECT comment_id, meta_key, meta_value FROM wp_commentmeta WHERE comment_id IN (7293) made by wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_recent_comments, _wp_dashboard_recent_comments_row, apply_filters('comment_row_actions'), call_user_func_array, akismet_comment_row_action, get_comment_meta, get_metadata, update_meta_cache
    [04-Nov-2012 22:36:50 UTC] WordPress database error Can't open file: './mollyand_wp1/wp_commentmeta.frm' (errno: 24) for query SELECT comment_id, meta_key, meta_value FROM wp_commentmeta WHERE comment_id IN (7286) made by wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_recent_comments, _wp_dashboard_recent_comments_row, apply_filters('comment_row_actions'), call_user_func_array, akismet_comment_row_action, get_comment_meta, get_metadata, update_meta_cache
    [04-Nov-2012 22:36:50 UTC] WordPress database error Can't open file: './mollyand_wp1/wp_commentmeta.frm' (errno: 24) for query SELECT comment_id, meta_key, meta_value FROM wp_commentmeta WHERE comment_id IN (7260) made by wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_recent_comments, _wp_dashboard_recent_comments_row, apply_filters('comment_row_actions'), call_user_func_array, akismet_comment_row_action, get_comment_meta, get_metadata, update_meta_cache
    [04-Nov-2012 22:36:50 UTC] WordPress database error Can't open file: './mollyand_wp1/wp_commentmeta.frm' (errno: 24) for query SELECT comment_id, meta_key, meta_value FROM wp_commentmeta WHERE comment_id IN (7258) made by wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_recent_comments, _wp_dashboard_recent_comments_row, apply_filters('comment_row_actions'), call_user_func_array, akismet_comment_row_action, get_comment_meta, get_metadata, update_meta_cache
    [04-Nov-2012 22:36:50 UTC] WordPress database error Out of resources when opening file '/tmp/#sql_2990_0.MYI' (Errcode: 24) for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (5015) ORDER BY t.name ASC made by wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_quick_press, get_tags_to_edit, get_terms_to_edit, wp_get_post_terms, wp_get_object_terms
    [04-Nov-2012 22:37:01 UTC] WordPress database error Out of resources when opening file '/tmp/#sql_2990_0.MYI' (Errcode: 24) for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC  made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, chimps_init_options, get_terms
    [04-Nov-2012 22:37:02 UTC] WordPress database error Out of resources when opening file '/tmp/#sql_2990_0.MYI' (Errcode: 24) for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1255, 1706, 2960, 3042, 3464, 4637, 5016) ORDER BY t.name ASC made by do_action('jetpack_page_stats'), call_user_func_array, stats_reports_page, stats_dashboard_widget_content, get_posts, WP_Query->query, WP_Query->get_posts, _prime_post_caches, update_post_caches, update_object_term_cache, wp_get_object_terms
    [04-Nov-2012 22:45:32 UTC] WordPress database error Out of resources when opening file '/tmp/#sql_2990_0.MYI' (Errcode: 24) for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC  made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, chimps_init_options, get_terms
    [04-Nov-2012 23:11:35 UTC] WordPress database error Out of resources when opening file '/tmp/#sql_2990_0.MYI' (Errcode: 24) for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC  made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, chimps_init_options, get_terms
    [04-Nov-2012 23:11:52 UTC] WordPress database error Out of resources when opening file '/tmp/#sql_2990_0.MYI' (Errcode: 24) for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC  made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, chimps_init_options, get_terms
    [04-Nov-2012 23:17:03 UTC] WordPress database error Out of resources when opening file '/tmp/#sql_2990_0.MYI' (Errcode: 24) for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC  made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, chimps_init_options, get_terms
    [04-Nov-2012 23:17:09 UTC] WordPress database error Out of resources when opening file '/tmp/#sql_2990_0.MYI' (Errcode: 24) for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC  made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, chimps_init_options, get_terms

    Not sure if that is enough info to provide a pointer as to what my problem might be.

    Would really appreciate some help with this and if I can provide any more info please shout.

    Thanks in advance.

    Stuart

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Midlifecyclist

    (@midlifecyclist)

    Not sure if my .htaccess file is causing some of my issues. See below.

    RewriteEngine on
    
    # BEGIN WordPress
    <IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteBase /
    RewriteRule ^index\.php$ - [L]
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule . /index.php [L]
    </IfModule>
    
    # END WordPress
    
    RewriteCond %{HTTP_REFERER} !^$
    RewriteCond %{HTTP_REFERER} !^https://mollyandtheprincess.com/.*$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://mollyandtheprincess.com$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://www.mollyandtheprincess.com/.*$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://www.mollyandtheprincess.com$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://www.facebook.com/.*$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://www.facebook.com$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://www.facebook.com/.*$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://www.facebook.com$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://pinterest.com/.*$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://pinterest.com$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://www.pinterest.com/.*$      [NC]
    RewriteCond %{HTTP_REFERER} !^https://www.pinterest.com$      [NC]
    RewriteRule .*\.(jpg|jpeg|gif|png|bmp)$ - [F,NC]

    Do you have any kind of caching turned on? I’ve seen similar errors before and they were tied toward something going a bit wonky in a caching plugin.

    Other than that, I’m not entirely sure what would be causing it. It really is intermittent. On my first attempt to load your site, I got that error. But I didn’t get one on reload or any other clicks. Could you give a list of the plugins you’re using?

    Thread Starter Midlifecyclist

    (@midlifecyclist)

    Hi Rebecca,

    I did instal W3 Total Cache plug in as an attempt to cure this problem but it didn’t seem to make any difference so I removed it via the admin panel.

    The only plug ins I have running at the moment are Akismet and Linkwithin.

    Problems with this blog initial started with random pictures not appearing, this still seems to happen randomly too. Not sure if the problems are connected.

    Kind regards

    Stuart

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘500 Errors – Running out of ideas!’ is closed to new replies.