KILLED QUERY on WP Engine

Resolved
(@bigbugsy)
I’ve noticed there are several WooCommerce-related KILLED QUERY errors in our log each night.
From WP Engine:
https://wpengine.com/support/troubleshoot-wordpress-wp-engine-error-log/#error_KILLED_QUERY
“The KILLED QUERY error specifies 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 run on a production database.”
What is this? How can I resolve it?
Thanks!
Example errors:
{

  "installName": "removed_for_privacy",

  "environment": "PROD",

  "type": "error",

  "date": "2025-02-23T07:29:33.445Z",

  "severity": null,

  "client": null,

  "message": "KILLED QUERY (24126 characters long generated in /nas/content/live/removed_for_privacy/wp-content/plugins/woocommerce/includes/data-stores/class-wc-order-data-store-cpt.php:1088): SELECT DISTINCT t.term_id, tr.object_id#012#011#011#011 FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id#012#011#011#011 WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (118547, 118543, 118544, 118541, 118538, 118535, 118532, 118523, 118508, 118504, 118505, 118501, 118502, 118495, 118487, 118478, 118466, 118458, 118449, 118439, 118432, 118429, 118425, 118414, 118380, 118375, 118371, 118368, 118364, 118365, 118362, 118361, 118350, 118351, 118347, 118348, 118343, 118340, 118324, 118320, 118321, 118292, 118289, 118286, 118280, 118276, 118270, 118266, 118267, 118263, 118264, 118261, 118255, 118251, 118227, 118208, 118191, 118187, 118183, 118184, 118173, 118163, 118148, 118149, 118140, 118136, 118129, 118094, 118076, 118058, 118048, 118032, 118015, 118016, 118012, 117993, 117990, 117971, 117960, 117956, 117957, 117953, 117954, 117934, 117935, 117920, 117914, 117910, 117911, 117907, 117908, 117904, 117905, 117901, 117893, 117890, 117882, 117876, 117873, 117866, 117862, 117855, 117844, 117842, 117833, 117824, 117821, 117817, 117818, 117814, 117815, 117776, 117770, 117767, 117759, 117744, 117741, 117732, 117721, 117715, 117708, 117695, 117692, 117685, 117676, 117648, 117633, 117612, 117599, 117579, 117576, 117573, 117570, 117556, 117548, 117541, 117535, 117519, 117516, 117511, 117506, 117499, 117469, 117465, 117440, 117418, 117415, 117410, 117393, 117388, 117379, 117370, 117361, 117338, 117318, 117310, 117285, 117269, 117247, 117235, 117230, 117226, 117219, 117211, 117208, 117196, 117191, 117188, 117187, 117184, 117185, 117181, 117182, 117179, 117178, 117152, 117134, 117130, 117104, 117091, 117054, 117055, 117052, 117039, 117021, 117018, 117013, 117009, 117004, 116999, 116996, 116992, 116985, 116972, 116968, 116963, 116957, 116924, 116920, 116904, 116895, 116889, 116880, 116873, 116864, 116856, 116857, 116851, 116847, 116803, 116752, 116697, 116682, 116658, 116639, 116635, 116636, 116632, 116633, 116576, 116533, 116518, 116510, 116506, 116507, 116484, 116477, 116476, 116473, 116474, 116471, 116468, 116458, 116443, 116436, 116417, 116404, 116401, 116392, 116374, 116315, 116311, 116299, 116300, 116291, 116263, 116185, 116180, 116170, 116154, 116145, 116129, 116124, 116108, 116105, 116093, 116094, 116074, 116047, 116029, 116025, 116006, 115997, 115978, 115975, 115962, 115947, 115939, 115897, 115894, 115877, 115878, 115874, 115875, 115871, 115872, 115852, 115833, 115828, 115824, 115825, 115822, 115817, 115786, 115783, 115780, 115768, 115738, 115733, 115706, 115675, 115668, 115540, 115506, 115490, 115468, 115450, 115446, 115380, 115375, 115330, 115288, 115273, 115261, 115177, 115158, 115149, 115109, 115046, 115042, 114980, 114927, 114867, 114837, 114806, 114782, 114776, 114764, 114754, 114751, 114718, 114712, 114702, 114682, 114683, 114658, 114630, 114631, 114627, 114628, 114624, 114625, 114621, 114622, 114618, 114619, 114586, 114576, 114574, 114567, 114561, 114555, 114543, 114528, 114514, 114497, 114492, 114484, 114465, 114387, 114384, 114366, 114365, 114323, 114320, 114308, 114302, 114293, 114275, 114256, 114257, 114250, 114243, 114244, 114226, 114218, 114192, 114187, 114127, 114116, 114097, 114082, 114072, 114067, 114055, 114052, 114036, 113990, 113970, 113960, 113957, 113936, 113916, 113913, 113904, 113901, 113882, 113876, 113872, 113873, 113868, 113827, 113828, 113806, 113803, 113776, 113686, 113635, 113613, 113612, 113607, 113608, 113567, 113538, 113539, 113520, 113503, 113448, 113435, 113416, 113303, 113278, 113197, 113193, 113194, 113191, 113171, 113172, 113140, 113102, 113058, 113049, 113050, 113030, 113019, 112975, 112960, 112936, 112872, 112871, 112869, 112868, 112802, 112505, 112504, 112487, 112397, 112398, 112287, 112247, 112246, 112134, 112133, 111557, 111556, 111480, 111476, 111477, 111436, 111430, 111317, 111171, 111170, 110980, 110682, 110683, 110631, 110592, 110593, 110303, 110302, 110132, 110133, 110053, 110052, 110019, 110018, 110015, 110016, 109994, 109995, 109860, 109861, 109704, 109705, 109701, 109702, 109698, 109699, 109655, 109656, 109455, 109456, 109452, 109453, 109444, 109443, 109440, 109441, 109419, 109420, 109150, 109151, 109086, 109085, 108723, 108574, 108575, 108314, 108313, 108310, 108311, 107870, 107871, 107824, 107746, 107747, 107742, 107722, 107723, 107545, 107546, 107542, 107543, 107334, 107335, 107120, 107121, 106716, 106717, 106714, 106713, 106636, 106637, 106633, 106634, 106630, 106631, 106628, 106627, 106624, 106625, 106619, 106618, 106477, 106478, 106417, 106418, 106414, 106415, 106411, 106412, 106405, 106406, 106402, 106403, 106399, 106400, 106397, 106396, 106394, 106393, 106269, 106270, 106196, 106195, 106033, 106034, 106030, 106031, 106027, 106028, 106024, 106025, 105966, 105967, 105963, 105964, 105960, 105961, 105943, 105942, 105939, 105940, 105936, 105937, 105933, 105934, 105930, 105931, 105927, 105928, 105924, 105925, 105922, 105921, 105887, 105886, 105804, 105805, 105652, 105653, 105646, 105645, 104588, 104589, 104405, 103887, 103888, 103485, 103486, 103367, 103366, 103350, 102954, 102953, 102951, 102950, 102889, 102888, 102603, 102181, 102180, 102177, 102178, 101463, 101464, 101002, 101001, 100557, 100558, 100503, 100504, 100500, 100501, 100316, 100317, 100274, 100275, 100261, 100262, 100258, 100259, 100256, 100165, 100166, 100118, 100117, 99774, 99775, 99628, 99627, 99536, 99537, 99531, 99530, 99524, 99525, 99357, 99356, 99350, 99351, 99297, 99296, 99290, 99291, 98724, 98723, 98718, 98717, 98712, 98711, 98706, 98705, 98699, 98700, 98694, 98693, 97785, 97786, 97779, 97780, 97773, 97774, 96900, 96901, 96895, 96894, 96888, 96889, 96869, 96763, 96764, 96537, 96538, 96499, 96500, 95188, 95187, 94127, 94128, 94121, 94122, 94070, 94071, 93640, 93641, 93503, 93502, 93483, 93484, 93477, 93478, 93444, 93443, 92556, 92557, 92550, 92551, 92475, 92476, 91963, 91964, 91703, 91702, 91616, 91617, 91609, 91610, 91565, 91459, 91460, 91453, 91454, 91447, 91446, 90654, 90655, 90019, 90020, 89979, 89980, 89931, 89932, 89650, 89651, 89366, 89365, 89206, 88986, 88987, 88038, 88039, 85615, 85387, 85388, 85381, 85382, 85375, 85376, 85370, 85369, 85363, 85364, 85284, 85285, 85277, 84860, 84861, 84409, 84410, 83777, 83778, 83063, 83064, 82995, 82996, 82989, 82990, 82983, 82984, 82977, 82978, 82291, 82292, 82212, 82213, 81843, 81844, 81543, 81544, 81537, 81538, 81320, 81321, 81314, 81315, 81028, 81027, 80080, 80081, 79671, 79672, 79231, 79232, 79096, 79097, 79090, 79091, 79083, 79084, 78567, 78568, 78367, 78368, 78103, 78104, 77706, 77707, 77700, 77701, 77212, 77213, 76768, 76769, 76631, 76630, 76199, 76200, 75525, 75526, 75519, 75520, 75514, 75513, 75173, 75174, 75046, 75045, 74666, 74665, 74252, 74253, 74006, 74007, 74000, 74001, 73994, 73995, 73986, 73987, 73682, 73683, 73134, 73135, 72547, 71794, 71795, 71592, 71593, 71586, 71587, 71580, 71581, 71325, 71326, 71260, 71261, 71254, 71255, 70987, 70988, 69813, 69814, 69806, 69807, 69800, 69801, 69795, 69794, 69788, 69789, 69498, 69497, 69434, 69435, 69293, 69294, 69288, 69289, 69230, 69231, 69070, 69071, 69003, 69004, 68998, 68999, 68688, 68689, 68683, 68684, 66741, 66742, 66060, 66061, 66006, 66007, 65988, 65989, 65957, 65958, 65779, 65780, 65520, 65521, 65412, 65411, 64816, 64815, 64665, 64666, 64622, 64623, 64391, 64392, 64386, 64387, 63718, 63719, 62472, 62473, 62467, 62468, 62271, 62272, 61842, 60694, 60695, 60689, 60690, 60597, 60598, 60592, 60591, 59853, 59852, 59831, 59832, 59459, 59460, 59041, 59042, 58888, 58887, 58300, 58301, 57071, 57072, 56414, 56415, 56082, 56083, 55835, 55836, 55830, 55831, 55826, 55825, 55427, 55426, 54429, 54430, 54424, 54425, 54419, 54420, 53893, 53894, 53743, 53744, 53487, 53488, 53482, 53483, 53328, 53329, 53037, 52718, 52719, 52428, 52427, 51423, 51424, 50563, 50564, 50102, 49595, ",

  "uuid": "bb7d8342-bb03-4671-8086-9f880ccd0bae"

}

