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

[Ivan Baldo]

    Hello Guido!!! Thanks a lot!

El 23/12/08 11:23, Guido Günther escribió:
> 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. 
>   
    As I said in my report, I already tried to raise the limit and it 
didn't work, SQLite complains.

    Thanks for looking into this!!!
P.s.: btw, I didn't found a way to report problems to the Calendarserver 
upstream developers.


-- 
Ivan Baldo - ibaldo at adinet.com.uy - http://ibaldo.codigolibre.net/
From Montevideo, Uruguay, at the south of South America.
Freelance programmer and GNU/Linux system administrator, hire me!
Alternatives: ibaldo at codigolibre.net - http://go.to/ibaldo