sturdywall12

@zenguerrilla glad you found the solution.

Once the WP is stable I suggest experimenting with exclusion or blacklisting folders and php files that causes the issue. As OpCache and JIT are very useful tools for increasing the application’s speed along with lesser resources usage whenever users are browsing the site.

Hello @zenguerrilla

We didn’t have the issue for a while. Somehow I spent few nights trying all sort of tweaks and fixes until I found what worked for me. Please note we have redis cache plugin enabled since the beginning. Along with the usual nginx fastcgi cache. We lowered the cache inactivity or its life to 50m instead of 1 full day.

I highly suspect the culprit is OpCache. Do you have it enabled?

If so, please make sure to follow my post here on GIT: https://github.com/rhubarbgroup/redis-cache/issues/547

Not sure if this is the fix for the issue but it is part of the solution. The other solution I came up with was excluding some files from the nginx fastcgi cache in nginx/website conf file:

In the location ~/ of .php, add this:

    if ($request_uri ~* "/wp-content/|xmlrpc.php|wp-cron.php|robots.txt|/wp-content/upgrade|/wp-content/backups-dup-pro|/wp-content/wp-cloudflare-super-page-cache|/wp-content/jetpack-waf|theme.php|phpmemtest.php|502_recovery_point.php|info.php|xmlrpc.php|wp-.*.php|/wp-admin/|/admin-*|wp-cron|/shopping-cart/|/checkout-3/|/my-account/"){
     set $no_cache 1;
    } 

Please let me know how it goes, I’m willing to share my server’s configuration with you and hopefully you get it fixed. I really hate how the support community works here, I had to pay for some random guy on freelance website who seemed to have +500 5 stars reviews, the guy was clueless and didn’t even sound professional at all. I mean I do have +18 years experience in web development, programming & network engineering. But I only took control over the company’s website as our previous hired web developer was a complete failure who was the type of “google, copy, paste & use AI to generate content quickly”. Extremely lazy guy. It took me few months to get kick started to learn and get going with WP. It’s a great platform, but it’s so easy for the platform to crash once you install the wrong plugin or something isn’t agreeing with the files/permisisons/etc..

Regards.

After further testing. The issue looks to be general to WordPress platform itself.

I tested this with changing the theme to generic WP theme. Again same error being thrown right at theme.php file line 189.

Counter measures I did were changing some fastcgi settings and excluding theme.php file from cache process. But looks like it doesn’t work.

From what I can see, the line 189 on theme.php file is related to stylesheet and possibily goes into infinite loop which causes 4GB memory allocation request.

I’ve been battling this issue for months now. I cannot find anyone to help me resolve this issue. Even the business owner is considering shifting to Shopify as WordPress cannot run withouth hiccups every now and then.

Even now with generic WP theme. It keeps throwing critical website error and many errors:

