Hi
My forum had been running fine for almost a month now when suddenly I noticed my WordPress error_log file balloon to over 85MB (from a few hundred KB). I looked at the contents and I found that the errors were of the following nature (the red text below). I can’t really tell what it is but the bulk of the error messages comes from a couple of thousand lines of the SQL statement involving the “update wp_sftrack SET notification” where it looks like something “recursive” is going on. This goes on for a couple of thousand entries with each succeeding error line getting longer and longer until it ends with the blue error log line below (I replaced the actual folder path with the orange ????? in this post for security reasons).
All I can say at this point is that it seems to start with something related to my theme (Catalyst Theme) then the bulk of the error messages come from the said SQL statement which includes the update on wp_sftrack.
Could you help point me in the right direction to try to figure out what’s causing it? It’s caused my forum to hang for a few times these past three days. Thanks in advance.
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query SELECT ID FROM wp_posts WHERE post_parent = 19 AND post_type = ‘page’ AND post_status = ‘publish’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/catalyst/page.php’), catalyst_framework, get_header, locate_template, load_template, require_once(‘/themes/catalyst/problem-with-post-edit-buttoneader.php’), body_class, get_body_class
[27-Jun-2013 03:36:19] 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 = 2 LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/catalyst/page.php’), catalyst_framework, get_header, locate_template, load_template, require_once(‘/themes/catalyst/problem-with-post-edit-buttoneader.php’), catalyst_hook_header, do_action(‘catalyst_hook_header’), call_user_func_array, catalyst_build_header, catalyst_hook_header_right, do_action(‘catalyst_hook_header_right’), call_user_func_array, catalyst_build_navbar1, wp_nav_menu, wp_get_nav_menu_object, get_term
[27-Jun-2013 03:36:19] 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 = ‘2’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/catalyst/page.php’), catalyst_framework, get_header, locate_template, load_template, require_once(‘/themes/catalyst/problem-with-post-edit-buttoneader.php’), catalyst_hook_header, do_action(‘catalyst_hook_header’), call_user_func_array, catalyst_build_header, catalyst_hook_header_right, do_action(‘catalyst_hook_header_right’), call_user_func_array, catalyst_build_navbar1, wp_nav_menu, wp_get_nav_menu_object, get_term_by
[27-Jun-2013 03:36:19] 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 = ‘2’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/catalyst/page.php’), catalyst_framework, get_header, locate_template, load_template, require_once(‘/themes/catalyst/problem-with-post-edit-buttoneader.php’), catalyst_hook_header, do_action(‘catalyst_hook_header’), call_user_func_array, catalyst_build_header, catalyst_hook_header_right, do_action(‘catalyst_hook_header_right’), call_user_func_array, catalyst_build_navbar1, wp_nav_menu, wp_get_nav_menu_object, get_term_by
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query SELECT * FROM wp_sflinks WHERE post_id=19 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/catalyst/page.php’), catalyst_framework, catalyst_hook_post_loop, do_action(‘catalyst_hook_post_loop’), call_user_func_array, catalyst_build_loop, catalyst_standard_loop, catalyst_hook_post_content, do_action(‘catalyst_hook_post_content’), call_user_func_array, catalyst_build_the_content, the_content, apply_filters(‘the_content’), call_user_func_array, sp_render_forum, apply_filters(‘the_content’), call_user_func_array, sp_linking_show_blog_link, sp_show_blog_link, sp_blog_links_control, spdb_table, spdb_select
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query UPDATE wp_sftrack
SET notification=’a:2:{i:0;i:1;i:1;s:22:”Invalid database query”;}’
WHERE id=3994 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/catalyst/page.php’), catalyst_framework, catalyst_hook_post_loop, do_action(‘catalyst_hook_post_loop’), call_user_func_array, catalyst_build_loop, catalyst_standard_loop, catalyst_hook_post_content, do_action(‘catalyst_hook_post_content’), call_user_func_array, catalyst_build_the_content, the_content, apply_filters(‘the_content’), call_user_func_array, sp_render_forum, apply_filters(‘the_content’), call_user_func_array, sp_linking_show_blog_link, sp_show_blog_link, sp_blog_links_control, spdb_table, spdb_select, sp_construct_database_error, sp_notify, spdb_query
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query UPDATE wp_sftrack
SET notification=’a:2:{i:0;i:1;i:1;s:22:”Invalid database query”;}’
WHERE id=3994 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/catalyst/page.php’), catalyst_framework, catalyst_hook_post_loop, do_action(‘catalyst_hook_post_loop’), call_user_func_array, catalyst_build_loop, catalyst_standard_loop, catalyst_hook_post_content, do_action(‘catalyst_hook_post_content’), call_user_func_array, catalyst_build_the_content, the_content, apply_filters(‘the_content’), call_user_func_array, sp_render_forum, apply_filters(‘the_content’), call_user_func_array, sp_linking_show_blog_link, sp_show_blog_link, sp_blog_links_control, spdb_table, spdb_select, sp_construct_database_error, sp_notify, spdb_query, sp_construct_database_error, sp_notify, spdb_query
[27-Jun-2013 03:36:19] WordPress database error MySQL server has gone away for query UPDATE wp_sftrack
SET notification=’a:2:{i:0;i:1;i:1;s:22:”Invalid database query”;}’
WHERE id=3994 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/catalyst/page.php’), catalyst_framework, catalyst_hook_post_loop, do_action(‘catalyst_hook_post_loop’), call_user_func_array, catalyst_build_loop, catalyst_standard_loop, catalyst_hook_post_content, do_action(‘catalyst_hook_post_content’), call_user_func_array, catalyst_build_the_content, the_content, apply_filters(‘the_content’), call_user_func_array, sp_render_forum, apply_filters(‘the_content’), call_user_func_array, sp_linking_show_blog_link, sp_show_blog_link, sp_blog_links_control, spdb_table, spdb_select, sp_construct_database_error, sp_notify, spdb_query, sp_construct_database_error, sp_notify, spdb_query, sp_construct_database_error, sp_notify, spdb_query
[27-Jun-2013 03:36:20] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /?????/public_html/wp-includes/functions.php on line 3788
