[Davical-general] Clients not synchronising calendar deletions (Both OS 7.1 and Mozilla Lightning)

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[Davical-general] Clients not synchronising calendar deletions (Both OS 7.1 and Mozilla Lightning)

Andrew McCallum
HI, is anybody having trouble with established Mozilla Lightning and iOS
clients synchronising to Davical????

My Mozilla Lightning (in Thunderbird) client that has been successfully
synchronising for over a year, but now the Lightning client does not
maintain synchronisation! New calendar entries made by another client
appear, but deletions do not sync.

In the Lightning debug log, it shows Davical returning the webdav-sync
Token as a changed 5 digit number but takes no action to sync.

I have a slew of iOS 7.1 clients also showing the same behaviour!

To add to the confusion, an Android CalDAV sync client is showing the
calendars correctly. So the server is working (to some extent). It shows
a new entry and removes the entry on deletion. These tests are all done
with a python client adding and deleting entries.

I'm running Davical and AWL from www.inf-it.com/davical/

The issues with Lightning started after I updated to Jan Mate changes.
The reason I updated was to solve the problem that was occurring on the
iOS devices.

THINKING OUT ALOUD: Could the sync-token be too large for some clients??
Can I reset it?

Thanks for any help,
Andy.

PS. I can add more detail but I want to know if I'm the only one....

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general
Reply | Threaded
Open this post in threaded view
|

[Davical-general] Fwd: Clients not synchronising calendar deletions (Both OS 7.1 and Mozilla Lightning)

Andrew McCallum
Hi,

As a follow up to my last email. My problem is now fully repeatable and I am getting a stack trace in apache2/error.log.

I am running the latest version of Davical from git.

The problem I am having is that calendar entries deleted by a python caldav client remain displayed by Mozilla Lightning and iOS devices. The Android Caldav sync client correctly syncs and removes the calendar entry. To get the entry deleted on Lightning, I need to delete the calendar re-subscribed. This symptom is the same for iOS devices.

So something has changed that is tricking the clients into NOT being informed of the change when they next sync.

The apache2/error.log does show a Stack Trace, for the particular deletion of the entries. The full excerpt of the log is at http://pastebin.com/ubKPTbUt

The most relevant part is:

[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: LOG: :***************** Request Header ****************

[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: LOG: :DELETE /caldav.php/andy_mccallum/calendar/092ecaba-ed89-11e3-a407-000c2918d675.ics
.
.
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: LOG: caldav: Query: DBGQ: SELECT * FROM locks WHERE :dav_name::text ~ ('^'||dav_name||:pattern_end_match)::text
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: LOG: caldav: Query: DBGQ:  ":dav_name" => "/andy_mccallum/calendar/092ecaba-ed89-11e3-a407-000c2918d675.ics"
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: LOG: caldav: Query: DBGQ:  ":pattern_end_match" => "$"
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: LOG: caldav: Query: DBGQ: Took: 0.000533 to find 0 rows.
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: BUG: :Exists true
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] ================= Stack Trace ===================
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38]  ===>  /usr/share/davical/htdocs/caldav.php[135] calls include()
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38]  ===>  /usr/share/davical/inc/caldav-DELETE.php[77] calls do_scheduling_for_delete()
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38]  ===>  /usr/share/davical/inc/schedule-functions.php[32] calls DAVResource->GetProperty()
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: ALL: vComponent:GetPropertiesByPath: Querying within 'VCALENDAR' for path '/VCALENDAR/*/ORGANIZER'
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: ALL: vComponent:GetPropertiesByPath: Matches: / --  -- VCALENDAR -- /*/ORGANIZER\n
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: ALL: vComponent:GetPropertiesByPath: Querying within 'VEVENT' for path '/*/ORGANIZER'
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: ALL: vComponent:GetPropertiesByPath: Matches: / --  -- * -- /ORGANIZER\n
.
.
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: ALL: DELETE:DELETE: User: 1005, ETag: , Path: /andy_mccallum/calendar/092ecaba-ed89-11e3-a407-000c2918d675.ics
[Sat Jun 07 00:55:17 2014] [error] [client 121.211.121.38] davical: LOG: :Response status 204 for DELETE /caldav.php/andy_mccallum/calendar/092ecaba-ed89-11e3-a407-000c2918d675.ics

