Q: Calendar server often throws exception: "canceling statement due to statement timeout"
My Calendar server in Server.app 5.0.15 on 10.10.5 pretty consistently throws the following exception:
2016-04-19 16:23:54+1000 [-] [caldav-1] [-] [twext.enterprise.jobs.jobitem#error] JobItem: 2693107, WorkItem: 2693107 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'')
2016-04-19 16:23:54+1000 [-] [caldav-1] /Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python2 .7/site-packages/twisted/internet/defer.py:588:_runCallbacks
2016-04-19 16:23:54+1000 [-] [caldav-1] /Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python2 .7/site-packages/twisted/internet/defer.py:1184:gotResult
2016-04-19 16:23:54+1000 [-] [caldav-1] /Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python2 .7/site-packages/twisted/internet/defer.py:1126:_inlineCallbacks
2016-04-19 16:23:54+1000 [-] [caldav-1] /Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python2 .7/site-packages/twisted/python/failure.py:389:throwExceptionIntoGenerator
2016-04-19 16:23:54+1000 [-] [caldav-1] --- <exception caught here> ---
2016-04-19 16:23:54+1000 [-] [caldav-1] /Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python2 .7/site-packages/twext/enterprise/jobs/jobitem.py:445:run
2016-04-19 16:23:54+1000 [-] [caldav-1] /Applications/Server.app/Contents/ServerRoot/Library/CalendarServer/lib/python2 .7/site-packages/twisted/internet/defer.py:1126:_inlineCallbacks
It doesn't seem to affect functionality, but it pollutes the logs every 30 seconds with this.
Does the actual SQL statement of "SELECT 1 FROM ONLY "public"."calendar_object" x WHERE "resource_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x" shed any light?
Thanks.
Server.app 5.0.15, OS X Yosemite (10.10.5), null
Posted on Apr 18, 2016 11:26 PM