在操作android中的sqlite数据库的时候,因为频繁的查询导致数据库在跑了一分多钟突然程序崩了报了这个错误,如下:
android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open database file (code 14)
at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)
at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:791)
at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788)
at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86)
at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1529)
at android.database.sqlite.SQLiteDatabase.replace(SQLiteDatabase.java:1445)
at com.mob.commons.logcollector.b.a(DBProvider.java:57)
at com.mob.commons.logcollector.e.a(MessageUtils.java:30)
at com.mob.commons.logcollector.c$2.run(LogsManager.java:203)
at com.mob.commons.e.a(Locks.java:109)
at com.mob.commons.e.a(Locks.java:43)
at com.mob.commons.logcollector.c.d(LogsManager.java:198)
at com.mob.commons.logcollector.c.a(LogsManager.java:136)
at com.mob.commons.logcollector.c$1.handleMessage(LogsManager.java:66)
at android.os.Handler.dispatchMessage(Handler.java:107)
at android.os.Looper.loop(Looper.java:224)
at com.mob.tools.MobHandlerThread.run(MobHandlerThread.java:56)
at com.mob.tools.MobHandlerThread$1.run(MobHandlerThread.java:136)
在查了一些博客以后发现问题是由于查询后生成的Cursor对象没有关闭导致的在对应的地方调用一下cursor.close();方法后正常,在相同的情况下测试了20多分钟,一切正常