Database deadlocks

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.

### 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

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.

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 FROMkjs_optionsWHEREoption_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`

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.