2024/08/30 17:00:20 [error] 151269#151269: *1610 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Allowed memory size of 2684354560 bytes exhausted (tried to allocate 4295229440 bytes) in /var/www/html/wordpress/wp-includes/theme.php on line 189" while reading response header from upstream, client: 172.70.38.150, server: mp-performance.ae, request: "GET /product-tag/5w-40/?lang=ar&v=7516fd43adaa HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"
2024/08/30 17:04:20 [error] 151269#151269: *1730 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 108.162.227.148, server: mp-performance.ae, request: "GET /product-tag/ngk/?on-sale=1&v=ea8a1a99f6c9 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"
2024/08/30 17:05:09 [error] 151269#151269: *1762 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 162.158.163.218, server: mp-performance.ae, request: "GET /product-tag/grips/?v=ea8a1a99f6c9 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"
2024/08/30 17:05:32 [error] 151269#151269: *1788 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 162.158.106.28, server: mp-performance.ae, request: "GET /product-tag/steering-yoke/?on-sale=1&v=ea8a1a99f6c9 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"
2024/08/30 17:05:55 [error] 151269#151269: *1805 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 162.158.189.161, server: mp-performance.ae, request: "GET /product-tag/engine-drain-bolt/?v=ea8a1a99f6c9 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"
2024/08/30 17:06:22 [error] 151269#151269: *1829 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 162.158.190.115, server: mp-performance.ae, request: "GET /product-tag/2-1-bar/?v=ea8a1a99f6c9 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"
2024/08/30 17:06:44 [error] 151269#151269: *1839 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 172.69.166.96, server: mp-performance.ae, request: "GET /product-tag/magneto-cover/?in-stock=1&on-backorder=1&v=ea8a1a99f6c9 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"
2024/08/30 17:06:54 [error] 151269#151269: *1845 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 172.69.59.125, server: mp-performance.ae, request: "GET /product-tag/obd2/?v=ea8a1a99f6c9 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"
2024/08/30 17:07:32 [error] 151269#151269: *1953 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 172.71.124.163, server: mp-performance.ae, request: "GET /product-tag/probolt/?v=ea8a1a99f6c9 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"
2024/08/30 17:08:15 [error] 151269#151269: *2037 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 172.71.131.137, server: mp-performance.ae, request: "GET /product-category/oem-parts/?v=ea8a1a99f6c9 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae", referrer: "https://mp-performance.ae/online-shop/?v=ea8a1a99f6c9"
2024/08/30 17:08:20 [error] 151269#151269: *2044 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 172.71.124.162, server: mp-performance.ae, request: "GET /product-tag/universal/?v=1c2903397d88 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"
2024/08/30 17:08:20 [error] 151269#151269: *2049 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function get_type() on null in /var/www/html/wordpress/wp-content/plugins/nasa-core/includes/incls/nasa_08_wc_attr_ux.php:342
Stack trace:
#0 /var/www/html/wordpress/wp-includes/class-wp-hook.php(322): Nasa_WC_Attr_UX->product_content_variations_ux_loop()
#1 /var/www/html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#2 /var/www/html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#3 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(198): do_action()
#4 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/ArchiveProductTemplatesCompatibility.php(149): Automattic\WooCommerce\Blocks\Templates\AbstractTemplateCompatibility->get_hooks_buffer()
#5 /var/www/html/wordpress/wp-content/plugins/woocommerce/src/Blocks/Templates/AbstractTemplateCompatibility.php(70): Automattic\WooCommerce\Blocks\Templates\ArchiveProductTemplate" while reading response header from upstream, client: 162.158.107.31, server: mp-performance.ae, request: "GET /product-tag/2023/?featured=1&on-backorder=1&on-sale=1&v=ea8a1a99f6c9 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "mp-performance.ae"

Help is really appreciated.

• This reply was modified 1 month, 3 weeks ago by sturdywall12.

It’s been few weeks since the issue disappeared. The issue gets triggered when either the NasaTheme is active or when I’m using the WP-ADMIN area.

I’m typing here my reply to NasaTheme support. I find this saddening as either WordPress thinks this issue is not from their software. Why can’t WordPress fix this bug/issue? Why me as web developer have to go through WordPress actual software and point the issue. Knowing I will be asked to disable this disable that plugin activate this. No actual debugging! Could someone help me please? This is production website and even WordPress blows a fuse over simple process and asks for 4GB memory allocation. This is a disaster!

Hello,

Upon confirmation, this error is related to the theme. As I tried to simulate how it gets triggered in the admin page by either going to update or dashboard settings of update. It only gets triggered when the elsssi theme is activated.

——
*65555 FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 3145728000 bytes exhausted (tried to allocate 4295229440 bytes) in /var/www/html/wordpress/wp-includes/theme.php on line 189" while reading response header from upstream, request: "POST /wp-admin/admin-ajax.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", referrer: "/wp-admin/post.php?post=10792&action=edit&lang=en"
—-

Line 189 of theme.php file is related to the theme’s stylesheet:

—
function get_stylesheet() {
/**
* Filters the name of current stylesheet.
*
* @since 1.5.0
*
* @param string $stylesheet Name of the current stylesheet.
*/
return apply_filters( 'stylesheet', get_option( 'stylesheet' ) );
}

—-

I suspect there’s incompatibility with the theme and either php8.3 or opcache or whatever else is running on the website. As I disabled almost all plugins and the issue still occurs.

WP tried to allocate 4 extra GB while doing that operation, something is not right. While this is development issue that should be handled by either NasaTheme or WordPress. I find the solutions generic and not helpful. I as web developer will not go through learning WP coding just to fix a glitch or bug issue. What hurts is how WordPress seems to be throwing the ball into NasaTheme field while NasaTheme might claim I should pay for someone to fix one of the party’s -NsasTheme or WordPress- incompetence.

Many people seem to suffer this issue. I need this fixed.

I did. Still does the same.

Strange thing is. Once I disabled all plugins. Activated them again. It didn’t throw 502 error for few hours until I decided to disable redis again. Now I have to restart pfp-fpm service each time I disable redis.

This might give us some insight, managed to trigger the fatal error:

https://share.zight.com/eDuKddZj

Hello.

