Strange problem with Action Scheduler / Huge growth of log file and Database

  • Resolved redfevers

    (@redfevers)


    3 years, 3 months ago

    Hi,

    I hope someone has some interesting (at least) proposition, since I am going pretty insane, and with no ideas where to look anymore, and how to solve this (now my most hated 2 words are Scheduled Action or Action Scheduler)…

    For a month now, dealing with unkown error, I did update WooCommerce to latest version and after publishing new product, the site has crashed… I did restore my DB and full website to earlier working state, but the problem persist on it… fixed some DB issues and missing tables about action schedules (4 tables). The website is running (let say), but there is strange problem which I can’t figure out… in the DB table wp_actionscheduler_logs there is multiple errors every second of not succeeding WP Cron actions that have been failed, and there are millions of them, as well on the hosting side, home/domain/logs folder there is domain_com.php.error.log which is growing parallel… talking about gigabytes of date every day in DB and log folder.

    I was increasing PHP limits, but it doesn’t matter how large allowance I put in .htaccess or php.ini or wp-config file, trying to access Action Schedules, it gives an error of exceeding allowed memory.

    Accessing Tools -> Scheduled Actions (or WooCommerce -> Status -> Scheduled Actions) error:
    Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 73728 bytes) in /home/ferropac/public_html/wp-includes/functions.php on line 5107

    This is WooCommerce System Report:

    
### WordPress Environment ###

WC Version: 5.9.0
REST API Version: ? 5.9.0
WC Blocks Version: ? 6.4.0
Action Scheduler Version: ? 3.3.0
WC Admin Version: ? 2.8.0
Log Directory Writable: ?
WP Version: 5.8.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: hr
External object cache: ?

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.25
PHP Post Max Size: 512 MB
PHP Time Limit: 300
PHP Max Input Vars: 5000
cURL Version: 7.79.1
OpenSSL/1.1.1l

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.32-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: 5.9.0
WC Database Prefix: wp_
Total Database Size: 1882.34MB
Database Data Size: 1096.27MB
Database Index Size: 786.07MB
wp_woocommerce_sessions: Data: 10.28MB + Index: 0.20MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 0.17MB + Index: 0.12MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 1044.20MB + Index: 773.66MB + Engine MyISAM
wp_aws_cache: Data: 0.86MB + Index: 0.00MB + Engine MyISAM
wp_aws_index: Data: 7.28MB + Index: 3.56MB + Engine MyISAM
wp_blc_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_blc_instances: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_blc_links: Data: 0.17MB + Index: 0.01MB + Engine MyISAM
wp_blc_synch: Data: 0.12MB + Index: 0.14MB + Engine MyISAM
wp_commentmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_comments: Data: 0.10MB + Index: 0.04MB + Engine MyISAM
wp_duplicator_packages: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
wp_fb3d_pages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_lockdowns: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_login_fails: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 10.29MB + Index: 1.02MB + Engine MyISAM
wp_pmxe_exports: Data: 0.07MB + Index: 0.00MB + Engine MyISAM
wp_pmxe_google_cats: Data: 0.26MB + Index: 0.21MB + Engine MyISAM
wp_pmxe_posts: Data: 0.12MB + Index: 0.10MB + Engine MyISAM
wp_pmxe_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_imports: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_posts: Data: 0.16MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_postmeta: Data: 13.61MB + Index: 4.71MB + Engine MyISAM
wp_posts: Data: 6.19MB + Index: 0.83MB + Engine MyISAM
wp_redirection_404: Data: 0.62MB + Index: 0.00MB + Engine MyISAM
wp_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_redirection_items: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_redirection_logs: Data: 0.19MB + Index: 0.00MB + Engine MyISAM
wp_shortpixel_folders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_shortpixel_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_termmeta: Data: 0.10MB + Index: 0.03MB + Engine MyISAM
wp_terms: Data: 0.05MB + Index: 0.09MB + Engine MyISAM
wp_term_relationships: Data: 0.36MB + Index: 0.49MB + Engine MyISAM
wp_term_taxonomy: Data: 0.05MB + Index: 0.05MB + Engine MyISAM
wp_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_usermeta: Data: 0.42MB + Index: 0.25MB + Engine MyISAM
wp_users: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 0.30MB + Index: 0.37MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wt_iew_action_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wt_iew_cron: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wt_iew_ftp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wt_iew_mapping_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yith_wcwl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yith_wcwl_lists: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

### Post Type Counts ###

3d-flip-book: 8
attachment: 3259
blocks: 20
custom_css: 1
ed_logo: 1
nav_menu_item: 54
page: 31
post: 12
product: 3069
product_variation: 1640
revision: 1011
shop_order: 155
vc_grid_item: 1
vc4_templates: 2
wpcf7_contact_form: 2
wpmm_theme: 4
yith-wcbm-badge: 1

### Security ###

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

### Active Plugins (27) ###

