Hi,

I've been trying to troubleshoot site resource problems. Many days our error log contains thousands of errors. Virtually all of the errors in the log reference Atahualpa 379. Most errors appear identical and there are often several dozen each second. Can anyone tell me what it means? Is this an Atahualpa issue or something else? If you can give me a hint, I would be most grateful! :-)

We're currently running Atahualpa 3.7.9 on Wordpress 3.5. All plugins are up to date.

Our error log for the last week is 1.7 MB of text. Here's a sample:

[11-Jan-2013 22:52:47] WordPress database error MySQL server has gone away for query SELECT ID FROM wp_posts WHERE post_name LIKE 'wp-comments-post-php%' AND post_type IN ('post', 'page', 'attachment') AND post_status = 'publish' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, redirect_canonical, redirect_guess_404_permalink
[11-Jan-2013 22:52:47] WordPress database error MySQL server has gone away 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 = 'nav_menu' AND t.term_id = 427 LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/atahualpa379/index.php'), get_header, locate_template, load_template, require_once('/themes/atahualpa379/header.php'), bfa_header_config, bfa_new_wp3_menus, wp_nav_menu, wp_get_nav_menu_object, get_term
[11-Jan-2013 22:52:47] WordPress database error MySQL server has gone away 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 = 'nav_menu' AND t.slug = '427' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/atahualpa379/index.php'), get_header, locate_template, load_template, require_once('/themes/atahualpa379/header.php'), bfa_header_config, bfa_new_wp3_menus, wp_nav_menu, wp_get_nav_menu_object, get_term_by
[11-Jan-2013 22:52:47] WordPress database error MySQL server has gone away 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 = 'nav_menu' AND t.name = '427' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/atahualpa379/index.php'), get_header, locate_template, load_template, require_once('/themes/atahualpa379/header.php'), bfa_header_config, bfa_new_wp3_menus, wp_nav_menu, wp_get_nav_menu_object, get_term_by
[11-Jan-2013 22:52:47] WordPress database error MySQL server has gone away for query SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_order,wp_posts.post_title ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/atahualpa379/index.php'), get_header, locate_template, load_template, require_once('/themes/atahualpa379/header.php'), bfa_header_config, bfa_new_wp3_menus, wp_nav_menu, call_user_func, wp_page_menu, wp_list_pages, get_pages
[11-Jan-2013 22:52:47] WordPress database error MySQL server has gone away 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 = 'nav_menu' AND t.term_id = 426 LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/atahualpa379/index.php'), get_header, locate_template, load_template, require_once('/themes/atahualpa379/header.php'), bfa_header_config, bfa_new_wp3_menus, wp_nav_menu, wp_get_nav_menu_object, get_term
[11-Jan-2013 22:52:47] WordPress database error MySQL server has gone away 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 = 'nav_menu' AND t.slug = '426' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/atahualpa379/index.php'), get_header, locate_template, load_template, require_once('/themes/atahualpa379/header.php'), bfa_header_config, bfa_new_wp3_menus, wp_nav_menu, wp_get_nav_menu_object, get_term_by


Thanks in advance for any information you can share!

Michael

it looks like there is a query that is timing out.

shut off all plugins and see if that fixes it.

Hi Juggledad,
Should I wait until it is actually happening and then deactivate the plugins?

At one point, I tried shutting down plugins because of another issue and isolated one as a problem, which I removed. It did seem to help when all plugins were inactive.

Now, we're running with half our plugins deactivated and half the ones that are active were inactive for a week while I was troubleshooting before.

Since the problem seems to happen at random times, I wondered if it would help troubleshoot if I waited to deactivate right when the problem happened.

In any case, it sounds like this doesn't look like a theme issue. I've been in the dark for a while trying to identify the culprit.

Oh, one other thing because I'm in the weeds here - Would a timeout cause 24 errors in a second? That seems like the usual pattern.

Thanks again!

Michael

how are you going to know when it happens? it must happen when someone does something, the question is what is that something something that causes it to happen...that is the question.

Yes, that makes sense. I've been looking over the logs again trying to see a pattern in the times it happens. Our site has a lot of traffic that comes in waves and I'm never quite sure what they're doing at any given time. Still, I'm hopeful that scouring the logs again will help me see a pattern.

Actually, I forgot that I once solved something like this by activating the WP debugger...

Thanks!

Michael