Patrick Gibson

Q: Server 5.0.3 upgrade broke Calendar Server

As per usual, after upgrading to the latest Server, things have stopped working properly. This time, it's our Calendar Server. Everyone is getting the following error:

 

Your calendar couldn’t be refreshed.

 

The request for account “Company Shared Calendar” failed.

 

Operation: CalDAVAccountRefreshQueueableOperation

 

The Calendar error log is filled with various errors:

 

2015-09-17 15:25:31-0700 [-] [twext.enterprise.jobs.queue#error] workCheck: jobqueue is no longer overloaded

2015-09-17 15:25:31-0700 [-] [caldav-5] Reading configuration from file: /Applications/Server.app/Contents/ServerRoot/private/etc/caldavd/caldavd-apple. plist

2015-09-17 15:25:31-0700 [-] [caldav-5] Adding configuration from file: /Library/Server/Preferences/Calendar.plist

2015-09-17 15:25:31-0700 [-] [caldav-5] Adding configuration from file: /Library/Server/Calendar and Contacts/Config/caldavd-system.plist

2015-09-17 15:25:31-0700 [-] [caldav-5] Missing configuration file: /Library/Server/Calendar and Contacts/Config/caldavd-user.plist

 

...

 

2015-09-17 15:31:40-0700 [-] [caldav-3]  [-] [txdav.common.datastore.sql#error] Transaction abort too long: PG-TXN</Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/ python2.7/site-packages/calendarserver/tools/purge.py#1287$_cancelEvents>, Statements: 9, IUDs: 0, Statement: None

2015-09-17 15:32:39-0700 [-] [caldav-3]  [AMP,client] [calendarserver.tools.purge#warn] Cleaning up future events for principal D96C3F43-98DD-48AD-9576-C20B01F8828F since they are no longer in directory

2015-09-17 15:33:09-0700 [-] [caldav-3]  [-] [twext.enterprise.jobs.jobitem#error] JobItem: 177543, WorkItem: 1342369 failed: [Failure instance: Traceback: <class 'pg8000.core.ProgrammingError'>: (u'ERROR', u'57014', u'canceling statement due to statement timeout', u'SQL statement "SELECT 1 FROM ONLY "public"."calendar_object" x WHERE "resource_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"', u'postgres.c', u'2970', u'ProcessInterrupts', u'', u'')

 

Does anyone have any ideas?

Posted on Sep 17, 2015 3:46 PM

Close

Q: Server 5.0.3 upgrade broke Calendar Server

  • All replies
  • Helpful answers

  • by Patrick Gibson,

    Patrick Gibson Patrick Gibson Sep 17, 2015 3:53 PM in response to Patrick Gibson
    Level 1 (106 points)
    Notebooks
    Sep 17, 2015 3:53 PM in response to Patrick Gibson

    (I should mention it's running on 10.10.5.)

  • by mscott_mdm,

    mscott_mdm mscott_mdm Sep 17, 2015 3:58 PM in response to Patrick Gibson
    Level 2 (225 points)
    Sep 17, 2015 3:58 PM in response to Patrick Gibson

    Patrick,

     

    Do you happen to recall if you saw the "Upgrading Server" dialog when you first launched the new Server.app? Some others seem to be having issues where Server.app doesn't recognize that it's been upgraded and server data isn't then upgraded, which can break most of the services.

     

    If you didn't see this dialog (or are not sure), try moving Server.app to the Trash, waiting for the dialog that tells you Server.app was detected being moved to the Trash, then move Server.app back to the Applications folder and run it again.

  • by Patrick Gibson,

    Patrick Gibson Patrick Gibson Sep 17, 2015 4:02 PM in response to mscott_mdm
    Level 1 (106 points)
    Notebooks
    Sep 17, 2015 4:02 PM in response to mscott_mdm

    Yes, I did get the Upgrading Server dialog that took a while to complete. The errors are suggesting some problems with the underlying PostgreSQL database, but I don't even know where to begin to confirming or repairing that.

  • by Patrick Gibson,

    Patrick Gibson Patrick Gibson Sep 17, 2015 4:14 PM in response to Patrick Gibson
    Level 1 (106 points)
    Notebooks
    Sep 17, 2015 4:14 PM in response to Patrick Gibson

    So, this is bizarre: after updating iTunes and Xcode, Calendar Server has magically started working.

  • by DaywalkerGLXVR6,

    DaywalkerGLXVR6 DaywalkerGLXVR6 Sep 18, 2015 11:01 AM in response to mscott_mdm
    Level 1 (0 points)
    Sep 18, 2015 11:01 AM in response to mscott_mdm

    *** wired as it sounds, but moving the Server.app to the Trash (nor removing the trash!!!) and putting it back. actually did work!

    The upgrade progress did start and complete successfully.

    On my machine also the calendar and contacts server was unable to find it's configuration.

     

    Thanks for the great hint!

  • by MT Buck,

    MT Buck MT Buck Sep 23, 2015 9:40 AM in response to mscott_mdm
    Level 1 (21 points)
    Sep 23, 2015 9:40 AM in response to mscott_mdm

    On Server 5.0.4 upgrade - all services upgraded fine, but the next day I noticed calendar service was not working.  Error displayed Operation error:  "CalDAVAccountRefreshQueueableOperation"  and in Server Log it said, "Missing configuration file: /Library/Server/Calendar and Contacts/Config/caldavd-user.plist"

     

    Your trick of moving the Server.app to the trash, waiting for the message, and then moving it back worked.  Thank you Thank you!!

  • by Pantoffel,

    Pantoffel Pantoffel Mar 23, 2016 6:15 AM in response to MT Buck
    Level 1 (0 points)
    Mar 23, 2016 6:15 AM in response to MT Buck

    How long did it roughly take for this message to appear, after moving Server.app to trash? I waited for maybe 15 minutes, but didn't get any messages. After putting it back, it did run some configuration routines and some of the services were turned off, including Calendar service. After turning it back on, though, the problem persists...