-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
6.4.12, 7.1.6
-
6.04
-
2
-
Severity 2 - Major
-
Summary
worklogAuthor JQL syntax doesn't work when there are too many issues returned
Steps to Reproduce
- Use JIRA Data Generator to create around 200,000 issues (I managed to reproduce the problem with only 80,000 issues but not sure if this will differ in different machines)
- Make sure that a particular user has logged work on most of the issues
- Run the following JQL query
worklogAuthor = <username>
In my test, I used
worklogAuthor = admin
Expected Results
All issues are returned normally
Actual Results
The following is seen in the UI
The following thrown in the atlassian-jira.log
2016-05-06 20:55:01,733 http-nio-7161-exec-24 ERROR admin 1255x6244x2 1ei1a46 127.0.0.1 /rest/issueNav/1/issueTable [c.a.j.p.i.service.issuetable.DefaultIssueTableService] com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {issuekey in (10000, 100000, 100001, 100003, 100004, 100005, 100006, 100007, 100008, 100009, 10001, 100012, 100013, 100014, 100015, 100016, 100017, 100018, 100019, 100020, 100021, 100022, 100023, 100024, 100025, 100026, 100028, 100029, 10003, 100030, 100031, 100032, 100033, 100034, 100035, 100036, 100037, 100038, 100039, 10004, 100041, 100042, 100043, 100044, 100045, 100046, 100047, 100048, 10005, 100050, 100051, 100052, 100053, 100055, 100056, 100057, 100059, 10006, 100060, 100061, 100062, 100063, 100064, 100065, 100066, 100069, 10007, 100070, 100071, 100072, 100073, 100074, 100075, 100077, 100078, 100079, 10008, 100080, 100083, 100084, 100085, 100086, 100087, 100088, 100089, 10009, 100090, 100091, 100092, 100093, 100094, 100096, 100097, 100098, 10010, 100100, 100101, 100102, 100103, 100104, 100107, 100108, 100109, 100110, 100111, 100113, 100114, 100115, 100116, 100117, 100118, 100119, 10012, 100120, 100121, 100122, 100123, 100124, 100125, 100126, 100127, 100128, 100129, 10013, 100130, 100131, 100132, 100133, 100135, 100137, 100138, 100139, 10014, 100140, 100141, 100142, 100144, 100145, 100146, 100147, 100148, 100149, 10015, 100150, 100151, 100152, 100153, 100154, 100155, 100156, 100158, 100159, 10016, 100161, 100162, 100163, 100164, 100165, 100166, 100167, 100168, 100169, 10017, 100170, 100171, 100172, 100173, 100174, 100175, 100176, 100177, 100179, 10018, 100180, 100181, 100182, 100184, 100185, 100187, 100188, 100189, 100190, 100191, 100193, 100194, 100195, 100196, 100197, 100198, 100199, 100200, 100202, 100204, 100205, 100207, 100208, 100209, 10021, 100210, 100212, 100213, 100214, 100215, 100216, 100219, 100220, 100221, 100222, 100223, 100224, 100226, 100227, 100228, 100229, 10023, 100230, 100231, 100232, 100233, 100234, 100235, 100236, 100237, 100238, 100239, 10024, 100241, 100242, 100243, 100245, 100246, 100248, 100249, 100250, 100253, 100254, 100256, 100257, 100259, 10026, 100261, 100262, 100263, 100264, 100266, 100267, 100268, 100269, 100270, 100271, 100272, 100273, 100274, 100275, 100276, 100277, 100278, 100279, 10028, 100281, 100282, 100283, 100285, 100286, 100287, 100289, 10029, 100290, 100291, 100292, 100293, 100294, 100296, 100297, 100298, 100299, 10030, 100300, 100301, 100302, 100303, 100304, 100305, 100306, 100307, 100308, 100309, 10031, 100310, 100312, 100313, 100314, 100315, 100316, 100317, 100318, 100319, 100321, 100322, 100323, 100324, 100325, 100326, 100328, 100329, 10033, 100330, 100331, 100332, 100333, 100334, 100335, 100336, 100337, 100338, 100339, 10034, 100340, 100341, 100342, 100343, 100345, 100346, 100347, 100348, 100349, 10035, 100350, 100352, 100353, 100354, 100356, 100358, 100360, 100361, 100362, 100363, 100365, 100366, 100367, 100368, 100369, 10037, 100370, 100371, 100372, 100374, 100375, 100376, 100378, 100379, 10038, 100381, 100382, 100383, 100384, 100385, 100386, 100387, 100388, 100389, 10039, 100390, 100391, 100392, 100393, 100395, 100396, 100397, 100398, 100399, 10040, 100400, 100401, 100402, 100403, 100404, 100405, 100406, 100407, 100408, 100409, 10041, 100410, 100411, 100412, 100413, 100414, 100416, 100418, 10042, 100420, 100421, 100422, 100423, 100424, 100426, 100427, 100428, 100429, 10043, 100430, 100431, 100432, 100433, 100435, 100436, 100437, 100438, 100439, 10044, 100441, 100442, 100443, 100444, 100446, 100447, 100449, 100450, 100451, 100452, 100453, 100455, 100456, 100457, 100458, 100459, 10046, 100460, 100461, 100462, 100463, 100464, 100465, 100468, 10047, 100470, 100471, 100473, 100474, 100475, 100476, 100477, 100478, 100479, 10048, 100480, 100481, 100482, 100484, 100485, 100486, 100487, 100488, 100489, 10049, 100490, 100491, 100492, 100493, 100495, 100496, 100497, 100498, 100499, 10050, 100500, 100501, 100502, 100504, 100505, 100506, 100507, 100508, 100509, 10051, 100510, 100511, 100512, 100513, 100514, 100515, 100516, 100517, 100518, 100519, 10052, 100520, 100522, 100524, 100528, 100529, 10053, 100530, 100531, 100532, 100534, 100535, 100536, 100537, 100538, 10054, 100541, 100542, 100543, 100544, 100545, 100546, 100547, 100548, 100549, 10055, 100550, 100551, 100553, 100554, 100555, 100556, 100557, 100558, 100559, 10056, 100560, 100561, 100562, 100563, 100564, 100565, 100566, 100567, 100568, 100569, 10057, 100571, 100572, 100573, 100574, 100575, 100576, 100577, 100578, 100579, 10058, 100580, 100581, 100582, 100583, 100584, 100586, 100587, 100588, 100589, 10059, 100591, 100592, 100593, 100594, 100595, 100596, 100597, 100598, 100599, 10060, 100600, 100601, 100602, 100603, 100604, 100605, 100606, 100607, 100608, 100609, 10061, 100610, 100612, 100613, 100614, 100615, 100616, 100617, 100618, 100619, 10062, 100620, 100622, 100623, 100624, 100625, 100626, 100628, 100629, 10063, 100632, 100634, 100635, 100636, 100637, 100638, 100639, 10064, 100640, 100641, 100642, 100643, 100644, 100646, 100647, 100650, 100651, 100652, 100653, 100654, 100655, 100656, 100657, 100658, 100659, 10066, 100660, 100661, 100662, 100663, 100664, 100665, 100666, 100667, 100668, 100669, 100670, 100672, 100673, 100674, 100676, 100677, 100678, 10068, 100680, 100681, 100685, 100686, 100687, 100688, 10069, 100690, 100693, 100694, 100695, 100696, 100698, 100699, 10070, 100700, 100702, 100703, 100704, 100705, 100706, 100707, 100708, 100709, 10071, 100710, 100713, 100714, 100715, 100716, 100717, 100718, 100719, 10072, 100723, 100724, 100727, 100728, 10073, 100730, 100731, 100732, 100733, 100734, 100735, 100737, 100738, 100739, 100740, 100741, 100742, 100744, 100746, 100747, 100748, 100749, 100750, 100751, 100752, 100755, 100756, 100757, 100758, 100759, 100761, 100763, 100764, 100766, 100768, 10077, 100770, 100771, 100772, 100773, 100775, 100776, 100777, 100778, 100779, 10078, 100780, 100782, 100783, 100784, 100786, 100787, 100788, 10079, 100790, 100791, 100792, 100793, 100794, 100795, 100796, 100797, 100798, 100799, 10080, 100800, 100801, 100802, 100803, 100805, 100807, 100808, 100809, 10081, 100810, 100811, 100812, 100815, 100816, 100817, 100819, 10082, 100820, 100821, 100822, 100823, 100824, 100825, 100826, 100827, 100828, 100830, 100831, 100832, 100834, 100835, 100836, 100837, 100838, 100839, 100841, 100842, 100843, 100844, 100845, 100849, 10085, 100850, 100852, 100853, 100854, 100855, 100856, 100857, 100858, 100859, 10086, 100860, 100865, 100866, 100869, 100870, 100872, 100873, 100874, 100875, 100876, 100877, 100878, 100879, 100880, 100881, 100882, 100883, 100884, 100886, 100888, 100889, 100890, 100891, 100892, 100893, 100894, 100896, 100897, 100899, 10090, 100900, 100901, 100902, 100903, 100904, 100905, 100906, 100907, 100908, 100909, 10091, 100910, 100911, 100912, 100913, 100914, 100915, 100916, 100917, 100918, 10092, 100920, 100921, 100922, 100924, 100926, 100927, 100929, 10093, 100931, 100932, 100933, 100934, 100935, 100936, 100937, 100938, 100939, 10094, 100940, 100942, 100944, 100945, 100946, 100947, 100948, 10095, 100951, 100952, 100953, 100955, 100956, 100957, 100958, 100959, 10096, 100961, 100962, 100963, 100964, 100965, 100966, 100969, 100971, 100972, 100973, 100974, 100975, 100976, 100977, 100978, 100979, 10098, 100980, 100981, 100982, 100987, 100988, 100989, 10099, 100990, 100991, 100992, 100994, 100995, 100996, 100997, 100998, 100999, 10100, 101000, 101001, 101002, 101003, 101005, 101007, 101009, 10101, 101010, 101011, 101012, 101013, 101014, 101015, 101016, 101017, 101018, 101019, 101020, 101021, 101022, 101023, 101025, 101026, 101028, 101029, 10103, 101031, 101032, 101033, 101034, 101035, 101037, 101038, 101039, 10104, 101040, 101041, 101042, 101043, 101045, 101046, 101048, 10105, 101050, 101051, 101052, 101053, 101054, 101056, 101057, 101059, 10106, 101061, 101062, 101063, 101064, 101065, 101066, 101067, 101068, 10107, 101070, 101073, 101074, 101076, 101077, 10108, 101080, 101081, 101084, 101086, 101087, 101088, 10109, 101091, 101092, 101093, 101094, 101095, 101097, 101098, 101099, 101100, 101102, 101103, 101104, 101105, 101107, 101108, 101109, 10111, 101110, 101111, 101112, 101113, 101114, 101115, 101116, 101117, 101119, 10112, 101120, 101121, 101122, 101123, 101124, 101126, 101128, 101129, 10113, 101130, 101131, 101132, 101133, 101134, 101135, 101136, 101137, 101138, 101139, 10114, 101140, 101141, 101142, 101143, 101144, 101146, 101147, 101148, 101149, 10115, 101150, 101151, 101152, 101153, 101154, 101156, 101157, 101158, 101159, 101160, 101161, 101162, 101163, 101164, 101165, 101166, 101167, 101168, 101169, 10117, 101170, 101171, 101172, 101173, 101174, 101175, 101176, 101177, 101178, 101179, 101181, 101182, 101183, 101185, 101186, 101187, 101188, 10119, 101190, 101191, 101192, 101193, 101194, 101195, 101196, 101197, 101198, 101199, 10120, 101200, 101205, 101206, 101207, 101208, 101209, 10121, 101210, 101211, 101212, 101214, 101215, 101216, 101217, 101219, 10122, 101221, 101222, 101224, 101225, 101226, 101227, 101229, 101230, 101231, 101232, 101233, 101234, 101236, 101237, 101238, 101239, 101240, 101241, 101242, 101243, 101246, 101247, 101248, 10125, 101250, 101251, 101252, 101253, 101254, 101256, 101257, 101258, 101259, 10126, 101261, 101262, 101263, 101264, 101265, 101266, 101267, 101268, 101270, 101271, 101272, 101274, 101275, 101276, 101278, 101279, 101280, 101283, 101285, 101287, 101288, 101289, 10129, 101290, 101291, 101292, 101293, 101294, 101295, 101296, 101297, 101298, 101299, 101301, 101302, 101303, 101304, 101305, 101306, 101307, 101308, 101309, 10131, 101311, 101313, 101314, 101315, 101316, 101319, 10132, 101321, 101322, 101323, 101324, 101325, 101326, 101327, 101328, 101329, 10133, 101330, 101331, 101332, 101333, 101334, 101335, 101336, 101337, 101338, 101339, 10134, 101340, 101342, 101343, 101344, 101345, 101346, 101347, 10135, 101350, 101351, 101352, 101353, 101354, 101355, 101356, 101357, 101359, 10136, 101361, 101362, 101364, 101365, 101366, 101367, 101368, 101369, 10137, 101370, 101371, 101372, 101373, 101374, 101375, 101376, 101377, 101378, 10138, 101380, 101381, 101382, 101383, 101385, 101386, 101387, 99922, 99924, 99925, 99926, 99927, 99928, 99930, 99931, 99932, 99933, 99935, 99936, 99937, 99938, 99940, 99941, 99942, 99944, 99945, 99946, 99947, 99948, 99949, 99950, 99951, 99952, 99953, 99954, 99955, 99956, 99957, 99958, 99959, 99960, 99961, 99965, 99966, 99967, 99968, 99969, 99970, 99972, 99974, 99976, 99977, 99978, 99982, 99984, 99986, 99987, 99988, 99989, 99990, 99991, 99992, 99993, 99995, 99996, 99997, 99999)}
It actually returned many more issue keys but I left them out because it exceeded the character limit to create this Bug
Notes
- This also affects worklogAuthor != admin
- Basically if any of the search returns a huge amount of issues, it will fail
- Some users might not have any problems when using = but only run into problems with != or vice versa. This depends on how many issues are returned
Workaround
No known workaround
- relates to
-
JRASERVER-69930 Using certain JQL functions causes a ClauseTooComplexSearchException when many values exist in the database
- Gathering Impact