search

bobbingwide / vgc

VGC - Garden Vista Group theme
GNU General Public License v2.0
0 stars 0 forks source link

WordPress database error: Deadlock found... #20

Closed bobbingwide closed 11 months ago

bobbingwide commented 2 years ago

WordPress database error: [Deadlock found when trying to get lock; try restarting transaction]
DELETE FROM `vgcwp_options` WHERE `option_name` = '_transient_wpseo_total_unindexed_posts_limited'

Occurred when visiting gvg.co.uk/wp-admin.

bobbingwide commented 11 months ago

It happened 3 times in quick succession on 4 Mar 2023

[04-Mar-2023 10:44:37 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM `vgcwp_options` WHERE `option_name` = '_transient_timeout_woocommerce_admin_payment_method_promotion_specs' 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, rest_api_loaded, rest_get_server, do_action('rest_api_init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\StoreApi\StoreApi->Automattic\WooCommerce\StoreApi\{closure}, Automattic\WooCommerce\StoreApi\RoutesController->register_all_routes, Automattic\WooCommerce\StoreApi\RoutesController->register_routes, Automattic\WooCommerce\StoreApi\Routes\V1\Checkout->get_args, Automattic\WooCommerce\StoreApi\Routes\V1\AbstractRoute->get_context_param, Automattic\WooCommerce\StoreApi\Routes\V1\AbstractRoute->get_item_schema, Automattic\WooCommerce\StoreApi\Schemas\V1\AbstractSchema->get_item_schema, Automattic\WooCommerce\StoreApi\Schemas\V1\CheckoutSchema->get_properties, WooCommerce->__get, WooCommerce->payment_gateways, WC_Payment_Gateways::instance, WC_Payment_Gateways->__construct, WC_Payment_Gateways->init, apply_filters('woocommerce_payment_gateways'), WP_Hook->apply_filters, Automattic\WooCommerce\Internal\Admin\WCPayPromotion\Init::possibly_register_pre_install_wc_pay_promotion_gateway, Automattic\WooCommerce\Internal\Admin\WCPayPromotion\Init::can_show_promotion, Automattic\WooCommerce\Internal\Admin\WCPayPromotion\Init::get_wc_pay_promotion_spec, Automattic\WooCommerce\Internal\Admin\WCPayPromotion\Init::get_promotions, Automattic\WooCommerce\Internal\Admin\WCPayPromotion\Init::get_specs, Automattic\WooCommerce\Admin\DataSourcePoller->get_specs_from_data_sources, get_transient, delete_option

It doesn't happen often. Closing as no fix planned since it's not the theme.