You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cordova.apache.org by "Joe Bowser (JIRA)" <ji...@apache.org> on 2015/06/16 01:05:00 UTC
[jira] [Commented] (CB-9054) App crashes on what seems to be an SQL
issue with Lollipop
[ https://issues.apache.org/jira/browse/CB-9054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14587102#comment-14587102 ]
Joe Bowser commented on CB-9054:
--------------------------------
What device are you using that has this issue? It sounds like Cordova and some other app are accessing the Contacts at the same time.
> 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
>
> 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