On Sun, 2012-12-02 at 03:41 +0200, Jānis Rukšāns wrote: > Hi, > > Every four months or so, my N9 decides to wipe out the tracker > database. I have no idea why this happens,
Eh, as having been a N9 developer myself I can tell you with a straight face that this is absolutely not normal and that you should return your phone to a nearby Nokia service center. > but previously I've been > able to get my contacts back by restoring from backup (made with > tracker-control -b), but not now. The kind folk on #tracker suggested > that reason why the restore isn't working might be Aegis going bananas > (there are warnings in the tracker-store.log about not being able to > move files to .cache/tracker/tmp/). Correct, Aegis makes it impossible for the normal user to tamper with Tracker's database directly. You'd need to root your device and chmod the directory in ~/.cache to gain access to the files. Note that you should completely shut down Tracker's process and that this isn't easy as your N9's other softwares will periodically reactivate it based on their needs. So those process must be shut down too to avoid this, while you are working with the files. I generally don't recommend this as doing it wrong can mean loss of data. > After some digging it turned out that restore fails because the backup > fails integrity checks (I guess that was also the reason of the wipe > out). Anyway, I can load the backup in sqlite3 CLI and dump it to SQL. Integrity check failure means that your N9 had a serious HW failure. For that you should return your device to a Nokia service center. Recovering your data will be very difficult. The problem is that making a backup of a sqlite database, using sqlite_backup API (which is what Tracker uses) can copy the corruption to the backup file. So once corrupted, making a backup and restoring that backup doesn't necessarily solve the problem. > My question is whether it is possible to dump some parts from the > backup and replay it against a fresh database. I'm interested only in > contacts and messages; as far as I can tell everything else has a > "data" counterpart that's reindexed. Which tables do I need to dump > for that? No. And I know this sucks. Sorry. > Thanks, > Jānis > _______________________________________________ > tracker-list mailing list > [email protected] > https://mail.gnome.org/mailman/listinfo/tracker-list -- Philip Van Hoof Software developer Codeminded BVBA - http://codeminded.be _______________________________________________ tracker-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/tracker-list
