[NSFW] 2 Million of actionscheduler_logs

You could purge those records for Action Scheduler using phpMyAdmin.

phpMyAdmin

Thank you for your reply and your suggestion.

I knew about this possibility, via phpMyAdmin (it’s still not a risk-free solution), but I wondered if it’s possible that WooCommerce could be at the origin of this absurd situation… and I can’t find any reasonable cause.

What types of actions show in the actionscheduler_actions database table?

https://github.com/woocommerce/woocommerce/wiki/Database-Description#table-actionscheduler_actions

Hello @lukefiretoss, on database I have this 3 actions:

• actionscheduler_actions
• actionscheduler_claims
• actionscheduler_groups

See screenshot.

Hi @orsp, thanks for letting us know.

It will be great if you could share your current System Status Report, which may give us some more clues here. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

Hi @seanomattic, thanks for help.

Here the System status report:

WordPress Environment

WordPress address (URL): https://www.privatephotoreview.com
Site address (URL): https://www.privatephotoreview.com
WC Version: 7.3.0
REST API Version: ?</img> 7.3.0
WC Blocks Version: ?</img> 9.1.5
Action Scheduler Version: ?</img> 3.4.0
Log Directory Writable: ?</img>
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?</img>
Language: en_GB
External object cache: –

Server Environment

Server Info: LiteSpeed
PHP Version: 7.4.33
PHP Post Max Size: 30 MB
PHP Time Limit: 300
PHP Max Input Vars: 3000
cURL Version: 7.87.0
OpenSSL/1.1.1s

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.37-MariaDB
Max Upload Size: 30 MB
Default Timezone is UTC: ?</img>
fsockopen/cURL: ?</img>
SoapClient: ?</img>
DOMDocument: ?</img>
GZip: ?</img>
Multibyte String: ?</img>
Remote Post: ?</img>
Remote Get: ?</img>

Database

