<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">There's not quite enough info here to know exactly what's wrong, but in general:</div><div class=""><br class=""></div><div class=""><ul class="MailOutline"><li class="">The failure is happening as the server tries to create a user's calendar home (initFromStore). This is something that happens once, the first time the user logs in.</li><li class="">If you haven't already done so, I would double check your account definitions (e.g. xml files, LDAP, whatever you're using).</li></ul><div class=""><br class=""></div></div><div class="">If you can manually connect with psql, try a couple queries to validate the DB:</div><div class=""><br class=""></div><div class=""><font face="Courier" class="">caldav=# select * from calendarserver;<br class=""> name | value <br class="">--------------------------+-------<br class=""> CALENDAR-DATAVERSION | 6<br class=""> ADDRESSBOOK-DATAVERSION | 2<br class=""> NOTIFICATION-DATAVERSION | 1<br class=""> MANAGED-ATTACHMENTS | 1<br class=""> VERSION | 59<br class=""> MIN-VALID-REVISION | 716<br class="">(6 rows)<br class=""><br class="">caldav=# select count(1) from calendar_home;<br class=""> count <br class="">-------<br class=""> 84<br class="">(1 row)</font></div><div class=""><br class=""></div><div class="">-dre</div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Nov 16, 2015, at 11:38 AM, Kyle Silfer <<a href="mailto:kyle@rtoads.com" class="">kyle@rtoads.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class=""><br class="">On Nov 16, 2015, at 10:24 AM, Kyle Silfer wrote:<br class=""><br class=""><blockquote type="cite" class=""><blockquote type="cite" class="">Simply add the following lines to your caldavd.plist<br class=""><br class=""><key>UseDatabase</key><br class=""><false/><br class=""></blockquote></blockquote><br class="">I tried the opposite (making the key true) but it had no effect.<br class=""><br class=""><blockquote type="cite" class="">Thanks for the clue! However, the Debian package is configured to use postgresql by default.<br class=""><br class="">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.<br class=""></blockquote><br class="">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.<br class=""><br class="">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.<br class=""><br class="">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.<br class=""><br class="">The full error from iCal is: <br class=""><br class="">"The server responded with<br class="">“HTTP/1.1 500 Internal Server Error”<br class="">to operation CalDAVAccountRefreshQueueableOperation.<br class=""><br class="">The full error from caldavd/error.log is:<br class=""><br class="">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)><br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span>Traceback (most recent call last):<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 423, in errback<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> self._startRunCallbacks(fail)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 490, in _startRunCallbacks<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> self._runCallbacks()<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 577, in _runCallbacks<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> current.result = callback(current.result, *args, **kw)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1155, in gotResult<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> _inlineCallbacks(r, g, deferred)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span>--- <exception caught here> ---<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> result = result.throwExceptionIntoGenerator(g)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> return g.throw(self.type, self.value, self.tb)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twistedcaldav/directory/common.py", line 101, in locateChild<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> child = yield self.homeResourceForRecord(record, request)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> result = result.throwExceptionIntoGenerator(g)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> return g.throw(self.type, self.value, self.tb)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twistedcaldav/directory/common.py", line 83, in homeResourceForRecord<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> child = yield self.homeResourceCreator(record, transaction)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> result = result.throwExceptionIntoGenerator(g)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> return g.throw(self.type, self.value, self.tb)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twistedcaldav/directory/calendar.py", line 223, in createHomeResource<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> parent, record.uid, transaction)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> result = result.throwExceptionIntoGenerator(g)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> return g.throw(self.type, self.value, self.tb)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twistedcaldav/resource.py", line 2027, in createHomeResource<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> transaction, name)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> result = result.throwExceptionIntoGenerator(g)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> return g.throw(self.type, self.value, self.tb)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twistedcaldav/resource.py", line 2389, in homeFromTransaction<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> storeHome = yield transaction.calendarHomeWithUID(uid)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> result = result.throwExceptionIntoGenerator(g)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/python/failure.py", line 389, in throwExceptionIntoGenerator<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> return g.throw(self.type, self.value, self.tb)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/txdav/common/datastore/sql.py", line 1606, in homeWithUID<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> homeObject = (yield homeObject.initFromStore())<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1099, in _inlineCallbacks<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> result = g.send(result)<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/txdav/common/datastore/sql.py", line 1570, in initFromStore<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> self._txn, resourceID=self._resourceID))[0]<br class="">2015-11-16 12:24:19-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span>exceptions.IndexError: list index out of range<br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><blockquote type="cite" class=""><blockquote type="cite" class=""><blockquote type="cite" class="">Am 13.11.2015 um 19:54 schrieb Kyle Silfer <<a href="mailto:kyle@rtoads.com" class="">kyle@rtoads.com</a>>:<br class=""><br class="">I've installed the latest Debian calendarserver package on Ubuntu 14.04 on 3 different more-or-less identical Dell servers.<br class=""><br class="">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.<br class=""><br class="">The symptom on the server side is:<br class=""><br class="">2015-11-13 09:21:33-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> File "/usr/lib/python2.7/dist-packages/txdav/common/datastore/sql.py", line 1570, in initFromStore<br class="">2015-11-13 09:21:33-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span> self._txn, resourceID=self._resourceID))[0]<br class="">2015-11-13 09:21:33-0700 [-] [caldav-0] <span class="Apple-tab-span" style="white-space:pre"> </span>exceptions.IndexError: list index out of range<br class=""><br class="">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.<br class=""><br class="">The error seems to be from Python and has come up for users of other packages too.<br class=""><br class="">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?<br class=""><br class="">Because my other two installs are working fine, including one where I imported the same data.<br class=""><br class="">Any clues?<br class=""><br class="">./k<br class=""><br class=""><br class="">_______________________________________________<br class="">calendarserver-users mailing list<br class=""><a href="mailto:calendarserver-users@lists.macosforge.org" class="">calendarserver-users@lists.macosforge.org</a><br class="">https://lists.macosforge.org/mailman/listinfo/calendarserver-users<br class=""></blockquote><br class=""><br class=""><br class=""></blockquote><br class="">--<br class="">Kyle Silfer<br class="">Reign of Toads<br class="">IT Consultation Services<br class="">505.265.5840 h<br class="">505.918.0978 c<br class="">505.346.0660 x242 w<br class=""><br class="">_______________________________________________<br class="">calendarserver-users mailing list<br class=""><a href="mailto:calendarserver-users@lists.macosforge.org" class="">calendarserver-users@lists.macosforge.org</a><br class="">https://lists.macosforge.org/mailman/listinfo/calendarserver-users<br class=""><br class=""><br class=""></blockquote><br class="">--<br class="">Kyle Silfer<br class="">Reign of Toads<br class="">IT Consultation Services<br class="">505.265.5840 h<br class="">505.918.0978 c<br class="">505.346.0660 x242 w<br class=""><br class="">_______________________________________________<br class="">calendarserver-users mailing list<br class=""><a href="mailto:calendarserver-users@lists.macosforge.org" class="">calendarserver-users@lists.macosforge.org</a><br class="">https://lists.macosforge.org/mailman/listinfo/calendarserver-users<br class=""></div></div></blockquote></div><br class=""></div></body></html>