2 Replies Latest reply: Jun 19, 2013 12:05 AM by s.mann
s.mann Level 1 Level 1 (0 points)

Hi,

 

we have problems since some weeks with our calendar server.. again..

We are on Mac OS X Lion Server 10.7.4

In /var/log/caldavd/error.log I can see many enries with this:

 

...

2013-06-12 12:50:53+0200 [-] [caldav-5]  [-] [twext.web2.server#error] [Failure instance: Traceback: <class 'pg.DatabaseError'>: error 'ERROR:  canceling statement due to statement timeout

2013-06-12 12:50:53+0200 [-] [caldav-5]     ' in 'select RESOURCE_ID, RESOURCE_NAME, ICALENDAR_UID, MD5, character_length(ICALENDAR_TEXT), ATTACHMENTS_MODE, DROPBOX_ID, ACCESS, SCHEDULE_OBJECT, SCHEDULE_TAG, SCHEDULE_ETAGS, PRIVATE_COMMENTS, CREATED, MODIFIED from CALENDAR_OBJECT where CALENDAR_RESOURCE_ID = 3747'

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:388:errback

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:455:_startRunCallbacks

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:542:_runCallbacks

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:1076:gotResult

2013-06-12 12:50:53+0200 [-] [caldav-5]     --- <exception caught here> ---

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:1018:_inlineCallbacks

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/python/failure.py:350:throwExceptionIntoGenerator

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/twistedcaldav/resource.py:309:renderHTTP

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:1018:_inlineCallbacks

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/python/failure.py:350:throwExceptionIntoGenerator

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/twext/web2/static.py:127:renderHTTP

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:1018:_inlineCallbacks

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/python/failure.py:350:throwExceptionIntoGenerator

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/twext/web2/resource.py:109:renderHTTP

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:1018:_inlineCallbacks

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/python/failure.py:350:throwExceptionIntoGenerator

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/twistedcaldav/method/propfind.py:127:http_PROPFIN D

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:1018:_inlineCallbacks

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/python/failure.py:350:throwExceptionIntoGenerator

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/twistedcaldav/storebridge.py:343:findChildrenFast er

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:1018:_inlineCallbacks

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/python/failure.py:350:throwExceptionIntoGenerator

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/txdav/common/datastore/sql.py:2012:objectResource s

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:1018:_inlineCallbacks

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/python/failure.py:350:throwExceptionIntoGenerator

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/txdav/common/datastore/sql.py:2326:loadAllObjects

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/internet/defer.py:1018:_inlineCallbacks

2013-06-12 12:50:53+0200 [-] [caldav-5]     /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/twis ted/python/failure.py:350:throwExceptionIntoGenerator

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/txdav/common/datastore/sql.py:512:execSQL

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/twext/internet/threadutils.py:64:_oneWorkUnit

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/twext/enterprise/adbapi2.py:293:<lambda>

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/twext/enterprise/adbapi2.py:230:_reallyExecSQL

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/txdav/base/datastore/dbapiclient.py:76:execute

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/pgdb.py:259:execute

2013-06-12 12:50:53+0200 [-] [caldav-5]     /usr/share/caldavd/lib/python/pgdb.py:289:executemany

2013-06-12 12:50:53+0200 [-] [caldav-5]     ]

 

In /Library/Logs/PostgreSQL/PostgreSQL.log I can see many enries with this:

 

...

2013-06-12 12:50:05 CEST ERROR:  canceling statement due to statement timeout

 

bash-3.2# serveradmin status calendar

calendar:state = "RUNNING"

calendar:setStateVersion = 1

calendar:readWriteSettingsVersion = 1

bash-3.2# serveradmin status postgres

postgres:state = "RUNNING"

 

A co-worker has access to around 10 shared calendars and gets a lot of errors similiar to the following screenshot:

https://31337deadbeef.cc/ical-500-error.jpg

And more and more co-worker report the same behavior.

 

To make it clear. This happens not all the day long, just from time to time, but it's annoying. What could be the cause?

I found this: https://discussions.apple.com/thread/3398078?start=75&tstart=0

But we do NOT use the wiki stuff on our server.

 

Any suggestions would be appreciated

 

Thanks,

Sirko


Mac Pro, Mac OS X (10.7.3)