[CalendarServer-users] multiget limit on a large calendar not enough

Jan Bätzner lists at jbweb.de
Sat Jun 13 04:07:50 PDT 2009

Hi everyone,

i am trying to use a large (7000 Entry) Calender with Sunbird. It  
works fine with iCal but Sunbird seems to initialize the newly  
configured calender with one multiget command. It fails with an error:

2009-06-13 09:24:01+0200 [-] [caldav-8443]  [-] 'Too many results in  
multiget report: 7014'

I tried to simply change the limit in twistedcaldav/method/ 

max_number_of_multigets = 10000

That gives me the following error:

2009-06-13 12:50:49+0200 [-] [caldav-8443] 	  File "/usr/lib/python2.5/ 
site-packages/twistedcaldav/sql.py", line 246, in _db_execute
2009-06-13 12:50:49+0200 [-] [caldav-8443] 	    q.execute(sql,  
2009-06-13 12:50:49+0200 [-] [caldav-8443] 	sqlite3.OperationalError:  
too many SQL variables

Well, that looks like a sqlite limitation. I cannot find out how to  
change that limit.
On the other side, i tried to find out, if it is possible to tell  
Sunbird not to use the multiget. Seems not an option.

Any Ideas how to get around this?

Thanks  in advance,

Sumo Solutions
Jan Bätzner+Gollierstr. 23+80339 München
Telefon: 089 38164965
Fax: 089 66652870
Mobiltelefon: 0179 4973072	

More information about the calendarserver-users mailing list