Hi Tone. Are you saying that you created a new database by using sqlite3 to import the dump you previously, and then you ran "pragma integrity_check;" on that new database, and found errors? That should be unpossible...
You have no contacts in the people app? Can you try using contacts-tool as well (from a privileged shell): $ contacts-tool list Thanks, Matt ________________________________ From: devel-boun...@lists.sailfishos.org [devel-boun...@lists.sailfishos.org] on behalf of Tone Kastlunger [users.giulie...@gmail.com] Sent: Tuesday, October 27, 2015 5:10 PM To: Sailfish OS Developers Subject: Re: [SailfishDevel] Contacts db issue Hey Matthew; thanks for the fast reply! Here's what I get from the new DB (after having run sqlite3 qtcontacts-sqlite/contacts.db "pragma integrity_check;" on the newly created db): [nemo@Jolla Contacts]$ sqlite3 qtcontacts-sqlite/contacts.db "pragma integrity_check;" *** in database main *** On tree page 3275 cell 0: invalid page number 11395 On tree page 3275 cell 0: Rowid 271735 out of order (min less than parent min of 524637) On tree page 2 cell 1: Child page depth differs and a bunch of the following: Page xx is never used Needless to say, after reboot, contact app shows no contacts at all (of course :) ). Best, tk On Tue, Oct 27, 2015 at 12:30 AM, Matthew Vogt <matthew.v...@jolla.com<mailto:matthew.v...@jolla.com>> wrote: Hi Tone. Yes, it sounds like you have a corrupted contacts database. Any idea how that might have happened? In any case, you can try to recreate the database to fix the issue. You need to do something along the lines of the following (but please sanity-check these instructions before running them, I'm typing them into email, not having tested them on device!): You will need to have a privileged user session: $ devel-su -p Then stop everything that might be writing to the contacts database: $ systemctl --user stop lipstick $ systemctl --user stop msyncd $ systemctl --user stop contactsd $ systemctl --user stop as-daemon Change to the directory where the database resides: $ cd ~/.local/share/system/privileged/Contacts Check that DB is actually corrupted; this will say 'ok' if there are no problems, or report a bunch of error messages: $ sqlite3 qtcontacts-sqlite/contacts.db "pragma integrity_check;" If there are problems, continue: Make a backup copy of the broken DB just in case we lose something: $ mkdir bkp $ cp -R qtcontacts-sqlite bkp/ Dump the DB contents: $ mkdir temp $ sqlite3 qtcontacts-sqlite/contacts.db .dump > temp/dump.sql Record the current schema version of the DB, which is reported by the following command (it is probably 15 or 16 or something similar): $ sqlite3 qtcontacts-sqlite/contacts.db "pragma user_version;" Recreate the database from the dump: $ mkdir new-db $ sqlite3 new-db/contacts.db < temp/dump.sql Set the schema version in the new database, where VER is the number reported above: $ sqlite3 new-db/contacts.db "pragma user_version = <VER>;" Move the new database to be the device database: $ mv qtcontacts-sqlite old-db $ mv new-db qtcontacts-sqlite Then reboot, and the device will restart using the new version of the DB. You can then remove the bkp, temp and old-db directories, assuming things went well. If things did not go well, you can restore the old-db directory to the 'qtcontacts-sqlite' location (after stopping everything as we did earlier) and contact me directly. Thanks, Matt ________________________________ From: devel-boun...@lists.sailfishos.org<mailto:devel-boun...@lists.sailfishos.org> [devel-boun...@lists.sailfishos.org<mailto:devel-boun...@lists.sailfishos.org>] on behalf of Tone Kastlunger [users.giulie...@gmail.com<mailto:users.giulie...@gmail.com>] Sent: Tuesday, October 27, 2015 5:47 AM To: devel@lists.sailfishos.org<mailto:devel@lists.sailfishos.org> Subject: [SailfishDevel] Contacts db issue Hey; looking through the logs (for something else) on my Jolla I happened to find the following error; it appears to be realated to the contacts db. Any way to fix it? "Failed to prepare query for joined details: database disk image is malformed Unable to fetch row Query: SELECT Details.detailId,Details.contactId,Details.detail,Details.detailUri,Details.linkedDetailUris,Details.contexts,Details.accessConstraints,Details.provenance,COALESCE(Details.modifiable, 0),COALESCE(Details.nonexportable, 0),Addresses.*,Anniversaries.*,Avatars.*,Birthdays.*,EmailAddresses.*,Families.*,GeoLocations.*,Guids.*,Hobbies.*,Nicknames.*,Notes.*,OnlineAccounts.*,Organizations.*,PhoneNumbers.*,Presences.*,Ringtones.*,Tags.*,Urls.*,OriginMetadata.*,GlobalPresences.*,ExtendedDetails.* FROM temp.RegenerateAggregate CROSS JOIN Details ON Details.contactId = temp.RegenerateAggregate.contactId LEFT JOIN Addresses ON Addresses.detailId = Details.detailId LEFT JOIN Anniversaries ON Anniversaries.detailId = Details.detailId LEFT JOIN Avatars ON Avatars.detailId = Details.detailId LEFT JOIN Birthdays ON Birthdays.detailId = Details.detailId LEFT JOIN EmailAddresses ON EmailAddresses.detailId = Details.detailId LEFT JOIN Families ON Families.detailId = Details.detailId LEFT JOIN GeoLocations ON GeoLocations.detailId = Details.detailId LEFT JOIN Guids ON Guids.detailId = Details.detailId LEFT JOIN Hobbies ON Hobbies.detailId = Details.detailId LEFT JOIN Nicknames ON Nicknames.detailId = Details.detailId LEFT JOIN Notes ON Notes.detailId = Details.detailId LEFT JOIN OnlineAccounts ON OnlineAccounts.detailId = Details.detailId LEFT JOIN Organizations ON Organizations.detailId = Details.detailId LEFT JOIN PhoneNumbers ON PhoneNumbers.detailId = Details.detailId LEFT JOIN Presences ON Presences.detailId = Details.detailId LEFT JOIN Ringtones ON Ringtones.detailId = Details.detailId LEFT JOIN Tags ON Tags.detailId = Details.detailId LEFT JOIN Urls ON Urls.detailId = Details.detailId LEFT JOIN OriginMetadata ON OriginMetadata.detailId = Details.detailId LEFT JOIN GlobalPresences ON GlobalPresences.detailId = Details.detailId LEFT JOIN ExtendedDetails ON ExtendedDetails.detailI Oct 26 21:38:30 Jolla [1156]: [W] ContactWriter::regenerateAggregates:3652 - "Failed to read constituent contacts for aggregate 8487 during regenerate" _______________________________________________ SailfishOS.org Devel mailing list To unsubscribe, please send a mail to devel-unsubscr...@lists.sailfishos.org<mailto:devel-unsubscr...@lists.sailfishos.org>
_______________________________________________ SailfishOS.org Devel mailing list To unsubscribe, please send a mail to devel-unsubscr...@lists.sailfishos.org
