Gmail sync not working, syncemail-client database disk image is malformed

asked 2017-06-26 19:37:56 +0200

Deele gravatar image

updated 2017-06-26 19:44:14 +0200

For many months already I had an issue, that I did not receive any e-mails through jolla mail app but I did not bother about it. Today I finally did some reserach.

I saw in journal file systemd-journal-260617_192609-644 tons of messages regarding database disk images being malformed or "encrypted".

Here is a copy of couple such messages:

26.06.17 19:01:42.287 art[12499]: unknown:0[W] unknown:0 - ( 12499 ) Failed to execute query; error:"database disk image is malformed Unable to fetch row"; statement:"SELECT COUNT(*) FROM mailmessages WHERE parentaccountid = (2) AND ( status & (524288)) AND ( NOT ( status & (8192)))"
26.06.17 19:01:42.550 ne[14187]: unknown:0[W] unknown:0 - DbManager::callback: Failed to execute SQL query. Couldn't update the progress! "file is encrypted or is not a database Unable to fetch row" :  "file is encrypted or is not a database"
26.06.17 19:01:42.553 ne[14187]: unknown:0[W] unknown:0 - bool DbManagerPrivate::deleteOldTables() Drop trigger: "file is encrypted or is not a database Unable to execute statement" : "file is encrypted or is not a database"
26.06.17 19:01:42.556 ne[14187]: unknown:0[W] unknown:0 - bool DbManagerPrivate::deleteOldTables() Drop metadata: "file is encrypted or is not a database Unable to execute statement" : "file is encrypted or is not a database"
26.06.17 19:01:42.804 ne[14187]: unknown:0[W] unknown:0 - DbManager::transferStatus: Failed to execute SQL query. Couldn't update the progress! "file is encrypted or is not a database Unable to execute statement" :  "file is encrypted or is not a database"
26.06.17 19:02:34.826 art[12499]: unknown:0[W] unknown:0 - ( 12499 ) Failed to execute query; error:"database disk image is malformed Unable to fetch row"; statement:"SELECT id FROM mailmessages WHERE parentaccountid = (2) AND parentfolderid = (36) AND 0 = (status & (256)) AND 0 = (status & (8192)) ORDER BY stamp DESC LIMIT 140"
26.06.17 19:02:36.768 estart[12411]: file:///usr/share/jolla-settings/settings.qml:15[W] unknown:15 - file:///usr/share/jolla-settings/settings.qml:15:43: QML TransferModel: file is encrypted or is not a database Unable to execute statement
26.06.17 19:02:36.773 art[12499]: unknown:0[D] unknown:0 - Sync completed with Errors!!!.

How to heal databases and make email client work?

edit retag flag offensive close delete