Title: Database deadlocks Last modified: October 13, 2022 --- # Database deadlocks * Resolved [sacfc](https://wordpress.org/support/users/sacfc/) * (@sacfc) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-deadlocks/) * We are getting frequent database deadlock errors in our logs which we have tracked back to this plugin. For example: * `WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM`kjs_options`WHERE`option_name`= '_transient_wc_facebook_aam_settings' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once(' wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook- >do_action, WP_Hook->apply_filters, WC_Facebookcommerce->get_integration, WC_Facebookcommerce_Integration- >__construct, WC_Facebookcommerce_Integration->load_aam_settings_of_pixel, get_transient, wp_cache_get, WP_Object_Cache->get, WP_Object_Cache->_transient_get, delete_option` Viewing 5 replies - 1 through 5 (of 5 total) * [Chris Moreira – a11n](https://wordpress.org/support/users/chrism245/) * (@chrism245) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-deadlocks/#post-16111588) * Hello! * Please share your current System Status Report. You can get it by navigating to the `WooCommerce / Status` section of your site. Once there, click on the ` Get system report` button and then copy it by clicking on the `Copy for support` button. Then paste it here in a comment. * Thread Starter [sacfc](https://wordpress.org/support/users/sacfc/) * (@sacfc) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-deadlocks/#post-16111602) * ``` ### WordPress Environment ### WordPress address (URL): https://fanzone.stalbanscityfc.com Site address (URL): https://fanzone.stalbanscityfc.com WC Version: 7.0.0 REST API Version: ✔ 7.0.0 WC Blocks Version: ✔ 8.5.1 Action Scheduler Version: ✔ 3.5.2 Log Directory Writable: ✔ WP Version: 6.0.3 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: – WP Cron: ✔ Language: en_GB External object cache: ✔ ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.4.32 PHP Post Max Size: 256 MB PHP Time Limit: 400 PHP Max Input Vars: 1000 cURL Version: 7.71.0 OpenSSL/1.1.1p SUHOSIN Installed: – MySQL Version: 5.7.40 Max Upload Size: 256 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ❌ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected. DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 7.0.0 WC Database Prefix: kjs_ Total Database Size: 844.18MB Database Data Size: 597.29MB Database Index Size: 246.89MB kjs_woocommerce_sessions: Data: 1.52MB + Index: 0.05MB + Engine InnoDB kjs_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB kjs_woocommerce_order_items: Data: 4.52MB + Index: 1.52MB + Engine InnoDB kjs_woocommerce_order_itemmeta: Data: 79.59MB + Index: 21.06MB + Engine InnoDB kjs_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB kjs_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_actionscheduler_actions: Data: 5.52MB + Index: 5.14MB + Engine InnoDB kjs_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_actionscheduler_logs: Data: 4.52MB + Index: 3.03MB + Engine InnoDB kjs_bv_activities_store: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_cocart_carts: Data: 3.03MB + Index: 0.02MB + Engine InnoDB kjs_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_comments: Data: 13.52MB + Index: 9.09MB + Engine InnoDB kjs_css_js_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_emember_uploads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_fooevents_check_in: Data: 4.52MB + Index: 1.52MB + Engine InnoDB kjs_foosales_square_checkouts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_foosales_square_devices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_foosales_square_refunds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_forum_ads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB kjs_gla_merchant_issues: Data: 0.16MB + Index: 0.00MB + Engine InnoDB kjs_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_litespeed_crawler: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_litespeed_crawler_blacklist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_litespeed_img_optm: Data: 0.41MB + Index: 0.19MB + Engine InnoDB kjs_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB kjs_litespeed_url: Data: 0.08MB + Index: 0.08MB + Engine InnoDB kjs_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB kjs_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_mailpoet_log: Data: 0.05MB + Index: 0.00MB + Engine InnoDB kjs_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_newsletters: Data: 7.52MB + Index: 0.03MB + Engine InnoDB kjs_mailpoet_newsletter_links: Data: 4.52MB + Index: 3.33MB + Engine InnoDB kjs_mailpoet_newsletter_option: Data: 0.05MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_newsletter_segment: Data: 0.05MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_newsletter_templates: Data: 7.52MB + Index: 0.00MB + Engine InnoDB kjs_mailpoet_scheduled_tasks: Data: 1.52MB + Index: 0.48MB + Engine InnoDB kjs_mailpoet_scheduled_task_subscribers: Data: 45.58MB + Index: 15.52MB + Engine InnoDB kjs_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_mailpoet_sending_queues: Data: 76.52MB + Index: 0.13MB + Engine InnoDB kjs_mailpoet_settings: Data: 0.03MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_mailpoet_statistics_clicks: Data: 0.36MB + Index: 0.31MB + Engine InnoDB kjs_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_statistics_newsletters: Data: 6.52MB + Index: 5.03MB + Engine InnoDB kjs_mailpoet_statistics_opens: Data: 3.52MB + Index: 7.58MB + Engine InnoDB kjs_mailpoet_statistics_unsubscribes: Data: 0.05MB + Index: 0.05MB + Engine InnoDB kjs_mailpoet_statistics_woocommerce_purchases: Data: 0.22MB + Index: 0.27MB + Engine InnoDB kjs_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_mailpoet_subscribers: Data: 1.50MB + Index: 3.03MB + Engine InnoDB kjs_mailpoet_subscriber_custom_field: Data: 0.09MB + Index: 0.05MB + Engine InnoDB kjs_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_subscriber_segment: Data: 1.52MB + Index: 0.70MB + Engine InnoDB kjs_mailpoet_subscriber_tag: Data: 0.05MB + Index: 0.03MB + Engine InnoDB kjs_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_mailpoet_user_agents: Data: 1.52MB + Index: 0.09MB + Engine InnoDB kjs_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_options: Data: 9.50MB + Index: 0.28MB + Engine InnoDB kjs_postmeta: Data: 216.73MB + Index: 116.30MB + Engine InnoDB kjs_posts: Data: 16.52MB + Index: 8.06MB + Engine InnoDB kjs_serial_numbers: Data: 0.02MB + Index: 0.08MB + Engine InnoDB kjs_serial_numbers_activations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_termmeta: Data: 0.08MB + Index: 0.08MB + Engine InnoDB kjs_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_term_relationships: Data: 0.33MB + Index: 0.17MB + Engine InnoDB kjs_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB kjs_usermeta: Data: 20.55MB + Index: 14.03MB + Engine InnoDB kjs_users: Data: 1.52MB + Index: 0.63MB + Engine InnoDB kjs_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB kjs_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB kjs_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_wc_customer_lookup: Data: 1.52MB + Index: 0.42MB + Engine InnoDB kjs_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_wc_order_coupon_lookup: Data: 0.17MB + Index: 0.20MB + Engine InnoDB kjs_wc_order_product_lookup: Data: 3.52MB + Index: 1.95MB + Engine InnoDB kjs_wc_order_stats: Data: 2.52MB + Index: 1.20MB + Engine InnoDB kjs_wc_order_tax_lookup: Data: 1.52MB + Index: 0.86MB + Engine InnoDB kjs_wc_product_attributes_lookup: Data: 0.22MB + Index: 0.17MB + Engine InnoDB kjs_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_wc_product_meta_lookup: Data: 0.20MB + Index: 0.33MB + Engine InnoDB kjs_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_woocommerce_square_customers: Data: 1.52MB + Index: 0.00MB + Engine InnoDB kjs_woo_sales_country_region: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_woo_shippment_provider: Data: 0.08MB + Index: 0.00MB + Engine InnoDB kjs_woo_square_integration_deleted_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_woo_square_integration_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_wpforms_entries: Data: 0.06MB + Index: 0.02MB + Engine InnoDB kjs_wpforms_entry_fields: Data: 0.05MB + Index: 0.05MB + Engine InnoDB kjs_wpforms_entry_meta: Data: 0.02MB + Index: 0.06MB + Engine InnoDB kjs_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_wpmailsmtp_debug_events: Data: 8.52MB + Index: 0.00MB + Engine InnoDB kjs_wpmailsmtp_emails_log: Data: 1.02MB + Index: 0.03MB + Engine InnoDB kjs_wpmailsmtp_email_tracking_events: Data: 6.52MB + Index: 6.03MB + Engine InnoDB kjs_wpmailsmtp_email_tracking_links: Data: 10.52MB + Index: 1.52MB + Engine InnoDB kjs_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_wpstg_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_wp_auth_session_tbl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_wp_eMember_membership_tbl: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_wp_eMember_members_tbl: Data: 0.05MB + Index: 0.00MB + Engine InnoDB kjs_wp_members_meta_tbl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB kjs_yoast_indexable: Data: 13.52MB + Index: 12.09MB + Engine InnoDB kjs_yoast_indexable_hierarchy: Data: 2.52MB + Index: 2.52MB + Engine InnoDB kjs_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB kjs_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB kjs_yoast_seo_links: Data: 0.09MB + Index: 0.06MB + Engine InnoDB ### Post Type Counts ### attachment: 532 cookielawinfo: 17 custom_css: 4 customize_changeset: 8 event_magic_tickets: 29695 feedzy_imports: 1 forum: 2 giftcard: 4 jp_img_sitemap: 1 jp_sitemap: 1 jp_sitemap_master: 1 mailpoet_page: 1 nav_menu_item: 25 page: 33 pms-discount-codes: 1 pms-subscription: 2 post: 2 product: 169 product_variation: 1554 reply: 4 revision: 1 shop_coupon: 26 shop_order: 18283 shop_order_refund: 110 shop_subscription: 8 topic: 2 wp_global_styles: 1 wpforms: 3 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (39) ### weLaunch Framework: by weLaunch.io – 1.0.12 CoCart - Headless ecommerce: by Sébastien Dumont – 3.7.6 Change wp-admin login: by Nuno Morais Sarmento – 1.1.0 CookieYes | GDPR Cookie Consent: by CookieYes – 3.0.3 Free Downloads WooCommerce: by Square One Media – 3.5.1 Facebook for WooCommerce: by Facebook – 2.6.27 Flying Scripts: by WP Speed Matters – 1.2.3 FooEvents for WooCommerce: by FooEvents – 1.16.2 FooEvents Custom Attendee Fields: by FooEvents – 1.6.23 FooEvents Multi-Day: by FooEvents – 1.6.3 FooEvents PDF Tickets: by FooEvents – 1.9.21 FooSales — Point of Sale (POS) for WooCommerce: by FooSales – 1.29.1 Site Kit by Google: by Google – 1.85.0 JWT Authentication for WP-API: by Enrique Chavez – 1.3.2 LiteSpeed Cache: by LiteSpeed Technologies – 5.2.1 MailPoet Premium: by MailPoet – 3.101.0 MailPoet: by MailPoet – 3.101.0 Mesmerize Companion: by Extend Themes – 1.6.132 My Custom Functions: by Space X-Chimp – 4.51 Performance Lab: by WordPress Performance Team – 1.6.0 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5 Restrict - membership, site, content and user access restrictions for WordPress (Premium): by Restrict – 2.2.1 Use Any Font: by Dnesscarkey – 6.2.96 User Role Editor: by Vladimir Garagulya – 4.63.1 WooCommerce Dynamic Pricing & Discounts: by RightPress – 2.4.5 Woocommerce Profile Photo: by Web For 99 – 1.1 WooCommerce Custom Add To Cart Button: by Barn2 Plugins – 1.1.3 WooCommerce Bulk Variations: by Barn2 Plugins – 2.1.5 Email Customizer for WooCommerce (Pro): by ThemeHigh – 3.6.0 WooCommerce Extra Product Options Pro: by ThemeHigh – 3.2.1 WooCommerce Fast Cart: by Barn2 Plugins – 1.1.6 WooCommerce Google Analytics Integration: by WooCommerce – 1.5.15 WooCommerce My Account: by WeLaunch – 1.1.0 WooCommerce Square: by WooCommerce – 3.2.0 WooCommerce: by Automattic – 7.0.0 Yoast SEO: by Team Yoast – 19.8 Super Page Cache for Cloudflare: by Optimole – 4.6.1 WP Mail SMTP Pro: by WPForms – 3.6.1 WPForms: by WPForms – 1.7.7.2 ### Inactive Plugins (1) ### WooCommerce Serial Numbers: by pluginever – 1.2.10 ### Dropin Plugins (1) ### object-cache.php: object-cache.php ### Settings ### API Enabled: ✔ Force SSL: ✔ Currency: GBP (£) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) pw gift card (pw-gift-card) simple (simple) subscription (subscription) variable (variable) variable subscription (variable-subscription) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: ✔ Enforce Approved Product Download Directories: ✔ ### WC Pages ### Shop base: #98 - /shop/ Basket: #99 - /cart/ Checkout: #100 - /checkout/ My account: #101 - /my-account/ Terms and conditions: #1088 - /terms-and-conditions/ ### Theme ### Name: Highlight PRO Version: 1.1.48 Author URL: https://extendthemes.com/ Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ ### Templates ### Archive Template: Your theme has a woocommerce.php file. You will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues. Overrides: highlight-pro/woocommerce/checkout/form-checkout.php highlight-pro/woocommerce/checkout/thankyou.php highlight-pro/woocommerce/loop/pagination.php highlight-pro/woocommerce/order/order-details.php ### Square ### Environment: Production Tokenization Enabled: Debug Mode: Off ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products experimental-product-tour shipping-smart-defaults shipping-setting-tour homescreen marketing multichannel-marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience settings Daily Cron: ✔ Next scheduled: 2022-10-19 14:10:58 +01:00 Options: ✔ Notes: 73 Onboarding: completed ### Action Scheduler ### Complete: 11,818 Oldest: 2022-09-17 19:36:55 +0100 Newest: 2022-10-18 19:32:30 +0100 Failed: 9 Oldest: 2021-09-16 15:30:03 +0100 Newest: 2022-06-07 20:29:06 +0100 Pending: 13 Oldest: 2022-10-18 20:32:30 +0100 Newest: 2022-10-25 12:16:04 +0100 ### CoCart ### Version: 3.7.6 Database Version: 3.7.6 Install Date: 22 December 2021 Carts in Session: 214 Carts Active: 150 out of 214 in session. Carts Expiring Soon: 17 out of 214 in session. Carts Expired: 64 out of 214 in session. Carts Source (by CoCart): 0 Carts Source (by Web): 160 Carts Source (by Other): 54 ### Status report information ### Generated at: 2022-10-18 19:36:24 +01:00 ``` * [Igor H](https://wordpress.org/support/users/ihereira/) * (@ihereira) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-deadlocks/#post-16111730) * Hi, * Thanks for sending the system report, can you provide us with a copy of any fatal error log found under **WooCommerce > System Status > Logs** (if any other error is available)? * Looking forward to hearing from you. * Thread Starter [sacfc](https://wordpress.org/support/users/sacfc/) * (@sacfc) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-deadlocks/#post-16111744) * Hi I’ve not seen anything in the WC logs – just in the standard WP error log file on the server: * `[15-Oct-2022 14:53:08 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM`kjs_options`WHERE` option_name` = ‘_transient_wc_facebook_aam_settings’ made by require(‘wp-blog- header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘ wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Facebookcommerce->get_integration, WC_Facebookcommerce_Integration->__construct, WC_Facebookcommerce_Integration->load_aam_settings_of_pixel, get_transient, wp_cache_get, WP_Object_Cache->get, WP_Object_Cache->_transient_get, delete_option [15-Oct- 2022 15:13:21 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM `kjs_options` WHERE `option_name` = ‘_transient_wc_facebook_aam_settings’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp- settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Facebookcommerce->get_integration, WC_Facebookcommerce_Integration->__construct, WC_Facebookcommerce_Integration->load_aam_settings_of_pixel, get_transient, wp_cache_get, WP_Object_Cache->get, WP_Object_Cache->_transient_get, delete_option` * [Chris Moreira – a11n](https://wordpress.org/support/users/chrism245/) * (@chrism245) * [3 years, 6 months ago](https://wordpress.org/support/topic/database-deadlocks/#post-16153967) * Hello! * I was checking more information about this, and you will need to find out which application (probably a plugin or theme) is locking the table. * I would start by checking the cache plugins on your site, which can be affecting this: * `LiteSpeed Cache` and `Super Page Cache for Cloudflare`. Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Database deadlocks’ is closed to new replies. * ![](https://ps.w.org/facebook-for-woocommerce/assets/icon.svg?rev=3469606) * [Meta for WooCommerce](https://wordpress.org/plugins/facebook-for-woocommerce/) * [Support Threads](https://wordpress.org/support/plugin/facebook-for-woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/facebook-for-woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/facebook-for-woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/facebook-for-woocommerce/reviews/) * 5 replies * 3 participants * Last reply from: [Chris Moreira – a11n](https://wordpress.org/support/users/chrism245/) * Last activity: [3 years, 6 months ago](https://wordpress.org/support/topic/database-deadlocks/#post-16153967) * Status: resolved