Q: How to fix 500 CalDAVAccountRefreshQueueableOperation
Hello
After updating from 10.7 to 10.10 (over 10.9) in basically one step, i encounter an error on my Calendar app.
I figured out that is is just a single entry:
2014-10-28 10:37:53+0100 [-] [caldav-2] [-] [txweb2.server#error] Exception rendering request: <REPORT /calendars/__uids__/C7D9C4F4-08C5-41DE-A85C-3AE3250B6FFD/calendar/ (1, 1)>
2014-10-28 10:37:53+0100 [-] [caldav-2] Traceback (most recent call last):
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 423, in errback
2014-10-28 10:37:53+0100 [-] [caldav-2] self._startRunCallbacks(fail)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 490, in _startRunCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] self._runCallbacks()
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 577, in _runCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] current.result = callback(current.result, *args, **kw)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1155, in gotResult
2014-10-28 10:37:53+0100 [-] [caldav-2] _inlineCallbacks(r, g, deferred)
2014-10-28 10:37:53+0100 [-] [caldav-2] --- <exception caught here> ---
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] result = result.throwExceptionIntoGenerator(g)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator
2014-10-28 10:37:53+0100 [-] [caldav-2] return g.throw(self.type, self.value, self.tb)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/twistedcaldav/resource.py", line 327, in renderHTTP
2014-10-28 10:37:53+0100 [-] [caldav-2] response = yield super(CalDAVResource, self).renderHTTP(request)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] result = result.throwExceptionIntoGenerator(g)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator
2014-10-28 10:37:53+0100 [-] [caldav-2] return g.throw(self.type, self.value, self.tb)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/txweb2/static.py", line 128, in renderHTTP
2014-10-28 10:37:53+0100 [-] [caldav-2] response = yield super(StaticRenderMixin, self).renderHTTP(request)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] result = result.throwExceptionIntoGenerator(g)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator
2014-10-28 10:37:53+0100 [-] [caldav-2] return g.throw(self.type, self.value, self.tb)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/txweb2/resource.py", line 121, in renderHTTP
2014-10-28 10:37:53+0100 [-] [caldav-2] returnValue((yield result))
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] result = result.throwExceptionIntoGenerator(g)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator
2014-10-28 10:37:53+0100 [-] [caldav-2] return g.throw(self.type, self.value, self.tb)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/twistedcaldav/method/report.py", line 137, in http_REPORT
2014-10-28 10:37:53+0100 [-] [caldav-2] result = (yield method(request, doc.root_element))
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] result = result.throwExceptionIntoGenerator(g)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator
2014-10-28 10:37:53+0100 [-] [caldav-2] return g.throw(self.type, self.value, self.tb)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/twistedcaldav/method/report_multiget_common.py", line 295, in multiget_common
2014-10-28 10:37:53+0100 [-] [caldav-2] yield doResponse()
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] result = result.throwExceptionIntoGenerator(g)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator
2014-10-28 10:37:53+0100 [-] [caldav-2] return g.throw(self.type, self.value, self.tb)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/twistedcaldav/method/report_multiget_common.py", line 209, in doResponse
2014-10-28 10:37:53+0100 [-] [caldav-2] isowner=isowner
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] result = result.throwExceptionIntoGenerator(g)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator
2014-10-28 10:37:53+0100 [-] [caldav-2] return g.throw(self.type, self.value, self.tb)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/twistedcaldav/method/report_common.py", line 384, in _namedPropertiesForResource
2014-10-28 10:37:53+0100 [-] [caldav-2] calendar = (yield resource.iCalendarForUser())
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] result = result.throwExceptionIntoGenerator(g)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator
2014-10-28 10:37:53+0100 [-] [caldav-2] return g.throw(self.type, self.value, self.tb)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/txdav/caldav/datastore/sql.py", line 3678, in componentForUser
2014-10-28 10:37:53+0100 [-] [caldav-2] caldata = yield self.component()
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1099, in _inlineCallbacks
2014-10-28 10:37:53+0100 [-] [caldav-2] result = g.send(result)
2014-10-28 10:37:53+0100 [-] [caldav-2] File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/txdav/caldav/datastore/sql.py", line 3631, in component
2014-10-28 10:37:53+0100 [-] [caldav-2] e, self._resourceID
2014-10-28 10:37:53+0100 [-] [caldav-2] txdav.common.icommondatastore.InternalDataStoreError: Data corruption detected (Invalid property: X-APPLE-TRAVEL-START;ROUTING=CAR;X-ADDRESS=MYSTREET 1\u20137\\\\n8888 Graz\\\\n\326sterreich;X-TITLE=MYSTREET 1\u20137:geo:47.000000\\,15.000000
2014-10-28 10:37:53+0100 [-] [caldav-2] BEGIN:VCALENDAR
2014-10-28 10:37:53+0100 [-] [caldav-2] VERSION:2.0
2014-10-28 10:37:53+0100 [-] [caldav-2] CALSCALE:GREGORIAN
2014-10-28 10:37:53+0100 [-] [caldav-2] PRODID:-//Apple Inc.//Mac OS X 10.9.5//EN
2014-10-28 10:37:53+0100 [-] [caldav-2] BEGIN:VTIMEZONE
2014-10-28 10:37:53+0100 [-] [caldav-2] TZID:Europe/Vienna
2014-10-28 10:37:53+0100 [-] [caldav-2] BEGIN:DAYLIGHT
2014-10-28 10:37:53+0100 [-] [caldav-2] DTSTART:19810329T020000
2014-10-28 10:37:53+0100 [-] [caldav-2] RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
2014-10-28 10:37:53+0100 [-] [caldav-2] TZNAME:MESZ
2014-10-28 10:37:53+0100 [-] [caldav-2] TZOFFSETFROM:+0100
2014-10-28 10:37:53+0100 [-] [caldav-2] TZOFFSETTO:+0200
2014-10-28 10:37:53+0100 [-] [caldav-2] END:DAYLIGHT
2014-10-28 10:37:53+0100 [-] [caldav-2] BEGIN:STANDARD
2014-10-28 10:37:53+0100 [-] [caldav-2] DTSTART:19961027T030000
2014-10-28 10:37:53+0100 [-] [caldav-2] RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
2014-10-28 10:37:53+0100 [-] [caldav-2] TZNAME:MEZ
2014-10-28 10:37:53+0100 [-] [caldav-2] TZOFFSETFROM:+0200
2014-10-28 10:37:53+0100 [-] [caldav-2] TZOFFSETTO:+0100
2014-10-28 10:37:53+0100 [-] [caldav-2] END:STANDARD
2014-10-28 10:37:53+0100 [-] [caldav-2] END:VTIMEZONE
2014-10-28 10:37:53+0100 [-] [caldav-2] BEGIN:VEVENT
2014-10-28 10:37:53+0100 [-] [caldav-2] UID:20B011FD-8208-4917-A1FA-11D7DD19E51F
2014-10-28 10:37:53+0100 [-] [caldav-2] DTSTART;TZID=Europe/Vienna:20141011T150000
2014-10-28 10:37:53+0100 [-] [caldav-2] DTEND;TZID=Europe/Vienna:20141011T200000
2014-10-28 10:37:53+0100 [-] [caldav-2] ATTENDEE;CN=Michael NOLASTNAME;CUTYPE=INDIVIDUAL;EMAIL=michael@NOLASTNAME.at;PARTS
2014-10-28 10:37:53+0100 [-] [caldav-2] TAT=ACCEPTED:urn:uuid:C7D9C4F4-08C5-41DE-A85C-3AE3250B6FFD
2014-10-28 10:37:53+0100 [-] [caldav-2] ATTENDEE;CN=Stephanie NOLASTNAME;CUTYPE=INDIVIDUAL;EMAIL=stephanie@NOLASTNAME.at;P
2014-10-28 10:37:53+0100 [-] [caldav-2] ARTSTAT=ACCEPTED;ROLE=REQ-PARTICIPANT;SCHEDULE-STATUS=2.0:urn:uuid:E51D1AC
2014-10-28 10:37:53+0100 [-] [caldav-2] A-AF95-4D37-975D-AB169534E4C9
2014-10-28 10:37:53+0100 [-] [caldav-2] CREATED:20141009T202137Z
2014-10-28 10:37:53+0100 [-] [caldav-2] DTSTAMP:20141011T122512Z
2014-10-28 10:37:53+0100 [-] [caldav-2] LOCATION:Martin NOLASTNAMEs Privat\\nNOSTREET 34\\n8888 Graz
2014-10-28 10:37:53+0100 [-] [caldav-2] ORGANIZER;CN=Michael NOLASTNAME;EMAIL=michael@NOLASTNAME.at:urn:uuid:C7D9C4F4-08C5
2014-10-28 10:37:53+0100 [-] [caldav-2] -41DE-A85C-3AE3250B6FFD
2014-10-28 10:37:53+0100 [-] [caldav-2] SEQUENCE:6
2014-10-28 10:37:53+0100 [-] [caldav-2] SUMMARY:Martin Geburtstagsfeier
2014-10-28 10:37:53+0100 [-] [caldav-2] END:VEVENT
2014-10-28 10:37:53+0100 [-] [caldav-2] BEGIN:X-CALENDARSERVER-PERUSER
2014-10-28 10:37:53+0100 [-] [caldav-2] UID:20B011FD-8208-4917-A1FA-11D7DD19E51F
2014-10-28 10:37:53+0100 [-] [caldav-2] X-CALENDARSERVER-PERUSER-UID:C7D9C4F4-08C5-41DE-A85C-3AE3250B6FFD
2014-10-28 10:37:53+0100 [-] [caldav-2] BEGIN:X-CALENDARSERVER-PERINSTANCE
2014-10-28 10:37:53+0100 [-] [caldav-2] TRANSP:OPAQUE
2014-10-28 10:37:53+0100 [-] [caldav-2] X-APPLE-STRUCTURED-LOCATION;X-ADDRESS=NOSTREET 34\\\\n8888 Graz;X-
2014-10-28 10:37:53+0100 [-] [caldav-2] APPLE-RADIUS=100;X-TITLE=Martin NOLASTNAMEs Privat:geo:47.000000\\,15.000000
2014-10-28 10:37:53+0100 [-] [caldav-2] X-APPLE-TRAVEL-DURATION:PT20M
2014-10-28 10:37:53+0100 [-] [caldav-2] X-APPLE-TRAVEL-START;ROUTING=CAR;X-ADDRESS=MYSTREET 1\u20137\\\\n8888 Graz\\\\
2014-10-28 10:37:53+0100 [-] [caldav-2] n\326sterreich;X-TITLE=MYSTREET 1\u20137:geo:47.000000\\,15.000000
2014-10-28 10:37:53+0100 [-] [caldav-2] BEGIN:VALARM
2014-10-28 10:37:53+0100 [-] [caldav-2] ACKNOWLEDGED:20141011T122512Z
2014-10-28 10:37:53+0100 [-] [caldav-2] ACTION:NONE
2014-10-28 10:37:53+0100 [-] [caldav-2] TRIGGER;VALUE=DATE-TIME:19760401T005545Z
2014-10-28 10:37:53+0100 [-] [caldav-2] UID:1784D466-EC6A-4A87-9151-6536F35986D8
2014-10-28 10:37:53+0100 [-] [caldav-2] X-WR-ALARMUID:1784D466-EC6A-4A87-9151-6536F35986D8
2014-10-28 10:37:53+0100 [-] [caldav-2] END:VALARM
2014-10-28 10:37:53+0100 [-] [caldav-2] BEGIN:VALARM
2014-10-28 10:37:53+0100 [-] [caldav-2] ACKNOWLEDGED:20141011T122512Z
2014-10-28 10:37:53+0100 [-] [caldav-2] ACTION:AUDIO
2014-10-28 10:37:53+0100 [-] [caldav-2] ATTACH:Basso
2014-10-28 10:37:53+0100 [-] [caldav-2] TRIGGER;X-APPLE-RELATED-TRAVEL=-PT15M:-PT35M
2014-10-28 10:37:53+0100 [-] [caldav-2] UID:70EE8730-FEDF-46DE-A851-47B4B59311AA
2014-10-28 10:37:53+0100 [-] [caldav-2] X-WR-ALARMUID:70EE8730-FEDF-46DE-A851-47B4B59311AA
2014-10-28 10:37:53+0100 [-] [caldav-2] END:VALARM
2014-10-28 10:37:53+0100 [-] [caldav-2] END:X-CALENDARSERVER-PERINSTANCE
2014-10-28 10:37:53+0100 [-] [caldav-2] END:X-CALENDARSERVER-PERUSER
2014-10-28 10:37:53+0100 [-] [caldav-2] END:VCALENDAR
2014-10-28 10:37:53+0100 [-] [caldav-2] ) in id: 1546
2014-10-28 10:37:53+0100 [-] [caldav-2]
the problem seems to be in this exact line:
2014-10-28 10:37:53+0100 [-] [caldav-2] txdav.common.icommondatastore.InternalDataStoreError: Data corruption detected (Invalid property: X-APPLE-TRAVEL-START;ROUTING=CAR;X-ADDRESS=MYSTREET 1\u20137\\\\n8888 Graz\\\\n\326sterreich;X-TITLE=MYSTREET 1\u20137:geo:47.000000\\,15.000000
I tried to fix this by changing and deleting it, but this did not solve the problem.
My phone by the way does not seem to bother at all.. (iOS 8.1)
How can i get rid of the problem?
I found a thread witch may be has a solution, but I am unable to access a postgres shell (psql)
i can not su to _calendar or _psotgres, and even as root I can not start psql
# psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
(this socket does not exists at this path)
Can anybody help me?
I liked the calendarserver
CardDAV seems to work without any problem!
Just CalDAV part is broken.
Mac mini, OS X Server
Posted on Oct 28, 2014 3:19 AM
Here is what I did today (not finished yet, but have to go now)
[root@server:/tmp] su -m _calendar
[_calendar@server:/tmp] psql -h /var/run/caldavd/PostgresSocket caldav
(interesting, this directory and the socket does not exists, but it works...)
caldav=# \dt (list al the tables)
and after some searching, i found that the main entries are stored here.
caldav=# \d calendar_object
and i found all my RIDs in this table.
So I decided to give it a try and delete the entries, in this table by hand.
# delete from calendar_object where resource_id = 1546;
DELETE 1
(and so on, with all the others)
For now, no errors are shown in the following command
[root@server:/tmp] /Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/bin/calendarserver_verify_data --ical --uuid C7D9C4F4-08C5-41DE-A85C-3AE3250B6FFD
NOTICE: there is no transaction in progress
---- CalVerify Bad Data Service version: 12 ----
---- Scanning calendar data ----
Number of events to process: 58
---- Verifying each calendar object resource ----
Bad iCalendar data: 0
+-------+-----------+-----+---------+
| Owner | Event UID | RID | Problem |
|-------+-----------+-----+---------|
+-------+-----------+-----+---------+
Overall Summary:
+-----------------------------+-------+------+
| Item | Count | % |
|-----------------------------+-------+------|
| Number of events to process | 58 | |
|-----------------------------+-------+------|
| Bad iCalendar data | 0 | 0.0% |
+-----------------------------+-------+------+
But i don't know is broke anything else with it.
The iPhone seems to be happy with it, but the Calendar.app on my macbook not...
I give you more details, later.
Posted on Mar 6, 2015 3:19 AM