nemomobile / buteo-sync-plugin-caldav Goto Github PK

Synching fails with the following error if there is the same event in multiple calendars:

Jan 17 11:40:43 Jolla caldav-client[12301]: [C] mKCal::SqliteStorage::Private::saveIncidences:2069 - sqlitestorage.cpp: 2069 - UNIQUE constraint failed: Components.UID, Components.RecurId, Components.DateDeleted for incidence "##redacted"

In case you are wondering how that happens: I have both my wife's and my own calendar synched to my phone. If I invite her to an event (or vice versa) the same event will be in both calendars.

So I don't think the assumption that the UID is actually unique across multiple calendars is correct.

See https://together.jolla.com/question/60213/caldav-sync-to-owncloud-with-non-latin-characters-results-in-question-marks-being-displayed/

This issue has been originally created for SailfishOS 1.0.8.19: https://together.jolla.com/question/55033/caldav-not-supporting-umlauts/

Creating an event "Büro" (containing the german umlaut "ü") does not get synced to a davical based server, using "Buero" instead works. Other clients (N9, ThunderBird Lightning, etc.) do not show this problem thus the davical server should be fine.

i had my account properly setup, but deleted and readded since i had a new calendar that did not show up. Now when i add the account it gives a success message but every time it syncs, all calendars are added and after some time it goes almost unresponsive, as i end up with more than 100 calendars!!!

In the log i get some errors, that are most likely the reason
Log for the initial adding:

Dez 14 12:27:24 Jolla caldav-client[7243]: [W] CalDavCalendarDatabasePrivate::writeAdditions:327 - bool CalDavCalendarDatabasePrivate::writeAdditions(const QHash<QString, QStringList>&) Failed to execute query 
Dez 14 12:27:24 Jolla caldav-client[7243]: [W] CalDavCalendarDatabasePrivate::writeAdditions:327 - "INSERT INTO Additions (incidenceUid, notebookUid) VALUES (:incidenceUid, :notebookUid)" 
Dez 14 12:27:24 Jolla caldav-client[7243]: [W] CalDavCalendarDatabasePrivate::writeAdditions:327 - QSqlError(19, "Unable to fetch row", "UNIQUE constraint failed: Additions.incidenceUid") 
Dez 14 12:27:25 Jolla caldav-client[7243]: [C] CalDavClient::syncFinished:333 - CalDAV sync failed: 403 "Unable to write to database"

Log for a sync try:

Dez 14 12:37:14 Jolla caldav-client[7787]: [C] CalDavClient::notebookSyncFinished:480 - Notebook sync finished. Total agents: 4 
Dez 14 12:37:14 Jolla caldav-client[7787]: [C] CalDavClient::notebookSyncFinished:480 - Notebook sync finished. Total agents: 4 
Dez 14 12:37:15 Jolla caldav-client[7787]: [C] CalDavClient::notebookSyncFinished:480 - Notebook sync finished. Total agents: 4 
Dez 14 12:37:15 Jolla caldav-client[7787]: [C] CalDavClient::notebookSyncFinished:480 - Notebook sync finished. Total agents: 4 
Dez 14 12:37:16 Jolla caldav-client[7787]: [W] mKCal::SqliteStorage::Private::loadIncidences:1658 - sqlitestorage.cpp: 1658 - not loading "4a4d39d44a" "61702e0a-039f-43e4-a137-66d872c8567c" (local changes) 
...
Dez 14 12:37:17 Jolla caldav-client[7787]: [W] mKCal::SqliteStorage::Private::loadIncidences:1658 - sqlitestorage.cpp: 1658 - not loading "b22b2ba624" "aeddf9c6-e741-4aa8-adec-fb846a73241f" (local changes) 
Dez 14 12:37:18 Jolla caldav-client[7787]: [W] CalDavCalendarDatabasePrivate::writeModifications:358 - bool CalDavCalendarDatabasePrivate::writeModifications(const QHash<QString, QHash<QString, QString> >&) Failed to execute query 
Dez 14 12:37:18 Jolla caldav-client[7787]: [W] CalDavCalendarDatabasePrivate::writeModifications:358 - "INSERT INTO Modifications (incidenceUid, notebookUid, iCalData) VALUES (:incidenceUid, :notebookUid, :iCalData)" 
Dez 14 12:37:18 Jolla caldav-client[7787]: [W] CalDavCalendarDatabasePrivate::writeModifications:358 - QSqlError(19, "Unable to fetch row", "UNIQUE constraint failed: Modifications.incidenceUid") 
Dez 14 12:37:19 Jolla caldav-client[7787]: [C] CalDavClient::syncFinished:333 - CalDAV sync failed: 403 "Unable to write to database"

