Travis Poole

I checked in FF and they don’t switch at all.

Well I agree with you. I believe its a hosting issue of some type. Its running off Windows. I just don’t know why it runs fine for a month or two then we wake up to an internal server error or the website just won’t load.

kmessinger:

Our issues stem from our website just randomly goes down and when we restart services, it comes back. I do not understand this. I have posted all of the errors and yet no one can seem to ever figure these issues out. We have experienced these issues for years. The website will run fine for a month or two then we wake up and it won’t load or we are having an internal server error thrown at us.

We do not have an old version of WordPress. We are only one update behind. We have not updated to 4.4 due to bugs.

Okay thank you.

Sorry guys … still looking for an idea here.

Thanks for your help.

Here is what we have:

At 2:47am:?A worker process with process id of ‘4368’ serving application pool ‘our website’ has requested a recycle because the worker process reached its allowed processing time limit.

At 2:49am:?A worker process ‘4368’ serving application pool ‘our website’ failed to stop a listener channel for protocol ‘http’ in the allotted time. The data field contains the error number.

Any ideas?

Hello,

Thanks for the response. We do not have the latest version of WordPress due to a few bugs. We have been advised to update to 4.4.1 once it has been released.

I confirmed with my Engineer that he restarted the web service. He said the cgi kept crashing where cgi is the php.exe.

Any clues?

Deactivating the plugin has helped. The admin side is running much faster now. The only issue now is a slow Dashboard for some reason. Now its taking 30-60 seconds to load. Here are the types of queries I am getting now:

SELECT *
FROM wp_comments
LEFT JOIN wp_posts
ON comment_post_ID = wp_posts.ID
WHERE ( ( comment_approved = ‘0’
OR comment_approved = ‘1’ ) )
AND wp_posts.post_type NOT IN (‘shop_order’,’shop_order_refund’,’shop_subscription’)
AND wp_posts.post_type <> ‘shop_webhook’
AND wp_comments.comment_type != ‘action_log’
ORDER BY wp_comments.comment_date_gmt DESC
LIMIT 475,50
WP_Comment_Query->get_comments+ 0.0548

Ton of those now that were not there before.

The Follow Up Emails plugin for WooCommerce is causing all sorts of issues for us. I have deactivated portions of it. I have notified their development team and I believe they are working the issue.

I think the problem may be related to Follow Up Emails Queries. There are a ton of them each time I try and load a page.

Slow Database Queries (above 0.05s)
Query Caller Time
SELECT comment_approved, COUNT( * ) AS num_comments
FROM wp_comments
WHERE comment_type NOT IN(‘order_note’,’action_log’)
GROUP BY comment_approved
ActionScheduler_wpCommentLogger->filter_comment_count+ 0.3839
SELECT SQL_CALC_FOUND_ROWS id
FROM wp_followup_email_orders
WHERE 1=1
AND email_id IN (‘67124′,’111271’)
FUE_Sending_Scheduler->get_items+ 0.4119
SELECT post_status, COUNT( * ) AS num_posts
FROM wp_posts
WHERE post_type = ‘shop_order’
GROUP BY post_status
wp_count_posts+ 0.1547
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
WHERE 1=1
AND wp_posts.post_type = ‘shop_order’
AND ((wp_posts.post_status = ‘wc-pending’
OR wp_posts.post_status = ‘wc-processing’
OR wp_posts.post_status = ‘wc-on-hold’
OR wp_posts.post_status = ‘wc-completed’
OR wp_posts.post_status = ‘wc-cancelled’
OR wp_posts.post_status = ‘wc-refunded’
OR wp_posts.post_status = ‘wc-failed’))
ORDER BY wp_posts.post_date DESC
LIMIT 0, 20
WP_Query->get_posts+ 0.1880
SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month
FROM wp_posts
WHERE post_type = ‘shop_order’
ORDER BY post_date DESC
WP_List_Table->months_dropdown+ 0.1265
SELECT order_item_id, order_item_name, order_item_type
FROM wp_woocommerce_order_items
WHERE order_id = 259312
AND order_item_type IN ( ‘line_item’ )
ORDER BY order_item_id;
WC_Abstract_Order->get_items+ 0.0532

Right this is the issue with a staging site. We have thousands of subscriptions so its virtually impossible to do that.

Thanks for the response royho. We have a very active website and its important that it runs properly. I have been surprised at all the bug fixing.

So just to update this:

I watched a renewal order today and as it should, it counted down to the minute until the next charge. However, it did not charge out. Then the next payment date just changed to today.

Any ideas what might be causing this? This issue has just popped up on us.

Thanks

Update: So I thought the site was going to crash again but for the first time, it released the renewal orders all at once. So around 11pm EST we had over 20 orders process through Stripe and generate renewal orders for our subscriptions.

Could anyone explain this behavior?

Thanks