{"id":1460495,"date":"2018-02-21T17:02:14","date_gmt":"2018-02-22T01:02:14","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/"},"modified":"2018-02-21T17:02:14","modified_gmt":"2018-02-22T01:02:14","slug":"long-running-processes-getting-killed-off-by-wp-engine","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/","title":{"rendered":"Long running processes getting killed off by WP Engine"},"content":{"rendered":"<p>I&#8217;ve been checking the logs on my WP Engine account, and it appears that something related to the lat\/long lookup within Events Calendar Pro is taking a very long time. As there&#8217;s generally only 1 main location for our events at my clients studio, I&#8217;d even be down for just disabling that within the plugin. Perhaps a checkbox for this function could be added to the settings?<\/p>\n<p>Seems like there&#8217;s a lot of other issues regarding performance in the forums, but they&#8217;re marked as private so I can&#8217;t see what the resolvement is for that.<\/p>\n<p>the site is https:\/\/yogaunioncwc.com\/events-yoga-union\/<\/p>\n<p>here&#8217;s an example of that error log message:<\/p>\n<p>Wed Feb 21 22:10:05.182780 2018] [:error] [pid 32733] [client 54.37.85.61:32924] KILLED QUERY (34557 characters long generated in \/nas\/content\/live\/yogaunion3\/wp-content\/plugins\/events-calendar-pro\/src\/Tribe\/Geo_Loc.php:948): \\n\\t\\t\\t\\t\\tSELECT\\n\\t\\t\\t\\t\\t\\tMAX( <code>coords<\/code>.<code>lat<\/code> ) AS <code>max_lat<\/code>,\\n\\t\\t\\t\\t\\t\\tMAX( <code>coords<\/code>.<code>lng<\/code> ) AS <code>max_lng<\/code>,\\n\\t\\t\\t\\t\\t\\tMIN( <code>coords<\/code>.<code>lat<\/code> ) AS <code>min_lat<\/code>,\\n\\t\\t\\t\\t\\t\\tMIN( <code>coords<\/code>.<code>lng<\/code> ) AS <code>min_lng<\/code>\\n\\t\\t\\t\\t\\tFROM (\\n\\t\\t\\t\\t\\t\\tSELECT <code>post_id<\/code> AS <code>venue_id<\/code>,\\n\\t\\t\\t\\t\\t\\t\\tCASE\\n\\t\\t\\t\\t\\t\\t\\tWHEN <code>meta_key<\/code> = &#8216;_VenueLat&#8217;\\n\\t\\t\\t\\t\\t\\t\\t\\tTHEN CAST( <code>meta_value<\/code> AS DECIMAL( 10, 6 ) )\\n\\t\\t\\t\\t\\t\\t\\tEND AS <code>lat<\/code>,\\n\\t\\t\\t\\t\\t\\t\\tCASE\\n\\t\\t\\t\\t\\t\\t\\t\\tWHEN <code>meta_key<\/code> = &#8216;_VenueLng&#8217;\\n\\t\\t\\t\\t\\t\\t\\t\\tTHEN CAST( <code>meta_value<\/code> AS DECIMAL( 10, 6 ) )\\n\\t\\t\\t\\t\\t\\t\\tEND AS <code>lng<\/code>\\n\\t\\t\\t\\t\\t\\tFROM <code>wp_postmeta<\/code>\\n\\t\\t\\t\\t\\t\\tWHERE\\n\\t\\t\\t\\t\\t\\t\\t(\\n\\t\\t\\t\\t\\t\\t\\t\\t<code>meta_key<\/code> = &#8216;_VenueLat&#8217;\\n\\t\\t\\t\\t\\t\\t\\t\\tOR <code>meta_key<\/code> = &#8216;_VenueLng&#8217;\\n\\t\\t\\t\\t\\t\\t\\t)\\n\\t\\t\\t\\t\\t\\t\\tAND <code>post_id<\/code> IN (\\n\\t\\t\\t\\t\\t\\t\\t\\tSELECT <code>meta_value<\/code>\\n\\t\\t\\t\\t\\t\\t\\t\\tFROM <code>wp_postmeta<\/code>\\n\\t\\t\\t\\t\\t\\t\\t\\tWHERE\\n\\t\\t\\t\\t\\t\\t\\t\\t\\t<code>meta_key<\/code> = &#8216;_EventVenueID&#8217;\\n\\t\\t\\t\\t\\t\\t\\t\\t\\tAND <code>post_id<\/code> IN ( 13649, 13657, 13706, 13708, 13724, 13741, 13755, 13757, 13758, 13759, 13765, 13767, 13769, 13770, 13771, 13772, 13773, 13810, 13813, 13818, 13819, 13820, 13821, 13822, 13831, 13834, 13835, 13836, 13837, 13838, 13839, 13840, 13841, 13842, 13843, 13845, 13846, 13847, 13848, 13889, 13903, 13904, 13905, 13906, 13908, 13909, 13936, 13938, 13940, 13945, 13947, 13948, 13950, 13951, 13952, 13953, 13954, 13955, 13956, 13957, 13958, 13963, 13974, 13997, 13999, 14000, 14001, 14002, 14003, 14006, 14008, 14009, 14010, 14011, 14014, 14015, 14016, 14017, 14018, 14019, 14020, 14041, 14043, 14044, 14045, 14046, 14047, 14048, 14052, 14070, 14099, 14383, 14385, 14387, 14389, 14392, 14402, 14410, 14421, 14423, 14424, 14425, 14426, 14427, 14430, 14432, 14444, 14447, 14592, 14596, 14625, 14627, 14628, 14629, 14633, 14646, 14652, 14655, 14657, 14742, 14756, 14762, 14766, 14806, 14812, 14834, 14836, 14838, 14843, 14846, 14854, 15107, 15138, 15139, 15140, 15141, 15142, 15143, 15144, 15145, 15149, 15151, 15175, 15176, 15177, 15183, 15188, 15204, 15240, 15255, 15258, 15259, 15260, 15270, 15604, 15634, 15651, 15653, 15654, 15655, 15656, 15657, 15658, 15659, 15660, 15661, 15672, 15677, 15680, 15681, 15695, 15696, 15697, 15698, 15699, 15700, 15706, 15709, 15710, 15711, 15712, 15763, 15764, 15765, 15766, 15767, 15984, 15985, 15986, 15987, 15988, 15989, 15990, 15991, 15992, 15993, 15994, 15995, 15996, 15997, 15998, 15999, 16000, 16001, 16002, 16003, 16004, 16005, 16006, 16007, 16008, 16009, 16010, 16011, 16012, 16013, 16014, 16015, 16016, 16017, 16018, 16019, 16020, 16021, 16022, 16023, 16024, 16025, 16026, 16027, 16028, 16029, 16030, 16031, 16032, 16044, 16067, 16068, 16069, 16070, 16071, 16072, 16073, 16074, 16075, 16076, 16077, 16078, 16079, 16080, 16081, 16082, 16083, 16084, 16085, 16086, 16087, 16088, 16089, 16090, 16091, 16092, 16093, 16105, 16106, 16107, 16108, 16109, 16110, 16111, 16112, 16113, 16114, 16353, 16769, 16772, 16773, 16774, 16775, 16776, 16777, 16778, 16779, 16780, 16781, 16782, 16783, 16784, 16785, 16786, 16787, 16788, 16789, 16790, 16791, 16792, 16793, 16794, 16795, 16796, 16797, 16798, 16799, 16800, 16801, 16802, 16803, 16804, 16805, 16806, 16807, 16808, 16809, 16810, 16824, 16841, 16975, 16976, 16977, 16978, 16979, 16980, 16981, 16982, 16983, 16984, 16985, 16986, 16987, 16988, 17819, 17840, 17844, 17848, 18034, 18078, 18090, 18093, 18094, 18095, 18132, 18134, 18150, 18162, 18165, 18166, 18246, 18316, 18319, 18320, 18321, 18322, 18323, 18326, 18329, 18330, 18331, 18332, 18333, 18334, 18335, 18336, 18337, 18338, 18339, 18340, 18361, 18364, 18365, 18366, 18370, 18373, 18374, 18375, 18376, 18377, 18378, 18379, 18380, 18381, 18461, 18616, 18617, 18618, 18619, 18620, 18621, 18622, 18623, 18624, 18625, 18626, 18627, 18628, 18629, 18630, 18631, 18632, 18633, 18634, 18635, 18636, 18637, 18638, 18639, 18640, 18641, 18642, 18643, 18644, 18645, 18646, 18647, 18648, 18649, 18650, 18651, 18652, 18653, 18654, 18655, 18656, 18657, 18658, 18659, 18660, 18661, 18662, 18663, 18664, 18665, 18666, 18667, 18668, 18669, 18670, 18671, 18672, 18673, 18674, 18675, 18676, 18677, 18678, 18679, 18680, 18681, 18682, 18683, 18684, 18685, 18686, 18687, 18688, 18689, 18690, 18691, 18692, 18693, 18694, 18695, 18696, 18697, 18698, 18699, 18700, 18701, 18702, 18703, 18704, 18705, 18706, 18707, 18708, 18709, 18710, 18711, 18712, 18713, 18714, 18715, 18716, 18717, 18721, 18723, 18725, 18726, 18727, 18728, 18729, 18730, 18731, 18732, 18733, 18734, 18735, 18750, 18755, 18758, 18768, 18771, 18854, 18866, 18876, 18881, 18885, 18890, 18894, 18897, 18903, 18914, 18919, 18940, 18943, 18945, 18948, 18949, 18950, 18951, 18952, 18964, 18979, 18980, 18981, 18987, 19072, 19075, 19076, 19077, 19078, 19079, 19080, 19081, 19082, 19083, 19084, 19087, 19088, 19089, 19090, 19091, 19092, 19093, 19094, 19095, 19096, 19100, 19105, 19106, 19108, 19111, 19114, 19116, 19118, 19119, 19120, 19125, 19128, 19131, 19133, 19136, 19137, 19149, 19154, 19159, 19167, 19168, 19169, 19170, 19171, 19172, 19173, 19174, 19175, 19176, 19177, 19178, 19179, 19180, 19181, 19182, 19183, 19184, 19185, 19186, 19187, 19188, 19189, 19190, 19191, 19192, 19193, 19194, 19195, 19196, 19197, 19198, 19199, 19200, 19201, 19202, 19203, 19204, 19205, 19206, 19207, 19208, 19209, 19210, 19211, 19212, 19213, 19214, 19215, 19216, 19217, 19218, 19219, 19220, 19221, 19222, 19223, 19224, 19225, 19226, 19227, 19228, 19229, 19230, 19231, 19232, 19233, 19234, 19235, 19236, 19237, 19238, 19239, 19240, 19241, 19242, 19243, 19244, 19245, 19246, 19247, 19248, 19249, 19250, 19251, 19252, 19253, 19254, 19255, 19256, 19257, 19259, 19260, 19261, 19262, 19263, 19264, 19265, 19266, 19267, 19268, 19269, 19270, 19271, 19272, 19273, 19274, 19275, 19276, 19277, 19278, 19279, 19280, 19281, 19282, 19283, 19284, 19285, 19286, 19287, 19288, 19289, 19291, 19292, 19293, 19294, 19295, 19296, 19297, 19298, 19299, 19300, 19301, 19302, 19303, 19304, 19305, 19306, 19307, 19308, 19309, 19310, 19311, 19313, 19314, 19315, 19316, 19317, 19318, 19319, 19320, 19321, 19322, 19323, 19324, 19325, 19326, 19327, 19328, 19329, 19330, 19331, 19332, 19333, 19334, 19335, 19336, 19337, 19338, 19339, 19340, 19341, 19342, 19344, 19345, 19346, 19347, 19348, 19349, 19350, 19351, 19352, 19353, 19354, 19355, 19356, 19357, 19358, 19359, 19360, 19361, 19362, 19363, 19364, 19365, 19366, 19367, 19368, 19369, 19370, 19371, 19372, 19374, 19375, 19376, 19377, 19378, 19379, 19380, 19381, 19382, 19383, 19384, 19385, 19386, 19387, 19388, 19389, 19390, 19391, 19392, 19393, 19394, 19395, 19398, 19399, 19400, 19401, 19402, 19403, 19404, 19405, 19406, 19407, 19408, 19409, 19410, 19411, 19412, 19413, 19414, 19415, 19416, 19417, 19418, 19419, 19420, 19421, 19422, 19423, 19424, 19425, 19426, 19427, 19428, 19429, 19430, 19431, 19432, 19433, 19435, 19436, 19437, 19438, 19439, 19440, 19441, 19442, 19443, 19444, 19445, 19446, 19447, 19448, 19449, 19450, 19451, 19452, 19453, 19454, 19455, 19456, 19457, 19458, 19459, 19460, 19461, 19462, 19463, 19464, 19465, 19466, 19467, 19468, 19469, 19471, 19472, 19473, 19474, 19475, 19476, 19477, 19478, 19479, 19480, 19481, 19482, 19483, 19484, 19485, 19486, 19487, 19488, 19489, 19490, 19491, 19492, 19494, 19495, 19496, 19497, 19498, 19499, 19500, 19501, 19502, 19503, 19504, 19505, 19506, 19507, 19508, 19509, 19510, 19511, 19512, 19513, 19515, 19516, 19517, 19518, 19519, 19520, 19521, 19522, 19523, 19524, 19525, 19526, 19527, 19528, 19529, 19530, 19531, 19532, 19533, 19534, 19535, 19536, 19537, 19538, 19539, 19540, 19541, 19542, 19543, 19544, 19545, 19546, 19547, 19548, 19549, 19550, 19551, 19552, 19553, 19554, 19555, 19556, 19557, 19558, 19559, 19560, 19561, 19562, 19563, 19564, 19565, 19566, 19567, 19568, 19569, 19570, 19571, 19572, 19573, 19574, 19576, 19577, 19578, 19579, 19580, 19581, 19582, 19583, 19584, 19585, 19586, 19587, 19588, 19589, 19590, 19591, 19592, 19593, 19594, 19595, 19596, 19597, 19598, 19600, 19601, 19602, 19603, 19604, 19605, 19606, 19607, 19608, 19609, 19610, 19611, 1961<\/p>\n","protected":false},"template":"","class_list":["post-1460495","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>Long running processes getting killed off by WP Engine -<\/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\/long-running-processes-getting-killed-off-by-wp-engine\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Long running processes getting killed off by WP Engine -\" \/>\n<meta property=\"og:description\" content=\"I&#8217;ve been checking the logs on my WP Engine account, and it appears that something related to the lat\/long lookup within Events Calendar Pro is taking a very long time. As there&#8217;s generally only 1 main location for our events at my clients studio, I&#8217;d even be down for just disabling that within the plugin. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/\" \/>\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\/long-running-processes-getting-killed-off-by-wp-engine\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/\",\"name\":\"Long running processes getting killed off by WP Engine -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2018-02-22T01:02:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/#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\":\"Long running processes getting killed off by WP Engine\"}]},{\"@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":"Long running processes getting killed off by WP Engine -","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\/long-running-processes-getting-killed-off-by-wp-engine\/","og_locale":"en_US","og_type":"article","og_title":"Long running processes getting killed off by WP Engine -","og_description":"I&#8217;ve been checking the logs on my WP Engine account, and it appears that something related to the lat\/long lookup within Events Calendar Pro is taking a very long time. As there&#8217;s generally only 1 main location for our events at my clients studio, I&#8217;d even be down for just disabling that within the plugin. [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/","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\/long-running-processes-getting-killed-off-by-wp-engine\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/","name":"Long running processes getting killed off by WP Engine -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2018-02-22T01:02:14+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-running-processes-getting-killed-off-by-wp-engine\/#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":"Long running processes getting killed off by WP Engine"}]},{"@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\/1460495","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\/1460495\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1460495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}