too many wc-admin_import_orders
-
I am having problems with my Scheduled actions. I see there are lots of “wc-admin_import_orders” pending. These are running every few seconds and I think it’s filling up the logs in my DB. My “wlv_actionscheduler_actions” is about 590 MB now in size, and there are probably a few thousand logs from “wc-admin_import_orders” .
The page I need help with: [log in to see the link]
-
Hi @meatface888,
Thanks for reaching out! I understand how frustrating this can be!
What you’re seeing with the repeated wc-admin_import_orders actions and growing database table size can happen if WooCommerce Admin’s background data import gets stuck or triggered repeatedly.
To help resolve this:
- Clear the pending wc-admin_import_orders actions under WooCommerce → Status → Scheduled Actions → Pending by searching for that hook and canceling them.
- Then go to WooCommerce → Status → Tools and click “Delete previously imported data” under the “Import historical data” section.
- Finally, re-run the import manually by selecting “Import historical data” and monitor if it completes normally this time.
If the scheduled actions keep queuing again, let us know. Please also share your System Status Report (WooCommerce → Status → Get system report → Copy for support) and we’ll take a closer look.
- The pending fills instantly after I delete anything in there.
- I think you mean under Analytics -> Settings -> “Import historical data”. Status says: Initializing with wheel spinning. Doesn’t change. It use to show items importing here. Still the same after I refresh the page. The bars are not moving and says “0 of 417” imported. After I stop it from importing, the “Delete previously imported data” button does not show up a message appears below “There was a problem rebuilding your report data” but if I refresh the page the status shows initializing with a wheel spinning. It seems to be auto starting right after I click the stop. When I check the Scheduled Actions page, I see “wc-admin_import_orders” in pending, and they are appearing in complete, which grows by about 20 every second. When I click stop importing and just refresh the page the status also shows initializing.
I remember in the past the import bar would look like it’s filling up, and when I click stop, there is a button that says “Delete previously imported data”. It could be the cpu usage is too high and it’s not updating properly. I have tried to press the delete import data but I think it starts importing again before anything gets deleted.
-
This reply was modified 11 months, 3 weeks ago by
meatface888.
Hi @meatface888
Thank you for your patience. Are you able to access your database and run queries, and how comfortable would you be with running snippets of code on your site to help rectify the situation?
Because as we’re not able to see the same behaviour on staging, I’d say we need to look at the database and clean up some of the settings there which are causing the import job to initialize.
The following snippet should help with the reset: https://gist.github.com/nicdwilson/f93d0a71de7b2c7646561663b8832da8
It will create a log file, and is designed to only run once. Please test it on staging first, and backup your site before trying to use it. Once it has generated the log, switch it off, and share the log file here.
Note that we don’t usually share code like this in support, and we don’t guarantee it is safe or works, but I feel you have been very patient, and I’m hoping this will solve the problem!
Sorry I don’t know how to work inside DB’s or understand how to run snippets.
The problems look very similar on both Production site and Staging site. They both constantly run “Import Historical Data” indefinitely which drives up the CPU usage dramatically and they are all completing under scheduled actions under complete. Both sites run wc-admin_import_orders about 90,000 every 30 min.
Also on both sites, every time I stop the “Import Historical Data” it auto starts again.
Thanks for the update @meatface888
Could you please open a support ticket at WooCommerce.com and quote this thread? We can then work though some options with you which will hopefully help resolve the problem.
I tried to open a ticket on the woocommerce.com site but not really sure where to do this. I tried to contact support and ithe site was asking me to connect my store even though it appeared to be connected. I tried deleting the connection and redoing it to see if I could get it unstuck but it never gets past the subscription part. Just keeps taking me back to the start and asks me for my URL again.
I went back into the chat and opened a chat by manually entering the website to fix the subscription issue. I have not had a response yet.
Hello meatface888,
Thank you for your reply.
I understand you were initially having trouble creating a ticket at WooCommerce.com, but I’m glad to hear you were able to submit one through the chat option.
Could you please check if you received an email confirmation with the ticket number? If so, kindly share the ticket number here so I can ensure a prompt follow-up on your request.
Have a great day!
I went through the Get Support link and clicked on the Get in Touch link at the bottom of the page. It said if no one replies to me in a few minutes they will email me but no one emailed me at all. I can’t find anywhere on the site to open a ticket.
Hi @meatface888,
I understand you’re still unsure whether your request reached us, especially after trying to open a ticket and not receiving an email confirmation. No worries, I can confirm that your chat with our Happiness Engineer @nicw has already initiated a support ticket on your behalf, and it’s currently being attended to behind the scenes.
Since we’re actively investigating this matter with you via the chat ticket, we’ll leave this forum thread unresolved for now, in case you’d like to update it once the issue is resolved as well.
We appreciate your patience, and we’ll be in touch as soon as there are updates.
The topic ‘too many wc-admin_import_orders’ is closed to new replies.