Simple Sales Tax Database update doesn’t complete

The data update does complete under normal circumstances, although it could take quite a while if you have very many products. This is especially true if you’re not running the latest version of SST (v6.2.6) since earlier versions had a bug where we were processing far less products per batch than was originally intended (2 instead of 50). The only way the update actually wouldn’t terminate is if the WP cron event that keeps the background updater running got interrupted somehow.

In regards to your DB outages, the DB update routine is not very intensive at all. It just updates one post meta field for products with SST origin address saved in relatively small batches. Unless you’re DB is extremely underpowered it shouldn’t cause a problem. In any case, please try updating to v6.2.6 if you haven’t already. Since we process larger batches of products in v6.2.6 as was originally intended, there should theoretically be less DB queries involved and that may help to reduce some of the load. You probably need more resources though if this simple data update is causing noticeable stress.

If that fails or you’re already running the latest version of SST, reach out to me directly at [email protected] with a temporary set of admin creds and I’ll see what I can do to help.

Thank you Brett! I don’t think it’s a server resources issue as this is sitting on a dedicated server. I’ll get you temporary admin credentials. Thank you very much for your thorough reply and willingness to come in to the site to help.

I checked out the sst_db_updates log under WooCommerce > Status > Logs and it looks like the update somehow stalled or got interrupted on 11/20. You can see in this screenshot that one of the update functions was queued to run but never got executed. I’m not quite sure what happened there, but I was able to manually force the updates to run and get the notice hidden.

Given the SST database update never actually ran I’m pretty sure your DB issues are unrelated.

Thanks so much Brett! Really appreciate it!

No problem! Happy to help.