ALamperti

Q: Calendar server corrupt event

Hi All,

 

I have a user's calendar which is giving a “500” to operation CalDAVAccountRefreshQueueableOperation error. I look at the server log seems to show an entry with a corrupt 'GEO' property. I'm guessing that deleting this event might clear the error, but I'm not sure how to do that.

 

Any ideas?

 

Server is a late 2012 mini running 10.10.1 with 16GB of ram.

 

Thanks!

 

2015-01-02 15:17:59-0500 [-] [caldav-0]  [-] [txweb2.server#error] Exception rendering request: <REPORT /calendars/__uids__/9FE3EA7D-93CC-4474-8A90-E6CBF99680C5/calendar/ (1, 1)>

2015-01-02 15:17:59-0500 [-] [caldav-0] Traceback (most recent call last):

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 423, in errback

2015-01-02 15:17:59-0500 [-] [caldav-0]    self._startRunCallbacks(fail)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 490, in _startRunCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    self._runCallbacks()

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 577, in _runCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    current.result = callback(current.result, *args, **kw)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1155, in gotResult

2015-01-02 15:17:59-0500 [-] [caldav-0]    _inlineCallbacks(r, g, deferred)

2015-01-02 15:17:59-0500 [-] [caldav-0] --- <exception caught here> ---

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    result = result.throwExceptionIntoGenerator(g)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator

2015-01-02 15:17:59-0500 [-] [caldav-0]    return g.throw(self.type, self.value, self.tb)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/twistedcaldav/resource.py", line 327, in renderHTTP

2015-01-02 15:17:59-0500 [-] [caldav-0]    response = yield super(CalDAVResource, self).renderHTTP(request)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    result = result.throwExceptionIntoGenerator(g)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator

2015-01-02 15:17:59-0500 [-] [caldav-0]    return g.throw(self.type, self.value, self.tb)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/txweb2/static.py", line 128, in renderHTTP

2015-01-02 15:17:59-0500 [-] [caldav-0]    response = yield super(StaticRenderMixin, self).renderHTTP(request)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    result = result.throwExceptionIntoGenerator(g)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator

2015-01-02 15:17:59-0500 [-] [caldav-0]    return g.throw(self.type, self.value, self.tb)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/txweb2/resource.py", line 121, in renderHTTP

2015-01-02 15:17:59-0500 [-] [caldav-0]    returnValue((yield result))

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    result = result.throwExceptionIntoGenerator(g)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator

2015-01-02 15:17:59-0500 [-] [caldav-0]    return g.throw(self.type, self.value, self.tb)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/twistedcaldav/method/report.py", line 137, in http_REPORT

2015-01-02 15:17:59-0500 [-] [caldav-0]    result = (yield method(request, doc.root_element))

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    result = result.throwExceptionIntoGenerator(g)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator

2015-01-02 15:17:59-0500 [-] [caldav-0]    return g.throw(self.type, self.value, self.tb)

2015-01-02 15:17:59-0500 [-] [caldav-0]  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

2015-01-02 15:17:59-0500 [-] [caldav-0]    yield doResponse()

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    result = result.throwExceptionIntoGenerator(g)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator

2015-01-02 15:17:59-0500 [-] [caldav-0]    return g.throw(self.type, self.value, self.tb)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/twistedcaldav/method/report_multiget_common.py", line 209, in doResponse

2015-01-02 15:17:59-0500 [-] [caldav-0]    isowner=isowner

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    result = result.throwExceptionIntoGenerator(g)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator

2015-01-02 15:17:59-0500 [-] [caldav-0]    return g.throw(self.type, self.value, self.tb)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/twistedcaldav/method/report_common.py", line 384, in _namedPropertiesForResource

2015-01-02 15:17:59-0500 [-] [caldav-0]    calendar = (yield resource.iCalendarForUser())

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1097, in _inlineCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    result = result.throwExceptionIntoGenerator(g)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/python/failure.py", line 389, in throwExceptionIntoGenerator

2015-01-02 15:17:59-0500 [-] [caldav-0]    return g.throw(self.type, self.value, self.tb)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/txdav/caldav/datastore/sql.py", line 3678, in componentForUser

2015-01-02 15:17:59-0500 [-] [caldav-0]    caldata = yield self.component()

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twi sted/internet/defer.py", line 1099, in _inlineCallbacks

2015-01-02 15:17:59-0500 [-] [caldav-0]    result = g.send(result)

2015-01-02 15:17:59-0500 [-] [caldav-0]  File "/Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python 2.7/site-packages/txdav/caldav/datastore/sql.py", line 3631, in component

2015-01-02 15:17:59-0500 [-] [caldav-0]    e, self._resourceID

2015-01-02 15:17:59-0500 [-] [caldav-0] txdav.common.icommondatastore.InternalDataStoreError: Data corruption detected (Invalid property: GEO:43.65\\;-72.36

2015-01-02 15:17:59-0500 [-] [caldav-0] BEGIN:VCALENDAR

2015-01-02 15:17:59-0500 [-] [caldav-0] VERSION:2.0

2015-01-02 15:17:59-0500 [-] [caldav-0] CALSCALE:GREGORIAN

2015-01-02 15:17:59-0500 [-] [caldav-0] PRODID:-//Apple Inc.//Mac OS X 10.9.2//EN

2015-01-02 15:17:59-0500 [-] [caldav-0] BEGIN:VEVENT

2015-01-02 15:17:59-0500 [-] [caldav-0] UID:event_166872212@meetup.com

2015-01-02 15:17:59-0500 [-] [caldav-0] DTSTART;TZID=America/New_York:20140329T140000

2015-01-02 15:17:59-0500 [-] [caldav-0] DTEND;TZID=America/New_York:20140329T170000

2015-01-02 15:17:59-0500 [-] [caldav-0] CLASS:PUBLIC

2015-01-02 15:17:59-0500 [-] [caldav-0] CREATED:20140218T130358Z

2015-01-02 15:17:59-0500 [-] [caldav-0] DESCRIPTION:Upper Valley MakerSpace\\nSaturday\\, March 29 at 2:00 PM\\n\\nmor

2015-01-02 15:17:59-0500 [-] [caldav-0] e details to come... just wanted to get the date out there!\\n\\nDetails: ht

2015-01-02 15:17:59-0500 [-] [caldav-0] tp://www.meetup.com/UpperValleyMakerSpace/events/166872212/

2015-01-02 15:17:59-0500 [-] [caldav-0] DTSTAMP:20140325T000154Z

2015-01-02 15:17:59-0500 [-] [caldav-0] GEO:43.65\\;-72.36

2015-01-02 15:17:59-0500 [-] [caldav-0] LAST-MODIFIED:20140218T130358Z

2015-01-02 15:17:59-0500 [-] [caldav-0] LOCATION:Trumball Nelson (200 Lebanon St\\, Hanover\\, NH\\, Hanover\\, NH\\, N

2015-01-02 15:17:59-0500 [-] [caldav-0] H)

2015-01-02 15:17:59-0500 [-] [caldav-0] ORGANIZER;CN=Meetup Reminder;SCHEDULE-AGENT=CLIENT:MAILTO:info@meetup.com

2015-01-02 15:17:59-0500 [-] [caldav-0] SEQUENCE:0

2015-01-02 15:17:59-0500 [-] [caldav-0] STATUS:CONFIRMED

2015-01-02 15:17:59-0500 [-] [caldav-0] SUMMARY:March meeting  - at Trumball Nelson

2015-01-02 15:17:59-0500 [-] [caldav-0] URL:http://www.meetup.com/UpperValleyMakerSpace/events/166872212/

2015-01-02 15:17:59-0500 [-] [caldav-0] END:VEVENT

2015-01-02 15:17:59-0500 [-] [caldav-0] BEGIN:X-CALENDARSERVER-PERUSER

2015-01-02 15:17:59-0500 [-] [caldav-0] UID:event_166872212@meetup.com

2015-01-02 15:17:59-0500 [-] [caldav-0] X-CALENDARSERVER-PERUSER-UID:9FE3EA7D-93CC-4474-8A90-E6CBF99680C5

2015-01-02 15:17:59-0500 [-] [caldav-0] BEGIN:X-CALENDARSERVER-PERINSTANCE

2015-01-02 15:17:59-0500 [-] [caldav-0] TRANSP:OPAQUE

2015-01-02 15:17:59-0500 [-] [caldav-0] END:X-CALENDARSERVER-PERINSTANCE

2015-01-02 15:17:59-0500 [-] [caldav-0] END:X-CALENDARSERVER-PERUSER

2015-01-02 15:17:59-0500 [-] [caldav-0] END:VCALENDAR

2015-01-02 15:17:59-0500 [-] [caldav-0] ) in id: 61458

Mac mini (Late 2012), OS X Yosemite (10.10.1), null

Posted on Jan 2, 2015 12:47 PM

Close

Q: Calendar server corrupt event

  • All replies
  • Helpful answers

  • by Linc Davis,

    Linc Davis Linc Davis Jan 2, 2015 4:15 PM in response to ALamperti
    Level 10 (207,926 points)
    Applications
    Jan 2, 2015 4:15 PM in response to ALamperti

    Export the calendar on the client as an ICS file, then delete it from the server and re-import the data.

  • by ALamperti,

    ALamperti ALamperti Jan 2, 2015 7:12 PM in response to Linc Davis
    Level 1 (0 points)
    Jan 2, 2015 7:12 PM in response to Linc Davis

    Good idea, but I don't seem to be able to delete the primary calendar associated with the server account. The other issue is that most of the events on the calendar are invites from other calendars and I'm not confident that those will correctly survive the export import process.

  • by Linc Davis,

    Linc Davis Linc Davis Jan 2, 2015 7:24 PM in response to ALamperti
    Level 10 (207,926 points)
    Applications
    Jan 2, 2015 7:24 PM in response to ALamperti

    What happens when you try to delete the calendar? The invites should be restored when you import, although with a corrupt calendar you can't be sure of anything. There's always the option of restoring from a backup.

  • by ALamperti,

    ALamperti ALamperti Jan 2, 2015 7:47 PM in response to Linc Davis
    Level 1 (0 points)
    Jan 2, 2015 7:47 PM in response to Linc Davis

    The delete option doesn't appear for the primary calendar. I checked in Calendar and in the wiki web version. i did export the events and reimport them into a second calendar on the account, but that calendar isn't the primary and thus doesn't get invitations. So if I were able to delete the primary I'd still have to designate the new calendar as the new primary.

  • by Linc Davis,

    Linc Davis Linc Davis Jan 2, 2015 9:51 PM in response to ALamperti
    Level 10 (207,926 points)
    Applications
    Jan 2, 2015 9:51 PM in response to ALamperti

    I don't understand this. What is preventing you from deleting the account in the Internet Accounts preference pane?

  • by ALamperti,

    ALamperti ALamperti Jan 3, 2015 9:48 AM in response to Linc Davis
    Level 1 (0 points)
    Jan 3, 2015 9:48 AM in response to Linc Davis

    Nothing prevents me from deleting the account on the client computer, but the calendar is corrupted on the server, so deleting the client copy doesn't belp. I need to either reinitiize the calendar or edit the corrupt event ON THE SERVER presumably with command line sql.

     

    does that make sense?

  • by Linc Davis,

    Linc Davis Linc Davis Jan 3, 2015 10:59 AM in response to ALamperti
    Level 10 (207,926 points)
    Applications
    Jan 3, 2015 10:59 AM in response to ALamperti

    Deleting the calendar on the client does delete it on the server, unless the database is so corrupt it's not working at all (which doesn't seem to be the case here.) You have, as I already mentioned, the option of restoring the whole database from a backup that predates the corruption. Good luck.

  • by ALamperti,

    ALamperti ALamperti Jan 5, 2015 6:05 AM in response to Linc Davis
    Level 1 (0 points)
    Jan 5, 2015 6:05 AM in response to Linc Davis

    If you are inclined and have a server installation, try this. Right click on the first calendar for a user, usually named with their first name. Note that there is no 'delete' option for this calendar. Now right click any other calendar that user has created (i.e. the second or later one in the list). Note that there is a 'delete' option. This is why I say I can't delete the calendar, or rather, that I can remove it from the client (i.e. delete the user account from the client computer) but not delete it from the server.

     

    If I delete the user at the server level, that will no doubt delete the calendar, however when I create a new account for that user, it will not re-link to all their invitations and such and their delegations will be lost etc... I was looking for a less drastic solution then that.

  • by Linc Davis,

    Linc Davis Linc Davis Jan 6, 2015 5:32 PM in response to ALamperti
    Level 10 (207,926 points)
    Applications
    Jan 6, 2015 5:32 PM in response to ALamperti

    Re-order the calendars so that the one to be deleted is not at the top of the list.

  • by Kreesurgeon56,

    Kreesurgeon56 Kreesurgeon56 May 11, 2016 8:01 AM in response to ALamperti
    Level 1 (8 points)
    May 11, 2016 8:01 AM in response to ALamperti

    Did you ever resolve this? I am having the same issue. Reordering the calendars doesn't work as the client is not syncing with the server so even if it's deleted it comes straight back. It also doesn't get deleted in webcal.