{"id":1389014,"date":"2017-11-22T07:14:04","date_gmt":"2017-11-22T15:14:04","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/"},"modified":"2017-11-22T07:14:04","modified_gmt":"2017-11-22T15:14:04","slug":"killed-query-error-leading-to-timeouts","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/","title":{"rendered":"KILLED QUERY error leading to timeouts"},"content":{"rendered":"<p>Hello,<\/p>\n<p>After the last Community Events and Events Calendar Pro updates, i&#8217;m getting the killed query update similar to the one <a href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/getting-killed-query-errors\/\">described here<\/a>.<\/p>\n<p>Problem is, I get this error when attempting to edit any event (front end displays fine), so I can&#8217;t accept new events submitted by our community.  Any solution?  We are using WP Engine for hosting. Here&#8217;s a sample error from our logs:<\/p>\n<p>[Wed Nov 22 14:50:47.903302 2017] [:error] [pid 21285] [client 64.222.152.152:57125] KILLED QUERY (20330 characters long generated in \/nas\/content\/live\/vtdigger\/wp-content\/plugins\/the-events-calendar\/src\/Tribe\/Linked_Posts.php:472): SELECT post_id, meta_key, meta_value FROM vtdWP_postmeta WHERE post_id IN (120907,120909,120911,120913,198400,198401,201729,198402,201730,195075,198404,198405,198406,198407,200199,207623,198408,200200,198409,198410,197131,198411,197132,198412,197133,198413,207629,197134,198414,199950,197135,198415,198671,199951,205071,197136,198416,198672,197137,198417,198673,197138,198674,205074,197139,198419,198675,205075,197140,198420,198676,205076,197141,198421,198677,204053,207637,197142,198422,198678,204054,197143,198423,198679,197144,198424,198680,198681,198682,202266,205850,202267,207643,198684,205852,198685,202269,205853,207645,202270,200735,200736,202272,200737,202273,199970,200738,199971,206883,200740,206884,207652,200741,200742,206886,200743,207655,200745,207657,200746,194603,200748,206892,200749,194605,200750,206894,194606,200751,206895,200752,206896,194608,199729,200753,206897,199730,200754,203570,194610,200755,203571,194611,199732,200756,194612,199733,200757,201013,203573,194613,201014,203574,194614,194615,201016,201272,194616,201017,201273,203321,203322,194618,201019,201275,194619,201020,201276,194620,194621,199486,201022,194622,199487,201023,194623,199488,194624,199489,201025,194625,201026,194626,199491,194627,199492,201028,197701,199493,201029,197702,198470,199494,200262,194886,198471,199495,200263,201031,194887,197704,198472,199496,201032,204616,194888,197705,198473,199241,204617,194889,197706,199242,199498,201034,194890,197707,199499,201035,194891,199500,194892,199501,199502,199503,202575,202576,198225,198226,202578,198227,202579,203347,198228,203348,202070,202071,205399,202072,204632,202073,205401,202075,202076,201567,201568,208993,208995,202853,208997,199014,202854,199015,208999,199016,199784,199017,199785,200041,200042,209002,199019,205163,199020,202348,199021,202349,205165,199022,202350,204398,202351,199024,202352,204400,199025,202353,203633,199026,203634,204402,195954,199027,195955,199028,203636,195956,199029,203637,195957,199030,199031,203639,195959,199032,203640,210040,195960,199033,195961,199034,200058,195962,199035,200059,195963,199036,195964,199037,210045,199038,208510,195966,199039,195967,199040,208512,195968,199041,195969,199042,195970,199043,208515,195971,199044,205700,199045,205701,208517,209797,195973,205702,195974,205703,201352,205704,195976,201353,208521,195977,209802,195978,201355,195979,201356,195980,201357,208525,209805,195981,201358,207247,209295,209807,195983,200848,195984,198033,200849,201361,209809,198034,201362,208530,209298,198035,207251,209811,198036,208532,198037,209301,198038,209814,208535,198040,209304,198041,208537,209817,200346,207258,209306,198043,200347,209819,198044,200605,209309,199838,200350,200606,198047,199839,200351,200607,198048,200608,203168,196256,200609,203169,196257,198050,200610,198051,200611,195491,200612,201124,202916,195492,196260,198053,200613,201125,202917,195493,196261,198054,200614,195494,198055,200615,196263,198056,200616,196264,198057,200617,196265,198058,200618,196266,200619,196267,200620,196268,200621,196269,200622,204206,196270,204207,200624,201392,200625,201393,204209,200627,200628,200629,200630,200631,200632,210367,206528,206529,202692,206532,210373,196549,202694,196550,202695,196552,210377,196553,201930,196554,201931,210379,194763,196555,194764,196556,201933,196557,201934,196558,201935,202447,196559,201936,202448,201937,201938,201171,201172,204510,199135,205279,199136,205536,205537,201699,205283,201700,195812,205285,195813,195814,195815,195816,195305,195817,195306,195818,195307,195819,195308,195309,195821,195310,195822,195311,195823,206320,195312,195824,204017,206321,206322,204019,195061,195063,197373,200189,197374,200190,197375,198399,56403,56427,108403,108405,67901,68449,105318,89757,51935,98642,98639,52783,75012,75001,74927,74985,55796,70444,98830,98845,52092,61477,61478,52239,98433,68750,69966,68475,68486,69311,99856,102045,102061,113993,114078,101952,89877,170644,161274,111395,110410,110416,185702,177644,90263,82735,115459,115439,144438,103700,168567,141897,124877,188077,79754,79575,99194,102050,102059,77036,124323,58497,58501,65443,105315,144189,144191,93723,78133,78216,187423,182996,174956,64135,64139,103706,163227,63221,63223,177743,132165,132167,132169,132171,118127,118128,118129,118130,108053,108055,113945,156968,59212,58777,175671,82999,83022,102460,102462,145780,145783,101938,101940,184651,182889,131724,183775,59208,58780,123058,123060,123062,123064,118122,118123,118124,118125,120916,120918,120920,120922,95081,100947,102485,102486,101002,84272,185634,185785,137131,56206,156599,194507,187794,105307,105309,164298,75043,156491,80406,71548,71550,98915,174854,64265,64267,144502,87175,178673,106859,106861,99279,99580,149856,149858,100774,106020,106021,96054,91097,57127,77608,57131,82490,57519,57521,178111,178114,79560,86483,75224,80215,98007,98033,75880,106588,106589,185856,93421,185849,185852,124874,65351,65354,102408,98836,98841,98849,98851,71204,98853,82746,98659,62827,71811,65703,63916,65709,63923,98762,77303,71163,97436,105589,105682,100926,112913,98665,103584,98764,104908,112354,70269,99588,83024,77910,114080,99576,73590,73592,80098,53736,89691,164301,164302,156470,155989,83169,54871,86286,83853,177451,185661,187457,187460,180586,181355,183919,188046,180629,183194,184220,185756,181415,186029,187309,187334,183771,185821,184806,177896,182763,179440,187464,187011,182434,187797,157885,100955,101004,153634,138624,143847,96260,96262,78283,75792,176820,102018,102019,149893,87551,86734,97866,97875,164899,164901,132722,99003,66283,66286,60146,139550,139552,76576,139554,104677,104678,66880,66883,177949,65472,65478,175667,56671,56737,97911,97990,163995,163997,177635,177639,185326,66168,66288,76364,103072,101359,77891,77798,91286,91363,111433,213269,104680,104681,146435,70456,75702,75972,108050,108051,76368,76371,115935,115936,115937,144901,68923,68926,88186,88188,110311,110332,55799,55801,65072,64941,149584,80065,185313,87737,100780,100930,100964,100994,101018,188100,64937,64685,104131,156458,81711,81402,81436,81713,166599,78280,80937,120876,120878,120880,120882,120885,120887,103704,103708,127631,62357,62361,57064,57066,52787,211961,104497,165971,81423,81715,97370,85305,85309,53299,104150,176420,147768,102466,102468,102470,134409,134411,134413,134415,134474,177260,85240,78807,160377,88852,88813,75749,85409,86383,161090,57052,57059,61242,61243,75875,92487,92490,111125,111127,83327,83330,89754,89760,89764,104451,65124,65126,65128,111130,111132,111135,111137,119040,119296,120064,120320,119297,119809,120065,119043,120323,119556,119812,120068,119301,119557,119046,119303,119815,120071,120328,119049,119306,119562,119818,120074,120330,119563,119052,120332,119309,119821,120077,120333,119566,120334,119055,120335,119312,119824,120080,120336,119569,120337,119058,119315,119827,119572,119061,120085,119318,119830,120086,119064,119577,119578,119834,119067,119323,120091,119324,119836,120092,119581,119070,119327,120096,119073,119585,119841,120098,119331,119587,119843,119076,119844,119333,120101,119079,119592,120104,119593,119082,119338,119339,119851,120107,119596,119852,119085,119853,119343,119599,120111,119088,119856,119345,120113,119602,119091,119348,120116,119605,119094,119863,119608,119864,119097,119353,119865,120121,118842,119354,120122,119100,118845,119357,119613,120125,106302,119614,119870,106303,119103,118848,119872,120128,106305,119617,106306,119106,119362,118851,119363,120131,106308,119620,106309,119109,118854,119366,119878,119111,119879,120135,119624,118857,120137,119626,119882,119371,118860,119116,119372,119117,120142,118863,119375,119631,119887,120143,119120,119632,119888,118866,119378,119891,119124,120148,118869,119381,119637,120149,119126,119638,118872,119896,119641,119897,119386,120154,118875,119131,119387,120155,119132,119900,118878,119646,120158,119391,119647,118881,119137,119393,119905,120161,119138,119906,118884,119396,119652,120164,119141,119653,118887,119911,120167,119144,119400,119912,118890,119402,119658,120170,119147,119659,119915,1188<\/p>\n","protected":false},"template":"","class_list":["post-1389014","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KILLED QUERY error leading to timeouts -<\/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\/killed-query-error-leading-to-timeouts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KILLED QUERY error leading to timeouts -\" \/>\n<meta property=\"og:description\" content=\"Hello, After the last Community Events and Events Calendar Pro updates, i&#8217;m getting the killed query update similar to the one described here. Problem is, I get this error when attempting to edit any event (front end displays fine), so I can&#8217;t accept new events submitted by our community. Any solution? We are using WP [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/\",\"name\":\"KILLED QUERY error leading to timeouts -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2017-11-22T15:14:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/#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\":\"KILLED QUERY error leading to timeouts\"}]},{\"@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":"KILLED QUERY error leading to timeouts -","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\/killed-query-error-leading-to-timeouts\/","og_locale":"en_US","og_type":"article","og_title":"KILLED QUERY error leading to timeouts -","og_description":"Hello, After the last Community Events and Events Calendar Pro updates, i&#8217;m getting the killed query update similar to the one described here. Problem is, I get this error when attempting to edit any event (front end displays fine), so I can&#8217;t accept new events submitted by our community. Any solution? We are using WP [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/","name":"KILLED QUERY error leading to timeouts -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2017-11-22T15:14:04+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/killed-query-error-leading-to-timeouts\/#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":"KILLED QUERY error leading to timeouts"}]},{"@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\/1389014","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":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1389014\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1389014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}