WC Database Version: 7.3.0
WC Database Prefix: pri_
Total Database Size: 755.45MB
Database Data Size: 548.68MB
Database Index Size: 206.77MB
pri_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
pri_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
pri_woocommerce_order_items: Data: 0.17MB + Index: 0.06MB + Engine InnoDB
pri_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.80MB + Engine InnoDB
pri_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
pri_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
pri_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
pri_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_actionscheduler_actions: Data: 264.62MB + Index: 69.77MB + Engine MyISAM
pri_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
pri_actionscheduler_logs: Data: 156.43MB + Index: 106.80MB + Engine MyISAM
pri_aioseo_cache: Data: 0.14MB + Index: 0.06MB + Engine InnoDB
pri_aioseo_notifications: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
pri_aioseo_posts: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
pri_cache_content: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_cache_module_content: Data: 0.12MB + Index: 0.14MB + Engine MyISAM
pri_commentmeta: Data: 0.14MB + Index: 0.10MB + Engine MyISAM
pri_comments: Data: 0.65MB + Index: 0.26MB + Engine MyISAM
pri_fs_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_account_access_tokens: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_account_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_account_groups_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_account_nodes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_account_node_status: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_account_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_account_status: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_apps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_feeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_grouped_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_post_comments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_fs_schedules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
pri_gf_addon_feed: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
pri_gf_addon_payment_callback: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
pri_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
pri_gf_draft_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_gf_entry: Data: 0.14MB + Index: 0.02MB + Engine MyISAM
pri_gf_entry_meta: Data: 0.71MB + Index: 0.46MB + Engine MyISAM
pri_gf_entry_notes: Data: 0.16MB + Index: 0.05MB + Engine MyISAM
pri_gf_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_gf_form_meta: Data: 1.27MB + Index: 0.00MB + Engine MyISAM
pri_gf_form_revisions: Data: 2.81MB + Index: 0.00MB + Engine MyISAM
pri_gf_form_view: Data: 1.89MB + Index: 0.84MB + Engine MyISAM
pri_gf_rest_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_login_redirects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_newsletter: Data: 0.38MB + Index: 0.13MB + Engine InnoDB
pri_newsletter_emails: Data: 0.42MB + Index: 0.00MB + Engine InnoDB
pri_newsletter_sent: Data: 0.31MB + Index: 0.22MB + Engine InnoDB
pri_newsletter_stats: Data: 0.27MB + Index: 0.16MB + Engine InnoDB
pri_newsletter_user_logs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
pri_options: Data: 8.99MB + Index: 0.39MB + Engine MyISAM
pri_postmeta: Data: 48.00MB + Index: 5.90MB + Engine MyISAM
pri_posts: Data: 21.98MB + Index: 1.74MB + Engine MyISAM
pri_ppress_forms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
pri_ppress_formsmeta: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
pri_ppress_meta_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
pri_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
pri_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
pri_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
pri_rg_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_rg_form_meta: Data: 1.19MB + Index: 0.00MB + Engine MyISAM
pri_rg_form_view: Data: 2.95MB + Index: 1.58MB + Engine MyISAM
pri_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
pri_rg_lead: Data: 0.11MB + Index: 0.02MB + Engine MyISAM
pri_rg_lead_detail: Data: 1.37MB + Index: 0.90MB + Engine MyISAM
pri_rg_lead_detail_long: Data: 0.58MB + Index: 0.02MB + Engine MyISAM
pri_rg_lead_meta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
pri_rg_lead_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_rg_paypal: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
pri_rg_paypal_transaction: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_rg_userregistration: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_signups: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
pri_sliderpro_skins: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
pri_sliderpro_sliders: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
pri_sliderpro_slides: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
pri_termmeta: Data: 0.08MB + Index: 0.08MB + Engine MyISAM
pri_terms: Data: 0.13MB + Index: 0.19MB + Engine MyISAM
pri_term_relationships: Data: 0.25MB + Index: 0.45MB + Engine MyISAM
pri_term_taxonomy: Data: 0.64MB + Index: 0.12MB + Engine MyISAM
pri_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
pri_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
pri_usermeta: Data: 4.73MB + Index: 1.71MB + Engine MyISAM
pri_users: Data: 0.13MB + Index: 0.10MB + Engine MyISAM
pri_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
pri_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
pri_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_wc_customer_lookup: Data: 0.08MB + Index: 0.05MB + Engine MyISAM
pri_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
pri_wc_order_product_lookup: Data: 0.15MB + Index: 0.11MB + Engine MyISAM
pri_wc_order_stats: Data: 0.07MB + Index: 0.05MB + Engine MyISAM
pri_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
pri_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
pri_wc_product_meta_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
pri_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
pri_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
pri_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_wpmm_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
pri_yoast_indexable: Data: 18.55MB + Index: 9.09MB + Engine InnoDB
pri_yoast_indexable_hierarchy: Data: 0.27MB + Index: 0.34MB + Engine InnoDB
pri_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
pri_yoast_primary_term: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
pri_yoast_seo_links: Data: 4.52MB + Index: 3.03MB + Engine InnoDB
pri_yoast_seo_meta: Data: 0.11MB + Index: 0.10MB + Engine MyISAM

Post Type Counts

acf: 1
amn_exact-metrics: 1
attachment: 16796
avia_framework_post: 3
custom_css: 1
export_template: 1
faq: 3
feedback: 3
jp_img_sitemap: 6
jp_img_sitemap_index: 1
jp_sitemap: 1
jp_sitemap_master: 1
mc4wp-form: 2
nav_menu_item: 119
newsletter: 6
oembed_cache: 42
page: 78
portfolio: 1
post: 2292
product: 88
product_variation: 37
revision: 69
safecss: 1
scheduled_export: 1
shop_coupon: 28
shop_order: 950
shop_order_refund: 1
sidebar: 5
slide: 50
tie_slider: 1
ufaq: 18
uncodeblock: 158
user_request: 25
wooframework: 1834
wp_block: 21
wp_global_styles: 1
wysijap: 1

Security

Secure connection (HTTPS): ?</img>
Hide errors from visitors: ?</img>

Active Plugins (38)

