Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

6 points

Calendar Server Reported Error: Operation CalDAVAccountRefreshQueueableOperation

I have setup several Users on a MAC OS X Server Lion with the sole purpose to use their Calendar and Addressbook as repository for calendar and address information for the Mac, Macbook and iPhone and shared calendars for all users of the OD. This worked quite well for a time. It seems to have stopped working a while ago (noone realised it because the individual device did not show an obvious problem and had all the required dates), definitively after the Update to 10.7.2, but presumably a couple of weeks before. To my knowledge I did not change anything beyond applying the apple updates.

One of the clients shows the dates of a shared calendar multiple times (depending on date up to 7 times, but mostly 3 times), the mobile devices and the other iMac only once.

Upon looking at the calendars (even as Admin on the Mac Server itself) the error message displayed is

Calendar Server Reported Error

Operation CalDAVAccountRefreshQueueableOperation

I hope there is a solution as we lost qiute a few dates on the iPhones during update to iOS 5 (the shared calendar data are apparently not backed-up).

Mac OS X (10.7.1), Server

Posted on Oct 16, 2011 10:10 AM

89 replies

aef5023 Author

Level 1

6 points

Oct 20, 2011 1:44 PM in response to aef5023

The other commands you asked before show now

ps aux | grep postgres

_postgres 727 0.0 0.0 2441124 444 ?? Ss 10:35PM 0:00.01 postgres: stats collector process

_postgres 726 0.0 0.0 2478340 1520 ?? Ss 10:35PM 0:00.01 postgres: autovacuum launcher process

_postgres 725 0.0 0.0 2478208 520 ?? Ss 10:35PM 0:00.03 postgres: wal writer process

_postgres 724 0.0 0.0 2478208 768 ?? Ss 10:35PM 0:00.05 postgres: writer process

_postgres 722 0.0 0.0 2441124 332 ?? Ss 10:35PM 0:00.02 postgres: logger process

_postgres 720 0.0 0.1 2478208 4796 ?? Ss 10:35PM 0:00.15 /usr/bin/postgres_real -D /var/pgsql -c listen_addresses= -c log_connections=on -c log_directory=/Library/Logs -c log_filename=PostgreSQL.log -c log_line_prefix=%t -c log_lock_waits=on -c log_statement=ddl -c logging_collector=on -c unix_socket_directory=/var/pgsql_socket -c unix_socket_group=_postgres -c unix_socket_permissions=0770

sharkmin 1016 0.0 0.0 2434892 468 s000 R+ 10:41PM 0:00.00 grep postgres

ps aux | grep caldavd

sharkmin 1018 0.0 0.0 2434892 528 s000 S+ 10:41PM 0:00.00 grep caldavd

sudo ls -l /var/pgsql_socket/

total 8

srwxrwx--- 1 _postgres _postgres 0 Oct 20 22:35 .s.PGSQL.5432

-rw------- 1 _postgres _postgres 15 Oct 20 22:35 .s.PGSQL.5432.lock

=> caldavd is still not running

mappler

Level 1

0 points

Oct 21, 2011 10:26 AM in response to aef5023

who can help? 😟

Oct 21, 2011 11:19 AM in response to aef5023

What do permissions on /var/pgsql and its contents look like?

Clearly postgres is running but not seeing your previous data.

mappler

Level 1

0 points

Oct 21, 2011 11:31 AM in response to Cyrus Daboo

ls -al /var/pgsql

total 80

drwx------ 18 _postgres _postgres 612 Oct 20 22:12 .

drwxr-xr-x 42 root wheel 1428 Oct 12 22:56 ..

-rw------- 1 _postgres _postgres 4 Oct 12 22:56 PG_VERSION

drwx------ 5 _postgres _postgres 170 Oct 12 22:57 base

drwx------ 42 _postgres _postgres 1428 Oct 20 22:13 global

drwx------ 3 _postgres _postgres 102 Oct 12 22:56 pg_clog

-rw------- 1 _postgres _postgres 3939 Oct 12 22:56 pg_hba.conf

-rw------- 1 _postgres _postgres 1636 Oct 12 22:56 pg_ident.conf

drwx------ 4 _postgres _postgres 136 Oct 12 22:56 pg_multixact

drwx------ 3 _postgres _postgres 102 Oct 20 22:12 pg_notify

drwx------ 3 _postgres _postgres 102 Oct 21 20:29 pg_stat_tmp

drwx------ 3 _postgres _postgres 102 Oct 12 22:56 pg_subtrans

drwx------ 2 _postgres _postgres 68 Oct 12 22:56 pg_tblspc

drwx------ 2 _postgres _postgres 68 Oct 12 22:56 pg_twophase

drwx------ 4 _postgres _postgres 136 Oct 12 22:56 pg_xlog

