[SailfishDevel] [CardDAV] duplicate entries

[E.S. Rosenberg]

2017-02-20 12:32 GMT+02:00 E.S. Rosenberg <
es.rosenberg+sailfishos.org at gmail.com>:

> 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
>> helpful!
>>
> 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
>> account.
>>
> 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
> issue.
> Any pointers what may be going wrong or where to look would be very
> welcome.
> Thanks,
> Eli
>

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.

Thanks,
Eli

>
>> Best regards,
>> Chris.
>>
>>
>> ------------------------------
>> *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:
>> https://together.jolla.com/question/58416/fixing-the-contacts-db/
>> <http://redir.aspx?REF=BkinU6px9FrM54d6ielCeDXCD5DIiZfVbcbzrM1uzBJs4ViOMFnUCAFodHRwczovL3RvZ2V0aGVyLmpvbGxhLmNvbS9xdWVzdGlvbi81ODQxNi9maXhpbmctdGhlLWNvbnRhY3RzLWRiLw..>
>>
>> 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)?
>>
>> Thanks,
>> Eli
>>
>> Stats:
>> 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
>> shos.org
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.sailfishos.org/pipermail/devel/attachments/20170220/55060c8a/attachment-0001.html>