phpError Log Deadlock

We are getting numerous of the following errors:

WordPress database error Deadlock found when trying to get lock; try restarting transaction for query ALTER TABLE wp_wc_order_product_lookup CHANGE COLUMN customer_id customer_id BIGINT UNSIGNED NULL 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, Automattic\WooCommerce\Admin\Install::check_version, Automattic\WooCommerce\Admin\Install::install, Automattic\WooCommerce\Admin\Install::create_tables, dbDelta

Please advise.

Our system Report:

`
### WordPress Environment ###

WordPress address (URL): https://littlebranchfarm.com
Site address (URL): https://littlebranchfarm.com
WC Version: 4.3.0
REST API Version: ✔ 1.0.10
WC Blocks Version: ✔ 2.9.0
Action Scheduler Version: ✔ 3.1.6
WC Admin Version: ✔ 1.3.0
Log Directory Writable: ✔
WP Version: 5.4.2
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: ✔

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.18
PHP Post Max Size: 128 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.66.0
OpenSSL/1.1.1g-fips

SUHOSIN Installed: –
MySQL Version: 5.7.25-28-log
Max Upload Size: 128 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 4.3.0
WC Database Prefix: wp_
Total Database Size: 157.48MB
Database Data Size: 133.70MB
Database Index Size: 23.78MB
wp_woocommerce_sessions: Data: 22.55MB + Index: 0.38MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 0.10MB + Index: 0.08MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 2.52MB + Index: 0.83MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 1.52MB + Index: 0.55MB + Engine InnoDB
wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_calendar: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_calendar_categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_calendar_config: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commentmeta: Data: 0.04MB + Index: 0.02MB + Engine MyISAM
wp_comments: Data: 0.13MB + Index: 0.06MB + Engine MyISAM
wp_eventscalendar_main: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_ewwwio_images: Data: 2.31MB + Index: 1.09MB + Engine MyISAM
wp_fsevents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_entry: Data: 1.52MB + Index: 0.14MB + Engine InnoDB
wp_gf_entry_meta: Data: 4.52MB + Index: 4.55MB + Engine InnoDB
wp_gf_entry_notes: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form_view: Data: 5.52MB + Index: 4.03MB + Engine InnoDB
wp_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 11.05MB + Index: 0.35MB + Engine MyISAM
wp_postmeta: Data: 27.76MB + Index: 3.83MB + Engine MyISAM
wp_posts: Data: 37.83MB + Index: 0.62MB + Engine MyISAM
wp_rg_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_form_meta: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
wp_rg_form_view: Data: 4.58MB + Index: 2.47MB + Engine MyISAM
wp_rg_incomplete_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_lead: Data: 0.48MB + Index: 0.05MB + Engine MyISAM
wp_rg_lead_detail: Data: 1.24MB + Index: 1.49MB + Engine MyISAM
wp_rg_lead_detail_long: Data: 0.26MB + Index: 0.01MB + Engine MyISAM
wp_rg_lead_meta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_rg_lead_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
wp_terms: Data: 0.26MB + Index: 0.37MB + Engine MyISAM
wp_term_relationships: Data: 0.22MB + Index: 0.39MB + Engine MyISAM
wp_term_taxonomy: Data: 0.28MB + Index: 0.25MB + Engine MyISAM
wp_usermeta: Data: 0.49MB + Index: 0.08MB + Engine MyISAM
wp_users: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_gpf_render_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.22MB + Index: 0.34MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wec_calendar: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wec_event: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wec_eventCalendarMeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wec_event_category_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wec_event_tag_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wec_feed: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wec_recurrence: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_gpf_google_taxonomy: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_pinterest: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_pinterest_boards_mapping: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_pinterest_google_categories_mapping: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_pinterest_google_product_categories: Data: 0.28MB + Index: 0.00MB + Engine InnoDB
wp_wordbooker_errorlogs: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wp_wordbooker_fb_friends: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wordbooker_fb_friend_lists: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wordbooker_postcomments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wordbooker_postlogs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wordbooker_process_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wordbooker_userdata: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wordbooker_userstatus: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wordbook_errorlogs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wordbook_postcomments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wordbook_postlogs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wordbook_userdata: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpsc_also_bought: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpsc_cart_contents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpsc_checkout_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpsc_claimed_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpsc_coupon_codes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpsc_currency_list: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_wpsc_download_status: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpsc_meta: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_wpsc_product_rating: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpsc_purchase_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wpsc_region_tax: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpsc_submited_form_data: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_yoast_indexable: Data: 4.52MB + Index: 0.59MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.47MB + Index: 0.14MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.38MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 3231
customize_changeset: 3
nav_menu_item: 131
oembed_cache: 1
page: 47
post: 46
product: 355
product_variation: 1330
revision: 2584
shop_coupon: 3
shop_order: 177
shop_order_refund: 2
tribe_events: 3
tribe_organizer: 3
tribe_venue: 3
wpsc-product-file: 1

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

### Active Plugins (18) ###

Gravity Forms: by Gravity Forms – 2.4.18
Akismet Anti-Spam: by Automattic – 4.1.6
Genesis Connect for WooCommerce: by StudioPress – 1.1.0 – Installed version not tested with active version of WooCommerce 4.3.0
Genesis Simple Sidebars: by StudioPress – 2.2.2
Imagify: by WP Media – 1.9.10
Jetpack by WordPress.com: by Automattic – 8.7
SG Optimizer: by SiteGround – 5.5.8
Temporary Login Without Password: by StoreApps – 1.6.3
User Role Editor: by Vladimir Garagulya – 4.55.1
WooCommerce Blocks: by Automattic – 2.9.0 – Installed version not tested with active version of WooCommerce 4.3.0
Product Feed ELITE for WooCommerce: by AdTribes.io – 1.0.7 – Installed version not tested with active version of WooCommerce 4.3.0
WooCommerce Google Analytics Integration: by WooCommerce – 1.4.22 – Installed version not tested with active version of WooCommerce 4.3.0
Pinterest for WooCommerce: by premmerce – 2.1.4 – Installed version not tested with active version of WooCommerce 4.3.0
WooCommerce Services: by Automattic – 1.23.2 – Installed version not tested with active version of WooCommerce 4.3.0
WooCommerce: by Automattic – 4.3.0
Yoast SEO Premium: by Team Yoast – 14.5
Yoast SEO: Local: by Team Yoast and Arjan Snaterse – 13.3 – Installed version not tested with active version of WooCommerce 4.3.0
Yoast SEO: WooCommerce: by Team Yoast – 13.3 – Installed version not tested with active version of WooCommerce 4.3.0

### Inactive Plugins (3) ###

Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.3
Yoast SEO: News: by Team Yoast – 11.0
Yoast SEO: Video: by Team Yoast – 13.1

### Dropin Plugins (1) ###

object-cache.php: Memcached

### Settings ###

API Enabled: ✔
Force SSL: ✔
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-catalog (exclude-from-catalog-2)
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: –

### WC Pages ###

Shop base: #7752 – /the-store/
Cart: #3538 – /cart/
Checkout: #1437 – /products-page/checkout/
My account: #3540 – /my-account/
Terms and conditions: #1242 – /policies/

### Theme ###

Name: Burl
Version: 1.0.0
Author URL: http://media317.net
Child Theme: ✔
Parent Theme Name: Genesis
Parent Theme Version: 3.3.2
Parent Theme Author URL: https://www.studiopress.com/
WooCommerce Support: ✔

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 4,361
Oldest: 2020-05-23 02:58:01 -0400
Newest: 2020-06-23 02:39:36 -0400

Pending: 12
Oldest: 2020-06-23 03:39:36 -0400
Newest: 2020-07-08 16:22:07 -0400

In-progress: 1
Oldest: –
Newest: –