android.database.sqlite.SQLiteException: unable to open database file (code 14)

GitHub | nifhel | 4 months ago
  1. 0

    SQLiteException: unable to open database file

    GitHub | 4 months ago | nifhel
    android.database.sqlite.SQLiteException: unable to open database file (code 14)
  2. 0

    Query for fetching email from contacts in Android 5.0 ? Getting Crash

    Stack Overflow | 2 years ago | Sam-In-TechValens
    android.database.sqlite.SQLiteException: unable to open database file (code 14)
  3. 0

    While testing an app crached on calling navigator.contacts.find with var options = new ContactFindOptions(); options.filter = ""; options.multiple = true; var fields = ["name", "emails", "phoneNumbers"]; var self = this; navigator.contacts.find(fields, function (res) { ... }, function (err) { ... }, options); 05-12 16:39:41.226 24766 24860 E SQLiteLog: (14) cannot open file at line 30046 of [9491ba7d73] 05-12 16:39:41.226 24766 24860 E SQLiteLog: (14) os_unix.c:30046: (24) open(/data/user/0/com.android.providers.contacts/databases/contacts2.db-journal) - 05-12 16:39:41.226 24766 24860 E SQLiteLog: (14) cannot open file at line 30046 of [9491ba7d73] 05-12 16:39:41.226 24766 24860 E SQLiteLog: (14) os_unix.c:30046: (24) open(/data/user/0/com.android.providers.contacts/databases/contacts2.db-journal) - 05-12 16:39:41.226 24766 24860 E SQLiteLog: (14) statement aborts at 91: [SELECT DISTINCT data15 FROM htc_data_view_restricted data LEFT OUTER JOIN (SELECT data_usage_stat.data_id as STAT_DATA_ID, SUM(data_usage_stat.times_used) as times_used, MAX(data_usage 05-12 16:39:41.226 24766 24860 E SQLiteDBG: func: nativeExecuteForCursorWindow, errno: 24, error msg: Too many open files, path: /data/user/0/com.android.providers.contacts/databases/contacts2.db, handle: 0x5588199170 05-12 16:39:41.226 24766 24860 E SQLiteQuery: exception: unable to open database file (code 14); query: SELECT DISTINCT data15 FROM htc_data_view_restricted data LEFT OUTER JOIN (SELECT data_usage_stat.data_id as STAT_DATA_ID, SUM(data_usage_stat.times_used) as times_used, MAX(data_usage_stat.last_time_used) as last_time_used FROM data_usage_stat GROUP BY data_usage_stat.data_id) as data_usage_stat ON (STAT_DATA_ID=data._id) WHERE (1 AND contact_id=? AND _id=photo_id) 05-12 16:39:41.226 24766 24860 E DatabaseUtils: Writing exception to parcel 05-12 16:39:41.226 24766 24860 E DatabaseUtils: android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open database file (code 14) 05-12 16:39:41.226 24766 24860 E DatabaseUtils: at android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method) 05-12 16:39:41.226 24766 24860 E DatabaseUtils: at android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:873) 05-12 16:39:41.226 24766 24860 E DatabaseUtils: at android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:836) 05-12 16:39:41.226 24766 24860 E DatabaseUtils: at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62) 05-12 16:39:41.226 24766 24860 E DatabaseUtils: at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:172) 05-12 16:39:41.226 24766 24860 E DatabaseUtils: at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:161) 05-12 16:39:41.226 24766 24860 E DatabaseUtils: at android.database.CursorToBulkCursorAdaptor.getBulkCursorDescriptor(CursorToBulkCursorAdaptor.java:162) 05-12 16:39:41.226 24766 24860 E DatabaseUtils: at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:152) 05-12 16:39:41.226 24766 24860 E DatabaseUtils: at android.os.Binder.execTransact(Binder.java:454) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: FATAL EXCEPTION: pool-2-thread-2 05-12 16:39:41.236 24706 24759 E AndroidRuntime: Process: com.foo.bar, PID: 24706 05-12 16:39:41.236 24706 24759 E AndroidRuntime: android.database.sqlite.SQLiteException: unable to open database file (code 14) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:181) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:137) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at android.content.ContentProviderProxy.query(ContentProviderNative.java:470) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at android.content.ContentResolver.query(ContentResolver.java:499) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at android.content.ContentResolver.query(ContentResolver.java:443) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at org.apache.cordova.contacts.ContactAccessorSdk5.photoQuery(ContactAccessorSdk5.java:910) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at org.apache.cordova.contacts.ContactAccessorSdk5.populateContactArray(ContactAccessorSdk5.java:439) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at org.apache.cordova.contacts.ContactAccessorSdk5.search(ContactAccessorSdk5.java:271) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at org.apache.cordova.contacts.ContactManager$1.run(ContactManager.java:93) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587) 05-12 16:39:41.236 24706 24759 E AndroidRuntime: at java.lang.Thread.run(Thread.java:818) 05-12 16:39:41.256 1254 4246 E ActivityManager: App crashed! Process: com.foo.bar 05-12 16:39:41.256 4490 4490 D WIFI_ICON: WifiActivity: 1

    Apache's JIRA Issue Tracker | 2 years ago | Susanna Huhtanen
    android.database.sqlite.SQLiteException: unable to open database file (code 14)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unable to open database file (code 14)

    GitHub | 9 months ago | BigPun86
    android.database.sqlite.SQLiteException: unable to open database file (code 14)
  6. 0

    com.andrew.apollo.MusicPlaybackService: SQLiteException: no such column: album_id (code 1)

    GitHub | 2 years ago | gubatron
    java.lang.RuntimeException: Unable to create service com.andrew.apollo.MusicPlaybackService: android.database.sqlite.SQLiteException: no such column: album_id (code 1): , while compiling: SELECT album_art FROM (SELECT album_info.*,audio_meta._data,audio_meta.is_music,audio_meta.is_drm FROM album_info LEFT OUTER JOIN audio_meta ON album_info._id=audio_meta.album_id) WHERE (_data not like '/storage/sdcard1/%' AND is_music=1 AND album_id=?) GROUP BY _id

  1. Rajesh 20 times, last 4 months ago
  2. jk 8 times, last 5 months ago
