svaldesm

To give you more context, it just happened again.
This is someone who has 165 products on their wishlist (from what I can see on NewRelic).

View post on imgur.com

The weird thing is that the parts that are highlighted in yellow are not recorded on NewRelic, they are something internal and that is what causes the huge slow down.
(ref: https://imgur.com/a/90gsAmm)

It appears as if there’s some kind of infinite loop or memory leak, because the response time is almost infinite and CPU usage is over 500%.

Please, your help is much appreacited, turns out that our best customers are the ones that are experiencing this issues right now (because they have the biggest wishlists)

Thanks,

Santiago

EDIT: Not sure if this might have something to do, but 65K / 145K rows that are on wp_yith_wcwl correspond to products that have been deleted from Woocoommerce, so they take it nowhere.
Is that case considered in your plugin? I think it should be reasonable to remove all entries on the wishlists from products that are removed from Woo.

• This reply was modified 4 years, 12 months ago by svaldesm.
• This reply was modified 4 years, 12 months ago by svaldesm.

Thanks for your reply.

You can download both tables here: https://bit.ly/2QJKaed
If I’m getting this right, we have 145K products that are added to a wishlist and 14K wishlists. Of those products, I think many might have already been sold and are out of stock (and won’t be stocked again).

We sell secondhand products, so every product is unique. Every once in a while we remove some of the products from Woocommerce (so that our store does not collapse). We have right now over 60K products.

As I can see, whenever someone has more than 50 products on their wishlist, the query takes almost one minute to load!

Is there a way to fix this?

Thanks!

Hi there,

Thanks, I checked and all rules of cache are working fine.
I’ll dig further.

I would like to ask something else: how do you handle this when there’s cache involved, specifically at a server level (like Varnish)?

For example, try this page: https://www.vestua.com/p/chaleco-zara-m-blanco-2/
If you add to wishlist and then reload, it will show as if the product was not added to the wishlist. Is there a way to load, (via AJAX and after page load, to avoid server overload), if the product was added to the wishlist in the past? You could change the icon based on that call and it wouldn’t be so confusing for cache users.

What do you think?

Thanks!

OK, so this is the thing: there’s a plugin that causes conflict with it, BUT the plugin does not have, in any part of the code, a reference to wp_mail()

It does have a function mail() inside, but that shouldn’t be a problem, is it?

So, the error is “Mail function already overridden.”

I’ve deactivated themes, plugins, etc. and the error is nowhere to be found.

Hi Till,

Thanks for your quick answer.

Regarding the plugin, I’ll check with a dev, but just to be sure, what reasons could be preventing it from working? It works in bulk, with a Cron running each bulk every time. What has happened in the past is that it gets stuck on, say, 20% and it doesn’t go on.

Regarding the cron, it’s woocommerce_cancel_unpaid_orders

It’s very unreliable, but when Redis it’s off, it works just fine. I’ve looked into it for a while but so far nothing. And in WC they say it’s not an issue of them (and I believe them because without Redis it works fine).

Thanks for your help and I’ll take a look at Redis Pro.

Amazing Eva, thanks for the great support!!!

Hi Eva,

I can see that, but what I mean is that, given that I want to pull both, I would like to separate them in those groups. Is there a way to add to the dropdown of choices the status of the product?

Thanks

Hi Eva
Thanks for all the help!
What I wonder now is, which one of the options in the feed is actually the “status” (publish, private)?
I tried “Visibility” but I got nothing.

Thanks!

Hi Eva,

Is there a workaround that I can do to make that work, maybe tuning the code? I know that would get replaced with any plugin update, but as far as you know, is there a way to make that happen?
Our use case probably is very specific and not similar to other customers, so it won’t make much sense to add it to the feed.

Thanks,

Santiago

Hi Eva,

I was asking because maybe that support might have more tools for fixing or debugging.

I created a new feed after the migration (this is the one showing weird behavior) so it’s not that.

Hi Eva,

It was not at the same time.
I’m out of ideas here. The strange behavior is that it works for most days and suddenly it stops working. I think it might be related to the update but I’m not sure how.
Could you please tell me if there are more ways to debug or if I can pay for premium support so you can take a look and debug?

Best,

Hi Eva,

I don’t think so. I think I *might* have found the cause.
Every time I update the plugin (via WP Plugin section), the next day it fails. It takes a couple days to be working again. After that, it works fine.
Do you see this happening for other people?

Now the feed has been refreshed and the duplicates are increasing (9,000).
I really don’t know how to debug this.

I tried with 2000 per batch. Same results: around 6,000 products duplicated.
I really don’t know how to proceed with this.

I recounted terms and lookup table on WooCommerce but it didn’t make any improvement.

• This reply was modified 5 years, 5 months ago by svaldesm.