Database errors in log

[peppies]

I just checked an error log and it has a lot of database errors. Is anyone having a clean error log anyway? The one I'm concerned about right ow is: [21-Dec-2015 14:41:22 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp1_options WHERE option_name = '_transient_wc_product_children_2808' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wplms/notitle.php'), the_content, apply_filters('the_content'), call_user_func_array, show_builder_layout, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, new_column, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, custom_post_carousel, thumbnail_generator, bp_course_get_course_credits, WC_Product_Variable_Subscription->get_price_html, WC_Product_Variable_Subscription->variable_product_sync, wc_delete_product_transients, delete_transient, delete_option, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

[sandy]

All these errors are related to WooCommerce transients. Transients are temporary stored values in database which are cleaned after a specific duration. So the above error may be temporary. Let me know if this appears frequently.  

[peppies]

The error started to appear regularly since December 13. Every single day, few times each day.

[Anshuman Sahu]

You can try repairing your database from phpmyadmin . refer : https://www.siteground.com/tutorials/phpmyadmin/phpmyadmin_optimize_database.htm

[Author]

Posts