MySQL server has gone away

Hi there ??

The error is due to a table missing from your website. Here are the steps we use to resolve this. Please, make sure to work your way down the list only if the steps don’t fix it, so only go to #2 if #1 doesn’t fix it, etc.

1. Activate and then deactivate the WooCommerce plugin.
2. Try to run the WooCommerce Database update. You can find it by going to WooCommerce > Status > Tool > Update Database.
3. Install the standalone Action Scheduler plugin here: https://github.com/woocommerce/action-scheduler/ (the green button there to download, and then install manually on your site as a plugin).
4. Manually create the table in your WordPress database.

Before you start

First, please make sure you have a good backup in place of your full site and database. Most hosting companies have this included in the subscription, but you could also consider using a service like Jetpack. If something goes wrong, it’s nice to know that you can restore your site.

I hope that helps ??

Great i will try this, but since we are using Woocommerce Multichannel for WooCommerce: Google, Amazon & eBay Integration for synching products between our site and Ebay, i will have to to this tomorrow morning because of the time zone difference (US) and i am in Europe, because in that time there are less actions regarding orders and stuff.

I understand every step you have provided me with except the 4 step, what table am i suppose to create? Sorry if it is a dumb question

Hi @vdgraphics ??

Apologies, I’ve misread the PHP warning that you are receiving. Upon double-checking it, I can see that it is related to your WordPress core and not to WooCommerce. However, I’ve found a good article on how to fix this issue. Here is the link:

https://kinsta.com/knowledgebase/mysql-server-has-gone-away/

Cheers! ??

Ok I will try to do like written in this article. One more error is also piling up, could you tell me what is it about:

[09-Feb-2021 15:28:32 UTC] WordPress database error Table ‘dbr6dfzr9ebvgh.wp0d_term_taxonomy’ doesn’t exist for query SELECT p.ID FROM wp0d_posts AS p INNER JOIN wp0d_term_relationships AS tr ON p.ID = tr.object_id INNER JOIN wp0d_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE p.post_date < ‘2019-10-14 13:45:39’ AND p.post_type = ‘product’ AND tt.taxonomy = ‘product_cat’ AND tt.term_id IN (8527,8568) AND p.post_status = ‘publish’ ORDER BY p.post_date DESC LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/woocommerce/templates/single-product.php’), wc_get_template_part, load_template, require(‘/themes/porto/woocommerce/content-single-product.php’), do_action(‘woocommerce_single_product_summary’), WP_Hook->do_action, WP_Hook->apply_filters, porto_woocommerce_product_nav, porto_woocommerce_prev_product, porto_adjacent_post_link_product, get_adjacent_post

Hi there!

Apologies for the delay.

Well, this error also points to your WordPress database. Could you please let me know if you could solve this by following the guide that I recommend to you?

Hi,

i have followed the instruction from that Kinsta article and also i run the repair DB process and now i am not seeing MySQL has gone away error but couple of different errors showed up:

WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT INTO wp0d_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, post_type, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type, guid) VALUES (1, ‘2021-02-12 17:45:55’, ‘2021-02-12 17:45:55’, ”, ”, ‘Order – February 12, 2021 @ 05:45 PM’, ”, ‘wc-pending’, ‘shop_order’, ‘closed’, ‘closed’, ‘wc_order_OIS9KaC5zsNgb’, ‘order-feb-12-2021-0545-pm’, ”, ”, ‘2021-02-12 17:45:55’, ‘2021-02-12 17:45:55’, 0, 0, ”, ”) made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, CodistoConnect->parse, CodistoConnect->sync, wc_create_order, WC_Order->save, WC_Abstract_Order->save, WC_Data_Store->create, WC_Order_Data_Store_CPT->create, Abstract_WC_Order_Data_Store_CPT->create, wp_insert_post, QM_DB->query

Glad to know that you could solve the WordPress database issue.

Upon reading this error, it seems to be related to your WooCommerce installation

Now, please follow the steps below in order to troubleshoot the WooCommerce database:

1. Activate and then deactivate the WooCommerce plugin.
2. Try to run the WooCommerce Database update. You can find it by going to WooCommerce > Status > Tool > Update Database.
3. Install the standalone Action Scheduler plugin here: https://github.com/woocommerce/action-scheduler/ (the green button there to download, and then install manually on your site as a plugin).

I hope that helps!

Hey Gabriel,

the error stopped showing with update database option and with that settings i applied from kinsta article, and what i found one more thing that could cause timeouts, right now we have 14500 products on our website, and when looking on the db tables on wp_post table we have 84000 rows but on wp_postmeta 1.108.000, what could cause such bloat on table. Could that also be the reason of those errors showing up?

Hi @vdgraphics,

I’m sorry we missed your last post. Have you been able to resolve this issue?

If not, here’s a bit more information about the difference between the wp_posts table and wp_postmeta table: https://stackoverflow.com/questions/32836351/what-is-the-wp-postmeta-table. As for whether, that’s the reason the error show up, I’m not sure.

As this question relates to a fairly complex development topic, I’m going to leave it open for a bit to see if anyone is able to chime in and help you out a bit further.

Hope you managed to fix the issue you were having! We haven’t heard back from you for a while and there’s no further activity, so I’m going to mark this post as resolved. If you have any further questions or need additional help with the WooCommerce plugin, please start a new thread and we’ll be able to help you out there. Thanks!