Subsite Woocommerce database update stuck and action scheduler warning

  • Resolved hamster2116

    (@hamster2116)


    2 years, 1 month ago

    Dear support, I have a multisite network and one of the subsites (not the main site) has a forever stuck WC database update. I manually click to run the actions and yet it still says there is an update due.

    There are two items in the queue

    woocommerce_run_update_callback ‘update_callback’ => ‘wc_update_700_remove_download_log_fk’

    and

    woocommerce_run_update_callback ‘update_callback’
    ‘update_callback’ => ‘wc_update_700_remove_recommended_marketing_plugins_transient’

    I disabled most plugins* and put it on storefront theme.
    *some plugins are network wide.

    Additionally there is the following warning:

    Action Scheduler: 0 past-due actions found; something may be wrong. Read documentation ?

    Note this is only happening on 1 individual subsite, which I use for testing stuff (basically like a staging site/clone of the main site).

    Status report: https://file.io/ube2IXcz9hbc

    Kindly advise what I can do about this. Thank you.

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

  • Hello,

    Thanks for your message. I was trying to access the system report to check better, but it looks it was deleted, can you send it again, please?

    You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response. Thanks.

    Thread Starter hamster2116

    (@hamster2116)

    @ihereira Sorry about that, please download the status report TXT here on dropbox: https://www.dropbox.com/s/t9w4177pt0ci68x/systemreport.txt?dl=0
    Thank you!

    Saif

    (@babylon1999)

    Hello @hamster2116,

    Thank you for sharing the report.

    Does your site happen to be hosted with WPEngine? They’re known to have a script that terminates any process taking more than 60 seconds in their multi-site environment.

    Even if you’re not hosted with them, please reach out to your host to make sure that’s not the case. It also doesn’t hurt to have them check if Cron is working properly. ??

    Let us know how it goes.

    Thread Starter hamster2116

    (@hamster2116)

    @babylon1999 It is hosted on Siteground and they confirmed no such script is implemented and the multisite setup looks correct to them, they did not find any Cron issues.

    They did however suggest to reset file / folder permissions and modify .htaccess like this
    ′

    <IfModule mod_dtimeout.c>
<Files ~ ".php">
SetEnvIf Request_URI "index.php" DynamicTimeout=300
SetEnvIf Request_URI "wp-admin/themes.php" DynamicTimeout=300
SetEnvIf Request_URI "wp-admin/admin-ajax.php" DynamicTimeout=300
SetEnvIf Request_URI "wp-admin/admin.php" DynamicTimeout=300
</Files>
</IfModule>

    I am not sure if I should do it or if that will help

    Thread Starter hamster2116

    (@hamster2116)

    @babylon1999 I’d appreciate any suggestions for fixing this. Last time I tried updating WC database and waited a couple hours for it to finish it apparently caused massive CPU seconds spike in my hosting.

    EDIT: here is a screenshot of scheduled pending tasks, it shows date from the past (September).
    https://snipboard.io/4CRMJx.jpg

    I made a test post scheduled 5 minutes in the future and it was NOT published (missed schedule), meaning Cron does not work properly.

    EDIT2: forgot to mention the subsite in question is behind a log in — meaning it does not get visits. Could this be the cron issue?

    Thanks in advance.

    • This reply was modified 2 years ago by hamster2116. Reason: more info
    • This reply was modified 2 years ago by hamster2116.
    anastas10s

    (@anastas10s)

    Hi there @hamster2116 ??

    They did however suggest to reset file / folder permissions and modify .htaccess like this

    Feel free o try it out, with server-side and browser cache empty, and see if it yields different results. Make sure to download a copy of the .htaccess file on your local machine before editing it.

    I’d appreciate any suggestions for fixing this. Last time I tried updating WC database and waited a couple hours for it to finish it apparently caused massive CPU seconds spike in my hosting.

    From what I gather, SiteGround offers a staging environment with some hosting plans. That should allow for safe experimentation, as it is intended for doing so.

    I made a test post scheduled 5 minutes in the future and it was NOT published (missed schedule), meaning Cron does not work properly.

    You can install a plugin like WP Crontrol to help you monitor the cron jobs.

    EDIT2: forgot to mention the subsite in question is behind a log in — meaning it does not get visits. Could this be the cron issue?

    That would influence the publishing of the post, indeed.

    I trust that points you in the right direction, but if you have more questions, let us know. We’re happy to help.

    • This reply was modified 2 years ago by anastas10s. Reason: typo
    Thread Starter hamster2116

    (@hamster2116)

    @babylon1999 Hi, I was able to fix it by removing the password protected log in and deactivating/activating woocommerce. Immediately the database update finished and the post that I scheduled in the future was published too. It looks like the password protection was the issue here. Thanks for the help anyways!

    Amir A. (woo-hc)

    (@amiralifarooq)

    You’re welcome @hamster2116 glad my colleague helped you to resolve your issue.

    Have a nice day!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Subsite Woocommerce database update stuck and action scheduler warning’ is closed to new replies.