[CB-9054] App crashes on what seems to be an SQL issue with Lollipop

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Affects Version/s: 3.5.0
• Component/s: cordova-android
• Assignee: Joey Robert Bowser
• Reporter: Susanna Huhtanen
• Created: 21/May/15 09:18
• Updated: 23/Aug/18 07:08
• Resolved: 07/Jul/15 17:57

Description

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