2017-02-20 12:54 GMT+02:00 E.S. Rosenberg < es.rosenberg+sailfishos....@gmail.com>:
> 2017-02-20 12:32 GMT+02:00 E.S. Rosenberg <es.rosenberg+sailfishos.org@ > gmail.com>: > >> 2017-02-20 3:41 GMT+02:00 Chris Adams <chris.ad...@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 > It seems I made a mistake when restoring the backup I now again have all my contacts :) 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. Thanks, Eli > >>> Best regards, >>> Chris. >>> >>> >>> ------------------------------ >>> *From:* Devel [devel-boun...@lists.sailfishos.org] on behalf of E.S. >>> Rosenberg [es.rosenberg+sailfishos....@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@lists.sailfi >>> shos.org >>> >> >> >
_______________________________________________ SailfishOS.org Devel mailing list To unsubscribe, please send a mail to devel-unsubscr...@lists.sailfishos.org