4 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. android.database.sqlite.SQLiteException

    unable to open database file (code 14)

    at android.database.DatabaseUtils.readExceptionFromParcel()
  2. Android Platform
    ContentResolver.query
    1. android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:179)
    2. android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:135)
    3. android.content.ContentProviderProxy.query(ContentProviderNative.java:421)
    4. android.content.ContentResolver.query(ContentResolver.java:497)
    5. android.content.ContentResolver.query(ContentResolver.java:439)
    5 frames
  3. com.sangcomz.fishbun
    AlbumActivity$DisplayThumbnail.doInBackground
    1. com.sangcomz.fishbun.ui.album.AlbumActivity.getAllMediaThumbnailsPath(AlbumActivity.java:312)
    2. com.sangcomz.fishbun.ui.album.AlbumActivity.access$500(AlbumActivity.java:36)
    3. com.sangcomz.fishbun.ui.album.AlbumActivity$DisplayThumbnail.doInBackground(AlbumActivity.java:271)
    4. com.sangcomz.fishbun.ui.album.AlbumActivity$DisplayThumbnail.doInBackground(AlbumActivity.java:257)
    4 frames
  4. Android Platform
    AsyncTask$2.call
    1. android.os.AsyncTask$2.call(AsyncTask.java:295)
    1 frame
  5. Java RT
    FutureTask.run
    1. java.util.concurrent.FutureTask.run(FutureTask.java:237)
    1 frame
  6. Android Platform
    AsyncTask$SerialExecutor$1.run
    1. android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:234)
    1 frame
  7. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:588)
    3. java.lang.Thread.run(Thread.java:818)
    3 frames