Neverending database updates
-
On a customer’s website I have upgraded to WooCommerce 8.9.1. It showed the usual database update nag so I clicked through and it created 3 Action Scheduler tasks:
- wc_update_890_update_connect_to_woocommerce_note
- wc_update_890_update_paypal_standard_load_eligibility
- wc_update_891_create_plugin_autoinstall_history_option
I tried manually running these which led to more and more tasks being created so I started running the updates from WP-CLI instead with
wp action-scheduler runIt did its updates and finished without incident. I return to the admin screen and the database upgrade nag is back, so I click through and it creates the exact same three actions as above. Again I run them from WP-CLI and return to the admin, the nag’s back, over and over and over. And yet,
wp-cli wc update Success: No updates required. Database version is 8.9.1Despite the neverending DB update nags. So…
- What do I have to do to get WooCommerce to shut up about the database updates it claims it both does and doesn’t need to perform? And,
- Why do we even have to click these nags in the first place? WooCommerce’s database management should be WooCommerce’s problem, not mine nor my customers’ concern.
I can share the system status report if required, but not in a public setting.
-
Hey @anastas10s,
Thanks for the reply but I don’t think the two things are linked. I have also seen that issue where the update buttons don’t work (which is a secondary source of frustration that I decided not to pollute my question with).
Here, when I click the button, it does initialize the database update with the 3 actions I mentioned appearing in the action scheduler. But despite those actions being executed over and over and over WooCommerce still nags for a database update. I’ve run the update easily 50 times and it’s still prompting to update. I ended up leaving this running on the command line:
while [ 1 ] ; do wp action-scheduler run ; wp wc update ; sleep 1 ; doneand it produces this output over and over and over:
Found 7 scheduled tasks Started processing action 149724 Completed processing action 149724 with hook: woocommerce_run_update_callback Running 7 actions 14 % [==========================> ] 0:00 / 0:00Started processing action 149728 Completed processing action 149728 with hook: woocommerce_run_update_callback Started processing action 149725 Completed processing action 149725 with hook: woocommerce_run_update_callback Started processing action 149729 Completed processing action 149729 with hook: woocommerce_run_update_callback Started processing action 149726 Completed processing action 149726 with hook: woocommerce_run_update_callback Started processing action 149730 Completed processing action 149730 with hook: woocommerce_run_update_callback Started processing action 149727 Completed processing action 149727 with hook: woocommerce_update_db_to_current_version Running 7 actions 100% [===========================================================================================================================================================================================] 0:00 / 0:00 1 batch executed. Success: 7 scheduled tasks completed. Success: No updates required. Database version is 8.9.1When I visit the Scheduled Actions tab in WooCommerce I see those same 3 tasks that I previously mentioned being generated over and over. These two screenshots were taken roughly 30 seconds apart and look almost identical:
Screenshot 1
Screenshot 2
Notice how the scheduled times have moved on but they are the exact same set of neverending tasks. The script I mentioned before has been running for an hour with no change in this behaviour.
- The topic ‘Neverending database updates’ is closed to new replies.
