After a reboot, i lost all my accounts. i looked into the logcat and got:
04-02 11:54:01.535 5305 8068 E SQLiteLog: (11) statement aborts at 24: [SELECT key, value FROM extras WHERE accounts_id=(select _id FROM accounts WHERE name=? AND type=?)] database disk image is malformed
04-02 11:54:01.537 5305 8068 E DefaultDatabaseErrorHandler: Corruption reported by sqlite on database: /data/system/users/0/accounts.db
04-02 11:54:01.538 5305 8068 E DefaultDatabaseErrorHandler: deleting the database file: /data/system/users/0/accounts.db
I restored the file completely from a TitaniumBackup XML-file (so the database is created cleanly again, no backup of a possible corrupt db file).
After a reboot, android deletes it again and recreates it, accessing it just after restoring (i.e. using a program, which looks up an account) gives the message
04-02 11:45:22.855 12225 12225 W System.err: Caused by: java.lang.IllegalStateException: The database '/data/system/users/0/accounts.db' is not open.
just after restore, i can open my accounts.db with `
sqlite3
and
SELECT * FROM ACCOUNTS
returns a correct list and
SELECT key, value FROM extras
` works as expected, too.
The file permissions are
-rw-rw---- 1 system system 72K 2017-04-02 11:55 accounts.db
-rw------- 1 system system 17K 2017-04-02 11:55 accounts.db-journal
My ROM is a CyanogenMod 13.
Asked by allo
(415 rep)
Apr 2, 2017, 10:00 AM
Last activity: Dec 8, 2020, 09:07 PM
Last activity: Dec 8, 2020, 09:07 PM