Server limits exceeded when generating feed

Hi,

Thanks for using our plugin and reaching out to us.

When you have been using the plugin for about a year without any problem than changes are something changed in your WordPress instance, perhaps some server-settings where changed or you added another plugin that is very resource intensive / combined with our plugin?

I do not handle server settings, my hosting provider does that.

I haven’t added a new resource intensive plugin.

What can i check more?

Just to mention that i use your plugin without any problems for about a year. But since the last 2 weeks started this strange situation.

Did you make changes to your feed configuration lately?

We made no changes to the plugin that requires usage of extra memory so when your webserver all of a sudden starts showing resource issues than this most likely is being caused by the host changing some server settings or some other configuration change in your website or plugins. It is impossible for us to tell from the outside what that could be.

I understand your point.

No, I haven’t made any changes to the feed configuration lately.

1) What kind of configuration change in my website could cause that problem? Can you guide me further in which direction to look for?

2) Could it be a kind of problem with wp-cron settings and the way this service is configured to the server? Are there specific settings for wp-cron that i could check?

Hi,

• When you or your host is making changes to server configurations such as the maximum allowed CPU usage, memory usage, database connections or maximum allowed execution times than things like this could happen. For some of these you might be able to find proof in your WooCommerce fatal error logs of the last few days.
• I don’t think this is related to WP-cron issues. When there is something wrong wit your WP-cron the feed would just not update, it would not cause a spike in CPU usage

Current state is that the feed does not generate at all…
Seems stuck at processing (50%) message….and the whole process is really slow evn getting only to 50%…
…and the tmp xml file seems only initialized but not getting grow and grow…
…and in the meantime CPU usage going to limit as well as more & more processes are opened reaching the limit…
…even trying from wp control cron events to make woosea_cron_hook to run NOW, nothing changed.
Perhaps something goes wrong with WP-cron?
How can i find out?

Hi,

Did you do this already?

When you or your host is making changes to server configurations such as the maximum allowed CPU usage, memory usage, database connections or maximum allowed execution times than things like this could happen. For some of these you might be able to find proof in your WooCommerce fatal error logs of the last few days.

My hosting provider doesn’t provide me with appropriate info. They say it’s not their fault.

Concerning woocomerce fatal errors, these are what i have recently found:

2022-07-01T22:19:31+00:00 CRITICAL Uncaught Error: Call to a member function addChild() on null in /home8/blumareb/public_html/wp-content/plugins/woo-product-feed-pro/classes/class-get-products.php:1798
Stack trace:
#0 /home8/blumareb/public_html/wp-content/plugins/woo-product-feed-pro/classes/class-get-products.php(4937): WooSEA_Get_Products->woosea_create_xml_feed(Array, Array, 'false')
#1 /home8/blumareb/public_html/wp-content/plugins/woo-product-feed-pro/woocommerce-sea.php(4560): WooSEA_Get_Products->woosea_get_products(Array)
#2 /home8/blumareb/public_html/wp-content/plugins/woo-product-feed-pro/woocommerce-sea.php(2191): woosea_continue_batch('HbT6UHfey1ukMO5...')
#3 /home8/blumareb/public_html/wp-includes/class-wp-hook.php(307): woosea_project_refresh('')
#4 /home8/blumareb/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters('', Array)
#5 /home8/blumareb/public_html/wp-includes/plugin.php(476): WP_Hook->do_action(Array)
#6 /home8/blumareb/public_html/wp-admin/admin-ajax.php(187): do_action('wp_ajax_woosea_...')
#7 {m in /home8/blumareb/public_html/wp-content/plugins/woo-product-feed-pro/classes/class-get-products.php on line 1798

2022-07-01T22:32:13+00:00 CRITICAL Uncaught Error: Call to a member function addChild() on null in /home8/blumareb/public_html/wp-content/plugins/woo-product-feed-pro/classes/class-get-products.php:1798
Stack trace:
#0 /home8/blumareb/public_html/wp-content/plugins/woo-product-feed-pro/classes/class-get-products.php(4937): WooSEA_Get_Products->woosea_create_xml_feed(Array, Array, 'false')
#1 /home8/blumareb/public_html/wp-content/plugins/woo-product-feed-pro/woocommerce-sea.php(4560): WooSEA_Get_Products->woosea_get_products(Array)
#2 /home8/blumareb/public_html/wp-content/plugins/woo-product-feed-pro/woocommerce-sea.php(2193): woosea_continue_batch('HbT6UHfey1ukMO5...')
#3 /home8/blumareb/public_html/wp-includes/class-wp-hook.php(307): woosea_project_refresh('')
#4 /home8/blumareb/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters('', Array)
#5 /home8/blumareb/public_html/wp-includes/plugin.php(476): WP_Hook->do_action(Array)
#6 /home8/blumareb/public_html/wp-admin/admin-ajax.php(187): do_action('wp_ajax_woosea_...')
#7 {m in /home8/blumareb/public_html/wp-content/plugins/woo-product-feed-pro/classes/class-get-products.php on line 1798

That’s all

Hi,

That error indicates you have created a Skroutz feed and added a color field mapping which somehow breaks over the color values some of your products have.

Can you show us the following:

• A screenshot of your field mapping page
• A screenshot of a product which holds your color values?

This is the case, right…
Here some screenshots…I hope this is what you wanted…

1) Skroutz-Feed-Field-Mapping-screenshot-1

2.1) Product-Attributes-screenshot-2.1

2.2) Product-Attributes-screenshot-2.2-xml

Thanks for this extra information. Can you try updating the plugin to version 11.7.1 of our plugin and see if that solves the issue at hand for you?

Assuming the issue at hand has been resolved and/or our help is no longer required we will close this topic. Do not hesitate to reach out to us again whenever you need our support.

@petrospapathomas Did you solve it? My feeds do often finish but our customers can’t access our site for about 20-30 minutes while generating the feed due to Server limits exhausted (server timeout).

My problem seemed to come from wp-cron.
So, i disabled it and used cPanel’s cron job instead.
That actually solved the problem for me (at least for the time).
Of course the limited resources of the hosting server is always an issue but i cannot make an upgrade to my hosting plan for the time.
Hope this helps you too.

Thanks, unfortunately there’s no difference for me having cPanel doing the cron stuff. Tried generating a feed with 8 products, took 1,5 hours until I aborted it, server completely unreachable while generating feed. I run this on a mid to high end Inmotion VPS server so resources shouldn’t be a problem.