juregolob

I have commented out lines 269:272 from woocommerce\includes\data-stores\class-wc-product-data-store-cpt.php

/*wc_get_container()
    ->get( DownloadPermissionsAdjuster::class )
    ->maybe_schedule_adjust_download_permissions( $product );
*/

It looks like this solves my issue of action scheduler adjust_download_permissions infinite loop. Our store doesn’t use downloadable products, but I will have to thoroughly test it nonetheless. This is a risky solution, but a necessary one, because of the extreme load on the server it caused.

@theconnectedrider, our API is custom made by a company that also provides other product and stock management software. The API was coded by WooCommerce experts, so it’s hard to think it’s their fault. Anyway, it’s probably because of the API sync. I’m hoping WooCommerce will patch this glitch soon. I’ve seen people having the same issue almost a year ago. It’s around 5-6 months for me and I believe it started when we setup the REST API.

We’re just waiting for our hosting provider to call us and ask what the f*** is going on, generating that much data ??

• This reply was modified 2 years, 8 months ago by juregolob.

Downgrading to PHP7.4 doesn’t help. It’s still repeating the same action.

The only difference between local staging copy and live production is that the live server has an active REST API connection for stock sync that refreshes every 5 minutes. It could be related to this, but we’re only syncing the price and stock for single products and variations.

There’s no adjust_download_permissions hook in WP-Crontrol. Some hooks have empty actions. Also no errors.

There’s no recent fatal error logs and older logs are about plugin crashes (not WooCommerce crashing but failed updates that I’ve already fixed).

Hooks:

litespeed_task_ucss
litespeed_task_lqip
action_scheduler_run_queue
litespeed_task_ccss
litespeed_task_imgoptm_req
litespeed_task_imgoptm_pull
cerber_scheduled_hash
cerber_bg_launcher
woocommerce_cancel_unpaid_orders
litespeed_task_crawler
wc_admin_process_orders_milestone
yith_wrvp_mail_action_schedule
wc_admin_unsnooze_admin_notes
cerber_hourly_1
wp_privacy_delete_old_export_files
cerber_hourly_2
upgrader_scheduled_cleanup
puc_cron_check_updates-filebird_pro
eael_remove_unused_options_data
woocommerce_scheduled_sales
woocommerce_cleanup_sessions
wp_https_detection
wp_version_check
wp_update_plugins
wp_update_themes
cerber_daily
woocommerce_cleanup_personal_data
woocommerce_tracker_send_event
woocommerce_cleanup_logs
woocommerce_cleanup_rate_limits
wpacu_daily_scheduled_events
wpacu_weekly_scheduled_events
jetpack_v2_heartbeat
recovery_mode_clean_expired_keys
wp_scheduled_delete
delete_expired_transients
wp_scheduled_auto_draft_delete
elementor/tracker/send_event
cmplz_every_day_hook
wc_admin_daily
filebird_remove_zip_files
cmplz_every_week_hook
wp_site_health_scheduled_check
woocommerce_geoip_updater
cmplz_every_month_hook
astra_delete_fonts_folder

Actions:

LiteSpeed\Placeholder::cron()
ActionScheduler_QueueRunner->run()
LiteSpeed\CSS::cron_ccss()
LiteSpeed\Img_Optm::cron_auto_request()
LiteSpeed\Img_Optm::cron_pull()
cerber_scheduled_hash()
Closure
wc_cancel_unpaid_orders()
LiteSpeed\Crawler::start()
Automattic\WooCommerce\Admin\Notes\OrderMilestones->other_milestones()
YITH_WRVP_Mail_Handler->mail_do_action_schedule()
cerber_do_hourly_1()
wp_privacy_delete_old_export_files()
cerber_do_hourly_2()
wp_delete_attachment()
Puc_v4p11_Scheduler->maybeCheckForUpdates()
Essential_Addons_Elementor\Classes\Bootstrap->remove_unused_options_data()
wc_scheduled_sales()
wc_cleanup_session_data()
wp_update_https_detection_errors()
wp_version_check()
wp_update_plugins()
wp_update_themes()
cerber_daily_run()
WC_Privacy->queue_cleanup_personal_data()
wc_cleanup_logs()
WP_Recovery_Mode->clean_expired_keys()
wp_scheduled_delete(),Closure
delete_expired_transients()
wp_delete_auto_drafts()
Elementor\Tracker::send_tracking_data()
cmplz_proof_of_consent->generate_cookie_policy_snapshot()
Automattic\WooCommerce\Admin\Events->do_wc_admin_daily()
cmplz_document->cron_check_last_updated_status()
WP_Site_Health->wp_cron_scheduled_check()
WC_Integration_MaxMind_Geolocation->update_database()
cmplz_cron_clean_placeholders()

Hey.

Reporting in with the same issue using the latest Woo. Just like @seanconklin said – there’s no such issue on a local staging site copy.

The amount of data generated is insane. Some stats from the SQL server (sharing, because I’ve never seen anything like this):

Uptime: 5 days 2 hours
Traffic: 13.3 TiB
Traffic per hour: 111.9 GiB
Connections per hour: 115K
Select statements per hour: 17.2M

I’m currently using Sean’s “bandaid” solution – better than nothing. Have you had any luck solving this issue so far?

Thank you so much! The second solution works.

Other solutions did not work for me, as I use WOOF filter. Luckily, the second article provides a solution also for the WOOF.