Hi There,<\/p>\n
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:<\/p>\n
[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….<\/p><\/blockquote>\n
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.”<\/p>\n
Do you have any insight as to why this might be happening and how we can fix it?<\/p>\n","protected":false},"template":"","class_list":["post-1424652","topic","type-topic","status-closed","hentry"],"yoast_head":"\n
Error Log - "KILLED QUERY" -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error Log - "KILLED QUERY" -\" \/>\n<meta property=\"og:description\" content=\"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): ntttSELECTnttttMAX( `coords`.`lat` ) AS `max_lat`,nttttMAX( `coords`.`lng` ) AS `max_lng`,nttttMIN( `coords`.`lat` ) AS `min_lat`,nttttMIN( `coords`.`lng` ) AS `min_lng`ntttFROM […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/\" \/>\n<meta property=\"article:modified_time\" content=\"2018-01-12T15:28:36+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/\",\"name\":\"Error Log - "KILLED QUERY" -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2018-01-12T15:27:07+00:00\",\"dateModified\":\"2018-01-12T15:28:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Events Calendar PRO\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Error Log – "KILLED QUERY"\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Error Log - "KILLED QUERY" -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/","og_locale":"en_US","og_type":"article","og_title":"Error Log - "KILLED QUERY" -","og_description":"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): ntttSELECTnttttMAX( `coords`.`lat` ) AS `max_lat`,nttttMAX( `coords`.`lng` ) AS `max_lng`,nttttMIN( `coords`.`lat` ) AS `min_lat`,nttttMIN( `coords`.`lng` ) AS `min_lng`ntttFROM […]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/","article_modified_time":"2018-01-12T15:28:36+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/","name":"Error Log - "KILLED QUERY" -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2018-01-12T15:27:07+00:00","dateModified":"2018-01-12T15:28:36+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/error-log-killed-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Events Calendar PRO","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/"},{"@type":"ListItem","position":5,"name":"Error Log – "KILLED QUERY""}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1424652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1424652\/revisions"}],"predecessor-version":[{"id":1424654,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1424652\/revisions\/1424654"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1424652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}