Query is too long for organizers info and venue info methods

[Jonathan Goldford]

Hey guys,

We’re seeing some errors in our clients logs (hosted on WP Engine) where the query is too long: (KILLED QUERY (19054 characters long generated in <path>/plugins/the-events-calendar/src/Tribe/Main.php:3536) * also same error for line 3444. We see this when loading any of the event pages in Admin and it takes a good while to load any page. So looks like the queries in get_venue_info and get_organizer_info are causing this.

Looking at our database, 3,660 venues with 1,215 of those as pending. For organizers, we have 3,235 with 1,100 as pending. Are we hitting a limitation here with the amount of data? Or is there any kind of workaround to narrow that query down or any settings we can use to keep the query from getting killed by WP Engine? Just trying to gather some ideas on what steps we can take to remedy this one.

Thanks guys for all your help!

Casey

[George]

Hey Casey,

Sorry for the trouble here. Those numbers of venues and organizers is indeed quite large, but we of course don’t expect there to be outright timeouts here.

I will escalate this to a developer on our team for some deeper insight into what might be causing this, and if there’s anything we can recommend to help. I would recommend opening a support ticket with WP Engine in the meantime to the same end.

Stay tuned!
George

[George]

Hey Casey—one thing worth trying here is setting a WP Engine option called WPE_GOVERNOR.

To test if this helps, try adding this line of code to your theme’s wp-config.php file:


define( 'WPE_GOVERNOR', false );


Cheers!
George

[Jonathan Goldford]

Hi George,

Thanks for getting back so quick on this and getting this in front of the developers. I’m going to open a ticket with WP Engine and look at testing the GOVERNOR option and see what comes about. I’ll reply back once I’ve heard from WPE and tested the option.

Thanks again!

Casey

[George]

Sounds good Casey—thanks for your patience here, let us know what you find! I will keep this thread updated in the meantime if we, too, have any other updates to post.

Thank you,
George

[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