Action scheduler – adjust download permissions bug
-
Hello.
I’m having issues with the action scheduler – it’s stuck in an infinite loop, repeating one action indefinitely.
Hook: adjust_download_permissionsThe actioscheduler tables are getting huge (30MB in less than a day) and the server load is insane – 13TiB of queries in 5 days with an average of 17M select statements per hour. I have tried selectively disabling plugins one by one until there was only WooCommerce left, but no luck. I have truncated actionscheduler_logs and actionscheduler_actions yesterday.
I’ve noticed other people have the same issue, but I have not found a solution.
Observation:
1. There’s no such problem on a local staging site copy. The action scheduler is acting like it should. The local machine is Apache server with PHP8.1 and also Litespeed server with PHP8.1. I made sure it’s not Litespeed server’s fault.
2. Plenty of transients: 2600, no expired transients.
3. There’s no recent fatal errors log.Status:
### WordPress Environment ### WordPress address (URL): https://sporteverest.si Site address (URL): https://sporteverest.si WC Version: 6.2.1 REST API Version: ? 6.2.1 WC Blocks Version: ? 6.7.3 Action Scheduler Version: ? 3.4.0 WC Admin Version: ? 3.1.0 Log Directory Writable: ? WP Version: 5.9.1 WP Multisite: – WP Memory Limit: 4 GB WP Debug Mode: – WP Cron: ? Language: sl_SI External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 8.1.3 PHP Post Max Size: 512 MB PHP Time Limit: 300 PHP Max Input Vars: 50000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 10.5.15-MariaDB-log Max Upload Size: 512 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 6.2.1 WC Database Prefix: wp_ Skupna velikost podatkovne zbirke: 157.59MB Velikost podatkov podatkovne zbirke: 108.19MB Velikost kazala podatkovne zbirke: 49.40MB wp_woocommerce_sessions: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_woocommerce_api_keys: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_woocommerce_attribute_taxonomies: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_woocommerce_downloadable_product_permissions: Podatki: 0.02 MB + Kazalo: 0.06 MB + Pogon InnoDB wp_woocommerce_order_items: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_woocommerce_order_itemmeta: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_woocommerce_tax_rates: Podatki: 0.02 MB + Kazalo: 0.06 MB + Pogon InnoDB wp_woocommerce_tax_rate_locations: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_woocommerce_shipping_zones: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_woocommerce_shipping_zone_locations: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_woocommerce_shipping_zone_methods: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_woocommerce_payment_tokens: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_woocommerce_payment_tokenmeta: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_woocommerce_log: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB cerber_acl: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB cerber_blocks: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB cerber_countries: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB cerber_lab: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB cerber_lab_ip: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB cerber_lab_net: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB cerber_log: Podatki: 0.17 MB + Kazalo: 0.13 MB + Pogon InnoDB cerber_qmem: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB cerber_traffic: Podatki: 0.23 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_actionscheduler_actions: Podatki: 12.02 MB + Kazalo: 13.34 MB + Pogon InnoDB wp_actionscheduler_claims: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_actionscheduler_groups: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_actionscheduler_logs: Podatki: 7.02 MB + Kazalo: 5.03 MB + Pogon InnoDB wp_aioseo_cache: Podatki: 0.34 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_aioseo_notifications: Podatki: 0.03 MB + Kazalo: 0.06 MB + Pogon InnoDB wp_aioseo_posts: Podatki: 2.52 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_aioseo_terms: Podatki: 0.05 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_cartflows_ca_cart_abandonment: Podatki: 0.05 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_cartflows_ca_email_history: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_cartflows_ca_email_templates: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_cartflows_ca_email_templates_meta: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_cerber_files: Podatki: 34.63 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_cerber_sets: Podatki: 2.52 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_cerber_uss: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_cmplz_cookiebanners: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_cmplz_cookies: Podatki: 0.06 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_cmplz_services: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_commentmeta: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_comments: Podatki: 0.02 MB + Kazalo: 0.09 MB + Pogon InnoDB wp_duplicator_pro_entities: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_duplicator_pro_packages: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_e_submissions: Podatki: 0.02 MB + Kazalo: 0.27 MB + Pogon InnoDB wp_e_submissions_actions_log: Podatki: 0.02 MB + Kazalo: 0.11 MB + Pogon InnoDB wp_e_submissions_values: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_fbv: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_fbv_attachment_folder: Podatki: 0.08 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_followup_coupons: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_followup_coupon_logs: Podatki: 0.02 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_followup_customers: Podatki: 0.02 MB + Kazalo: 0.06 MB + Pogon InnoDB wp_followup_customer_carts: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_followup_customer_notes: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_followup_customer_orders: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_followup_email_excludes: Podatki: 0.02 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_followup_email_logs: Podatki: 0.02 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_followup_email_orders: Podatki: 0.05 MB + Kazalo: 0.09 MB + Pogon InnoDB wp_followup_email_tracking: Podatki: 0.02 MB + Kazalo: 0.08 MB + Pogon InnoDB wp_followup_followup_history: Podatki: 0.02 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_followup_order_categories: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_followup_order_items: Podatki: 0.02 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_followup_subscribers: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_followup_subscribers_to_lists: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_followup_subscriber_lists: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_groups_capability: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_groups_group: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_groups_group_capability: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_groups_user_capability: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_groups_user_group: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_links: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_litespeed_avatar: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_litespeed_crawler: Podatki: 0.33 MB + Kazalo: 0.34 MB + Pogon InnoDB wp_litespeed_crawler_blacklist: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_litespeed_img_optm: Podatki: 1.52 MB + Kazalo: 0.61 MB + Pogon InnoDB wp_litespeed_img_optming: Podatki: 0.05 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_litespeed_url: Podatki: 0.20 MB + Kazalo: 0.30 MB + Pogon InnoDB wp_litespeed_url_file: Podatki: 0.31 MB + Kazalo: 0.92 MB + Pogon InnoDB wp_ms_snippets: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_options: Podatki: 11.47 MB + Kazalo: 1.61 MB + Pogon InnoDB wp_postmeta: Podatki: 21.55 MB + Kazalo: 16.06 MB + Pogon InnoDB wp_posts: Podatki: 3.52 MB + Kazalo: 1.05 MB + Pogon InnoDB wp_rank_math_404_logs: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_rank_math_analytics_keyword_manager: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_rank_math_analytics_objects: Podatki: 0.09 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_rank_math_internal_links: Podatki: 0.06 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_rank_math_internal_meta: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_redirection_404: Podatki: 0.02 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_redirection_groups: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_redirection_items: Podatki: 0.02 MB + Kazalo: 0.09 MB + Pogon InnoDB wp_redirection_logs: Podatki: 0.02 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_reviewx_criterias: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_reviewx_import_history: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_reviewx_process_jobs: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_reviewx_reminder_email: Podatki: 0.05 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_snippets: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_termmeta: Podatki: 0.08 MB + Kazalo: 0.09 MB + Pogon InnoDB wp_terms: Podatki: 0.05 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_term_relationships: Podatki: 0.48 MB + Kazalo: 0.36 MB + Pogon InnoDB wp_term_taxonomy: Podatki: 0.06 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_tm_taskmeta: Podatki: 0.17 MB + Kazalo: 0.06 MB + Pogon InnoDB wp_tm_tasks: Podatki: 0.14 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_usermeta: Podatki: 0.08 MB + Kazalo: 0.06 MB + Pogon InnoDB wp_users: Podatki: 0.02 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_wc_admin_notes: Podatki: 0.05 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_wc_admin_note_actions: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_wc_category_lookup: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_wc_customer_lookup: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_wc_download_log: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_wc_order_coupon_lookup: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_wc_order_product_lookup: Podatki: 0.02 MB + Kazalo: 0.06 MB + Pogon InnoDB wp_wc_order_stats: Podatki: 0.02 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_wc_order_tax_lookup: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_wc_product_meta_lookup: Podatki: 0.36 MB + Kazalo: 0.63 MB + Pogon InnoDB wp_wc_rate_limits: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_wc_reserved_stock: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_wc_tax_rate_classes: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_wc_webhooks: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_woocommerce_bundled_itemmeta: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_woocommerce_bundled_items: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_woof_query_cache: Podatki: 5.52 MB + Kazalo: 5.55 MB + Pogon InnoDB wp_woof_stat_buffer: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_woof_stat_tmp: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_wpforms_entries: Podatki: 0.06 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_wpforms_entry_fields: Podatki: 0.05 MB + Kazalo: 0.05 MB + Pogon InnoDB wp_wpforms_entry_meta: Podatki: 0.02 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_wpforms_tasks_meta: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_wpmailsmtp_debug_events: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_wpmailsmtp_emails_log: Podatki: 0.16 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_wpmailsmtp_email_tracking_events: Podatki: 0.02 MB + Kazalo: 0.03 MB + Pogon InnoDB wp_wpmailsmtp_email_tracking_links: Podatki: 0.11 MB + Kazalo: 0.02 MB + Pogon InnoDB wp_wpmailsmtp_tasks_meta: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB wp_yith_wccl_meta: Podatki: 0.02 MB + Kazalo: 0.00 MB + Pogon InnoDB ### Post Type Counts ### astra-advanced-hook: 2 attachment: 2004 cartflows_flow: 1 cartflows_step: 2 custom_css: 2 elementor_library: 18 elementor_snippet: 1 jp_img_sitemap: 1 jp_sitemap: 1 jp_sitemap_master: 1 nav_menu_item: 95 oembed_cache: 3 page: 42 post: 1 product: 715 product_variation: 2021 shop_order: 9 unique: 1 wc_product_tab: 1 wcs_ruleset: 2 wp_global_styles: 1 wpforms: 4 yith-wcbm-badge: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (45) ### All in One SEO: od All in One SEO Team – 4.1.8 AnyWhere Elementor Pro (Premium): od WP Vibes – 2.21.3 Astra Pro: od Brainstorm Force – 3.6.5 Code Snippets: od Code Snippets Pro – 2.14.3 Complianz | GDPR/CCPA Cookie Consent: od Really Simple Plugins – 6.1.0.1 Conditional Shipping for WooCommerce: od Lauri Karisola / WooElements.com – 2.2.3 Custom Post Type UI: od WebDevStudios – 1.10.2 Disable Sporteverest Bloat: od ospiotr – 2.6.4 Yoast Duplicate Post: od Enrico Battocchi & Team Yoast – 4.4 Duplicator Pro: od Snap Creek – 4.5.0 Duplicator Pro: od Snap Creek – 4.5.0 Elementor Pro: od Elementor.com – 3.6.3 Elementor: od Elementor.com – 3.5.6 Essential Addons for Elementor - Pro: od WPDeveloper – 5.0.7 Essential Addons for Elementor: od WPDeveloper – 5.0.9 FileBird: od Ninja Team – 4.9.9 Groups: od itthinx – 2.16.1 Improved Badges for WooCommerce: od 7VX LLC USA CA – 4.0.4 Kadence Sporteverest Email Designer: od Kadence WP – 1.4.10 LiteSpeed Cache: od LiteSpeed Technologies – 4.5.0.1 Loco Translate: od Tim Whitlock – 2.5.8 Redirection: od John Godley – 5.2.3 ReviewX Pro: od WPDeveloper – 1.3.0 ReviewX: od WPDeveloper – 1.4.3 ShiftNav Pro - Responsive Mobile Menu: od Chris Mavricos SevenSpark – 1.6.2 UberMenu 3 - The Ultimate WordPress Mega Menu: od Chris Mavricos SevenSpark – 3.7.5 Payment Plugins Braintree For WooCommerce: od Payment Plugins [email protected] – 3.2.32 UPN Nalog - Woocommerce: od WooNinja – 1.3.3 Sporteverest Branding: od Sporteverest – 1.0.30 WooCommerce Brands: od WooCommerce – 1.6.24 Sporteverest Checkout Field Editor: od Sporteverest – 1.6.0 Sporteverest Extra Product Sorting Options: od SkyVerge – 2.9.0 Sporteverest Group Coupons: od itthinx – 1.19.0 WOOF - Sporteverest Products Filter: od realmag777 – 2.2.6.4 WooCommerce Sale Flash Pro: od WooCommerce – 1.2.20 Sporteverest Sequential Order Numbers Pro: od SkyVerge – 1.17.0 Sporteverest: od Automattic – 6.2.1 Asset CleanUp Pro: Page Speed Booster: od Gabe Livan – 1.2.0.3 Asset CleanUp: Page Speed Booster: od Gabe Livan – 1.3.8.5 WP Cerber Security, Anti-spam & Malware Scan: od Cerber Tech Inc. – 8.9.6 WP Mail SMTP Pro: od WPForms – 3.3.0 WPS Hide Login: od WPServeur NicolasKulka wpformation – 1.9.3 Custom Product Tabs for Sporteverest: od YIKES Inc. – 1.7.7 YITH Sporteverest Customize My Account Page: od YITH – 3.1.0 YITH Sporteverest Recently Viewed Products Premium: od YITH – 2.0.2 ### Inactive Plugins (4) ### Anywhere Elementor: od WPVibes – 1.2.5 Query Monitor: od John Blackbourn – 3.8.2 ShiftNav - Responsive Mobile Menu: od Chris Mavricos SevenSpark – 1.7.1 WooCommerce Email Customizer: od WooCommerce – 1.1.19 ### Must Use Plugins (2) ### aaa-wp-cerber.php: od Cerber Tech Inc. – 1.0 Asset CleanUp Pro: Plugin Filtering: od Gabriel Livan – 1.0 ### Settings ### API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: bundle (bundle) 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: – ### WC Pages ### Osnova trgovine: #38 - /trgovina/ Ko?arica: ? Stran ne vsebuje kratke kode [woocommerce_cart] ali bloka woocommerce/cart. Zaklju?ek nakupa: ? Stran ne vsebuje kratke kode [woocommerce_checkout] ali bloka woocommerce/checkout. Moj ra?un: #41 - /moj-racun/ Pogoji poslovanja: #5007 - /splosni-pogoji/ ### Theme ### Name: Astra Version: 3.7.7 Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme Child Theme: ? – ?e spreminjate Sporteverest na nadrejeni temi ki je niste zgradili sami svetujemo da uporabite podrejeno temo. Kako ustvariti podrejeno temo WooCommerce Support: ? ### Templates ### Overrides: – ### Action Scheduler ### Preklicano: 39.006 Oldest: -0001-11-30 00:00:00 +0000 Newest: -0001-11-30 00:00:00 +0000 Zaklju?i: 31 Oldest: 2022-03-01 11:31:59 +0000 Newest: 2022-03-02 09:49:02 +0000 V obdelavi: 4 Oldest: 2022-03-02 09:49:32 +0000 Newest: 2022-03-07 09:00:16 +0000 ### Status report information ### Generated at: 2022-03-02 10:49:08 +01:00
I’m also using this code snippet, but it does not solve my issue.
add_action( 'init', function() { as_unschedule_all_actions( 'adjust_download_permissions' ); } );
Any feedback is greatly appreciated, as this is slowing down everything on our hosting.
- The topic ‘Action scheduler – adjust download permissions bug’ is closed to new replies.