{

  "installName": "removed_for_privacy",

  "environment": "PROD",

  "type": "error",

  "date": "2025-02-23T07:30:37.230Z",

  "severity": null,

  "client": null,

  "message": "KILLED QUERY (20586 characters long generated in /nas/content/live/removed_for_privacy/wp-content/plugins/woocommerce/includes/data-stores/class-wc-order-data-store-cpt.php:1082): SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (118547,118543,118544,118541,118538,118535,118532,118523,118508,118504,118505,118501,118502,118495,118487,118478,118466,118458,118449,118439,118432,118429,118425,118414,118380,118375,118371,118368,118364,118365,118362,118361,118350,118351,118347,118348,118343,118340,118324,118320,118321,118292,118289,118286,118280,118276,118270,118266,118267,118263,118264,118261,118255,118251,118227,118208,118191,118187,118183,118184,118173,118163,118148,118149,118140,118136,118129,118094,118076,118058,118048,118032,118015,118016,118012,117993,117990,117971,117960,117956,117957,117953,117954,117934,117935,117920,117914,117910,117911,117907,117908,117904,117905,117901,117893,117890,117882,117876,117873,117866,117862,117855,117844,117842,117833,117824,117821,117817,117818,117814,117815,117776,117770,117767,117759,117744,117741,117732,117721,117715,117708,117695,117692,117685,117676,117648,117633,117612,117599,117579,117576,117573,117570,117556,117548,117541,117535,117519,117516,117511,117506,117499,117469,117465,117440,117418,117415,117410,117393,117388,117379,117370,117361,117338,117318,117310,117285,117269,117247,117235,117230,117226,117219,117211,117208,117196,117191,117188,117187,117184,117185,117181,117182,117179,117178,117152,117134,117130,117104,117091,117054,117055,117052,117039,117021,117018,117013,117009,117004,116999,116996,116992,116985,116972,116968,116963,116957,116924,116920,116904,116895,116889,116880,116873,116864,116856,116857,116851,116847,116803,116752,116697,116682,116658,116639,116635,116636,116632,116633,116576,116533,116518,116510,116506,116507,116484,116477,116476,116473,116474,116471,116468,116458,116443,116436,116417,116404,116401,116392,116374,116315,116311,116299,116300,116291,116263,116185,116180,116170,116154,116145,116129,116124,116108,116105,116093,116094,116074,116047,116029,116025,116006,115997,115978,115975,115962,115947,115939,115897,115894,115877,115878,115874,115875,115871,115872,115852,115833,115828,115824,115825,115822,115817,115786,115783,115780,115768,115738,115733,115706,115675,115668,115540,115506,115490,115468,115450,115446,115380,115375,115330,115288,115273,115261,115177,115158,115149,115109,115046,115042,114980,114927,114867,114837,114806,114782,114776,114764,114754,114751,114718,114712,114702,114682,114683,114658,114630,114631,114627,114628,114624,114625,114621,114622,114618,114619,114586,114576,114574,114567,114561,114555,114543,114528,114514,114497,114492,114484,114465,114387,114384,114366,114365,114323,114320,114308,114302,114293,114275,114256,114257,114250,114243,114244,114226,114218,114192,114187,114127,114116,114097,114082,114072,114067,114055,114052,114036,113990,113970,113960,113957,113936,113916,113913,113904,113901,113882,113876,113872,113873,113868,113827,113828,113806,113803,113776,113686,113635,113613,113612,113607,113608,113567,113538,113539,113520,113503,113448,113435,113416,113303,113278,113197,113193,113194,113191,113171,113172,113140,113102,113058,113049,113050,113030,113019,112975,112960,112936,112872,112871,112869,112868,112802,112505,112504,112487,112397,112398,112287,112247,112246,112134,112133,111557,111556,111480,111476,111477,111436,111430,111317,111171,111170,110980,110682,110683,110631,110592,110593,110303,110302,110132,110133,110053,110052,110019,110018,110015,110016,109994,109995,109860,109861,109704,109705,109701,109702,109698,109699,109655,109656,109455,109456,109452,109453,109444,109443,109440,109441,109419,109420,109150,109151,109086,109085,108723,108574,108575,108314,108313,108310,108311,107870,107871,107824,107746,107747,107742,107722,107723,107545,107546,107542,107543,107334,107335,107120,107121,106716,106717,106714,106713,106636,106637,106633,106634,106630,106631,106628,106627,106624,106625,106619,106618,106477,106478,106417,106418,106414,106415,106411,106412,106405,106406,106402,106403,106399,106400,106397,106396,106394,106393,106269,106270,106196,106195,106033,106034,106030,106031,106027,106028,106024,106025,105966,105967,105963,105964,105960,105961,105943,105942,105939,105940,105936,105937,105933,105934,105930,105931,105927,105928,105924,105925,105922,105921,105887,105886,105804,105805,105652,105653,105646,105645,104588,104589,104405,103887,103888,103485,103486,103367,103366,103350,102954,102953,102951,102950,102889,102888,102603,102181,102180,102177,102178,101463,101464,101002,101001,100557,100558,100503,100504,100500,100501,100316,100317,100274,100275,100261,100262,100258,100259,100256,100165,100166,100118,100117,99774,99775,99628,99627,99536,99537,99531,99530,99524,99525,99357,99356,99350,99351,99297,99296,99290,99291,98724,98723,98718,98717,98712,98711,98706,98705,98699,98700,98694,98693,97785,97786,97779,97780,97773,97774,96900,96901,96895,96894,96888,96889,96869,96763,96764,96537,96538,96499,96500,95188,95187,94127,94128,94121,94122,94070,94071,93640,93641,93503,93502,93483,93484,93477,93478,93444,93443,92556,92557,92550,92551,92475,92476,91963,91964,91703,91702,91616,91617,91609,91610,91565,91459,91460,91453,91454,91447,91446,90654,90655,90019,90020,89979,89980,89931,89932,89650,89651,89366,89365,89206,88986,88987,88038,88039,85615,85387,85388,85381,85382,85375,85376,85370,85369,85363,85364,85284,85285,85277,84860,84861,84409,84410,83777,83778,83063,83064,82995,82996,82989,82990,82983,82984,82977,82978,82291,82292,82212,82213,81843,81844,81543,81544,81537,81538,81320,81321,81314,81315,81028,81027,80080,80081,79671,79672,79231,79232,79096,79097,79090,79091,79083,79084,78567,78568,78367,78368,78103,78104,77706,77707,77700,77701,77212,77213,76768,76769,76631,76630,76199,76200,75525,75526,75519,75520,75514,75513,75173,75174,75046,75045,74666,74665,74252,74253,74006,74007,74000,74001,73994,73995,73986,73987,73682,73683,73134,73135,72547,71794,71795,71592,71593,71586,71587,71580,71581,71325,71326,71260,71261,71254,71255,70987,70988,69813,69814,69806,69807,69800,69801,69795,69794,69788,69789,69498,69497,69434,69435,69293,69294,69288,69289,69230,69231,69070,69071,69003,69004,68998,68999,68688,68689,68683,68684,66741,66742,66060,66061,66006,66007,65988,65989,65957,65958,65779,65780,65520,65521,65412,65411,64816,64815,64665,64666,64622,64623,64391,64392,64386,64387,63718,63719,62472,62473,62467,62468,62271,62272,61842,60694,60695,60689,60690,60597,60598,60592,60591,59853,59852,59831,59832,59459,59460,59041,59042,58888,58887,58300,58301,57071,57072,56414,56415,56082,56083,55835,55836,55830,55831,55826,55825,55427,55426,54429,54430,54424,54425,54419,54420,53893,53894,53743,53744,53487,53488,53482,53483,53328,53329,53037,52718,52719,52428,52427,51423,51424,50563,50564,50102,49595,49596,44697,42458,42457,42409,42408,42168,42167,41998,40865,40866,40704,40705,39660,39661,39528,39529,39406,39407,38541,38454,38453,38205,38206,38078,38079,38074,38073,38068,38069,37879,37699,37700,37043,36423,36424,36263,36264,36258,36259,36254,36253,35761,35762,35756,35757,35204,35205,35199,35200,35195,35194,35179,35178,35063,34934,34935,34922,34923,34737,34736,34335,34334,34330,34329,33422,33421,31795,31794,31789,31790,31751,31752,31404,31405,31174,30941,30940,30003,30004,29910,29911,29906,29905,29901,29900,29684,29685,29448,29243,29241,29235,29233,29227,29225,29219,29217,28379,28380,28355,28274,28248,28037,28038,27860,27859,27807,27808,27229,27228,26774,26773,26758,26759,26549,26548,26498,26493,26494,26458,26459,26453,26454,26427,25667,25628,25629,25523,25439,25215,25214,24468,24047,23698,23699,23632,23633,23628,23627,23623,23624,23281,23280,22433,22312,22313,22264,22262,22216,22215,22173,22174,22162,22150,22149,22107,21886,21885,21874,21873,21711,21710,21708,21707,21685,21674,21539,21027,21026,20842,20697,20505,19220,19219,19208,19207,19138,19139,19135,19136,19078,19077,19036,19018,19017,19003,19002,19000,18999,18951,18920,18919,18903,18902,18900,18899,18897,18896,18868,18793,18792,18790,18789,18787,18786,18668,186",

  "uuid": "f092ecbd-06a5-413b-bb8a-507681c0ce8f"

}

