[CalendarServer-dev] Reproducible pg lock timeout during future events cleanup

Axel Rau Axel.Rau at Chaos1.DE
Sat Jul 23 04:06:25 PDT 2016


Hi,

This error is reproducable on my development server:
- - -
2016-07-23T10:07:08+0000 [caldav-0]  [calendarserver.tools.purge#warn] Cleaning up future events for principal 54371764-438E-4D2A-8E25-A1A15E8CB14B since they are no longer in directory
2016-07-23T10:07:40+0000 [caldav-0]  [twext.enterprise.jobs.jobitem#error] JobItem: 4699, WorkItem: 74300 failed: [Failure instance: Traceback: <class 'pg8000.core.ProgrammingError'>: (u'ERROR', u'57014', u'canceling statement due to statement timeout', u'while locking tuple (456,4) in relation "calendar_object"\nSQL statement "SELECT 1 FROM ONLY "caldavd"."calendar_object" x WHERE "resource_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x“', u'postgres.c', u'2967', u'ProcessInterrupts', u'', u'')
- - -
Shall I try upgrading to 8.1 or could it help to collect more info on 8.0?

Thanks, Axel
---
PGP-Key:29E99DD6  ☀  computing @ chaos claudius



More information about the calendarserver-dev mailing list