Return-Path: X-Original-To: apmail-cordova-issues-archive@minotaur.apache.org Delivered-To: apmail-cordova-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D6E37185DC for ; Mon, 22 Jun 2015 20:59:00 +0000 (UTC) Received: (qmail 18768 invoked by uid 500); 22 Jun 2015 20:59:00 -0000 Delivered-To: apmail-cordova-issues-archive@cordova.apache.org Received: (qmail 18745 invoked by uid 500); 22 Jun 2015 20:59:00 -0000 Mailing-List: contact issues-help@cordova.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list issues@cordova.apache.org Received: (qmail 18732 invoked by uid 99); 22 Jun 2015 20:59:00 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Jun 2015 20:59:00 +0000 Date: Mon, 22 Jun 2015 20:59:00 +0000 (UTC) From: "Joe Bowser (JIRA)" To: issues@cordova.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (CB-9054) App crashes on what seems to be an SQL issue with Lollipop MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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: issues-unsubscribe@cordova.apache.org For additional commands, e-mail: issues-help@cordova.apache.org