Killed Query

• danatupserve

• July 21, 2017 at 2:49 am

Any time a post is updated we’re getting the following error:

[Thu Jul 20 16:39:38.864094 2017] [:error] [pid 15024] [client xxx.xx.xxx.xx:xxxx] KILLED QUERY (53285 characters long generated in /nas/wp-content/staging/oursite/wp-content/plugins/advanced-custom-fields-pro/api/api-helpers.php:1163): SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (7011,7010,6756,9859,6757,2977,2013,9574,2290,7012,7008,2173,6752,2359,5499,8286,5039,3167,3819,3816,10657,10675,1888,7562,9497,5239,5236,6435,6120,10268,10181,3400,5183,2046,9190,2037,2189,2044,8417,9083,9201,9195,4158,8656,6098,10081,9196,2051,645,2732,7372,2778,6562,6558,7337,7324,8906,8901,9447,4319,4314,4309,6711,9391,7001,5182,9967,7016,7373,7364,9224,9221,9219,646,6814,6884,647,5181,1425,10084,6897,6891,1259,5884,5670,2468,6239,6378,6382,6667,7797,7931,5335,4947,10662,10651,5265,6751,4566,8528,10082,9118,7909,7914,8412,8419,3942,5842,9489,10273,10270,5189,9908,10661,10652,8921,7879,7872,7972,8677,2050,693,9270,8654,3716,3712,8740,8737,1898,861,9340,9339,9404,1670,1667,10262,10259,10258,3267,5659,5657,3272,8583,8733,9098,10617,1668,3481,9279,9281,3166,8746,7530,5000,7882,1424,6965,6957,4403,8938,9841,2621,2829,1175,1176,2347,9315,9313,2772,2768,2771,2769,8346,3373,3362,5776,5770,5767,5067,9017,841,4828,6124,328,9483,6477,562,2727,4019,2478,10751,5006,2170,2545,2192,2828,3969,3407,1627,1617,3257,3254,5093,3770,3630,3624,4766,3582,3581,1532,10234,7134,7129,8549,8189,5897,10329,10317,9276,8836,383,8840,6430,6427,3970,5157,4397,5899,6728,3967,1548,296,4871,252,8766,9829,8105,8629,5164,8770,8763,9302,9474,7417,7411,5310,4906,1782,9630,9624,2663,8110,10647,10645,9226,9220,6537,10271,1929,4392,4010,4018,6125,4014,3733,3497,3491,3486,2888,10539,10086,10569,3695,1572,7817,719,3929,2106,2095,6364,6363,361,9963,629,4715,9777,2475,346,6501,4450,664,4485,2898,1923,10044,2354,7086,10534,5399,2340,1666,4486,4330,4673,4669,101,6560,6557,1240,3693,783,5970,5969,3026,3024,9454,9451,10694,2655,4393,4062,4061,4698,9408,9910,826,7189,2699,2685,9864,1205,251,4777,5820,1250,4776,4620,7881,7874,2004,2596,1124,295,477,2498,2500,9818,1546,3140,3132,3374,7164,7161,7165,5712,5710,3240,3552,5257,9420,4426,6067,630,986,1575,2568,631,6943,6935,10730,4407,9310,977,7238,7935,7932,7930,7297,7293,7975,9481,1636,4893,10713,10700,1681,3050,8887,3025,7199,9983,5216,1353,2641,7635,5846,5294,7892,1387,464,9480,4960,7838,10007,4653,4169,4163,123,2034,9583,4342,8008,4658,2164,1177,5223,880,1829,6220,4530,9553,2692,2684,2678,8739,1118,1298,10127,9770,6207,6205,5907,1821,7964,10212,10209,915,2830,5075,5981,3319,8491,7954,7414,7956,5740,10614,9290,9287,10757,1626,1613,7288,10558,10554,4584,6500,4961,6350,6346,4151,6484,1531,9210,8089,7469,7370,7524,7516,4835,4820,1241,7851,5750,362,3424,9754,6568,4110,6619,4121,4116,6767,10228,2674,2662,7415,7410,3764,294,1409,10076,7246,7689,1221,6370,6367,9484,247,3731,5843,5840,5631,8210,2128,2586,895,1090,6621,5215,5756,9921,4896,4890,9645,592,8009,5977,5974,5978,9214,8529,5991,8527,1619,1615,1612,1610,1609,6262,4895,8530,3182,3183,7578,9140,7249,5162,3508,1709,2205,9914,2435,9856,1109,1110,1111,648,10249,10247,1574,7716,6857,444,7442,6693,8952,9345,9032,3377,1368,7754,8071,8090,9716,9714,9750,3862,3868,9749,4280,8680,1016,1017,5876,9188,7675,8910,3334,7886,4544,5616,8658,1060,4335,4671,8657,8651,5218,1982,5802,2867,4357,9756,10691,1860,6134,3795,10172,4772,5634,3599,6607,3412,6057,5112,5105,7294,1452,9839,10298,5577,4069,4888,7915,7319,7317,962,1823,8042,649,10236,198,2780,2776,3083,1768,1454,3259,881,5302,10723,815,5059,816,2317,2371,3933,492,3218,3209,4359,184,8555,9816,9813,4471,8393,8391,4945,4944,8389,8723,10060,9697,3165,4823,8192,5213,1708,2129,2357,6347,3746,3738,10282,5562,2033,7256,5479,5477,704,705,3609,3606,8936,842,8099,8094,2728,942,10786,10277,9143,7439,6266,3671,1143,9218,3011,5090,1206,2140,2139,6070,6072,4586,10218,9498,3811,8425,3607,3777,3772,3771,3608,3707,1530,1279,10168,5221,5217,4617,6617,3062,3058,9975,1814,1601,10573,10731,7544,9370,5875,10726,5020,478,1382,264,10530,550,1384,1374,8365,92,2895,10297,2892,9506,2876,2863,8040,8037,1354,7702,1566,9467,2469,8729,8718,8716,1125,7841,7742,9171,2827,882,883,4405,7296,4991,9529,9534,329,2427,7171,5140,5633,5197,6389,9153,7712,7986,9413,2546,2932,3134,3131,9022,7506,7504,10425,10423,10583,10424,10422,4259,7287,9265,5290,5288,8916,9803,1928,1460,607,6927,493,10429,10628,2642,3381,8326,3626,3620,1178,2479,632,8102,9437,10432,367,6802,8895,1222,6734,6730,2745,2470,896,7717,7432,5352,5702,843,465,1968,7200,408,5242,5237,3414,1435,7061,7953,3006,6793,6782,6822,8449,8445,3440,6523,8744,6573,2355,3222,3224,8747,8649,8755,10095,10096,5076,4394,4324,7357,7494,7958,7177,2804,2800,6520,10225,6998,7418,494,7088,7083,7082,8035,9099,106,9661,5017,5015,10170,3572,10544,4043,3992,3986,3982,5005,8279,8278,7662,9061,6436,7663,8287,4068,5319,8289,7407,7849,9073,5765,6924,6913,5823,9172,10145,10143,6895,6892,5202,10676,4349,4347,4346,2788,2777,5960,4644,1839,6231,6230,8456,8453,6096,1838,6653,5453,5443,5441,9769,9767,10541,2027,4067,2713,2705,2700,5311,7803,3753,6839,6833,3745,3651,3650,1551,1550,3503,9373,3658,1430,1423,5821,9416,10245,10244,5261,5255,5927,5920,862,5663,4438,6371,6850,7072,9479,9363,9360,9245,9241,9235,9239,9234,2331,4441,9757,10038,1697,8003,7755,7748,1514,1507,6555,1518,5547,8293,6147,6143,3519,3518,9477,706,7988,3065,8015,8012,8010,7970,4882,9711,827,5597,4774,8538,2599,310,3978,4185,4176,7434,9154,4179,6010,6119,4857,9257,5645,8926,633,677,10010,678,1376,2017,2015,368,8217,8216,6305,2847,5798,863,5520,9609,8235,8234,9594,7543,7539,2736,7548,9026,2312,7547,7542,2735,4105,6858,9027,3093,3886,311,6668,7738,7743,9738,7108,694,141,3169,3161,4409,4408,7592,4411,7594,4085,7917,4388,7307,7595,7591,1738,7570,7080,9659,7556,7805,2417,6153,207,1036,9647,1950,1037,796,1945,1944,10666,1144,512,6113,6109,10066,10065,6726,6725,6729,6110,8647,8645,6116,6073,6062,6069,6063,6071,6064,3685,3680,1741,1930,10556,2283,3634,3633,5768,6035,7868,4684,4683,8867,8862,3283,2485,8355,8351,1924,312,7613,6190,9902,9900,9043,4191,9336,5394,7285,5389,8002,5390,1061,1062,6343,6341,3936,6559,4738,2190,4524,4521,1703,1698,10444,10435,10571,8957,6426,6429,3028,4461,5753,9464,9463,5744,8104,9540,3276,9792,9786,7522,5269,7981,7977,7107,7267,620,7191,7190,9402,9401,4469,844,845,2869,2862,9903,7553,10288,10286,10285,1053,2999,3987,5022,2996,2214,6003,10445,2070,4786,10102,193,9253,6971,5614,5476,4520,4472,3559,4995,7503,7304,6028,864,865,8215,9588,10369,8134,9713,9712,6432,6264,3516,4460,3125,4052,3996,4299,4543,7412,3117,3123,6700,3037,4952,4418,6029,1828,6354,6210,6211,6196,6202,3233,3757,6199,7132,1126,1127,1128,3512,3511,5854,4458,3769,369,4628,5773,866,5463,5459,1978,6254,2315,2421,6200,3451,6396,3927,208,10564,10555,6423,6418,7509,3416,2984,2979,2981,1861,6425,665,2987,4065,9843,8678,916,8849,9012,5193,2711,7648,7705,4173,4174,6958,6954,6952,8953,8612,3708,5387,5382,3874,4166,7359,4467,2382,1727,2333,1486,6088,9275,1771,943,3008,4760,5735,4668,4194,3336,2341,6491,3616,9984,7228,7682,4833,4681,4769,5060,5058,9660,3870,5414,4147,8883,897,8772,3112,10738,2366,10371,7124,2794,5540,5045,8378,4703,307,1705,679,5343,817,818,2606,1129,4475,3136,1602,1715,3040,6128,7371,2471,445,446,9015,6438,4033,3637,3632,8151,8575,2337,3561,4515,2949,3016,4421,8259,10199,4739,10189,10174,8112,593,9968,5757,10442,5831,7900,6515,9366,115,140,8997,4344,10438,8748,10180,7261,3687,3682,1778,1777,6723,6712,5636,5635,1964,1959,2289,1963,8400,2350,2345,4868,4860,5053,7794,6084,8074,6079,8136,8080,5225,1628,7812,7784,4931,6419,7800,7779,2687,7583,345,1280,10343,1320,9715,9533,3456,828,6554,6543,3139,4641,5322,3623,4732,3628,3621,4817,9197,3654,3179,3174,1826,7560,6722,9231,6710,9405,3415,10034,10029,9046,4799,2096,1223,1224,163,171,2149,2147,2223,2217,2215,2093,806,8325,8322,8675,8191,7473,7487,7475,5219,9161,1299,6151,6145,6043,963,4532,513,7216,7210,7217,7976,7973,9357,5369,5357,5460,5466,5465,5462,186,178,2255,2246,8989,4657,132,579,580,9597,1300,5637,2939,10407,5082,172,2161,9415,8623,7206,7198,4189,10695,10696,8679,6918,6909,807,8685,9301,8055,8186,8177,8051,285,9521,9522,2024,8960,7121,7111,10795,7116,9764,944,524,707,9101,5602,109,2819,3972,447,4034,10646,5980,1652,1649,10611,10610,1491,1483,7918,1880,1878,164,6574,1646,65

I’ve identified that this only occurs when Yoast SEO is activated.

Theme: Twenty Seventeen
ACF Pro: 5.5.14
Yoast SEO Premium: 5.0.2

We heavily utilize both plugins, so any insight as to how we could resolve would be greatly appreciated.

Thanks,
Dan

• danatupserve

• July 21, 2017 at 3:48 am

This turned out to be a server issue. There was a governor that I suspect was misconfigured. It should have only been killed at 60sec but it was firing immediately on post/update.