Error Log – "KILLED QUERY"

[Vincent DiGioia]

Hi There,

Our site is hosted on WPEngine, and lately I’ve been seeing a large amount of errors in our error log that look like the string below:

[client xx.xxx.xx.xxx:43329] KILLED QUERY (20414 characters long generated in /nas/content/live/themename/wp-content/plugins/events-calendar-pro/src/Tribe/Geo_Loc.php:907): \n\t\t\tSELECT\n\t\t\t\tMAX( `coords`.`lat` ) AS `max_lat`,\n\t\t\t\tMAX( `coords`.`lng` ) AS `max_lng`,\n\t\t\t\tMIN( `coords`.`lat` ) AS `min_lat`,\n\t\t\t\tMIN( `coords`.`lng` ) AS `min_lng`\n\t\t\tFROM (\n\t\t\t\tSELECT `post_id` AS `venue_id`,\n\t\t\t\tCASE\n\t\t\t\t\tWHEN `meta_key` = ‘_VenueLat’\n\t\t\t\t\tTHEN CAST( `meta_value` AS DECIMAL( 10, 6 ) )\n\t\t\t\tEND AS `lat`,\n\t\t\t\tCASE\n\t\t\t\t\tWHEN `meta_key` = ‘_VenueLng’\n\t\t\t\t\tTHEN CAST( `meta_value` AS DECIMAL( 10, 6 ) )\n\t\t\t\tEND AS `lng`\n\t\t\tFROM `wp_postmeta`\n\t\t\tWHERE\n\t\t\t\t(\n\t\t\t\t\t`meta_key` = ‘_VenueLat’\n\t\t\t\t\tOR `meta_key` = ‘_VenueLng’\n\t\t\t\t)\n\t\t\t\tAND `post_id` IN (\n\t\t\t\t\tSELECT `meta_value`\n\t\t\t\t\tFROM `wp_postmeta`\n\t\t\t\t\tWHERE\n\t\t\t\t\t\t`meta_key` = ‘_EventVenueID’\n\t\t\t\t\t\tAND `post_id` IN ( 5342, 5413, 5414, 5415, 5416, 5417, 5418, 5419, 5420, 5421, 5422, 5423, 5424, 5425, 5426, 5427, 5429, 5430, 5431, 5432, 5433, 5434, 5435, 5436, 5437, 5438, 5439, 5440, 5441, 5442, 5443, 5445, 5446, 5447, 5448, 5449, 5450, 5451, 5452, 5453, 5454, 5455, 5456, 5457, 5458, 5459, 5461, 5462, 5463, 5464, 5465….

According to WPEngine the KILLED QUERY error is “used to determine which queries of SELECT Statements have been killed and not executed by WP Engine due to the query length being over 16k characters; which is inefficient and should not be ran on a production database.”

Do you have any insight as to why this might be happening and how we can fix it?

• This topic was modified 6 years, 4 months ago by Vincent DiGioia.

[Jaime Marchwinski]

Hi Vincent,

Thanks so much for reaching out!

I’m sorry to hear that you are seeing these errors on your site!

Is there a specific situation that triggers the errors to occur?

In addition, as a first troubleshooting step, please update youEvents Calendar related plugins and test if you see the same errors occur.

Let me know how it goes!

 

Thanks,

Jaime

[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