Site Slows to Crawl Since Upgrade(s)

[Barry]

This effectively takes us back to square one.

Let’s roll back a bit and make sure we’re both on the same page before we go any further as I’m worried we’re slightly out of sync with one another.

• You originally contacted us because of performance problems and one of our recommendations was to clean up expired events
• For some reason it sounds like automated removal of expired (recurring) events is not working as expected
• We can come back to the above, but what you went on to ask for was a means of manually removing any expired events – and the most recent set of problems seem to have stemmed from that action

Directly modifying the database isn’t something we’d generally recommend, but you had noted you were comfortable working with SQL and would take full responsibility for your actions in terms of taking this step.

Unfortunately, it seems something did go wrong in that the post counts for events were thrown out of whack. The next recommendation was to rollback that piece of work (ie, restore your backup) and remove expired events manually, through the user interface.

Can you confirm that you did indeed restore your backup? If so, the post count (of 21k events) was presumably accurate once again (as all 21,000+ events must have been restored). At one point did it fall back out of sync?

[Andy]

I restored to the back up of those tables; but never ran SELECT * FROM wp_posts WHERE post_type = 'tribe_events' before running the SQL examples provided.

I think my concern is, if we do not have caching (something affecting what is returned from wp_count_posts()), and there is to be a 1 to 1 correlation between that query and All Events counts, where is this disconnect?

Also, I only see “Trash Series” when hovering over events in that listing. I do see “Edit Single” which warns me I am “about to break this event out of it’s series” – does that give any additional insight/leads to the issue?

I’ve also noticed 2-3 updates since this thread has began. I ran those today.

After disabling the plugin, I used the following code to register a post type of the same name:

add_action( 'init','szbl_events_register');
function szbl_events_register()
{
  register_post_type( 'tribe_events', array(
          'labels' => array( 'name' => 'Tribe Test' ),
          'public' => true,
          'name' => 'Events',
          'show_ui' => true
  ));
}

It shows the 1:1 count match to the count in the database:
https://www.dropbox.com/s/n24bid2x00k0w2i/Screenshot%202016-01-18%2014.33.54.png?dl=0

[Barry]

Hi Andy,

I think my concern is, if we do not have caching (something affecting what is returned from wp_count_posts()), and there is to be a 1 to 1 correlation between that query and All Events counts, where is this disconnect?

I was unable to replicate the same problem originally; but your test result is an interesting one. What do you see if you re-enable our plugin (and remove/comment out that snippet)? Are the post counts still out?

Also, I only see “Trash Series” when hovering over events in that listing. I do see “Edit Single” which warns me I am “about to break this event out of it’s series” – does that give any additional insight/leads to the issue?

Could it be that, having removed a number of expired single and recurring events (noting that the parent events would have been left in place) you have paged to a part of the list that only contains parent events?

In other words, within this part of the list are you seeing examples of two events from the same series, where both have a Trash Series link? If so, it certainly sounds like something has gone wrong somewhere along the line.

Are you in a position to share a copy of your database? If possible, could you upload it to Dropbox or even to your site or some other publicly accessible place – and share the URL by private reply?

Thanks!

[Andy]

This reply is private.

[Barry]

Thanks Andy – that gives me a much better view of the problem. Please bear with me while I look at this in some more detail.

[Barry]

Hi Andy,

Thanks again for your patience so far.

On taking a closer look I see that many recurring events in your database have, in a sense, been duplicated. Looking back at the system information you shared I also see that there was apparently a large jump from version 3.0 to 3.8 without any updates in between.

Unfortunately, I think one side effect of this is the creation of the problem you are now facing (and this would probably also explain the failure of the recurring event cleanup task).

Back in our 3.5.2 release post we linked to a plugin that can be used to cleanup situations like this one. Unfortunately, enough time has passed that the original plugin will not work with our very latest builds – however I have modified it and uploaded a fresh copy which you can install and activate:

« Download the updated Tribe Cleanup plugin »

Once activated, please navigate to Events → Settings → General and locate the Merge Duplicate Recurring Events button. Click this and the same screen ought to reload.

If you open the events admin list in another tab you should notice the post counts have reduced to something more reasonable. What you need to do is keep running the tool until this count comes down to the expected value (1,048).

Please do take the usual precautions (ie, a database backup – unless of course the existing backup is suitable) before running through this process.

Does that help?

[Andy]

This appears to be the missing link I’ve been mentioning! We’re back to 1048 – will leave the plugin active and see how we look in the AM.

Thank you!

[Barry]

Fantastic – definitely keep us posted 🙂

[Barry]

Hi Andy,

I wanted to check in here as I’ll be out for the second half of the week (and as forum load has been higher than normal lately, it’s possible other team members will be unable to take this up in my absence).

Is everything going ok following the cleanup and has this helped with the overall objectives of improving site performance?

[Andy]

We are good for now, more of a monitoring game. You’ve been a huge help, thank you! I will make a new reply if we need further support but so far so good — thanks for following up!

[Barry]

Great to hear and fingers crossed we don’t have any sudden reversions!

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts