Server 5.0.3 upgrade broke Calendar Server

Question

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

Reply

Answer 1

Sep 17, 2015 3:53 PM in response to Patrick Gibson

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

Reply

Answer 2

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.

Reply

Answer 3

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.

Reply

Answer 4

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.

Reply

Answer 5

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!

Reply

Answer 6

MT Buck

Level 1

30 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!!

Reply

Answer 7

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...

Reply