{

  "installName": "removed_for_privacy",

  "environment": "PROD",

  "type": "error",

  "date": "2025-02-23T07:30:37.248Z",

  "severity": null,

  "client": null,

  "message": "KILLED QUERY (24126 characters long generated in /nas/content/live/removed_for_privacy/wp-content/plugins/woocommerce/includes/data-stores/class-wc-order-data-store-cpt.php:1088): SELECT DISTINCT t.term_id, tr.object_id#012#011#011#011 FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id#012#011#011#011 WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (118547, 118543, 118544, 118541, 118538, 118535, 118532, 118523, 118508, 118504, 118505, 118501, 118502, 118495, 118487, 118478, 118466, 118458, 118449, 118439, 118432, 118429, 118425, 118414, 118380, 118375, 118371, 118368, 118364, 118365, 118362, 118361, 118350, 118351, 118347, 118348, 118343, 118340, 118324, 118320, 118321, 118292, 118289, 118286, 118280, 118276, 118270, 118266, 118267, 118263, 118264, 118261, 118255, 118251, 118227, 118208, 118191, 118187, 118183, 118184, 118173, 118163, 118148, 118149, 118140, 118136, 118129, 118094, 118076, 118058, 118048, 118032, 118015, 118016, 118012, 117993, 117990, 117971, 117960, 117956, 117957, 117953, 117954, 117934, 117935, 117920, 117914, 117910, 117911, 117907, 117908, 117904, 117905, 117901, 117893, 117890, 117882, 117876, 117873, 117866, 117862, 117855, 117844, 117842, 117833, 117824, 117821, 117817, 117818, 117814, 117815, 117776, 117770, 117767, 117759, 117744, 117741, 117732, 117721, 117715, 117708, 117695, 117692, 117685, 117676, 117648, 117633, 117612, 117599, 117579, 117576, 117573, 117570, 117556, 117548, 117541, 117535, 117519, 117516, 117511, 117506, 117499, 117469, 117465, 117440, 117418, 117415, 117410, 117393, 117388, 117379, 117370, 117361, 117338, 117318, 117310, 117285, 117269, 117247, 117235, 117230, 117226, 117219, 117211, 117208, 117196, 117191, 117188, 117187, 117184, 117185, 117181, 117182, 117179, 117178, 117152, 117134, 117130, 117104, 117091, 117054, 117055, 117052, 117039, 117021, 117018, 117013, 117009, 117004, 116999, 116996, 116992, 116985, 116972, 116968, 116963, 116957, 116924, 116920, 116904, 116895, 116889, 116880, 116873, 116864, 116856, 116857, 116851, 116847, 116803, 116752, 116697, 116682, 116658, 116639, 116635, 116636, 116632, 116633, 116576, 116533, 116518, 116510, 116506, 116507, 116484, 116477, 116476, 116473, 116474, 116471, 116468, 116458, 116443, 116436, 116417, 116404, 116401, 116392, 116374, 116315, 116311, 116299, 116300, 116291, 116263, 116185, 116180, 116170, 116154, 116145, 116129, 116124, 116108, 116105, 116093, 116094, 116074, 116047, 116029, 116025, 116006, 115997, 115978, 115975, 115962, 115947, 115939, 115897, 115894, 115877, 115878, 115874, 115875, 115871, 115872, 115852, 115833, 115828, 115824, 115825, 115822, 115817, 115786, 115783, 115780, 115768, 115738, 115733, 115706, 115675, 115668, 115540, 115506, 115490, 115468, 115450, 115446, 115380, 115375, 115330, 115288, 115273, 115261, 115177, 115158, 115149, 115109, 115046, 115042, 114980, 114927, 114867, 114837, 114806, 114782, 114776, 114764, 114754, 114751, 114718, 114712, 114702, 114682, 114683, 114658, 114630, 114631, 114627, 114628, 114624, 114625, 114621, 114622, 114618, 114619, 114586, 114576, 114574, 114567, 114561, 114555, 114543, 114528, 114514, 114497, 114492, 114484, 114465, 114387, 114384, 114366, 114365, 114323, 114320, 114308, 114302, 114293, 114275, 114256, 114257, 114250, 114243, 114244, 114226, 114218, 114192, 114187, 114127, 114116, 114097, 114082, 114072, 114067, 114055, 114052, 114036, 113990, 113970, 113960, 113957, 113936, 113916, 113913, 113904, 113901, 113882, 113876, 113872, 113873, 113868, 113827, 113828, 113806, 113803, 113776, 113686, 113635, 113613, 113612, 113607, 113608, 113567, 113538, 113539, 113520, 113503, 113448, 113435, 113416, 113303, 113278, 113197, 113193, 113194, 113191, 113171, 113172, 113140, 113102, 113058, 113049, 113050, 113030, 113019, 112975, 112960, 112936, 112872, 112871, 112869, 112868, 112802, 112505, 112504, 112487, 112397, 112398, 112287, 112247, 112246, 112134, 112133, 111557, 111556, 111480, 111476, 111477, 111436, 111430, 111317, 111171, 111170, 110980, 110682, 110683, 110631, 110592, 110593, 110303, 110302, 110132, 110133, 110053, 110052, 110019, 110018, 110015, 110016, 109994, 109995, 109860, 109861, 109704, 109705, 109701, 109702, 109698, 109699, 109655, 109656, 109455, 109456, 109452, 109453, 109444, 109443, 109440, 109441, 109419, 109420, 109150, 109151, 109086, 109085, 108723, 108574, 108575, 108314, 108313, 108310, 108311, 107870, 107871, 107824, 107746, 107747, 107742, 107722, 107723, 107545, 107546, 107542, 107543, 107334, 107335, 107120, 107121, 106716, 106717, 106714, 106713, 106636, 106637, 106633, 106634, 106630, 106631, 106628, 106627, 106624, 106625, 106619, 106618, 106477, 106478, 106417, 106418, 106414, 106415, 106411, 106412, 106405, 106406, 106402, 106403, 106399, 106400, 106397, 106396, 106394, 106393, 106269, 106270, 106196, 106195, 106033, 106034, 106030, 106031, 106027, 106028, 106024, 106025, 105966, 105967, 105963, 105964, 105960, 105961, 105943, 105942, 105939, 105940, 105936, 105937, 105933, 105934, 105930, 105931, 105927, 105928, 105924, 105925, 105922, 105921, 105887, 105886, 105804, 105805, 105652, 105653, 105646, 105645, 104588, 104589, 104405, 103887, 103888, 103485, 103486, 103367, 103366, 103350, 102954, 102953, 102951, 102950, 102889, 102888, 102603, 102181, 102180, 102177, 102178, 101463, 101464, 101002, 101001, 100557, 100558, 100503, 100504, 100500, 100501, 100316, 100317, 100274, 100275, 100261, 100262, 100258, 100259, 100256, 100165, 100166, 100118, 100117, 99774, 99775, 99628, 99627, 99536, 99537, 99531, 99530, 99524, 99525, 99357, 99356, 99350, 99351, 99297, 99296, 99290, 99291, 98724, 98723, 98718, 98717, 98712, 98711, 98706, 98705, 98699, 98700, 98694, 98693, 97785, 97786, 97779, 97780, 97773, 97774, 96900, 96901, 96895, 96894, 96888, 96889, 96869, 96763, 96764, 96537, 96538, 96499, 96500, 95188, 95187, 94127, 94128, 94121, 94122, 94070, 94071, 93640, 93641, 93503, 93502, 93483, 93484, 93477, 93478, 93444, 93443, 92556, 92557, 92550, 92551, 92475, 92476, 91963, 91964, 91703, 91702, 91616, 91617, 91609, 91610, 91565, 91459, 91460, 91453, 91454, 91447, 91446, 90654, 90655, 90019, 90020, 89979, 89980, 89931, 89932, 89650, 89651, 89366, 89365, 89206, 88986, 88987, 88038, 88039, 85615, 85387, 85388, 85381, 85382, 85375, 85376, 85370, 85369, 85363, 85364, 85284, 85285, 85277, 84860, 84861, 84409, 84410, 83777, 83778, 83063, 83064, 82995, 82996, 82989, 82990, 82983, 82984, 82977, 82978, 82291, 82292, 82212, 82213, 81843, 81844, 81543, 81544, 81537, 81538, 81320, 81321, 81314, 81315, 81028, 81027, 80080, 80081, 79671, 79672, 79231, 79232, 79096, 79097, 79090, 79091, 79083, 79084, 78567, 78568, 78367, 78368, 78103, 78104, 77706, 77707, 77700, 77701, 77212, 77213, 76768, 76769, 76631, 76630, 76199, 76200, 75525, 75526, 75519, 75520, 75514, 75513, 75173, 75174, 75046, 75045, 74666, 74665, 74252, 74253, 74006, 74007, 74000, 74001, 73994, 73995, 73986, 73987, 73682, 73683, 73134, 73135, 72547, 71794, 71795, 71592, 71593, 71586, 71587, 71580, 71581, 71325, 71326, 71260, 71261, 71254, 71255, 70987, 70988, 69813, 69814, 69806, 69807, 69800, 69801, 69795, 69794, 69788, 69789, 69498, 69497, 69434, 69435, 69293, 69294, 69288, 69289, 69230, 69231, 69070, 69071, 69003, 69004, 68998, 68999, 68688, 68689, 68683, 68684, 66741, 66742, 66060, 66061, 66006, 66007, 65988, 65989, 65957, 65958, 65779, 65780, 65520, 65521, 65412, 65411, 64816, 64815, 64665, 64666, 64622, 64623, 64391, 64392, 64386, 64387, 63718, 63719, 62472, 62473, 62467, 62468, 62271, 62272, 61842, 60694, 60695, 60689, 60690, 60597, 60598, 60592, 60591, 59853, 59852, 59831, 59832, 59459, 59460, 59041, 59042, 58888, 58887, 58300, 58301, 57071, 57072, 56414, 56415, 56082, 56083, 55835, 55836, 55830, 55831, 55826, 55825, 55427, 55426, 54429, 54430, 54424, 54425, 54419, 54420, 53893, 53894, 53743, 53744, 53487, 53488, 53482, 53483, 53328, 53329, 53037, 52718, 52719, 52428, 52427, 51423, 51424, 50563, 50564, 50102, 49595, ",

  "uuid": "9394f4f4-7615-45bc-928c-aa46b810554c"

}