-rw------- 1 _postgres _postgres 17935 Oct 12 22:56 postgresql.conf

-rw------- 1 _postgres _postgres 385 Oct 20 22:12 postmaster.opts

-rw------- 1 _postgres _postgres 37 Oct 20 22:12 postmaster.pid

aef5023 Author

Level 1

6 points

Oct 21, 2011 11:55 AM in response to Cyrus Daboo

Yesterday, looking at permissions around postgres and caldavd I found that some of the permissions look really odd (but then I have no experience with Mac OsX system permissions). With subsequent other error messages around caldevd running, I had the hunch that all might be caused by faulty permissions. I am going to run repair permissions and then see what happens.

aef5023 Author

Level 1

6 points

Oct 21, 2011 12:19 PM in response to aef5023

The permission repair fixed a number of permissions, but things still do not work (even though there are some changes, see below)

Permissions differ on “Library/Server/Calendar and Contacts”; should be drwxr-xr-x ; they are drwxr-x--x .

Repaired “Library/Server/Calendar and Contacts”

Permissions differ on “private/etc/apache2/httpd.conf”; should be -r--r--r-- ; they are -rw-r--r-- .

Repaired “private/etc/apache2/httpd.conf”

Nothing remarakble. The Calendar I caused myself to test

caldavd still does not run and aborts with same errors as before

mappler

Level 1

0 points

Oct 21, 2011 12:13 PM in response to aef5023

"repair permissions" does not help.

aef5023 Author

Level 1

6 points

Oct 21, 2011 12:19 PM in response to mappler

no, neither with me

aef5023 Author

Level 1

6 points

Oct 21, 2011 12:23 PM in response to Cyrus Daboo

my ls -l /var/pgsql looks absolutely identical with mappler's list

aef5023 Author

Level 1

6 points

Oct 21, 2011 12:52 PM in response to aef5023

subdirectories

/var/pgsql/base:

total 0

drwx------ 213 _postgres _postgres 7242 Oct 20 22:20 1

drwx------ 213 _postgres _postgres 7242 Sep 4 14:37 11866

drwx------ 214 _postgres _postgres 7276 Oct 21 21:28 11874

/var/pgsql/base/1:

total 10560

-rw------- 1 _postgres _postgres 106496 Sep 4 14:37 11581

-rw------- 1 _postgres _postgres 24576 Sep 4 14:37 11581_fsm

.....

-rw------- 1 _postgres _postgres 512 Sep 4 14:37 pg_filenode.map

/var/pgsql/base/11866:

total 10560

-rw------- 1 _postgres _postgres 106496 Sep 4 14:37 11581

....

-rw------- 1 _postgres _postgres 98532 Oct 21 21:28 pg_internal.init

/var/pgsql/global:

total 880

-rw------- 1 _postgres _postgres 8192 Sep 4 14:37 11601

....

etc., all follow the same scheme. Nowhere is caldav mentioned as name

Oct 21, 2011 12:55 PM in response to aef5023

Please both of you file bugs on bugreporter.apple.com and include the following:

/var/log/system.log

/Library/Logs/PostgreSQL.log

/var/log/caldavd/*

Report back the bug number here.

Also, if you have backups of /var/pgsql from before the upgrade, please compare that (permissions, file sizes etc) with what you currently have.

Oct 21, 2011 12:59 PM in response to Cyrus Daboo

Please also check to see if there are other /var/pgsql* directories present.

mappler

Level 1

0 points

Oct 21, 2011 1:11 PM in response to Cyrus Daboo

/var/pgsql*

drwx------ 18 _postgres _postgres 612 Oct 20 22:12 pgsql

drwx------ 17 _postgres _postgres 578 Jul 22 01:39 pgsql.pre-restore-2011-07-22_01:39:10_CEST

drwx------ 17 _postgres _postgres 578 Sep 30 20:10 pgsql.pre-restore-2011-09-30_20:10:02_CEST

drwx------ 17 _postgres _postgres 578 Oct 12 22:56 pgsql.pre-restore-2011-10-12_22:56:38_CEST

drwxr-x--- 4 _postgres _postgres 136 Oct 20 22:12 pgsql_socket

mappler

Level 1

0 points

Oct 21, 2011 1:31 PM in response to Cyrus Daboo

Problem ID: 10296885

(sorry, posted wrong ID first)

Message was edited by: mappler

Oct 21, 2011 1:25 PM in response to mappler

How does the contents of

/var/pgsql.pre-restore-2011-10-12_22:56:38_CEST compare with /var/pgsql? Are there a lot more base/*, global/* files present with large sizes in the "pre-restore" one?

Calendar Server Reported Error: Operation CalDAVAccountRefreshQueueableOperation