So the delete is succeeding and the Android client shows that it has.

Any help would be massively(!) appreciated.

Andy.

-------- Original Message --------
Subject: Clients not synchronising calendar deletions (Both OS 7.1 and Mozilla Lightning)
Date: Fri, 06 Jun 2014 17:43:48 +1000
From: Andy McCallum [hidden email]
To: [hidden email]


HI, is anybody having trouble with established Mozilla Lightning and iOS 
clients synchronising to Davical????

My Mozilla Lightning (in Thunderbird) client that has been successfully 
synchronising for over a year, but now the Lightning client does not 
maintain synchronisation! New calendar entries made by another client 
appear, but deletions do not sync.

In the Lightning debug log, it shows Davical returning the webdav-sync 
Token as a changed 5 digit number but takes no action to sync.

I have a slew of iOS 7.1 clients also showing the same behaviour!

To add to the confusion, an Android CalDAV sync client is showing the 
calendars correctly. So the server is working (to some extent). It shows 
a new entry and removes the entry on deletion. These tests are all done 
with a python client adding and deleting entries.

I'm running Davical and AWL from www.inf-it.com/davical/

The issues with Lightning started after I updated to Jan Mate changes. 
The reason I updated was to solve the problem that was occurring on the 
iOS devices.

THINKING OUT ALOUD: Could the sync-token be too large for some clients?? 
Can I reset it?

Thanks for any help,
Andy.

PS. I can add more detail but I want to know if I'm the only one....



------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general
Reply | Threaded
Open this post in threaded view
|

Re: Clients not synchronising calendar deletions (Both OS 7.1 and Mozilla Lightning)

Ján Máté-2
In reply to this post by Andrew McCallum
Hi Andy,

On 06 Jun 2014, at 09:43, Andy McCallum <[hidden email]> wrote:

> HI, is anybody having trouble with established Mozilla Lightning and iOS
> clients synchronising to Davical????
>
> My Mozilla Lightning (in Thunderbird) client that has been successfully
> synchronising for over a year, but now the Lightning client does not
> maintain synchronisation! New calendar entries made by another client
> appear, but deletions do not sync.
>
> In the Lightning debug log, it shows Davical returning the webdav-sync
> Token as a changed 5 digit number but takes no action to sync.
>
> I have a slew of iOS 7.1 clients also showing the same behaviour!
>
> To add to the confusion, an Android CalDAV sync client is showing the
> calendars correctly. So the server is working (to some extent). It shows
> a new entry and removes the entry on deletion. These tests are all done
> with a python client adding and deleting entries.
>
> I'm running Davical and AWL from www.inf-it.com/davical/
>
> The issues with Lightning started after I updated to Jan Mate changes.
> The reason I updated was to solve the problem that was occurring on the
> iOS devices.
we use the latest stable DAViCal (1.1.1) + Awl (0.53) with my patches from the
URL above and we (~70 people) have no problem with synchronization
(CalDavZAP latest + iOS 7) ...

>
> THINKING OUT ALOUD: Could the sync-token be too large for some clients??

no, sync-token is a string and the only thing the client checks is whether it is changed
or not ...

> Can I reset it?

You can delete all sync-tokens from "sync_tokens" table by using:

DELETE FROM sync_tokens;

Good clients will re-download all data from the server and then continue to sync
using sync-tokens ...


JM


>
> Thanks for any help,
> Andy.
>
> PS. I can add more detail but I want to know if I'm the only one....
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> _______________________________________________
> Davical-general mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/davical-general

------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
_______________________________________________
Davical-general mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/davical-general

smime.p7s (5K) Download Attachment