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