I am guessing that, since i already added and then deleted the account, there is some metaData left which now prevents me from adding. Can i somehow manually delete that metaData?
Or recreate the database-file?

Is there a reason that this plugin depends on libsocialcache ? With a quick search, it seems that there is no dependency on socialcache at all inside this project.

Hallo,

I have a very ugly problem:

I'm syncing my calendars with Zentyal 3.5 (SOGo/openchange) via caldav. My personal calendar is shifted by one hour and the all shard calendars of other users not.

I checked the time zone settings of the different calendars and of my phone: all are in the same zone (BERLIN).

The servers internal clock is setted to UTC and the sync with other clients like Thunderbird, Kontact or Android via caldav is working well.

Is there anybody who can help me?

with best regards

Denis

After setting up a caldav account with my owncloud 7 server appointments are no longer being synced to the device. At account creation I think everything was synced correctly and new events created on the phone are propagated to the server. In the journal I see lots of errors of the form:

NotebookSyncAgent::updateIncidences:666 - Unable to add incidence "7c379424-742e-4136-89e8-dd94d4b11e9b" to notebook "87a6db4a-18e5-4e44-a990-d73b870d81f1"
CalDAV sync failed: 401 "unable to write notebook changes"

and occasional errors of the form:

mKCal::SqliteFormat::modifyComponents:503 - sqliteformat.cpp: 503 - failed to modify attendees for incidence "4020159d-2075-4bb8-acbd-9a9afe66ac2f"
CalDavClient::syncFinished:333 - CalDAV sync failed: 403 "unable to save calendar storage"

Is there anything other log info that would be useful?

I was pointed in this direction by Tanghus. Please forgive me if this is completely misplaced here.

Just before Christmas, my Jolla deleted everything in my calender 6 months back[1] and all future entries. I found a thread about this issue on TJC and posted a comment there.

I have no idea why this happened. I don't have much information to help debug or reproduce the problem. All I have is this extract from my ownCloud server log.

[1] I assume this 6 months limit is because the sync client doesn't sync further back.

After the DST switch last weekend all my synched events are off by one our. I've checked the content of the mkcal database and for an event that is supposed to start at Thu, 02 Apr 2015 13:00:00 GMT+2 (Europe/Berlin with DST) I find:

DateStart = 1427976000
DateStartLocal = 1427979600
StartTimeZone = Europe/Berlin

You can see that the DateStartLocal is actually correct (13:00 local time), while the DateStart is off by one hour (12:00 GMT, but should be 11:00 GMT). The Jolla calendar shows 14:00 as the start time.

This is the data stored in the CalDAV Server (Baikal):

VERSION:2.0
PRODID:-//EGroupware//NONSGML EGroupware Calendar 1.9.004//DE
BEGIN:VTIMEZONE
TZID:Europe/Berlin
X-LIC-LOCATION:Europe/Berlin
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
DTSTART:19700329T020000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:19701025T030000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
CLASS:PUBLIC
SUMMARY:REDACTED
DTSTART;TZID=Europe/Berlin:20150402T130000
DTEND;TZID=Europe/Berlin:20150402T140000
PRIORITY:5
TRANSP:OPAQUE
CATEGORIES:REDACTED
UID:calendar-42066-f2bd5fa3746e5d6bdbfac09ac22cc8c2
STATUS:CONFIRMED
CREATED:20150330T152325Z
LAST-MODIFIED:20150330T152325Z
DTSTAMP:20150330T154508Z
END:VEVENT
END:VCALENDAR

Other people seem to experience this as well, see:
https://together.jolla.com/question/60486/all-dates-shifted-by-one-hour-in-calendar-after-updating-to-11038/
https://together.jolla.com/question/86562/daylight-saving-time-confuses-calendar/