{

  "installName": "removed_for_privacy",

  "environment": "PROD",

  "type": "error",

  "date": "2025-02-23T07:30:37.348Z",

  "severity": null,

  "client": null,

  "message": "KILLED QUERY (30544 characters long generated in /nas/content/live/removed_for_privacy/wp-content/plugins/woocommerce/includes/data-stores/class-wc-order-data-store-cpt.php:1236): SELECT post_id as object_id, meta_id, meta_key, meta_value#012#011#011#011#011FROM wp_postmeta#012#011#011#011#011WHERE post_id IN ( '118547', '118543', '118544', '118541', '118538', '118535', '118532', '118523', '118508', '118504', '118505', '118501', '118502', '118495', '118487', '118478', '118466', '118458', '118449', '118439', '118432', '118429', '118425', '118414', '118380', '118375', '118371', '118368', '118364', '118365', '118362', '118361', '118350', '118351', '118347', '118348', '118343', '118340', '118324', '118320', '118321', '118292', '118289', '118286', '118280', '118276', '118270', '118266', '118267', '118263', '118264', '118261', '118255', '118251', '118227', '118208', '118191', '118187', '118183', '118184', '118173', '118163', '118148', '118149', '118140', '118136', '118129', '118094', '118076', '118058', '118048', '118032', '118015', '118016', '118012', '117993', '117990', '117971', '117960', '117956', '117957', '117953', '117954', '117934', '117935', '117920', '117914', '117910', '117911', '117907', '117908', '117904', '117905', '117901', '117893', '117890', '117882', '117876', '117873', '117866', '117862', '117855', '117844', '117842', '117833', '117824', '117821', '117817', '117818', '117814', '117815', '117776', '117770', '117767', '117759', '117744', '117741', '117732', '117721', '117715', '117708', '117695', '117692', '117685', '117676', '117648', '117633', '117612', '117599', '117579', '117576', '117573', '117570', '117556', '117548', '117541', '117535', '117519', '117516', '117511', '117506', '117499', '117469', '117465', '117440', '117418', '117415', '117410', '117393', '117388', '117379', '117370', '117361', '117338', '117318', '117310', '117285', '117269', '117247', '117235', '117230', '117226', '117219', '117211', '117208', '117196', '117191', '117188', '117187', '117184', '117185', '117181', '117182', '117179', '117178', '117152', '117134', '117130', '117104', '117091', '117054', '117055', '117052', '117039', '117021', '117018', '117013', '117009', '117004', '116999', '116996', '116992', '116985', '116972', '116968', '116963', '116957', '116924', '116920', '116904', '116895', '116889', '116880', '116873', '116864', '116856', '116857', '116851', '116847', '116803', '116752', '116697', '116682', '116658', '116639', '116635', '116636', '116632', '116633', '116576', '116533', '116518', '116510', '116506', '116507', '116484', '116477', '116476', '116473', '116474', '116471', '116468', '116458', '116443', '116436', '116417', '116404', '116401', '116392', '116374', '116315', '116311', '116299', '116300', '116291', '116263', '116185', '116180', '116170', '116154', '116145', '116129', '116124', '116108', '116105', '116093', '116094', '116074', '116047', '116029', '116025', '116006', '115997', '115978', '115975', '115962', '115947', '115939', '115897', '115894', '115877', '115878', '115874', '115875', '115871', '115872', '115852', '115833', '115828', '115824', '115825', '115822', '115817', '115786', '115783', '115780', '115768', '115738', '115733', '115706', '115675', '115668', '115540', '115506', '115490', '115468', '115450', '115446', '115380', '115375', '115330', '115288', '115273', '115261', '115177', '115158', '115149', '115109', '115046', '115042', '114980', '114927', '114867', '114837', '114806', '114782', '114776', '114764', '114754', '114751', '114718', '114712', '114702', '114682', '114683', '114658', '114630', '114631', '114627', '114628', '114624', '114625', '114621', '114622', '114618', '114619', '114586', '114576', '114574', '114567', '114561', '114555', '114543', '114528', '114514', '114497', '114492', '114484', '114465', '114387', '114384', '114366', '114365', '114323', '114320', '114308', '114302', '114293', '114275', '114256', '114257', '114250', '114243', '114244', '114226', '114218', '114192', '114187', '114127', '114116', '114097', '114082', '114072', '114067', '114055', '114052', '114036', '113990', '113970', '113960', '113957', '113936', '113916', '113913', '113904', '113901', '113882', '113876', '113872', '113873', '113868', '113827', '113828', '113806', '113803', '113776', '113686', '113635', '113613', '113612', '113607', '113608', '113567', '113538', '113539', '113520', '113503', '113448', '113435', '113416', '113303', '113278', '113197', '113193', '113194', '113191', '113171', '113172', '113140', '113102', '113058', '113049', '113050', '113030', '113019', '112975', '112960', '112936', '112872', '112871', '112869', '112868', '112802', '112505', '112504', '112487', '112397', '112398', '112287', '112247', '112246', '112134', '112133', '111557', '111556', '111480', '111476', '111477', '111436', '111430', '111317', '111171', '111170', '110980', '110682', '110683', '110631', '110592', '110593', '110303', '110302', '110132', '110133', '110053', '110052', '110019', '110018', '110015', '110016', '109994', '109995', '109860', '109861', '109704', '109705', '109701', '109702', '109698', '109699', '109655', '109656', '109455', '109456', '109452', '109453', '109444', '109443', '109440', '109441', '109419', '109420', '109150', '109151', '109086', '109085', '108723', '108574', '108575', '108314', '108313', '108310', '108311', '107870', '107871', '107824', '107746', '107747', '107742', '107722', '107723', '107545', '107546', '107542', '107543', '107334', '107335', '107120', '107121', '106716', '106717', '106714', '106713', '106636', '106637', '106633', '106634', '106630', '106631', '106628', '106627', '106624', '106625', '106619', '106618', '106477', '106478', '106417', '106418', '106414', '106415', '106411', '106412', '106405', '106406', '106402', '106403', '106399', '106400', '106397', '106396', '106394', '106393', '106269', '106270', '106196', '106195', '106033', '106034', '106030', '106031', '106027', '106028', '106024', '106025', '105966', '105967', '105963', '105964', '105960', '105961', '105943', '105942', '105939', '105940', '105936', '105937', '105933', '105934', '105930', '105931', '105927', '105928', '105924', '105925', '105922', '105921', '105887', '105886', '105804', '105805', '105652', '105653', '105646', '105645', '104588', '104589', '104405', '103887', '103888', '103485', '103486', '103367', '103366', '103350', '102954', '102953', '102951', '102950', '102889', '102888', '102603', '102181', '102180', '102177', '102178', '101463', '101464', '101002', '101001', '100557', '100558', '100503', '100504', '100500', '100501', '100316', '100317', '100274', '100275', '100261', '100262', '100258', '100259', '100256', '100165', '100166', '100118', '100117', '99774', '99775', '99628', '99627', '99536', '99537', '99531', '99530', '99524', '99525', '99357', '99356', '99350', '99351', '99297', '99296', '99290', '99291', '98724', '98723', '98718', '98717', '98712', '98711', '98706', '98705', '98699', '98700', '98694', '98693', '97785', '97786', '97779', '97780', '97773', '97774', '96900', '96901', '96895', '96894', '96888', '96889', '96869', '96763', '96764', '96537', '96538', '96499', '96500', '95188', '95187', '94127', '94128', '94121', '94122', '94070', '94071', '93640', '93641', '93503', '93502', '93483', '93484', '93477', '93478', '93444', '93443', '92556', '92557', '92550', '92551', '92475', '92476', '91963', '91964', '91703', '91702', '91616', '91617', '91609', '91610', '91565', '91459', '91460', '91453', '91454', '91447', '91446', '90654', '90655', '90019', '90020', '89979', '89980', '89931', '89932', '89650', '89651', '89366', '89365', '89206', '88986', '88987', '88038', '88039', '85615', '85387', '85388', '85381', '85382', '85375', '85376', '85370', '85369', '85363', '85364', '85284', '85285', '85277', '84860', '84861', '84409', '84410', '83777', '83778', '83063', '83064', '82995', '82996', '82989', '82990', '82983', '82984', '82977', '82978', '82291', '82292', '82212', '82213', '81843', '81844', '81543', '81544', '81537', '81538', '81320', '81321', '81314', '81315', '81028', '81027', '8",

  "uuid": "7dc5be8e-4def-46ac-bc2b-4544b5461b15"

}

