• Resolved dhathriitsupport

    (@dhathriitsupport)


    We are currently experiencing an issue related to scheduled actions in the database for the past 3 weeks; causing slow website performance (both front-end & back-end).
    For new customers, the site is generally slow after the issue occurred.
    Sometimes the website becomes unresponsive for 2-5 minutes due to delayed or pending actions.
    We are using the ‘Repair Action Scheduler by RankMath’ plugin as a quick-fix. But this is happening frequently, so we are looking for a permanent fix.

    We are using the site24x7 monitoring tool, which shows response timeouts from the in different parts of the country(India). Please find attached the system status report for your reference

    `
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.dhathriayurveda.in
    Site address (URL): https://www.dhathriayurveda.in
    WC Version: 7.5.1
    REST API Version: ? 7.5.1
    WC Blocks Version: ? 9.6.6
    Action Scheduler Version: ? 3.5.4
    Log Directory Writable: ?
    WP Version: ? 6.1.1 - There is a newer version of WordPress available (6.2)
    WP Multisite: –
    WP Memory Limit: 12 GB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 8.0.28
    PHP Post Max Size: 12 GB
    PHP Time Limit: 180
    PHP Max Input Vars: 5000
    cURL Version: 7.84.0
    OpenSSL/1.1.1p
    
    SUHOSIN Installed: –
    MySQL Version: 10.6.11-MariaDB-cll-lve
    Max Upload Size: 12 GB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 7.5.1
    WC Database Prefix: wp_
    Total Database Size: 861.31MB
    Database Data Size: 533.61MB
    Database Index Size: 327.70MB
    wp_woocommerce_sessions: Data: 8.52MB + Index: 0.22MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 10.52MB + Index: 3.52MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 84.63MB + Index: 52.14MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + 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_acfw_store_credits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 9.52MB + Index: 11.03MB + 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: 8.52MB + Index: 5.03MB + Engine InnoDB
    wp_bv_activities_store: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 4.52MB + Index: 4.03MB + Engine InnoDB
    wp_commentmeta_backup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 38.58MB + Index: 30.09MB + Engine InnoDB
    wp_dgwt_wcas_stats: Data: 0.41MB + Index: 0.00MB + Engine InnoDB
    wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_fm_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_imagify_files: Data: 0.05MB + Index: 0.08MB + Engine InnoDB
    wp_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_litespeed_img_optm: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
    wp_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mclean_refs: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
    wp_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mo_openid_linked_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nextend2_smartslider3_sliders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
    wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_field_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_upgrades: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 58.28MB + Index: 2.72MB + Engine InnoDB
    wp_orders_manifests: Data: 0.48MB + Index: 0.00MB + Engine InnoDB
    wp_postmeta: Data: 184.72MB + Index: 151.38MB + Engine InnoDB
    wp_posts: Data: 23.52MB + Index: 8.66MB + Engine InnoDB
    wp_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_slides: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_snippets: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
    wp_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_sync_track_order: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.33MB + Index: 0.22MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.22MB + Index: 0.03MB + Engine InnoDB
    wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_usermeta: Data: 37.56MB + Index: 31.09MB + Engine InnoDB
    wp_users: Data: 4.52MB + Index: 4.55MB + Engine InnoDB
    wp_wati_abandonment: Data: 5.52MB + Index: 0.14MB + Engine InnoDB
    wp_wati_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcpdf_invoice_number: Data: 0.28MB + Index: 0.00MB + Engine InnoDB
    wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.05MB + 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: 2.52MB + Index: 1.89MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.19MB + Index: 0.23MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 8.52MB + Index: 6.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 4.52MB + Index: 3.55MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + 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_wdr_order_discounts: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wp_wdr_order_item_discounts: Data: 1.52MB + Index: 0.31MB + Engine InnoDB
    wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfblockediplog: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
    wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfconfig: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilemods: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wfhits: Data: 1.52MB + Index: 0.17MB + Engine InnoDB
    wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfknownfilelist: Data: 8.52MB + Index: 0.00MB + Engine InnoDB
    wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wflogins: Data: 0.50MB + Index: 0.16MB + Engine InnoDB
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfstatus: Data: 6.52MB + Index: 3.03MB + Engine InnoDB
    wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woof_query_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpf_meta_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpmailsmtp_debug_events: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpr_rocket_cache: Data: 0.14MB + Index: 0.17MB + Engine InnoDB
    wp_wpr_rucss_used_css: Data: 0.31MB + Index: 0.55MB + Engine InnoDB
    wp_wpstg_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wsal_metadata: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wsal_occurrences: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wt_iew_action_history: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
    wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wt_sc_coupon_lookup: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcwl: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    wp_yith_wcwl_lists: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_indexable: Data: 0.28MB + Index: 0.09MB + 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.09MB + Index: 0.03MB + Engine InnoDB
    wp_zbscrm_api_keys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_admlog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_aka: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_zbs_companies: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_zbs_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_zbs_customfields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_zbs_dbmigration_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_zbs_dbmigration_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_zbs_events: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_zbs_event_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_externalsources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_zbs_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_zbs_invoices: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_zbs_lineitems: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_zbs_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_zbs_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_object_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_zbs_quotes: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_zbs_quotes_templates: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_zbs_security_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_segments_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_settings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_zbs_sys_cronmanagerlogs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_sys_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_sys_email_hist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_zbs_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_tags_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_zbs_tax_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_temphash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_zbs_transactions: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    acf-field: 156
    acf-field-group: 8
    acfe-dop: 2
    attachment: 874
    cookielawinfo: 6
    custom_css: 3
    elementor_library: 29
    elementor-hf: 3
    job: 3
    mc4wp-form: 1
    nav_menu_item: 41
    nf_sub: 7263
    page: 13
    post: 50
    product: 137
    product_variation: 53
    shop_coupon: 36
    shop_order: 27320
    shop_order_refund: 25
    wp_global_styles: 1
    yith-wcbm-badge: 9
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (42) ###
    
    Hostinger: by Hostinger – 1.1.0
    Action Scheduler: by Automattic – 3.5.4
    Advanced Custom Fields: by WP Engine – 6.0.7
    Advanced Database Cleaner: by Younes JFR. – 3.1.2
    FiboSearch - AJAX Search for WooCommerce: by FiboSearch Team – 1.22.3
    All-in-One WP Migration: by ServMask – 7.73
    Change Quantity on Checkout for WooCommerce: by Bhavik Kiri – 2.1
    Classic Editor: by WordPress Contributors – 1.6.3
    Code Snippets: by Code Snippets Pro – 3.3.0
    Elementor: by Elementor.com – 3.12.0
    Elementor Header & Footer Builder: by Brainstorm Force
    Nikhil Chavan – 1.6.13
    
    Health Check & Troubleshooting: by The www.remarpro.com community – 1.6.0
    Heartbeat Control by WP Rocket: by WP Rocket – 2.0
    Imagify: by Imagify – Optimize Images & Convert WebP – 2.1.1
    Ninja Forms: by Saturday Drive – 3.6.20
    OoohBoi Steroids for Elementor: by OoohBoi – 2.1.5
    Order Export & Order Import for WooCommerce: by WebToffee – 2.3.2
    Redirection: by John Godley – 5.3.9
    Remove Dashboard Access: by TrustedLogin – 1.1.5
    Retainful - Abandoned Cart Recovery Emails and Next Order Coupons: by Retainful – 2.6.19
    Shiprocket: by Shiprocket – 2.0.1
    States, Cities, and Places for WooCommerce: by Kingsley Ochu – 1.3.2
    Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.37
    Super Socializer: by Team Heateor – 7.13.47
    SVG Support: by Benbodhi – 2.5.5
    Import Export WordPress Users and WooCommerce Customers: by WebToffee – 2.3.8
    WATI Chat and Notification: by WATI.IO – 1.1.2
    Woo Discount Rules: by Flycart – 2.5.4
    Advanced Order Export For WooCommerce: by AlgolPlus – 3.4.0
    Razorpay for WooCommerce: by Team Razorpay – 4.4.3
    Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.19
    WooCommerce Extended Coupon Features FREE: by Soft79 – 3.3.3
    Pixel Manager for WooCommerce: by SweetCode – 1.30.3
    PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.4.0
    WooCommerce: by Automattic – 7.5.1
    Yoast SEO: by Team Yoast – 20.4
    WP Crontrol: by John Blackbourn & crontributors – 1.15.2
    WP Mail SMTP: by WPForms – 3.7.0
    WP Rocket: by WP Media – 3.12.6.1
    Custom Product Tabs for WooCommerce: by YIKES
    Inc. – 1.8.2
    
    YITH WooCommerce Badge Management: by YITH – 2.15.0
    Yoast Test Helper: by Team Yoast – 1.17
    
    ### Inactive Plugins (3) ###
    
    J Cart Upsell and Cross-sell for WooCommerce: by Giacomo Zoffoli – 3.3.7
    Repair Action Scheduler: by Rank Math – 1.1
    WP Modal Popup with Cookie Integration: by Astoundify – 2.4
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (1) ###
    
    Health Check Troubleshooting Mode: by  – 1.8.1
    
    ### Settings ###
    
    API Enabled: ?
    Force SSL: –
    Currency: INR (?)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 0
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    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: –
    Order datastore: WC_Order_Data_Store_CPT
    
    ### WC Pages ###
    
    Shop base: #6 - /shop/
    Cart: #7 - /cart/
    Checkout: #8 - /checkout/
    My account: #9 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Shopic Child
    Version: 2.2.2
    Author URL: 
    Child Theme: ?
    Parent Theme Name: Shopic
    Parent Theme Version: 2.2.2
    Parent Theme Author URL: https://pavothemes.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: shopic/woocommerce/cart/mini-cart.php
    shopic/woocommerce/checkout/form-checkout.php
    shopic/woocommerce/content-single-product.php
    shopic/woocommerce/content-widget-product.php
    shopic/woocommerce/content-widget-reviews.php
    shopic/woocommerce/loop/loop-start.php
    shopic/woocommerce/myaccount/form-login.php
    shopic/woocommerce/order/form-tracking.php
    shopic/woocommerce/product-searchform.php
    shopic/woocommerce/single-product/product-image.php
    shopic/woocommerce/single-product/tabs/tabs.php
    
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    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
    product-variation-management
    settings
    
    Daily Cron: ? Next scheduled: 2023-04-04 08:35:38 +05:30
    Options: ?
    Notes: 47
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Complete: 26,079
    Oldest: 2023-03-04 04:22:01 +0000
    Newest: 2023-04-04 04:13:05 +0000
    
    Failed: 25
    Oldest: 2023-03-16 09:56:15 +0000
    Newest: 2023-04-03 08:54:29 +0000
    
    Pending: 7
    Oldest: 2023-04-04 04:14:05 +0000
    Newest: 2023-04-06 13:48:52 +0000
    
    
    ### Status report information ###
    
    Generated at: 2023-04-04 09:43:59 +05:30
    `
