[SailfishDevel] [CardDAV] duplicate entries
es.rosenberg+sailfishos.org at gmail.com
Mon Feb 20 18:32:13 UTC 2017
2017-02-20 12:54 GMT+02:00 E.S. Rosenberg <
es.rosenberg+sailfishos.org at gmail.com>:
> 2017-02-20 12:32 GMT+02:00 E.S. Rosenberg <es.rosenberg+sailfishos.org@
>> 2017-02-20 3:41 GMT+02:00 Chris Adams <chris.adams at jolla.com>:
>>> Hi Eli,
>> Hi Chris,
>>> Sorry for top posting, but OWA doesn't quote properly.
>> No problem....
>>> Firstly, was_local contacts occur when a local (phone device) contact is
>>> aggregated into another contact which already had a local constituent. We
>>> only allow one single local constituent per aggregate contact, so one of
>>> them gets demoted to was_local. This can occur if you import from a .vcf
>>> or via Bluetooth, for example.
>> Is there somewhere I can read more on this subject?
>>> If you can reproduce the duplication event and provide sync logs of that
>>> event (as per https://sailfishos.org/wiki/Ca
>>> lDAV_and_CardDAV_Community_Contributions#Sync_Logs) that would be
>> I'll try.
>>> You should be able to delete the contacts from the database so long as
>>> you also delete any entries from the OOB table which relate to that CardDAV
>> So I actually deleted very aggressively yesterday (all carddav and all
>> google) but did not modify oob, which resulted in 0 contacts being read,
>> however even restoring the backed up contacts.db file does not fix this
>> Any pointers what may be going wrong or where to look would be very
> Tiny additional update:
> From digging through contacts.db it seems that it needs a lot more cleanup
> then just the contacts table, tables with crazy counts:
> addresses, birthdays, avatars, deletedcontacts (~4k entries), details
> (>100k), emailaddresses, guids (~25k), organizations (~16k), phonenumbers
> (~56k), relationships (~25k), urls.
It seems I made a mistake when restoring the backup I now again have all my
Now my first step I think is going to be to cleanly remove all carddav sync
data, any pointers on that will be much appreciated (I assume I need to
somehow cascade the delete into all the linked tables), when that is done
I'll turn carddav back on and see if I can again trigger such a sync
situation with logs.
>>> Best regards,
>>> *From:* Devel [devel-bounces at lists.sailfishos.org] on behalf of E.S.
>>> Rosenberg [es.rosenberg+sailfishos.org at gmail.com]
>>> *Sent:* Monday, February 20, 2017 9:13 AM
>>> *To:* Sailfish OS Developers
>>> *Subject:* [SailfishDevel] [CardDAV] duplicate entries
>>> Hi everyone,
>>> Last week I noticed that my phone seems to have gone into similar
>>> behavior as I described a long time ago with google sync here:
>>> I currenlty have 26k entries in contacts.db for 9xx contacts.
>>> I suspect that this may be linked to a stage where I was connected via a
>>> filtered provider that tried to MITM the connection and caused it to close
>>> with an authentication error, I'm going to clean it up the same way I
>>> described there and turn carddav back on but I am wondering if anyone else
>>> has experienced similar issues.
>>> Is anyone aware of any reason not to just delete everything with
>>> syncTarget == carddav (or != local)?
>>> 987 aggregate
>>> 23128 carddav
>>> 1419 google
>>> 930 local
>>> 2 sim
>>> 65 telepathy
>>> 2 voicemail
>>> 3 was_local
>>> What does 'was_local' mean?
>>> SailfishOS.org Devel mailing list
>>> To unsubscribe, please send a mail to devel-unsubscribe at lists.sailfi
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Devel