[Calendarserver-maintainers] Bug#509195: Bug#509195: Unable to work with more than 1000 items in a group calendar

[Guido Günther]

Hi Ivan,
On Fri, Dec 19, 2008 at 12:19:00PM -0200, Ivan Baldo wrote:
>   I had a group calendar that after some time it surpassed 1000 items one
> day, at the next day I couldn't access that group calendar.
>   I tried with Iceowl (Sunbird) and Evolution and both had the same problem.
>   To solve the issue I had to manually go to the
> /var/spool/caldavd/calendars/__uids__/ab7ac0ee-956b-5f15-ba03-2e1c53be8855/calendar
> directory and delete the oldest .ics files and have less than 1000 of them.
>   In the error.log it complained about this:
> [-] [caldav-8008]  [-] 'Too many matching components in calendar-query report'.
>   There is a variable called max_number_of_results set to 1000 in
> /usr/share/pyshared/twistedcaldav/method/report_calquery.py but even setting
> it to 1100 caused SQLite to complain.
>   I don't know how to solve this issue, thanks for your help.
The limit seems to be in twisted-clendarserver (max_number_of_matches).
Calendarserver itself gets a NumberOfMatches exception then
(eport_calquery.py) and calendar access is denied:

  except NumberOfMatchesWithinLimits:
        log.err("Too many matching components in calendar-query report")
        raise HTTPError(ErrorResponse(responsecode.FORBIDDEN, (dav_namespace, "number-of-matches-within-limits")))

Could try rising max_number_of_matches in twisted-calendarserver and see
if this helps?  I'll do some tests myself after holiday and recheck with
upstream howto best solve this. 
 -- Guido