I’m installing the plugin and will observe the queries. However, after further observation to the logs. I figure the code I reported comes when I access the wp-admin after authorization, visitor checking a product and another visitor visiting the main page. For now I have disabled all analytics. However, the fatal error in sql queries is being reported in multiple pages and plugins pages such as google site kit. Please check the following code:

2024/07/27 09:15:36 [error] 162989#162989: *621 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'posts.ID' in 'on clause' for query SELECT SUM( order_item_meta.meta_value ) as qty, order_item_meta_2.meta_value as product_id FROM wp_tkqbrzh17a_posts AS orders INNER JOIN wp_tkqbrzh17a_woocommerce_order_items AS order_items ON orders.ID = order_id INNER JOIN wp_tkqbrzh17a_woocommerce_order_itemmeta AS order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id INNER JOIN wp_tkqbrzh17a_woocommerce_order_itemmeta AS order_item_meta_2 ON order_items.order_item_id = order_item_meta_2.order_item_id  INNER JOIN wp_tkqbrzh17a_postmeta AS currency_postmeta ON posts.ID = currency_postmeta.post_id WHERE orders.post_type IN ( 'shop_order' ) AND orders.post_status IN ( 'wc-completed','wc-processing','wc-on-hold' ) AND order_item_meta.meta_key = '_qty' AND order_item_meta_2.meta_key = '_product_id' AND orders.post_date_gmt >= '2024-07-01' AND orders.post_date_gmt <= '2024-07-27 09:15:36'  AND currency_postmeta.meta_key = '_order_currency'" while reading response header from upstream, client: 172.69.222.221, server: mp-performance.ae, request: "GET /wp-admin/index.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.2-fpm.sock:", host: "mp-performance.ae", referrer: "https://mp-performance.ae/wp-admin/admin.php?page=wc-admin&path=%2Fgoogle%2Fproduct-feed"
2024/07/27 09:26:04 [error] 163472#163472: *4 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'posts.ID' in 'on clause' for query SELECT SUM( order_item_meta.meta_value ) as qty, order_item_meta_2.meta_value as product_id FROM wp_tkqbrzh17a_posts AS orders INNER JOIN wp_tkqbrzh17a_woocommerce_order_items AS order_items ON orders.ID = order_id INNER JOIN wp_tkqbrzh17a_woocommerce_order_itemmeta AS order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id INNER JOIN wp_tkqbrzh17a_woocommerce_order_itemmeta AS order_item_meta_2 ON order_items.order_item_id = order_item_meta_2.order_item_id  INNER JOIN wp_tkqbrzh17a_postmeta AS currency_postmeta ON posts.ID = currency_postmeta.post_id WHERE orders.post_type IN ( 'shop_order' ) AND orders.post_status IN ( 'wc-completed','wc-processing','wc-on-hold' ) AND order_item_meta.meta_key = '_qty' AND order_item_meta_2.meta_key = '_product_id' AND orders.post_date_gmt >= '2024-07-01' AND orders.post_date_gmt <= '2024-07-27 09:26:04'  AND currency_postmeta.meta_key = '_order_currency'" while reading response header from upstream, client: 172.69.222.125, server: mp-performance.ae, request: "GET /wp-admin/index.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.2-fpm.sock:", host: "mp-performance.ae", referrer: "https://mp-performance.ae/wp-admin/admin.php?page=wc-admin&path=%2Fgoogle%2Fproduct-feed"
2024/07/27 09:28:49 [error] 163472#163472: *101 FastCGI sent in stderr: "PHP message: PHP Warning:  Attempt to read property "post_date" on null in /var/www/html/wordpress/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version3/class-wc-rest-product-categories-controller.php on line 61; PHP message: PHP Warning:  Attempt to read property "post_date_gmt" on null in /var/www/html/wordpress/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version3/class-wc-rest-product-categories-controller.php on line 62; PHP message: PHP Warning:  Attempt to read property "post_modified" on null in /var/www/html/wordpress/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version3/class-wc-rest-product-categories-controller.php on line 63; PHP message: PHP Warning:  Attempt to read property "post_modified_gmt" on null in /var/www/html/wordpress/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version3/class-wc-rest-product-categories-controller.php on line 64" while reading response header from upstream, client: 172.69.222.221, server: mp-performance.ae, request: "GET /wp-json/wc-analytics/products/categories?per_page=100&_locale=user HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.2-fpm.sock:", host: "mp-performance.ae", referrer: "https://mp-performance.ae/wp-admin/admin.php?page=wc-admin&path=%2Fanalytics%2Fproducts"
2024/07/27 09:29:57 [error] 163472#163472: *395 FastCGI sent in stderr: "PHP message: PHP Warning:  Attempt to read property "post_date" on null in /var/www/html/wordpress/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version3/class-wc-rest-product-categories-controller.php on line 61; PHP message: PHP Warning:  Attempt to read property "post_date_gmt" on null in /var/www/html/wordpress/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version3/class-wc-rest-product-categories-controller.php on line 62; PHP message: PHP Warning:  Attempt to read property "post_modified" on null in /var/www/html/wordpress/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version3/class-wc-rest-product-categories-controller.php on line 63; PHP message: PHP Warning:  Attempt to read property "post_modified_gmt" on null in /var/www/html/wordpress/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version3/class-wc-rest-product-categories-controller.php on line 64" while reading response header from upstream, client: 172.69.222.220, server: mp-performance.ae, request: "GET /wp-json/wc-analytics/products/categories?per_page=100&_locale=user HT