{

  "installName": "removed_for_privacy",

  "environment": "PROD",

  "type": "error",

  "date": "2025-02-23T07:30:37.356Z",

  "severity": null,

  "client": null,

  "message": "KILLED QUERY (20635 characters long generated in /nas/content/live/removed_for_privacy/wp-content/plugins/woocommerce/includes/data-stores/abstract-wc-order-data-store-cpt.php:604): SELECT order_item_type, order_item_id, order_id, order_item_name FROM wp_woocommerce_order_items WHERE order_id in ( 118547,118543,118544,118541,118538,118535,118532,118523,118508,118504,118505,118501,118502,118495,118487,118478,118466,118458,118449,118439,118432,118429,118425,118414,118380,118375,118371,118368,118364,118365,118362,118361,118350,118351,118347,118348,118343,118340,118324,118320,118321,118292,118289,118286,118280,118276,118270,118266,118267,118263,118264,118261,118255,118251,118227,118208,118191,118187,118183,118184,118173,118163,118148,118149,118140,118136,118129,118094,118076,118058,118048,118032,118015,118016,118012,117993,117990,117971,117960,117956,117957,117953,117954,117934,117935,117920,117914,117910,117911,117907,117908,117904,117905,117901,117893,117890,117882,117876,117873,117866,117862,117855,117844,117842,117833,117824,117821,117817,117818,117814,117815,117776,117770,117767,117759,117744,117741,117732,117721,117715,117708,117695,117692,117685,117676,117648,117633,117612,117599,117579,117576,117573,117570,117556,117548,117541,117535,117519,117516,117511,117506,117499,117469,117465,117440,117418,117415,117410,117393,117388,117379,117370,117361,117338,117318,117310,117285,117269,117247,117235,117230,117226,117219,117211,117208,117196,117191,117188,117187,117184,117185,117181,117182,117179,117178,117152,117134,117130,117104,117091,117054,117055,117052,117039,117021,117018,117013,117009,117004,116999,116996,116992,116985,116972,116968,116963,116957,116924,116920,116904,116895,116889,116880,116873,116864,116856,116857,116851,116847,116803,116752,116697,116682,116658,116639,116635,116636,116632,116633,116576,116533,116518,116510,116506,116507,116484,116477,116476,116473,116474,116471,116468,116458,116443,116436,116417,116404,116401,116392,116374,116315,116311,116299,116300,116291,116263,116185,116180,116170,116154,116145,116129,116124,116108,116105,116093,116094,116074,116047,116029,116025,116006,115997,115978,115975,115962,115947,115939,115897,115894,115877,115878,115874,115875,115871,115872,115852,115833,115828,115824,115825,115822,115817,115786,115783,115780,115768,115738,115733,115706,115675,115668,115540,115506,115490,115468,115450,115446,115380,115375,115330,115288,115273,115261,115177,115158,115149,115109,115046,115042,114980,114927,114867,114837,114806,114782,114776,114764,114754,114751,114718,114712,114702,114682,114683,114658,114630,114631,114627,114628,114624,114625,114621,114622,114618,114619,114586,114576,114574,114567,114561,114555,114543,114528,114514,114497,114492,114484,114465,114387,114384,114366,114365,114323,114320,114308,114302,114293,114275,114256,114257,114250,114243,114244,114226,114218,114192,114187,114127,114116,114097,114082,114072,114067,114055,114052,114036,113990,113970,113960,113957,113936,113916,113913,113904,113901,113882,113876,113872,113873,113868,113827,113828,113806,113803,113776,113686,113635,113613,113612,113607,113608,113567,113538,113539,113520,113503,113448,113435,113416,113303,113278,113197,113193,113194,113191,113171,113172,113140,113102,113058,113049,113050,113030,113019,112975,112960,112936,112872,112871,112869,112868,112802,112505,112504,112487,112397,112398,112287,112247,112246,112134,112133,111557,111556,111480,111476,111477,111436,111430,111317,111171,111170,110980,110682,110683,110631,110592,110593,110303,110302,110132,110133,110053,110052,110019,110018,110015,110016,109994,109995,109860,109861,109704,109705,109701,109702,109698,109699,109655,109656,109455,109456,109452,109453,109444,109443,109440,109441,109419,109420,109150,109151,109086,109085,108723,108574,108575,108314,108313,108310,108311,107870,107871,107824,107746,107747,107742,107722,107723,107545,107546,107542,107543,107334,107335,107120,107121,106716,106717,106714,106713,106636,106637,106633,106634,106630,106631,106628,106627,106624,106625,106619,106618,106477,106478,106417,106418,106414,106415,106411,106412,106405,106406,106402,106403,106399,106400,106397,106396,106394,106393,106269,106270,106196,106195,106033,106034,106030,106031,106027,106028,106024,106025,105966,105967,105963,105964,105960,105961,105943,105942,105939,105940,105936,105937,105933,105934,105930,105931,105927,105928,105924,105925,105922,105921,105887,105886,105804,105805,105652,105653,105646,105645,104588,104589,104405,103887,103888,103485,103486,103367,103366,103350,102954,102953,102951,102950,102889,102888,102603,102181,102180,102177,102178,101463,101464,101002,101001,100557,100558,100503,100504,100500,100501,100316,100317,100274,100275,100261,100262,100258,100259,100256,100165,100166,100118,100117,99774,99775,99628,99627,99536,99537,99531,99530,99524,99525,99357,99356,99350,99351,99297,99296,99290,99291,98724,98723,98718,98717,98712,98711,98706,98705,98699,98700,98694,98693,97785,97786,97779,97780,97773,97774,96900,96901,96895,96894,96888,96889,96869,96763,96764,96537,96538,96499,96500,95188,95187,94127,94128,94121,94122,94070,94071,93640,93641,93503,93502,93483,93484,93477,93478,93444,93443,92556,92557,92550,92551,92475,92476,91963,91964,91703,91702,91616,91617,91609,91610,91565,91459,91460,91453,91454,91447,91446,90654,90655,90019,90020,89979,89980,89931,89932,89650,89651,89366,89365,89206,88986,88987,88038,88039,85615,85387,85388,85381,85382,85375,85376,85370,85369,85363,85364,85284,85285,85277,84860,84861,84409,84410,83777,83778,83063,83064,82995,82996,82989,82990,82983,82984,82977,82978,82291,82292,82212,82213,81843,81844,81543,81544,81537,81538,81320,81321,81314,81315,81028,81027,80080,80081,79671,79672,79231,79232,79096,79097,79090,79091,79083,79084,78567,78568,78367,78368,78103,78104,77706,77707,77700,77701,77212,77213,76768,76769,76631,76630,76199,76200,75525,75526,75519,75520,75514,75513,75173,75174,75046,75045,74666,74665,74252,74253,74006,74007,74000,74001,73994,73995,73986,73987,73682,73683,73134,73135,72547,71794,71795,71592,71593,71586,71587,71580,71581,71325,71326,71260,71261,71254,71255,70987,70988,69813,69814,69806,69807,69800,69801,69795,69794,69788,69789,69498,69497,69434,69435,69293,69294,69288,69289,69230,69231,69070,69071,69003,69004,68998,68999,68688,68689,68683,68684,66741,66742,66060,66061,66006,66007,65988,65989,65957,65958,65779,65780,65520,65521,65412,65411,64816,64815,64665,64666,64622,64623,64391,64392,64386,64387,63718,63719,62472,62473,62467,62468,62271,62272,61842,60694,60695,60689,60690,60597,60598,60592,60591,59853,59852,59831,59832,59459,59460,59041,59042,58888,58887,58300,58301,57071,57072,56414,56415,56082,56083,55835,55836,55830,55831,55826,55825,55427,55426,54429,54430,54424,54425,54419,54420,53893,53894,53743,53744,53487,53488,53482,53483,53328,53329,53037,52718,52719,52428,52427,51423,51424,50563,50564,50102,49595,49596,44697,42458,42457,42409,42408,42168,42167,41998,40865,40866,40704,40705,39660,39661,39528,39529,39406,39407,38541,38454,38453,38205,38206,38078,38079,38074,38073,38068,38069,37879,37699,37700,37043,36423,36424,36263,36264,36258,36259,36254,36253,35761,35762,35756,35757,35204,35205,35199,35200,35195,35194,35179,35178,35063,34934,34935,34922,34923,34737,34736,34335,34334,34330,34329,33422,33421,31795,31794,31789,31790,31751,31752,31404,31405,31174,30941,30940,30003,30004,29910,29911,29906,29905,29901,29900,29684,29685,29448,29243,29241,29235,29233,29227,29225,29219,29217,28379,28380,28355,28274,28248,28037,28038,27860,27859,27807,27808,27229,27228,26774,26773,26758,26759,26549,26548,26498,26493,26494,26458,26459,26453,26454,26427,25667,25628,25629,25523,25439,25215,25214,24468,24047,23698,23699,23632,23633,23628,23627,23623,23624,23281,23280,22433,22312,22313,22264,22262,22216,22215,22173,22174,22162,22150,22149,22107,21886,21885,21874,21873,21711,21710,21708,21707,21685,21674,21539,21027,21026,20842,20697,20505,19220,19219,19208,19207,19138,19139,19135,19136,19078,19077,19036,19018,19017,19003,19002,19000,18999,18951,18920,18919,18903,18902,18900,18899,18897,18896,1886",

  "uuid": "0b6896ac-009b-4f3b-be53-b627d0c48f12"

}
Viewing 5 replies - 1 through 5 (of 5 total)
Moses M. (woo-hc)
(@mosesmedh)

1 year, 1 month ago

Hi @bigbugsy,

I’ve reviewed the kill query notice you provided, and it’s clear that the query is quite long and appears to be related to orders.

Could you let me know the average number of orders you receive daily or hourly? Additionally, please check WooCommerce > Status > Logs for any fatal errors or WooCommerce-related issues and share them via Pastebin. Also, please provide your WooCommerce status report by navigating to WooCommerce > Status > Get System Report > Copy for Support, so I can better understand your site’s setup.

Thread Starter Dustin L.
(@bigbugsy)

1 year, 1 month ago

Hi @mosesmedh

Thanks for your help!

We have received on average 7 orders per day so far this year.

Here is the info you requested:

fatal-errors-2025-02-21.log
https://pastebin.com/LL8g5N9Z

plugin-woocommerce-2025-02-24.log
https://pastebin.com/zsBEmYsM

SystemStatusReport_redacted.com_2025-02-24T17-21-04.txt
https://pastebin.com/DSbc5wT8

The last fatal errors report was on February 21. The same KILLED QUERY errors occurred today (February 24), so I’m not sure that the fatal errors are a factor.

One thing that may be involved:

This store has been around since before HPOS. In December, I enabled HPOS with compatibility mode. It was on for a few days until I discovered a problem. At that time, I switched back to WordPress posts storage (legacy) and disabled compatibility mode.

