Apps keep crashing due to SQlite errors?

[Chris Clawson]

This issue keeps cropping up, and I don't know what's causing it. Sometimes when I open an app it FCs immediately. Once it starts doing this, the only way to fix it seems to be a complete uninstall and reinstall, losing the data in the process. Restoring the data with TitaniumBackup didn't work.

Checking the logs, I see lines like this:
I/Database(11687): sqlite returned: error code = 14, msg = cannot open file at line 27205 of [42537b6056]

Here's a sample:

--------- beginning of /dev/log/main
D/szipinf ( 9434): Initializing inflate state
I/Database( 9434): sqlite returned: error code = 14, msg = cannot open file at line 27205 of [42537b6056]
E/Database( 9434): sqlite3_open_v2("/data/data/com.amazonaws.mobile.apps.Authenticator/databases/databases", &handle, 6, NULL) failed
D/AndroidRuntime( 9434): Shutting down VM
W/dalvikvm( 9434): threadid=1: thread exiting with uncaught exception (group=0x40018560)
E/AndroidRuntime( 9434): FATAL EXCEPTION: main
E/AndroidRuntime( 9434): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.amazonaws.mobile.apps.Authenticator/com.amazonaws.mobile.apps.Authenticator.AuthenticatorActivity}: android.database.sqlite.SQLiteException: unable to open database file
E/AndroidRuntime( 9434): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1768)
E/AndroidRuntime( 9434): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1784)
E/AndroidRuntime( 9434): 	at android.app.ActivityThread.access$1500(ActivityThread.java:123)
E/AndroidRuntime( 9434): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:939)
E/AndroidRuntime( 9434): 	at android.os.Handler.dispatchMessage(Handler.java:99)
E/AndroidRuntime( 9434): 	at android.os.Looper.loop(Looper.java:130)
E/AndroidRuntime( 9434): 	at android.app.ActivityThread.main(ActivityThread.java:3835)
E/AndroidRuntime( 9434): 	at java.lang.reflect.Method.invokeNative(Native Method)
E/AndroidRuntime( 9434): 	at java.lang.reflect.Method.invoke(Method.java:507)
E/AndroidRuntime( 9434): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:864)
E/AndroidRuntime( 9434): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:622)
E/AndroidRuntime( 9434): 	at dalvik.system.NativeStart.main(Native Method)
E/AndroidRuntime( 9434): Caused by: android.database.sqlite.SQLiteException: unable to open database file
E/AndroidRuntime( 9434): 	at android.database.sqlite.SQLiteDatabase.dbopen(Native Method)
E/AndroidRuntime( 9434): 	at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1849)
E/AndroidRuntime( 9434): 	at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:820)
E/AndroidRuntime( 9434): 	at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:854)
E/AndroidRuntime( 9434): 	at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:847)
E/AndroidRuntime( 9434): 	at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:572)
E/AndroidRuntime( 9434): 	at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:203)
E/AndroidRuntime( 9434): 	at com.amazonaws.mobile.apps.Authenticator.AccountDb.initialize(AccountDb.java:58)
E/AndroidRuntime( 9434): 	at com.amazonaws.mobile.apps.Authenticator.AuthenticatorActivity.onCreate(AuthenticatorActivity.java:80)
E/AndroidRuntime( 9434): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
E/AndroidRuntime( 9434): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1722)
E/AndroidRuntime( 9434): 	... 11 more
W/ActivityManager(  193):   Force finishing activity com.amazonaws.mobile.apps.Authenticator/.AuthenticatorActivity
W/ActivityManager(  193):   Force finishing activity org.jtb.alogcat/.LogActivity
W/ActivityManager(  193): Activity pause timeout for HistoryRecord{409ce7b0 com.amazonaws.mobile.apps.Authenticator/.AuthenticatorActivity}
I/ActivityManager(  193): No longer want android.process.media (pid 9154): hidden #16
I/Process ( 9434): Sending signal. PID: 9434 SIG: 9
I/ActivityManager(  193): Process com.amazonaws.mobile.apps.Authenticator (pid 9434) has died.
I/ActivityManager(  193): Starting: Intent { act=android.intent.action.MAIN cat=[android.intent.category.LAUNCHER] flg=0x10100000 cmp=org.jtb.alogcat/.LogActivity bnds=[12,129][86,211] } from pid 193
D/ViewConsistency( 9413): AbsListView android.widget.ListView@405e05d0 enabled= true
D/ViewConsistency( 9413): AbsListView android.widget.ListView@405e05d0 enabled= true
I/ActivityManager(  193): Displayed org.jtb.alogcat/.LogActivity: +693ms (total +8s125ms)
W/ActivityManager(  193): Activity destroy timeout for HistoryRecord{409ce7b0 com.amazonaws.mobile.apps.Authenticator/.AuthenticatorActivity}

Any ideas? I can post more logs if it'll help. I'm running MiRaGe-CM7.2-IHO (04152013) and Link2SD.

 

[bigsupersquid]

Google sez:
Android SQLiteOpenHelper cannot open database file - Stack Overflow

lists permissions problems or missing db files.
Maybe try fix-permissions under advanced menu in recovery.
may or may not apply.

 

[Chris Clawson]

Well, fixing permissions just made it worse, so I am going to try reflashing and reloading.