As this is production site and the issue will only show on production environment. I have to disable 5-10 plugins and observe each few days. Thanks for the advice.

Is it possible for cache plugin such as WP Fastest to cause such issue?

Will get back with results once I figure the culprit.

Yes. It shows up in any random php file. At random times, mostly if I’m doing any PHP operation such as working on the site at wp-admin pages. For example:

2024/07/24 14:53:59 [error] 99605#99605: *43050 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant "ABSPATH" in /var/www/html/wordpress/wp-includes/blocks/index.php:8
Stack trace:
#0 {main}
  thrown in /var/www/html/wordpress/wp-includes/blocks/index.php on line 8" while reading response header from upstream, client: 198.41.242.185, server: mp-performance.ae, request: "GET /wp-includes/blocks/index.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.2-fpm.sock:", host: "mp-performance.com"

2024/07/24 17:47:02 [error] 99605#99605: *49963 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Out of memory (allocated 41943040 bytes) (tried to allocate 630980608 bytes) in /var/www/html/wordpress/wp-content/plugins/wp-crontrol/src/bootstrap.php on line 24" while reading response header from upstream, client: 172.71.135.88, server: mp-performance.ae, request: "GET /wp-admin/plugin-install.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.2-fpm.sock:", host: "mp-performance.ae", referrer: "https://mp-performance.ae/wp-admin/plugins.php"

2024/07/19 08:01:44 [error] 47865#47865: *64 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Allowed memory size of 2097152000 bytes exhausted (tried to allocate 4295229440 bytes) in /var/www/html/wordpress/wp-includes/theme.php on line 189" while reading response header from upstream, client: 172.71.210.130, server: mp-performance.ae, request: "GET /wp-admin/admin-ajax.php?action=nasa_list_fonts_admin&fill= HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.2-fpm.sock:", host: "mp-performance.ae", referrer: "https://mp-performance.ae/wp-admin/admin.php?page=wc-status"

You can convert the allowed memory size of “2097152000” to mb, it’s in fact 2gb. For some reason WP/PHP wants to allocate out of sudden extra 4GB on top of the 2GB.

I always have my VPS htop function running, the memory never goes above 1.2GB on server resources side. But my PHP-Fpm being on-demand, the system is idling with 700-800mb RAM and while providing webserver or php-fpm child processes the ram only gets consumed up to 1.2-1.3GB.

Please advise. Thanks!

@doublezed2

I’m running the site on sole VPS. There are no other sites using the database. We had it emigrated from Cloudways as the droplet/cloud was too slow for wordpress. It wasn’t easy to emigrate the website until we decided to buy pro version of duplicator.

Me as web developer of the site would say the database the config file has this entry “$table_prefix = ‘wp_tkqbrzh17a_’;” which clearly shows the prefix is coming from the config.

These wp_ tables might be leftovers from emigration process. It honestly looks like the usual classic wp_ prefix WordPress uses on the very first installation.

what do you suggest for now?

• This reply was modified 2 months, 4 weeks ago by sturdywall12.

Hello @carolm29

All plugins are disabled except Woo, Woo payment & WPML.

I only see the error popping up on /var/log/nginx/error.log every now and then. Around 5-10 times per day.

As I said in my first post, the error is reported by PHP and is only posted to the error logs of the server.

Here’s what you need:

1. System Status Report: https://gist.github.com/ubut12d/14291fc6ee51b0890e0c644605b35a18
2. Nothing to be found. No Fatal Errors.

Thanks!

7935499 is the ticket number.