[CalendarServer-users] "list index out of range" error on previously functioning caldavd installation

Kyle Silfer kyle at rtoads.com
Mon Nov 16 11:38:42 PST 2015 

On Nov 16, 2015, at 10:24 AM, Kyle Silfer wrote:

>> Simply add the following lines to your caldavd.plist
>> 
>> <key>UseDatabase</key>
>> <false/>

I tried the opposite (making the key true) but it had no effect.

> Thanks for the clue! However, the Debian package is configured to use postgresql by default.
> 
> But I think based on what you're saying that there may be a communication issue between the database and caldavd. Postgresql is so obtuse to configure for "peer" versus password authentication, I may have screwed something up when I attempted to delete and recreate the database.

Well, I mirrored my pg_hba.conf and caldavd.plist files from the working server to the problem server and it doesn't matter, I am getting the same error.

I am now thinking that maybe my method of dropping the caldav database and recreating it to start fresh didn't work somehow. If the issue is mangled communication between caldavd and the database, I guess I will try deleting/recreating the postgresql database yet again.

Below is the full error incident as reported by iCal and caldavd/error.log, if anyone can interpret it. I am at a loss. This occurs after iCal client has connected to the server successfully as an admin user but before I have left the account adding window. The client offers two choices: "Stay Offline" or "Go Online". Choosing the latter resulting in the error repeating itself.

The full error from iCal is: 

"The server responded with
“HTTP/1.1 500 Internal Server Error”
to operation CalDAVAccountRefreshQueueableOperation.

The full error from caldavd/error.log is:

2015-11-16 12:24:19-0700 [-] [caldav-0]  [-] [twext.web2.server#error] Exception rendering request: <PROPFIND /calendars/__uids__/38EAE584-2B75-582B-A058-018391D1003F/ (1, 1)>
2015-11-16 12:24:19-0700 [-] [caldav-0] 	Traceback (most recent call last):
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 423, in errback
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    self._startRunCallbacks(fail)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 490, in _startRunCallbacks
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    self._runCallbacks()
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 577, in _runCallbacks
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    current.result = callback(current.result, *args, **kw)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1155, in gotResult
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    _inlineCallbacks(r, g, deferred)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	--- <exception caught here> ---
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    result = result.throwExceptionIntoGenerator(g)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    return g.throw(self.type, self.value, self.tb)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twistedcaldav/directory/common.py", line 101, in locateChild
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    child = yield self.homeResourceForRecord(record, request)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    result = result.throwExceptionIntoGenerator(g)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    return g.throw(self.type, self.value, self.tb)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twistedcaldav/directory/common.py", line 83, in homeResourceForRecord
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    child = yield self.homeResourceCreator(record, transaction)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    result = result.throwExceptionIntoGenerator(g)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    return g.throw(self.type, self.value, self.tb)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twistedcaldav/directory/calendar.py", line 223, in createHomeResource
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    parent, record.uid, transaction)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    result = result.throwExceptionIntoGenerator(g)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    return g.throw(self.type, self.value, self.tb)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twistedcaldav/resource.py", line 2027, in createHomeResource
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    transaction, name)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    result = result.throwExceptionIntoGenerator(g)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    return g.throw(self.type, self.value, self.tb)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twistedcaldav/resource.py", line 2389, in homeFromTransaction
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    storeHome = yield transaction.calendarHomeWithUID(uid)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    result = result.throwExceptionIntoGenerator(g)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    return g.throw(self.type, self.value, self.tb)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/txdav/common/datastore/sql.py", line 1606, in homeWithUID
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    homeObject = (yield homeObject.initFromStore())
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1099, in _inlineCallbacks
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    result = g.send(result)
2015-11-16 12:24:19-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/txdav/common/datastore/sql.py", line 1570, in initFromStore
2015-11-16 12:24:19-0700 [-] [caldav-0] 	    self._txn, resourceID=self._resourceID))[0]
2015-11-16 12:24:19-0700 [-] [caldav-0] 	exceptions.IndexError: list index out of range

















>>> Am 13.11.2015 um 19:54 schrieb Kyle Silfer <kyle at rtoads.com>:
>>> 
>>> I've installed the latest Debian calendarserver package on Ubuntu 14.04 on 3 different more-or-less identical Dell servers.
>>> 
>>> On one of the 3 servers I am experiencing an error. It started when I imported calendar events from a particularly large calendar. The symptom on the client side is a "CalDAVAccountRefreshQueueableOperation" error. It occurs now with every attempt to connect to the account.
>>> 
>>> The symptom on the server side is:
>>> 
>>> 2015-11-13 09:21:33-0700 [-] [caldav-0] 	  File "/usr/lib/python2.7/dist-packages/txdav/common/datastore/sql.py", line 1570, in initFromStore
>>> 2015-11-13 09:21:33-0700 [-] [caldav-0] 	    self._txn, resourceID=self._resourceID))[0]
>>> 2015-11-13 09:21:33-0700 [-] [caldav-0] 	exceptions.IndexError: list index out of range
>>> 
>>> Thinking this to perhaps be due to corrupt data, I deleted the caldav database plus files in the /var/spool/caldavd and /var/lib/caldavd, restarted the server and am still getting that error each time I try to connect.
>>> 
>>> The error seems to be from Python and has come up for users of other packages too.
>>> 
>>> If it isn't the calendar data that is causing or contributing to this error, is there a Python cache or other persistent data that needs to be deleted to really have a fresh start with calendarserver?
>>> 
>>> Because my other two installs are working fine, including one where I imported the same data.
>>> 
>>> Any clues?
>>> 
>>> ./k
>>> 
>>> 
>>> _______________________________________________
>>> calendarserver-users mailing list
>>> calendarserver-users at lists.macosforge.org
>>> https://lists.macosforge.org/mailman/listinfo/calendarserver-users
>> 
>> 
>> 
> 
> --
> Kyle Silfer
> Reign of Toads
> IT Consultation Services
> 505.265.5840 h
> 505.918.0978 c
> 505.346.0660 x242 w
> 
> _______________________________________________
> calendarserver-users mailing list
> calendarserver-users at lists.macosforge.org
> https://lists.macosforge.org/mailman/listinfo/calendarserver-users
> 
> 

--
Kyle Silfer
Reign of Toads
IT Consultation Services
505.265.5840 h
505.918.0978 c
505.346.0660 x242 w

More information about the calendarserver-users mailing list