3D FlipBook: by iberezansky – 1.11.5
Advanced Woo Search: by ILLID – 2.41
Schema - All In One Schema Rich Snippets: by Brainstorm Force – 1.6.4
Broken Link Checker: by WPMU DEV – 1.11.16
Contact Form 7: by Takayuki Miyoshi – 5.5.3
Enable Media Replace: by ShortPixel – 3.6.3
Envato Market: by Envato – 2.0.6
Flexible Shipping: by WP Desk – 4.10.1
Google XML Sitemaps: by Auctollo – 4.1.1
Insert Headers and Footers: by WPBeginner – 1.6.0
Jetpack: by Automattic – 10.3
OG - Better Share on Social Media: by Marcin Pietrzak – 2.9.4
Perfect Brands for WooCommerce: by QuadLayers – 2.0.0
PW WooCommerce Exclude Free Shipping: by Pimwick
LLC – 1.23

Really Simple SSL: by Really Simple Plugins – 5.2.0
Redirection: by John Godley – 5.1.3
ShortPixel Image Optimizer: by ShortPixel – 4.22.6
Category Order and Taxonomy Terms Order: by Nsp-Code – 1.5.7.7
W3 Total Cache: by BoldGrid – 2.1.9
WooCommerce Weight Based Shipping: by weightbasedshipping.com – 5.3.16
WooCommerce Blocks: by Automattic – 6.4.0
Call for Price for WooCommerce: by Tyche Softwares – 3.3.1
WooCommerce: by Automattic – 5.9.0
WP Mega Menu Pro: by Themeum – 1.3.4
WP Mega Menu: by Themeum – 1.4.2
WPS Hide Login: by WPServeur
NicolasKulka
wpformation – 1.9.1

YITH WooCommerce Wishlist: by YITH – 3.3.0

### Inactive Plugins (7) ###

Akismet Anti-Spam: by Automattic – 4.2.1
All-in-One WP Migration: by ServMask – 7.50
Classic Editor: by WordPress Contributors – 1.6.2
Duplicator: by Snap Creek – 1.4.3
HookMeUp – Additional Content for WooCommerce: by GetBowtied – 1.3.5
OnSale Page for WooCommerce: by wpgenie – 1.1.0
WooCommerce - Store Exporter: by Visser Labs – 2.7

### Dropin Plugins (4) ###

advanced-cache.php: advanced-cache.php
db.php: db.php
maintenance.php: maintenance.php
object-cache.php: object-cache.php

### Settings ###

API Enabled: ?
Force SSL: –
Currency: BAM (KM)
Currency Position: right_space
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 2
Taxonomies: Product Types: simple (simple)
grouped (grouped)
variable (variable)
external (external)

Taxonomies: Product Visibility: exclude-from-search (exclude-from-search)
exclude-from-catalog (exclude-from-catalog)
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: #169 - /trgovina/
Cart: #170 - /kosarica/
Checkout: #171 - /placanje/
My account: #172 - /moj-racun/
Terms and conditions: #7101 - /uvjeti-kupovine/

### Theme ###

Name: Karlo Child
Version: 3.0
Author URL: 
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.14.3
Parent Theme Author URL: https://www.uxthemes.com/
WooCommerce Support: ?

### Templates ###

Overrides: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart-shipping.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/terms.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product-cat.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome/woocommerce/myaccount/form-login.php
flatsome/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
flatsome/woocommerce/single-product/product-image.php
flatsome/woocommerce/single-product/product-thumbnails.php
flatsome/woocommerce/single-product/rating.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php
flatsome/woocommerce/content-product_cat.php

### Action Scheduler ###

Complete: 27
Oldest: 2021-11-26 09:19:04 +0100
Newest: 2021-11-29 14:20:10 +0100

Failed: 1
Oldest: 2021-11-26 09:19:08 +0100
Newest: 2021-11-26 09:19:08 +0100

Pending: 1
Oldest: 2021-11-30 12:43:17 +0100
Newest: 2021-11-30 12:43:17 +0100

### Status report information ###

Generated at: 2021-11-30 00:07:55 +01:00

    The page I need help with: [log in to see the link]

Viewing 2 replies - 16 through 17 (of 17 total)
  • Thread Starter redfevers

    (@redfevers)

    Hi @3sonsdevelopment ,

    Finally found some time to deal with the issue. I did as you suggested, disabled all the plugins, deleted all Action Scheduler tables. After that I activated Action Scheduler plugin which created new tables.

    There was some pending task for Migration – I did run it manually to complete pending task. After that I did activate all my plugins and it works like a charm!

    Thank you so much for your help!

    Finally SOLVED!

    Best

    Igor H

    (@ihereira)

    Glad to know that my colleagues pointed you in the right direction.

    If you have any further questions, I recommend creating a new thread, since this one is solved.

    Best.

Viewing 2 replies - 16 through 17 (of 17 total)
  • The topic ‘Strange problem with Action Scheduler / Huge growth of log file and Database’ is closed to new replies.