Server errors reported with WP Smush

Got the following error: [Sun Jan 15 23:08:02.229148 2017] [:error] [pid 11842] [client 104.197.167.248:28029] KILLED QUERY (38977 characters long generated in /nas/content/live/eatjxn/wp-content/plugins/wp-smush-pro/lib/class-wp-smush-stats.php:75): SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (72,73,74,78,85,88,91,113,116,117,126,136,137,138,139,140,156,157,158,168,169,177,190,191,192,199,200,207,210,211,212,226,227,228,229,235,241,242,243,244,245,246,276,277,296,297,298,299,300,301,302,319,322,323,324,325,326,327,348,349,350,361,362,367,368,391,392,393,394,395,396,397,398,399,402,420,421,422,423,424,439,440,441,442,448,449,450,483,490,494,504,505,514,515,516,517,518,519,520,521,522,523,527,528,547,548,559,560,561,565,566,567,572,573,574,575,576,580,581,584,587,589,596,597,598,603,604,605,606,612,613,615,616,624,625,626,627,640,641,642,643,652,665,666,667,668,678,679,680,681,682,687,688,689,690,691,747,748,749,750,751,752,815,816,826,827,828,845,846,847,857,903,905,935,936,937,965,974,977,982,983,984,985,986,987,990,991,992,993,1000,1001,1002,1003,1065,1066,1085,1088,1093,1094,1112,1113,1114,1126,1151,1193,1194,1197,1199,1200,1201,1202,1203,1209,1228,1251,1252,1258,1259,1282,1409,1410,1411,1412,1427,1442,1481,1520,1523,1526,1535,1547,1637,1638,1639,1640,1643,1653,1686,1692,1751,1752,1753,1754,1755,1756,1763,1764,1772,1779,1782,1783,1784,1792,1793,1798,1799,1800,1812,1829,1830,1866,1867,1868,1882,1885,1888,1904,1922,1923,1924,1925,1926,1927,1969,1983,1984,1985,1986,2002,2005,2025,2029,2030,2037,2038,2039,2040,2041,2056,2059,2060,2061,2064,2073,2076,2077,2078,2079,2115,2116,2117,2137,2138,2139,2141,2151,2152,2153,2155,2179,2180,2181,2188,2198,2199,2230,2232,2233,2247,2248,2249,2270,2271,2272,2290,2291,2292,2300,2301,2302,2315,2329,2330,2331,2400,2432,2447,2449,2452,2453,2454,2458,2460,2482,2483,2484,2485,2486,2511,2514,2515,2516,2540,2545,2554,2555,2562,2564,2565,2567,2602,2603,2604,2611,2624,2625,2626,2627,2635,2637,2639,2640,2643,2665,2671,2683,2715,2761,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2836,2867,2882,2894,2895,2909,2910,2911,2912,2913,2923,2924,2925,2926,2927,2939,2940,2941,2942,2943,2945,2946,2947,2979,2980,2996,3014,3041,3095,3096,3125,3136,3137,3138,3147,3148,3154,3155,3163,3167,3170,3171,3172,3173,3174,3175,3176,3195,3199,3200,3202,3203,3223,3224,3225,3226,3227,3228,3248,3285,3286,3287,3288,3296,3303,3304,3305,3308,3323,3324,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,3346,3347,3348,3349,3350,3351,3352,3353,3354,3355,3356,3357,3358,3359,3360,3361,3369,3370,3371,3372,3373,3374,3375,3376,3382,3390,3393,3394,3396,3400,3402,3403,3404,3406,3413,3429,3455,3467,3468,3469,3471,3472,3488,3500,3502,3563,3564,3566,3567,3577,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3607,3608,3609,3610,3611,3613,3614,3626,3627,3687,3688,3689,3691,3692,3697,3709,3710,3712,3714,3721,3727,3728,3729,3740,3741,3742,3743,3744,3745,3761,3777,3778,3779,3788,3789,3790,3791,3792,3807,3808,3810,3827,3828,3829,3830,3831,3832,3836,3870,3869,3872,3884,3887,3921,3929,3930,3931,3932,3935,3973,3983,4003,4052,4053,4056,4057,4058,4066,4067,4068,4071,4134,4139,4140,4142,4151,4152,4153,4154,4155,4157,4174,4175,4176,4179,4192,4198,4214,4215,4216,4217,4218,4219,4220,4221,4222,4223,4224,4225,4226,4227,4228,4229,4230,4231,4232,4233,4234,4235,4236,4237,4238,4239,4240,4241,4242,4243,4244,4245,4247,4255,4256,4257,4258,4262,4266,4267,4268,4269,4270,4271,4272,4273,4274,4275,4276,4277,4278,4279,4280,4281,4282,4283,4284,4285,4286,4287,4288,4289,4290,4291,4292,4293,4294,4295,4296,4297,4298,4304,4318,4364,4365,4366,4367,4368,4376,4377,4378,4379,4380,4381,4382,4384,4385,4386,4387,4388,4389,4390,4391,4392,4393,4409,4410,4411,4412,4413,4414,4415,4416,4417,4418,4419,4420,4421,4422,4423,4424,4425,4426,4428,4429,4430,4431,4432,4433,4434,4435,4436,4437,4438,4439,4440,4441,4445,4446,4459,4464,4468,4478,4479,4490,4494,4502,4503,4504,4514,4515,4524,4525,4528,4530,4532,4558,4562,4563,4583,4584,4597,4598,4599,4619,4620,4628,4632,4642,4651,4660,4661,4662,4664,4674,4681,4683,4684,4685,4686,4688,4695,4698,4699,4700,4701,4707,4711,4722,4734,4735,4736,4743,4748,4797,4815,4820,4821,4822,4823,4824,4825,4826,4827,4828,4836,4850,4851,4858,4870,4871,4875,4882,4891,4898,4902,4904,4905,4906,4907,4908,4911,4912,4913,4924,4927,4928,4929,4935,4936,4937,4938,4939,4940,4941,4942,4943,4944,4945,4946,4947,4948,4949,4950,4951,4952,4953,4954,4955,4956,4957,4958,4961,4962,4963,4964,4982,4983,4993,4994,4995,5009,5010,5011,5012,5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,5024,5025,5026,5027,5028,5029,5030,5031,5032,5033,5034,5035,5036,5037,5038,5039,5040,5041,5042,5046,5050,5052,5053,5054,5071,5091,5099,5100,5101,5102,5115,5116,5123,5124,5125,5143,5144,5145,5147,5156,5158,5159,5160,5161,5162,5163,5178,5181,5182,5183,5184,5185,5186,5232,5233,5234,5235,5236,5237,5238,5239,5240,5241,5242,5278,5279,5280,5281,5282,5283,5303,5307,5313,5314,5315,5337,5338,5339,5354,5356,5357,5359,5360,5361,5371,5370,5372,5373,5374,5395,5411,5412,5413,5414,5415,5447,5452,5453,5463,5499,5500,5535,5536,5545,5546,5548,5552,5555,5599,5600,5601,5616,5630,5670,5686,5707,5709,5711,5714,5719,5721,5722,5728,5735,5763,5776,5777,5806,5807,5808,5809,5822,5825,5830,5834,5837,5848,5849,5850,5853,5865,5866,5867,5868,5869,5880,5928,5929,5947,5948,5960,5961,5962,5963,5972,5973,6033,6042,6043,6048,6049,6072,6073,6074,6075,6087,6134,6135,6144,6154,6182,6191,6211,6212,6214,6215,6216,6218,6219,6221,6234,6235,6237,6238,6239,6289,6301,6302,6305,6306,6307,6308,6309,6310,6311,6365,6406,6407,6414,6417,6449,6450,6451,6455,6476,6477,6495,6498,6499,6500,6501,6502,6509,6514,6520,6593,6594,6597,6604,6607,6608,6639,6649,6669,6670,6671,6672,6690,6691,6692,6693,6694,6712,6713,6727,6729,6730,6731,6732,6754,6781,6784,6792,6802,6818,6819,6835,6840,6844,6848,6853,6870,6882,6883,6888,6889,6890,6891,6892,6941,6942,6945,6952,6953,6954,6955,6960,6965,6966,6967,6968,6969,6970,6971,6972,6973,6974,6975,6976,6977,6978,6979,6980,6981,6982,6983,6984,6985,6986,6987,6988,6989,6990,6991,6992,6994,6996,6997,7000,7001,7011,7014,7015,7016,7023,7029,7039,7040,7041,7042,7050,7058,7061,7068,7069,7073,7074,7075,7083,7087,7088,7089,7110,7113,7117,7118,7150,7157,7183,7184,7190,7191,7195,7206,7207,7209,7211,7212,7214,7215,7254,7255,7256,7264,7265,7266,7287,7289,7288,7290,7299,7300,7317,7322,7327,7329,7331,7348,7349,7350,7353,7354,7360,7378,7389,7394,7406,7407,7424,7432,7433,7434,7447,7450,7455,7456,7457,7458,7459,7470,7471,7472,7473,7474,7475,7476,7477,7478,7479,7480,7481,7482,7483,7484,7485,7486,7487,7488,7489,7490,7491,7493,7492,7494,7495,7496,7497,7498,7499,7500,7501,7502,7503,7504,7505,7506,7507,7509,7508,7510,7511,7513,7514,7515,7516,7517,7518,7519,7525,7526,7540,7560,7561,7562,7613,7624,7638,7639,7640,7647,7658,7669,7679,7680,7685,7692,7709,7710,7711,7714,7717,7722,7723,7724,7725,7726,7727,7728,7729,7730,7731,7732,7733,7734,7735,7736,7737,7738,7739,7740,7741,7742,7743,7744,7745,7746,7747,7748,7749,7750,7751,7752,7753,7754,7755,7756,7757,7758,7759,7760,7761,7762,7763,7764,7765,7766,7767,7768,7769,7770,7771,7772,7773,7774,7775,7790,7791,7792,7793,7794,7795,7796,7813,7814,7815,7822,7824,7862,8405,7890,7897,7912,7913,7914,7915,7916,7918,7917,7919,7920,7921,7922,7923,7924,7925,7926,7927,7928,7929,7930,7931,7932,7933,7934,7935,7936,7937,7938,7939,7940,7941,7942,7943,7944,7945,7946,7947,7948,7949,7950,7951,7952,7953,7954,7955,7956,7957,7958,7959,7960,7961,7962,7964,7965,7985,7996,8008,8017,8036,8040,8052,8053,8060,8074,8075,8077,8078,8083,8123,8127,8142,8159,8160,8161,8408,8213,8214,8231,8232,8233,8234,8243,8244,8245,8252,8271,8281,8294,8295,8296,8297,8298,8299,8300,8301,8302,8303,8304,8305,8306,8307,8308,8309,8310,8394,8395,8399,8400,8401,8402,8636,8447,8453,8454,8455,8456,8469,8470,8471,8480,8492,8493,8494,8534,8568,8569,8572,8644,8645,8646,8650,8651,8661,8662,8663,8664,8665,8693,8694,8695,8696,8697,8698,8699,8721,8780,8789,8790,8795,8811,8814,8816,8818,8820,8822,8825,8826,8837,8867,8876,8903,8917,8919,8937,8939,8941,8944,8947,8951,8953,8955,8957,8959,8961,8963,8965,8967,8968,8971,8973,8975,8977,8979,8983,8984,8985,8986,8987,8988,8989,8993,9034,9035,9036,9055,9056,9059,9061,9063,9065,9069,9074,9076,907

  • Nastia

    Hello Eric Busby , I trust you are doing well!

    Would you please let me know under what circumstances you are getting this error? Please choose one option from the list:
    - Once you activated the plugin
    - After you started running bulk smush from Media > WP Smush
    - After manually smushing an image

    Can you please try to replicate the same issue with all the other plugins are deactivated? Deactivate all other plugins and test if the error is gone. If everything is well, activate one plugin at a time to find the one that causes this.

    Follow the steps from the flowchart:
    https://premium.wpmudev.org/manuals/using-wpmu-dev/getting-support/

    Please let me know how it went!

    Kind regards,
    Nastia

  • David Verzolla

    We've been experiencing the same issue reported above.

    There are a lot of entries on Apache Log as you can see below:

    [Tue Feb 21 12:20:46.274345 2017] [:error] [pid 32311] [client 201.33.111.254:44664] KILLED QUERY (57746 characters long generated in /nas/content/live/gecom/wp-content/plugins/wp-smush-pro/lib/class-wp-smush-stats.php:75): SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (..."a bunch of IDs")

    I've tried to add as attachment on this but I couldn't.

    How can we proceed?

  • Sajid

    Hello David Verzolla,
    Hope you are doing good today :slight_smile:

    I am sorry to hear you are getting this issue on your site too. I am unable to replicate this issue on my own test site.

    Let me please ping the developer of this plugin for his invaluable feedback on this matter. As soon as I will hear back from this member, I will post a reply here. Please note that, our developers have other routine task on daily basis, their response time can be slower than normal support here, so we really appreciate your patience here.

    Take care and have a nice day ahead :slight_smile:

    Best Regards,
    Sajid - WPMU DEV Support