Skip navigation

error 500 with shared calendars

441 Views 2 Replies Latest reply: Jun 19, 2013 12:05 AM by s.mann RSS
s.mann Calculating status...
Currently Being Moderated
Jun 18, 2013 1:48 AM

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)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.