lundi 20 avril 2015

SQLiteCantOpenDatabaseException : unable to open database file (code 14)

I randomly get errors SQLiteCantOpenDatabaseException : unable to open database file (code 14)...

Here are some interresting logs :

04-20 11:55:47.936: E/SQLiteLog(1432): (14) cannot open file at line 30241 of [00bb9c9ce4]
04-20 11:55:47.936: E/SQLiteLog(1432): (14) os_unix.c:30241: (24) open(/data/data/http://ift.tt/1JlRkZG) - 
04-20 11:55:47.936: E/SQLiteLog(1432): (14) cannot open file at line 30241 of [00bb9c9ce4]
04-20 11:55:47.936: E/SQLiteLog(1432): (14) os_unix.c:30241: (24) open(/data/data/http://ift.tt/1JlRkZG) - 
04-20 11:55:47.936: E/SQLiteLog(1432): (14) statement aborts at 27: [SELECT T.'_id',T.'WEBSERVICE',T.'STATUS',T.'TENTATIVE',T.'CREATED',T.'START',T.'METHOD',T.'EXECUTED',T.'FINISHED',T.'SIZE',T.'RESPONSE' FROM WEBSERVICE_REQUEST T  WHERE T.'CREATED'<? A
04-20 11:55:47.936: E/SQLiteQuery(1432): exception: unable to open database file (code 14); query: SELECT T.'_id',T.'WEBSERVICE',T.'STATUS',T.'TENTATIVE',T.'CREATED',T.'START',T.'METHOD',T.'EXECUTED',T.'FINISHED',T.'SIZE',T.'RESPONSE' FROM WEBSERVICE_REQUEST T  WHERE T.'CREATED'<? AND T.'STATUS'<>? AND T.'STATUS'<>?
04-20 11:55:47.976: I/WebserviceService(1432): Execute old queries older than Mon Apr 20 11:53:47 UTC+02:00 2015
04-20 11:55:47.976: E/CursorWindow(1432): Could not allocate CursorWindow '/data/data/http://ift.tt/1yJYqXp' of size 2097152 due to error -24.
04-20 11:55:47.996: E/TrafficStats(1432): Can't open /proc/uid_stat/10104/tcp_snd: Too many open files
04-20 11:55:47.996: E/TrafficStats(1432): Can't open /proc/uid_stat/10104/udp_snd: Too many open files
04-20 11:55:47.996: E/TrafficStats(1432): Can't open /proc/uid_stat/10104/tcp_rcv: Too many open files
04-20 11:55:47.996: E/TrafficStats(1432): Can't open /proc/uid_stat/10104/udp_rcv: Too many open files
04-20 11:55:47.996: A/Looper(1432): Could not create wake pipe.  errno=24

Here is the full stack :

android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open database file (code 14)
at android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
at android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:969)
at android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:836)
at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)
at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:143)
at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:133)
at de.greenrobot.dao.LazyList.<init>(LazyList.java:133)
at de.greenrobot.dao.Query.listLazy(Query.java:103)
at de.greenrobot.dao.QueryBuilder.listLazy(QueryBuilder.java:360)
at my.company.WebserviceService.dumpOldQueries(WebserviceService.java:465)
at my.company.WebserviceService.onCreate(WebserviceService.java:95)
at android.app.ActivityThread.handleCreateService(ActivityThread.java:2396)
at android.app.ActivityThread.access$1700(ActivityThread.java:134)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1306)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:137)
at android.app.ActivityThread.main(ActivityThread.java:4867)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:511)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1007)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:774)
at dalvik.system.NativeStart.main(Native Method)

Why is it trying to open the journal file ?

And what is error code -24 ? (I wasn't able to find it anwhere on the internet !)

Thanks :)

Aucun commentaire:

Enregistrer un commentaire