[
https://issues.apache.org/jira/browse/CB-9054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joe Bowser reassigned CB-9054:
------------------------------
Assignee: Joe Bowser
> App crashes on what seems to be an SQL issue with Lollipop
> ----------------------------------------------------------
>
> Key: CB-9054
> URL: https://issues.apache.org/jira/browse/CB-9054
> Project: Apache Cordova
> Issue Type: Bug
> Components: Android
> Affects Versions: 3.5.0
> Reporter: Susanna Huhtanen
> Assignee: Joe Bowser
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