ManageWP - Worker: by GoDaddy – 4.9.16
Gravity Forms: by Gravity Forms – 2.6.9
Akismet Anti-Spam: by Automattic – 5.0.2
Social Counters - Arqam Lite: by TieLabs – 1.0.9
Yoast Duplicate Post: by Enrico Battocchi and Team Yoast – 4.5
Easy WP SMTP: by Easy WP SMTP team – 1.5.3
FS Poster: by FS-Code – 6.2.4
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.12.1
Gravity Forms Advanced Post Creation Add-On: by Gravity Forms – 1.3
Gravity Forms reCAPTCHA Add-On: by Gravity Forms – 1.1
Gravity Forms User Registration Add-On: by Gravity Forms – 5.0
Jannah Autoload Posts: by TieLabs – 1.2.0
Jannah - Extensions: by TieLabs – 1.0.14
Jannah Speed Optimization: by TieLabs – 1.2.2
Limit log in attempts reloaded: by Limit log in attempts reloaded – 2.25.11
Newsletter - Amazon SES: by The Newsletter Team – 1.3.8
Newsletter - Extended Composer Blocks: by The Newsletter Team – 1.3.8
Newsletter - Addons Manager: by The Newsletter Team – 1.1.8
Newsletter - Geolocation: by The Newsletter Team – 1.1.8
Newsletter - Gravity Forms Addon: by The Newsletter Team – 1.0.7
Newsletter - Import: by The Newsletter Team – 1.3.5
Newsletter - Leads: by The Newsletter Team – 1.2.9
Newsletter - Reports and Retargeting: by The Newsletter Team – 4.4.5
Newsletter: by Stefano Lissa & The Newsletter Team – 7.5.9
OG — Better Share on Social Media: by Marcin Pietrzak – 3.1.9
Otter – Page Builder Blocks & Extensions for Gutenberg: by ThemeIsle – 2.2.0
Otter Pro: by ThemeIsle – 2.2.0
Redirection: by John Godley – 5.3.6
Simple Local Avatars: by 10up – 2.7.3
Taqyeem: by TieLabs – 2.6.5
Ultimate FAQ - WordPress FAQ and Accordion Plugin: by – 2.2.4
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.22.24

User Role Editor: by Vladimir Garagulya – 4.63.2
WooCommerce PayPal Payments: by WooCommerce – 2.0.1
WooCommerce: by Automattic – 7.3.0
LightStart - Maintenance Mode, Coming Soon and Landing Page Builder: by Themeisle – 2.6.2
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.2.10

WPS Hide Login: by WPServeur
NicolasKulka
wpformation – 1.9.6

Inactive Plugins (0)

Must Use Plugins (1)

ManageWP - Worker Loader: by GoDaddy – 1.0.0

Settings

API Enabled: –
Force SSL: –
Currency: EUR (€)
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: ?</img>
Enforce Approved Product Download Directories: ?</img>
Order datastore: WC_Order_Data_Store_CPT

WC Pages

Shop base: #8705 - /bookshop/
Basket: #8706 - /cart/
Checkout: #8707 - /checkout/
My account: #8709 - /my-account/
Terms and conditions: #36616 - /privacy/terms-and-conditions/

Theme

Name: Jannah Child
Version: 1.0.5
Author URL: https://tielabs.com
Child Theme: ?</img>
Parent Theme Name: Jannah
Parent Theme Version: 6.1.1
Parent Theme Author URL: https://tielabs.com/
WooCommerce Support: ?</img>

Templates

Overrides: –

WooCommerce PayPal Payments

Onboarded: ?</img>
Shop country code: FR
WooCommerce currency supported: ?</img>
Advanced Card Processing available in country: ?</img>
Pay Later messaging available in country: ?</img>
Webhook status: –
Vault enabled: ?</img>
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –
Tracking enabled: –

Admin

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-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
settings

Daily Cron: ?</img> Next scheduled: 2023-01-18 12:15:29 +01:00
Options: ?</img>
Notes: 113
Onboarding: completed

Action Scheduler

Canceled: 1
Oldest: 2023-01-17 18:01:03 +0100
Newest: 2023-01-17 18:01:03 +0100

Complete: 912,669
Oldest: 2022-12-20 12:42:21 +0100
Newest: 2023-01-17 18:02:06 +0100

Pending: 2
Oldest: 2023-01-18 17:59:42 +0100
Newest: 2023-01-18 17:59:42 +0100

Status report information

Generated at: 2023-01-17 18:03:37 +01:00
`

Hey, thanks @orsp!

What’s interesting here is the bulk of these actions are complete and seem to have happened in the past two weeks or so. Does one of your third-party extensions have an automated task that runs really frequently? Maybe every few minutes?

Action Scheduler

Canceled: 1
Oldest: 2023-01-17 18:01:03 +0100
Newest: 2023-01-17 18:01:03 +0100

Complete: 912,669
Oldest: 2022-12-20 12:42:21 +0100
Newest: 2023-01-17 18:02:06 +0100

Pending: 2
Oldest: 2023-01-18 17:59:42 +0100
Newest: 2023-01-18 17:59:42 +0100

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.