_tribe_rsvp_status Database query killing database server.

[provbusnews]

Every time someone views an event or in the admin the database server gets hit with the following query

SELECT 2h7sq1pIz_posts.ID FROM 2h7sq1pIz_posts LEFT JOIN 2h7sq1pIz_postmeta ON (2h7sq1pIz_posts.ID = 2h7sq1pIz_postmeta.post_id AND 2h7sq1pIz_postmeta.meta_key = '_tribe_rsvp_status' ) LEFT JOIN 2h7sq1pIz_postmeta AS mt1 ON ( 2h7sq1pIz_posts.ID = mt1.post_id )

This query takes about 10seconds to run and returns over 750k records!

This just started happening with updates to Event Calendar.

[Andras]

Hi provbusnews,

Thanks for getting in touch!

Sorry to hear about this issue. Not quite sure what could be happening there but I’d be happy to help you figure out.

That query def. doesn’t look good. I ran it on my test site database and got 997 rows, and a lot of the rows appear more times.

I haven’t been able to reproduce that query on my site though, so we would need to find it what triggers that. Would you be able to do a conflict test to determine that.

You can also try installing the Query Monitor plugin and send me a screenshot of the query in question and its details.

Thanks,

Andras

 

[provbusnews]

I can try, this is a production site with a ton of traffic. Currently, I disable both Event Tickets and Event Tickets Plus and the queries stop. I will try to investigate more to see what I can find.

[Andras]

Thanks for getting back to me on this.

I understand if it’s difficult to do testing on a prod site. Would you be able to set up a staging site where testing wouldn’t disturb traffic?

A.

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts