2017-02-20 20:32 GMT+02:00 E.S. Rosenberg < es.rosenberg+sailfishos....@gmail.com>:
> > > 2017-02-20 12:54 GMT+02:00 E.S. Rosenberg <es.rosenberg+sailfishos.org@ > gmail.com>: > >> 2017-02-20 12:32 GMT+02:00 E.S. Rosenberg <es.rosenberg+sailfishos.org@g >> mail.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 > Hi Chris, Is there any chance you can provide a schematic overview of the contacts.db file of the different relations etc.? I really want to clean up but reverse engineering from column names is sub-ideal. 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