Viewing 7 replies - 1 through 7 (of 7 total)
  • Saif

    (@babylon1999)

    Hello @dhathriitsupport,

    We are currently experiencing an issue related to scheduled actions in the database for the past 3 weeks; causing slow website performance (both front-end & back-end).

    Could you please provide a screenshot of the scheduled tasks that seem to be slowing down your site?

    This will help us pinpoint the exact cause of the slowdown. You can use Snipboard to share screenshots.

    In the meantime, I suggest cloning your site to another hosting provider or local host, disabling all plugins except WooCommerce, and switching to the Storefront theme to make sure the poor performance is not due to a third-party plugin or theme.

    Let us know how it goes!

    Thread Starter dhathriitsupport

    (@dhathriitsupport)

    Hi,

    Thanks for your reply. As you mentioned, please see the below link for your reference.

    We are using a replica of the live site for testing purposes and we haven’t found any issues with it. However, we have noticed that when we make major updates to the live site, it can cause the website to become unresponsive.

    Screenshot – https://ibb.co/hc3Q9c8

    Hi,

    Thanks for your response, and for sending the screenshot.

    May I ask, can you please share a copy of any fatal error log found under WooCommerce > System Status > Logs? (if any). That will help to investigate, thanks.

    Thread Starter dhathriitsupport

    (@dhathriitsupport)

    Hi,

    Thank you for your reply. As you mentioned, please find the logs below

    Sometimes, we encounter this error, and due to the issue with the action scheduler, we are also experiencing errors from most of the plugins.

    2023-03-17T07:33:39+00:00 CRITICAL Uncaught TypeError: trim(): Argument #1 ($string) must be of type string, array given in /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/class-wc-countries.php:576
    Stack trace: 0 [internal function]: trim() 1 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/class-wc-countries.php(576): array_map() 2 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/class-wc-order.php(967): WC_Countries->get_formatted_address() 3 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/src/Internal/Admin/Orders/ListTable.php(962): WC_Order->get_formatted_shipping_address() 4 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-orders.php(218): Automattic\WooCommerce\Internal\Admin\Orders\ListTable->render_shipping_address_column() 5 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/admin/list-tables/abstract-class-wc-admin-list-table.php(261): WC_Admin_List_Table_Orders->render_shipping_address_column() 6 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-includes/class-wp-hook.php(308): WC_Admin_List_Table->render_columns() 7 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters() 8 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-includes/plugin.php(517): WP_Hook->do_action() 9 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-posts-list-table.php(1363): do_action() 10 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-list-table.php(1532): WP_Posts_List_Table->column_default() 11 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-posts-list-table.php(1397): WP_List_Table->single_row_columns() 12 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-posts-list-table.php(807): WP_Posts_List_Table->single_row() 13 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-posts-list-table.php(783): WP_Posts_List_Table->_display_rows() 14 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-list-table.php(1444): WP_Posts_List_Table->display_rows() 15 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-list-table.php(1371): WP_List_Table->display_rows_or_placeholder() 16 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/edit.php(487): WP_List_Table->display() 17 {main} thrown in /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/class-wc-countries.php on line 576 2023-03-17T11:48:03+00:00 CRITICAL Uncaught TypeError: trim(): Argument #1 ($string) must be of type string, array given in /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/class-wc-countries.php:576
    Stack trace: 0 [internal function]: trim() 1 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/class-wc-countries.php(576): array_map() 2 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/class-wc-order.php(967): WC_Countries->get_formatted_address() 3 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/src/Internal/Admin/Orders/ListTable.php(962): WC_Order->get_formatted_shipping_address() 4 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-orders.php(218): Automattic\WooCommerce\Internal\Admin\Orders\ListTable->render_shipping_address_column() 5 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/admin/list-tables/abstract-class-wc-admin-list-table.php(261): WC_Admin_List_Table_Orders->render_shipping_address_column() 6 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-includes/class-wp-hook.php(308): WC_Admin_List_Table->render_columns() 7 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters() 8 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-includes/plugin.php(517): WP_Hook->do_action() 9 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-posts-list-table.php(1363): do_action() 10 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-list-table.php(1532): WP_Posts_List_Table->column_default() 11 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-posts-list-table.php(1397): WP_List_Table->single_row_columns() 12 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-posts-list-table.php(807): WP_Posts_List_Table->single_row() 13 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-posts-list-table.php(783): WP_Posts_List_Table->_display_rows() 14 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-list-table.php(1444): WP_Posts_List_Table->display_rows() 15 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/includes/class-wp-list-table.php(1371): WP_List_Table->display_rows_or_placeholder() 16 /home/u903913197/domains/dhathriayurveda.in/public_html/wp-admin/edit.php(487): WP_List_Table->display() 17 {main} thrown in /home/u903913197/domains/dhathriayurveda.in/public_html/wp-content/plugins/woocommerce/includes/class-wc-countries.php on line 576

    Hi,

    Thanks for sending the error log.

    Can you please update the version of WordPress on your site to see if that makes a difference? You can try that first on staging environment.

    Make sure to create a backup before making any change.

    If that does not help, I’d suggest installing the WP Crontrol plugin, it can help you to get more information about the issue.

    Let us know how that goes.

    Thread Starter dhathriitsupport

    (@dhathriitsupport)

    Hi,

    As you suggested we have updated WordPress to 6.2 and updated all the plugins.

    We have also installed wp crontrol and found 23 events with no action, some of the actions are from removed plugins. Will share the list of all events, period.

    https://drive.google.com/file/d/1KeqqEvMIKyjrQH4liUHhfgarIgONImMj/view?usp=sharing

    Saif

    (@babylon1999)

    Hello @dhathriitsupport,

    Please refer to this guide on how to remove cron jobs leftover from deleted plugins: https://w3guy.com/remove-wordpress-plugin-cron-job/.

    Make sure to create a backup before making any changes.

    Cheers!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘We are experiencing an issue related to scheduled actions in the database’ is closed to new replies.