Skip Navigation

[Resolved] View Generating KILLED QUERY Error

This support ticket is created 6 years, 2 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Kolkata (GMT+05:30)

This topic contains 3 replies, has 2 voices.

Last updated by Minesh 6 years, 2 months ago.

Assisted by: Minesh.

Author
Posts
#1131262

Link to a page where the issue can be seen:
hidden link

I am using Views (see: Posts - 3 Column - Grid - Overlay) to display 3 items. No pagination. When I view the page, the following error is generated. I am trying to troubleshoot another issue and I am pretty sure the error below is related.

Thank you

##############

[Sun Oct 21 00:45:01.442962 2018] [:error] [pid 11453] [client 128.32.58.136:26015] KILLED QUERY (25966 characters long generated in /nas/content/live/richcondev2/wp-content/plugins/types/vendor/toolset/types/embedded/classes/loader.php:99): SELECT * FROM wp_postmeta WHERE post_id IN (70628,70627,70518,70516,70506,70495,70488,70464,70463,70456,70445,70361,70364,70392,70429,70421,70409,70389,70400,70379,70284,70184,70287,70325,70269,70303,70301,70262,70257,70215,70248,70190,70087,70083,70077,70074,70068,70060,70052,70047,70041,70035,70031,70028,70019,70013,70011,69998,69992,69987,69981,69970,69963,69960,69950,69936,69945,69937,69932,69905,69898,69921,69788,69796,69890,69762,69812,69827,69834,69852,69862,69883,69843,69872,69759,69753,69748,69740,69735,69723,69727,69717,69706,69701,69675,69688,69610,69637,69639,69560,69602,69558,69136,69594,69567,69485,69506,69486,69467,69462,69457,69056,69373,69391,69409,69352,69300,69271,69258,69261,69215,69212,69202,69208,69144,69193,69137,69057,69059,69049,69046,69037,68727,69032,69028,69025,69020,69015,68784,68974,68987,68795,68791,68797,68781,68777,68544,68769,68766,68760,68752,68747,68731,68722,68712,68703,68674,68670,68652,68480,68629,68571,68572,68568,68564,68415,68553,68541,68532,68525,68520,68521,68515,68471,68468,68465,68457,68453,68450,68447,68444,68440,68421,68401,68398,68417,68399,68392,68390,68382,68372,68355,68364,68326,68348,68341,68324,68320,68291,68301,68298,68294,68082,68064,68060,68056,68054,68051,68045,68024,68008,68003,67989,67979,67968,67973,67945,67958,67952,67937,67935,67930,67926,67921,67916,67911,67907,67894,67889,67880,67875,67870,67863,67854,67844,67841,67835,67752,67809,67800,67802,67765,67783,67780,67775,67758,67744,67732,67728,67724,67719,67714,67708,67706,67702,67697,67668,67671,67658,67657,67654,67647,67644,67641,67637,67499,67612,67601,67599,67603,67596,67589,67592,67584,67582,67576,67567,67562,67529,67540,67530,67522,67516,67514,67507,67420,67494,67490,67478,67483,67472,67468,67481,67469,67463,67456,67449,67448,67431,67416,67428,67425,67386,67407,67402,67400,67388,67361,67348,67342,67333,67329,67151,67054,67192,67165,67147,67138,67066,67125,67114,67092,67087,67085,67057,67050,67048,67039,67033,67018,67009,66993,66966,67015,67012,66980,66954,66952,66897,66930,66927,66906,66868,66892,66880,66874,66867,66871,66853,66843,66842,66822,66767,66763,66758,66746,66739,66704,66726,66721,66720,66715,66709,66692,66610,66681,66632,66675,66590,66649,66637,66618,66614,66612,66594,66606,66589,66583,66578,66562,66549,66551,66545,66540,66527,66520,66522,66513,66509,66501,66491,66421,66432,66427,66416,66369,66370,66366,66358,66354,66340,66334,66327,66329,66321,66317,66311,66303,66293,66296,66279,66282,66267,66262,66255,66248,66244,66240,66236,66232,66225,66209,66221,66207,66200,66191,66161,66183,66158,66150,66148,66142,66138,66123,66113,66105,66091,66076,66074,66064,66032,66034,65994,66001,66020,65980,66011,65989,65917,65984,65963,65965,65919,65937,65920,65900,65887,65872,65860,65847,65840,65836,65832,65828,65826,65804,65783,65771,65652,65756,65748,65746,65724,65670,65689,65668,65664,65615,65601,65599,65588,65585,65565,65560,65552,65548,65539,65530,65529,65512,65500,65488,65463,65486,65476,65465,65470,65466,65457,65442,65443,65429,65414,65415,65389,65360,65359,65354,65347,65346,65335,65336,65329,65308,65261,65300,65257,65243,65237,65213,65210,65191,65181,65163,65161,65165,65039,65149,65142,65131,65139,65111,65087,65076,65048,65046,65034,65015,65014,65011,64976,64972,64970,64949,64932,64927,64920,64924,64915,64907,64904,64884,64895,64890,64863,64853,64827,64810,64813,64798,64784,64794,64780,64777,64767,64749,64760,64741,64746,64734,64732,64722,64725,64719,64697,64701,64702,64690,64679,64666,64652,64648,64640,64622,64624,64616,64610,64601,64595,64588,64583,64573,64569,64563,64558,64554,64548,64538,64522,64496,64497,64483,64486,64480,64468,64466,64470,64376,64392,64337,64424,64419,64334,64412,64382,64406,64401,64397,64386,64317,64374,64355,64341,64329,64319,64266,64308,64304,64280,64298,64271,64285,64263,64274,64226,64258,64253,64219,64224,64173,64191,64181,64158,64154,64147,64142,64137,64104,64100,64092,64089,64086,64083,64068,64064,64048,64046,64042,64031,64017,63973,63962,63945,63942,63927,63906,63911,63902,63899,63894,63887,63852,63706,63841,63838,63828,63822,63815,63817,63805,63792,63801,63782,63778,63767,63749,63728,63720,63708,63673,63696,63691,63667,63658,63644,63639,63618,63611,63606,63557,63584,63574,63573,63556,63542,63545,63524,63510,63519,63505,63506,63501,63492,63478,63473,63469,63460,63455,63306,63449,63434,63405,63396,63390,63397,63386,63328,63323,63298,63291,63280,63264,63261,63259,63222,63236,63238,63220,63179,63175,63133,63136,63165,63125,63105,63117,63109,63084,63085,63056,63074,63072,63067,63026,63052,63011,63018,62959,62949,62977,62961,62962,62953,62939,62936,62924,62913,62893,62890,62884,62867,62865,62862,62837,62845,62843,62835,62829,62816,62819,62812,62806,62800,62760,62738,62749,62746,62723,62720,62705,62695,62697,62686,62683,62667,62672,62656,62650,62638,62639,62582,62629,62625,62621,62612,62619,62598,62584,62579,62575,62570,62559,62567,62556,62552,62546,62541,62536,62524,62528,62518,62487,62483,62439,62440,62437,62432,62424,62388,62373,62368,62365,62349,62344,62332,62331,62305,62321,62312,62307,62289,62282,62278,62269,62246,62253,62228,62235,62221,62219,62188,62215,62200,62190,62179,62053,62015,61999,61983,61981,61986,62027,62023,62003,62000,61939,61963,61950,61949,61945,61932,61912,61910,61888,61878,61865,61852,61843,61828,61794,61785,61776,61761,61728,61712,61693,61687,61678,61667,61662,61655,61650,61643,61639,61633,61629,61623,61546,61612,61581,61559,61566,61550,61537,61529,61519,61515,61507,61486,61480,61467,61456,61453,61450,61447,61388,61410,61370,61424,61400,61355,61319,61310,61348,61342,61337,61334,61331,61328,61297,61289,60963,61261,61232,61229,61219,61215,61211,61200,61127,61122,61135,61101,61068,61006,61057,61030,60979,61022,61025,60960,60671,60947,60996,60955,60940,60913,60916,60852,60841,60847,60776,60782,60788,60709,60751,60727,60716,60679,60676,60575,60544,60588,60638,60633,60630,60596,60441,60535,60548,60523,60519,60500,60391,60458,60465,60455,60393,60421,60417,60414,60410,60203,60316,60297,59472,60227,59462,59791,60184,59588,59716,60151,60241,60011,60035,60170,59835,60154,60136,60052,60115,60110,60091,60062,60063,59977,60040,60018,59928,60001,59991,59888,59965,59906,59851,59748,59821,59806,59778,59702,59710,59685,59722,59611,59619,59603,59580,59582,59495,59568,59559,59125,59487,59534,59452,59437,59461,59423,59380,59345,59249,59279,59354,59333,59362,59204,59146,59305,59297,59273,59184,59220,59254,59245,59239,59212,59232,59168,59156,59139,59052,59131,59065,59088,59060,58956,59024,58930,59029,58429,58955,58949,58925,58892,58885,58870,58853,58836,58830,58818,58812,58803,58801,58777,58708,58742,58669,58652,58665,58675,58663,58649,58594,58525,58618,58539,58541,58557,58471,58413,58399,58479,58377,58367,58354,58296,58247,58243,58133,58156,58115,58068,58087,58056,58034,58039,58024,57995,57979,57969,57963,57959,57949,57934,57925,57912,57895,57845,57819,57808,57761,57782,57774,57753,57501,57393,57708,57688,57681,57511,57481,57467,57449,57362,57300,57351,57286,57313,57252,57260,57225,57233,57218,56956,57203,57157,57170,57113,56977,56973,56936,56819,56887,56867,56806,56836,56738,56766,56794,56718,56720,56686,56676,56536,56615,56649,56562,56587,56477,56458,56475,56417,56402,56393,56390,56363,56351,56339,56312,56257,56262,56228,54131,56148,56211,56186,56192,56113,56003,56073,55990,56048,55996,55976,55962,55935,55848,55925,55899,55880,55830,55790,55812,55729,55761,55741,55705,55646,55689,55637,55277,55609,55582,55563,55546,55266,55346,55259,55223,55244,55169,55142,55183,55151,55156,55134,55106,55095,55028,55058,55015,54993,54962,54715,54940,54302,54918,54869,54818,54819,54795,54679,54680,54754,54515,54590,54528,54523,54471,54497,54475,54464,54439,54399,54380,54345,54323,54330,54243,54264,54244,54223,54111,54167,54100,54079,54053,54005,53955,53986,53951,53921,53896,53882,53854,53811,53826,53786,53746,53715,53728,53672,53692,53665,53653,53559,53620,53590,53588,53618,53540,53530,53513,53497,53471,53465,53454,53417,53405,53395,53376,53336,53319,53285,53268,53245,53

#1131792

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

Well - I checked on your install, you are querying the default posttype "post" using views and that "post" posttype having 4561 entries. It's obvious that view's query is going to fail as you are querying too many posts that should took all the server resources.

I suggest adding pagination to your view that will help you to resolve your issue or as you defined set a specific limit.

#1132171
query.png

Hello. Pagination makes no sense for this landing page. I tried it anyway. Same error. The limit is already set to display 3 records. Since I cannot delete the entries, can you suggest anything else? Since 4,500 entries is causing an issue, is there a practical limit when using Views?

#1132593

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Well - I see you are using wpengine16, to ensure there is no issue from WPEngine server settings - could you please crosscheck with WPEngline support as well and raise the query there.

Additionally - what if you try to query all 4500 posts without views - are you able to load the posts?