[TIME-152] Using a group with too many members can be really slow or crash Jira.

Great plugin, but found an issue.

We found that by using jira-users in the plugin, where our number of users (34413) exceeds the limit imposed on postgres jdbc (32767) will crash Jira (4.3.3).

Could the plugin be updated to ensure that putting in a large group will not crash Jira?

1-05-11 06:29:14,620 http-8080-4 WARN asevastiyano 389x527x1 1m7v6jo 135.105. 242.14,127.0.0.1 /secure/ConfigureReport.jspa [velocity] Warning! The iterative is an Iterator in the #foreach() loop at [0,0] in template templates/timesheetr eport/timesheet-entry.vm. Because it's not resetable, if used in more than once, this may lead to unexpected results. 2011-05-11 06:29:14,625 http-8080-4 WARN asevastiyano 389x527x1 1m7v6jo 135.105. 242.14,127.0.0.1 /secure/ConfigureReport.jspa [velocity] Warning! The iterative is an Iterator in the #foreach() loop at [0,0] in template templates/timesheetr eport/timesheet-entry.vm. Because it's not resetable, if used in more than once, this may lead to unexpected results. 2011-05-11 06:31:45,150 http-8080-11 WARN asevastiyano 391x530x1 1m7v6jo 135.105 .242.14,127.0.0.1 /secure/ConfigureReport!excelView.jspa [velocity] Warning! The iterative is an Iterator in the #foreach() loop at [0,0] in template templates /timesheetreport/timesheet-report-excel.vm. Because it's not resetable, if used in more than once, this may lead to unexpected results. 2011-05-11 06:40:33,073 http-8080-7 ERROR [500ErrorPage.jsp] Exception caug ht in 500 page SQL Exception while executing the following:SELECT ID, issueid, A UTHOR, grouplevel, rolelevel, worklogbody, CREATED, UPDATEAUTHOR, UPDATED, START DATE, timeworked FROM public.worklog WHERE (STARTDATE >= ? ) AND (STARTDATE < ? ) AND (AUTHOR IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ...

Thanks for your time.

By wracz/Warren Racz on Thu, 12 May 2011 11:51:52 -0700

Comments (1)