Could this be a left over process from then? The store has over 11,000 orders.

Thank you
Jonayed (woo-hc)
(@jonayedhosen)

1 year, 1 month ago
Hi @bigbugsy ,

It looks like you’re encountering “KILLED QUERY” errors on WP Engine, specifically related to WooCommerce. This typically happens when database queries exceed WP Engine’s 16 KB query limit, which can be common for sites with a large number of orders, products, or taxonomies, leading to oversized queries.

You may want to reach out to WP Engine for further assistance. In some cases, they suggest adding the following line to your wp-config.php file to help resolve the issue:
```
define( 'WPE_GOVERNOR', false );
```
Additionally, optimizing your database can help reduce long queries. You can find more details on database optimization here: How to Optimize database for WooCommerce Stores

Let me know if this helps!
Thread Starter Dustin L.
(@bigbugsy)

1 year, 1 month ago
Thank you. I implemented the:
```
define( 'WPE_GOVERNOR', false );
```
…code yesterday. I didn’t get the KILLED QUERY notice overnight and the site is still standing, so I guess it is okay.
Moses M. (woo-hc)
(@mosesmedh)

1 year, 1 month ago

Hi @bigbugsy,

Thank you for reaching out again. I’m glad you managed to silence the notice and that your site is running fine. If you need any further help with WooCommerce-related issues, feel free to start a new topic.
Viewing 5 replies - 1 through 5 (of 5 total)
The topic ‘KILLED QUERY on WP Engine’ is closed to new replies.