WordPress.org

Ready to get started?Download WordPress

Forums

w3 total cache ~ generating php sql db errors (4 posts)

  1. hexangel
    Member
    Posted 1 year ago #

    Apr 24, 10:11:09	 WordPress database error MySQL server has gone away for query SELECT meta_id FROM wp_postmeta WHERE meta_key = '_aioseop_noindex' AND post_id = 3842 made by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, All_in_One_SEO_Pack->save_post_data, delete_post_meta, delete_metadata, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    Apr 24, 10:11:09	 WordPress database error MySQL server has gone away for query SELECT * FROM wp_posts WHERE ID = 3842 LIMIT 1 made by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, All_in_One_SEO_Pack->save_post_data, delete_post_meta, wp_is_post_revision, wp_get_post_revision, get_post, WP_Post::get_instance, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    Apr 24, 10:11:09	 WordPress database error MySQL server has gone away for query SELECT meta_id FROM wp_postmeta WHERE meta_key = '_aioseop_disable_analytics' AND post_id = 3842 made by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, All_in_One_SEO_Pack->save_post_data, delete_post_meta, delete_metadata, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    Apr 24, 10:11:09	 WordPress database error MySQL server has gone away for query SELECT * FROM wp_posts WHERE ID = 3842 LIMIT 1 made by edit_post, _fix_attachment_links, get_post, WP_Post::get_instance, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    Apr 24, 10:11:09	 WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_options WHERE option_name = 'permalink_structure' LIMIT 1 made by edit_post, _fix_attachment_links, get_option, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    Apr 24, 10:11:09	 WordPress database error MySQL server has gone away for query SELECT * FROM wp_posts WHERE ID = 3842 LIMIT 1 made by edit_post, wp_set_post_lock, get_post, WP_Post::get_instance, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    Apr 24, 10:11:09	 WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_options WHERE option_name = 'sticky_posts' LIMIT 1 made by edit_post, unstick_post, get_option, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    Apr 24, 10:11:09	 WordPress database error MySQL server has gone away for query SELECT * FROM wp_posts WHERE ID = 3842 LIMIT 1 made by redirect_post, get_post_status, get_post, WP_Post::get_instance, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    Apr 24, 10:11:09	 WordPress database error MySQL server has gone away for query SELECT * FROM wp_posts WHERE ID = 3842 LIMIT 1 made by redirect_post, get_edit_post_link, get_post, WP_Post::get_instance, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    Apr 24, 10:11:09	 WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_options WHERE option_name = 'wpmp_mpexo_enabled_beta' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), call_user_func_array, wpmp_mpexo_shutdown, wpmp_mpexo_send_payload, get_option, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

    Any ideas what could be cause W3 to be throwing these kinds of php errors consistently?

  2. hexangel
    Member
    Posted 1 year ago #

    For the time-being, I've turned off db caching, which appears to have resolved the issue.

    However, I believe these errors in particular were thrown by wp-admin updating a post ... which seems to me mighty odd since the cache is intended for users of the site, not administration of the blog.

  3. vietnhi
    Member
    Posted 1 year ago #

    I faced the same error. In fact, if I dont disabled W3TC, all my posts, products,... disappear (PHP cant connect to mysql to retrieve the data).

    Any fix for this ??

    Regards,
    Viet

  4. Frederick Townes
    Member
    Posted 1 year ago #

    W3 doesn't "cause" those errors. W3TC adds a drop in that allows W3 to cache read operations from MySQL. That is why you see W3 being appended to those errors, it's not originating problems that didn't exist before. If you're using DB caching to disk, it probably isn't providing a performance improvement and you should test that.

Topic Closed

This topic has been closed to new replies.

About this Topic