Query Failure Errors

Hi,

We’re having some problems with wp mail smtp. We frequently get query failure errors.

Please see the error message below.

{
“installName”: “pieregister”,
“environment”: “PROD”,
“type”: “error”,
“date”: “2022-09-30T09:54:59.000Z”,
“severity”: “notice”,
“client”: “117.20.19.35:0”,
“message”: “KILLED QUERY (589430 characters long generated in /nas/content/live/pieregister/wp-content/plugins/wp-mail-smtp/src/Admin/DebugEvents/DebugEvents.php:186): SELECT id, content, initiator, event_type, created_at FROM wp_wpmailsmtp_debug_events WHERE id IN ( 5317372, 5317373, 5317374, 5317375, 5317376, 5317377, 5317378, 5317379, 5317380, 5317381, 5317382, 5317383, 5317384, 5317385, 5317386, 5317387, 5317388, 5317389, 5317390, 5317391, 5317392, 5317393, 5317394, 5317395, 5317396, 5317397, 5317398, 5317399, 5317400, 5317401, 5317402, 5317403, 5317404, 5317405, 5317406, 5317407, 5317408, 5317409, 5317410, 5317411, 5317412, 5317413, 5317414, 5317415, 5317416, 5317417, 5317418, 5317419, 5317420, 5317421, 5317422, 5317423, 5317424, 5317425, 5317426, 5317427, 5317428, 5317429, 5317430, 5317431, 5317432, 5317433, 5317434, 5317435, 5317436, 5317437, 5317438, 5317439, 5317440, 5317441, 5317442, 5317443, 5317444, 5317445, 5317446, 5317447, 5317448, 5317449, 5317450, 5317451, 5317452, 5317453, 5317454, 5317455, 5317456, 5317457, 5317458, 5317459, 5317460, 5317461, 5317462, 5317463, 5317464, 5317465, 5317466, 5317467, 5317468, 5317469, 5317470, 5317471, 5317472, 5317473, 5317474, 5317475, 5317476, 5317477, 5317478, 5317479, 5317480, 5317481, 5317482, 5317483, 5317484, 5317485, 5317486, 5317487, 5317488, 5317489, 5317490, 5317491, 5317492, 5317493, 5317494, 5317495, 5317496, 5317497, 5317498, 5317499, 5317500, 5317501, 5317502, 5317503, 5317504, 5317505, 5317506, 5317507, 5317508, 5317509, 5317510, 5317511, 5317512, 5317513, 5317514, 5317515, 5317516, 5317517, 5317518, 5317519, 5317520, 5317521, 5317522, 5317523, 5317524, 5317525, 5317526, 5317527, 5317528, 5317529, 5317530, 5317531, 5317532, 5317533, 5317534, 5317535, 5317536, 5317537, 5317538, 5317539, 5317540, 5317541, 5317542, 5317543, 5317544, 5317545, 5317546, 5317547, 5317548, 5317549, 5317550, 5317551, 5317552, 5317553, 5317554, 5317555, 5317556, 5317557, 5317558, 5317559, 5317560, 5317561, 5317562, 5317563, 5317564, 5317565, 5317566, 5317567, 5317568, 5317569, 5317570, 5317571, 5317572, 5317573, 5317574, 5317575, 5317576, 5317577, 5317578, 5317579, 5317580, 5317581, 5317582, 5317583, 5317584, 5317585, 5317586, 5317587, 5317588, 5317589, 5317590, 5317591, 5317592, 5317593, 5317594, 5317595, 5317596, 5317597, 5317598, 5317599, 5317600, 5317601, 5317602, 5317603, 5317604, 5317605, 5317606, 5317607, 5317608, 5317609, 5317610, 5317611, 5317612, 5317613, 5317614, 5317615, 5317616, 5317617, 5317618, 5317619, 5317620, 5317621, 5317622, 5317623, 5317624, 5317625, 5317626, 5317627, 5317628, 5317629, 5317630, 5317631, 5317632, 5317633, 5317634, 5317635, 5317636, 5317637, 5317638, 5317639, 5317640, 5317641, 5317642, 5317643, 5317644, 5317645, 5317646, 5317647, 5317648, 5317649, 5317650, 5317651, 5317652, 5317653, 5317654, 5317655, 5317656, 5317657, 5317658, 5317659, 5317660, 5317661, 5317662, 5317663, 5317664, 5317665, 5317666, 5317667, 5317668, 5317669, 5317670, 5317671, 5317672, 5317673, 5317674, 5317675, 5317676, 5317677, 5317678, 5317679, 5317680, 5317681, 5317682, 5317683, 5317684, 5317685, 5317686, 5317687, 5317688, 5317689, 5317690, 5317691, 5317692, 5317693, 5317694, 5317695, 5317696, 5317697, 5317698, 5317699, 5317700, 5317701, 5317702, 5317703, 5317704, 5317705, 5317706, 5317707, 5317708, 5317709, 5317710, 5317711, 5317712, 5317713, 5317714, 5317715, 5317716, 5317717, 5317718, 5317719, 5317720, 5317721, 5317722, 5317723, 5317724, 5317725, 5317726, 5317727, 5317728, 5317729, 5317730, 5317731, 5317732, 5317733, 5317734, 5317735, 5317736, 5317737, 5317738, 5317739, 5317740, 5317741, 5317742, 5317743, 5317744, 5317745, 5317746, 5317747, 5317748, 5317749, 5317750, 5317751, 5317752, 5317753, 5317754, 5317755, 5317756, 5317757, 5317758, 5317759, 5317760, 5317761, 5317762, 5317763, 5317764, 5317765, 5317766, 5317767, 5317768, 5317769, 5317770, 5317771, 5317772, 5317773, 5317774, 5317775, 5317776, 5317777, 5317778, 5317779, 5317780, 5317781, 5317782, 5317783, 5317784, 5317785, 5317786, 5317787, 5317788, 5317789, 5317790, 5317791, 5317792, 5317793, 5317794, 5317795, 5317796, 5317797, 5317798, 5317799, 5317800, 5317801, 5317802, 5317803, 5317804, 5317805, 5317806, 5317807, 5317808, 5317809, 5317810, 5317811, 5317812, 5317813, 5317814, 5317815, 5317816, 5317817, 5317818, 5317819, 5317820, 5317821, 5317822, 5317823, 5317824, 5317825, 5317826, 5317827, 5317828, 5317829, 5317830, 5317831, 5317832, 5317833, 5317834, 5317835, 5317836, 5317837, 5317838, 5317839, 5317840, 5317841, 5317842, 5317843, 5317844, 5317845, 5317846, 5317847, 5317848, 5317849, 5317850, 5317851, 5317852, 5317853, 5317854, 5317855, 5317856, 5317857, 5317858, 5317859, 5317860, 5317861, 5317862, 5317863, 5317864, 5317865, 5317866, 5317867, 5317868, 5317869, 5317870, 5317871, 5317872, 5317873, 5317874, 5317875, 5317876, 5317877, 5317878, 5317879, 5317880, 5317881, 5317882, 5317883, 5317884, 5317885, 5317886, 5317887, 5317888, 5317889, 5317890, 5317891, 5317892, 5317893, 5317894, 5317895, 5317896, 5317897, 5317900, 5317901, 5317904, 5317905, 5317908, 5317909, 5317912, 5317913, 5317916, 5317917, 5317920, 5317921, 5317924, 5317925, 5317928, 5317929, 5317932, 5317933, 5317936, 5317937, 5317940, 5317941, 5317942, 5317943, 5317944, 5317945, 5317946, 5317947, 5317948, 5317949, 5317950, 5317951, 5317952, 5317953, 5317954, 5317955, 5317956, 5317957, 5317958, 5317959, 5317960, 5317961, 5317962, 5317963, 5317964, 5317965, 5317966, 5317967, 5317968, 5317969, 5317970, 5317971, 5317972, 5317973, 5317974, 5317975, 5317976, 5317977, 5317978, 5317979, 5317980, 5317981, 5317982, 5317983, 5317984, 5317985, 5317986, 5317987, 5317988, 5317989, 5317990, 5317991, 5317992, 5317993, 5317994, 5317995, 5317996, 5317997, 5317998, 5317999, 5318000, 5318001, 5318002, 5318003, 5318004, 5318005, 5318006, 5318007, 5318008, 5318009, 5318010, 5318011, 5318012, 5318013, 5318014, 5318015, 5318016, 5318017, 5318018, 5318019, 5318020, 5318021, 5318022, 5318023, 5318024, 5318025, 5318026, 5318027, 5318028, 5318029, 5318030, 5318031, 5318032, 5318033, 5318034, 5318035, 5318036, 5318037, 5318038, 5318039, 5318040, 5318041, 5318042, 5318043, 5318044, 5318045, 5318046, 5318047, 5318048, 5318049, 5318050, 5318051, 5318052, 5318053, 5318054, 5318055, 5318056, 5318057, 5318058, 5318059, 5318060, 5318061, 5318062, 5318063, 5318064, 5318065, 5318066, 5318067, 5318068, 5318069, 5318070, 5318071, 5318072, 5318073, 5318074, 5318075, 5318076, 5318077, 5318078, 5318079, 5318080, 5318081, 5318082, 5318083, 5318084, 5318085, 5318086, 5318087, 5318088, 5318089, 5318090, 5318091, 5318092, 5318093, 5318094, 5318095, 5318096, 5318097, 5318098, 5318099, 5318100, 5318101, 5318102, 5318103, 5318104, 5318105, 5318106, 5318107, 5318108, 5318109, 5318110, 5318111, 5318112, 5318113, 5318114, 5318115, 5318116, 5318117, 5318118, 5318119, 5318120, 5318121, 5318122, 5318123, 5318124, 5318125, 5318126, 5318127, 5318128, 5318129, 5318130, 5318131, 5318132, 5318133, 5318134, 5318135, 5318136, 5318137, 5318138, 5318139, 5318140, 5318141, 5318142, 5318143, 5318144, 5318145, 5318146, 5318147, 5318148, 5318149, 5318150, 5318151, 5318152, 5318153, 5318154, 5318155, 5318156, 5318157, 5318158, 5318159, 5318160, 5318161, 5318162, 5318163, 5318164, 5318165, 5318166, 5318167, 5318168, 5318169, 5318170, 5318171, 5318172, 5318173, 5318174, 5318175, 5318176, 5318177, 5318178, 5318179, 5318180, 5318181, 5318182, 5318183, 5318184, 5318185, 5318186, 5318187, 5318188, 5318189, 5318190, 5318191, 5318192, 5318193, 5318194, 5318195, 5318196, 5318197, 5318198, 5318199, 5318200, 5318201, 5318202, 5318203, 5318204, 5318205, 5318206, 5318207, 5318208, 5318209, 5318210, 5318211, 5318212, 5318213, 5318214, 5318215, 5318216, 5318217, 5318218, 5318219, 5318220, 5318221, 5318222, 5318223, 5318224, 5318225, 5318226, 5318227, 5318228, 5318229, 5318230, 5318231, 5318232, 5318233, 5318234, 5318235, 5318236, 5318237, 5318238, 5318239, 5318240, 5318241, 5318242, 5318243, 5318244, 5318245, 5318246, 5318247, 5318248, 5318249, 5318250, 5318251, 5318252, 5318253, 5318254, 5318255, 5318256, 5318257, 5318258, 5318259, 5318260, 5318261, 5318262, 5318263, 5318264, 5318265, 53”,
“uuid”: “c0e0b616-5d4d-4682-bd02-f587e36eba06”
}

We get these notices by wp engine. Can you please assist us? What exactly is it, and why is it appearing?

Thank you

• This topic was modified 2 years, 2 months ago by dualilani.