Tribunal Constitucional miembros.Makakuha ng libreng 700pho sa bawat deposito

Resolved athanasiusrc
(@athanasiusrc)

3 years, 9 months ago

The woocommerce_cleanup_draft_orders function is adding hundreds of entries an hour to the action_scheduler_actions table which is resulting in thousands of action ignored via wpcron entries an hour in the action_scheduler_logs table. It is bringing our site to its knees and I don’t know how to stop it. The site is currently very low traffic with few orders so I don’t know why it is behaving this way.

Viewing 3 replies - 1 through 3 (of 3 total)

(@rahul020691)

Hi there,

Did you add any custom code hooking into an action with that name: woocommerce_cleanup_draft_orders ?

To check a bit more and understand the setup, can you please share a copy of your System Status report as found under WooCommerce > Status > System status? Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

Thanks!

Mirko P.

(@rainfallnixfig)

3 years, 9 months ago

Hi there,

Just a heads up, we’ve not heard back from you in a while so I’ll go ahead and mark this thread as resolved. Hopefully, you were able to find a solution to this issue.

If you have further questions, please feel free to open a new topic.

Thanks.

Thread Starter

athanasiusrc

(@athanasiusrc)

3 years, 9 months ago


### WordPress Environment ###

WordPress address (URL): https://14ercertificates.com
Site address (URL): https://14ercertificates.com
WC Version: 5.3.0
REST API Version: ? 5.3.0
WC Blocks Version: ? 5.2.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.2.6
Log Directory Writable: ?
WP Version: 5.7.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.18
PHP Post Max Size: 256 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.66.0
OpenSSL/1.1.1k-fips

SUHOSIN Installed: –
MySQL Version: 5.7.32-35-log
Max Upload Size: 256 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.0.0
WC Database Prefix: wp1c_
Total Database Size: 493.63MB
Database Data Size: 491.56MB
Database Index Size: 2.07MB
wp1c_woocommerce_sessions: Data: 0.28MB + Index: 0.00MB + Engine InnoDB
wp1c_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp1c_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp1c_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp1c_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp1c_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp1c_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp1c_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp1c_actionscheduler_actions: Data: 1.86MB + Index: 0.45MB + Engine MyISAM
wp1c_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp1c_actionscheduler_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp1c_actionscheduler_logs: Data: 482.10MB + Index: 0.00MB + Engine MyISAM
wp1c_affiliate_wp_affiliatemeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_affiliate_wp_affiliates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_affiliate_wp_creatives: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_affiliate_wp_customermeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_affiliate_wp_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_affiliate_wp_direct_links: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_affiliate_wp_payouts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_affiliate_wp_referrals: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_affiliate_wp_rest_consumers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_affiliate_wp_visits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp1c_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_inf_infusionsoft_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_itsec_opaque_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp1c_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp1c_litespeed_cssjs: Data: 0.35MB + Index: 0.02MB + Engine MyISAM
wp1c_litespeed_img_optm: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp1c_litespeed_img_optming: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp1c_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_options: Data: 2.52MB + Index: 0.05MB + Engine InnoDB
wp1c_postmeta: Data: 1.52MB + Index: 0.44MB + Engine InnoDB
wp1c_posts: Data: 1.52MB + Index: 0.06MB + Engine InnoDB
wp1c_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp1c_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_revslider_sliders: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp1c_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_shortpixel_folders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp1c_shortpixel_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp1c_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp1c_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp1c_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp1c_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp1c_wc_customer_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp1c_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp1c_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp1c_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp1c_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp1c_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp1c_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp1c_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp1c_yoast_seo_links: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp1c_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 81
custom_css: 1
jetpack_migration: 2
nav_menu_item: 4
omapi: 1
page: 11
post: 3
product: 18
product_variation: 85
revision: 72
shop_order: 15
shop_order_refund: 5
wpcf7_contact_form: 1

### Security ###

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

### Active Plugins (12) ###

Akismet Anti-Spam: by Automattic – 4.1.9
Contact Form 7: by Takayuki Miyoshi – 5.4.1
PixelYourSite: by PixelYourSite – 8.2.2
SG Optimizer: by SiteGround – 5.7.20
WebP Express: by Bj?rn Rosell – 0.19.1
WooCommerce Blocks: by Automattic – 5.2.0
WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.1
WooCommerce Stripe Gateway: by WooCommerce – 5.2.0
WooCommerce Product Add-ons: by WooCommerce – 3.0.16
WooCommerce Shipping & Tax: by WooCommerce – 1.25.13 (update to version 1.25.14 is available)
WooCommerce: by Automattic – 5.3.0 (update to version 5.4.1 is available)
WP Head Optimizer: by Nilay Patel – 1.0.0

### Inactive Plugins (3) ###

AffiliateWP: by AffiliateWP
LLC – 2.2.10

AffiliateWP - Direct Link Tracking: by AffiliateWP – 1.1.3
LiteSpeed Cache: by LiteSpeed Technologies – 3.6.4

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

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

Shop base: #14 - /shop/
Cart: #15 - /cart/
Checkout: #16 - /checkout/
My account: #17 - /my-account/
Terms and conditions: #3 - /privacy-policy/

### Theme ###

Name: Divi
Version: 4.9.4
Author URL: https://www.elegantthemes.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 ###

Overrides: –

### Action Scheduler ###

Complete: 4,662
Oldest: 2021-05-27 14:40:01 +0000
Newest: 2021-06-08 09:56:20 +0000

Failed: 119
Oldest: 2021-05-27 14:40:11 +0000
Newest: 2021-05-27 14:40:07 +0000

Pending: 170
Oldest: 2021-06-09 06:43:32 +0000
Newest: 2021-06-13 03:47:51 +0000

### Status report information ###

Generated at: 2021-06-16 13:59:42 +00:00

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘woocommerce_cleanup_draft_orders adding thousands of entries’ is closed to new replies.