Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-60917

worklogAuthor JQL syntax doesn't work when too many issues are returned

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Medium
    • None
    • 6.4.12, 7.1.6
    • JQL

    Description

      Summary

      worklogAuthor JQL syntax doesn't work when there are too many issues returned

      Steps to Reproduce

      1. 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)
      2. Make sure that a particular user has logged work on most of the issues
      3. 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

      1. This also affects worklogAuthor != admin
      2. 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

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ywoo Yit Wei
              Votes:
              6 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated: