{"action":"opened","issue":{"url":"https://api.github.com/repos/our-city-app/mobicage-android-client/issues/48","repository_url":"https://api.github.com/repos/our-city-app/mobicage-android-client","labels_url":"https://api.github.com/repos/our-city-app/mobicage-android-client/issues/48/labels{/name}","comments_url":"https://api.github.com/repos/our-city-app/mobicage-android-client/issues/48/comments","events_url":"https://api.github.com/repos/our-city-app/mobicage-android-client/issues/48/events","html_url":"https://github.com/our-city-app/mobicage-android-client/issues/48","id":340243772,"node_id":"MDU6SXNzdWUzNDAyNDM3NzI=","number":48,"title":"Database errors occur when the user follows/unfollows a service","user":{"login":"lucasvanhalst","id":6652304,"node_id":"MDQ6VXNlcjY2NTIzMDQ=","avatar_url":"https://avatars0.githubusercontent.com/u/6652304?v=4","gravatar_id":"","url":"https://api.github.com/users/lucasvanhalst","html_url":"https://github.com/lucasvanhalst","followers_url":"https://api.github.com/users/lucasvanhalst/followers","following_url":"https://api.github.com/users/lucasvanhalst/following{/other_user}","gists_url":"https://api.github.com/users/lucasvanhalst/gists{/gist_id}","starred_url":"https://api.github.com/users/lucasvanhalst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lucasvanhalst/subscriptions","organizations_url":"https://api.github.com/users/lucasvanhalst/orgs","repos_url":"https://api.github.com/users/lucasvanhalst/repos","events_url":"https://api.github.com/users/lucasvanhalst/events{/privacy}","received_events_url":"https://api.github.com/users/lucasvanhalst/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-11T13:32:30Z","updated_at":"2018-07-11T13:32:30Z","closed_at":null,"author_association":"NONE","body":"---\n\nMigrated from https://github.com/rogerthat-platform/rogerthat-android-client/issues/228\nOriginally created by @abom on *Mon, 04 Sep 2017 12:27:22 GMT*\n\n---\nSearch services then follow any service, then go back or unfollow a service from the services list.\r\n\r\n```\r\nDEBUG    2017-09-04 12:17:16,982 logging_page.py:36] Error logged over HTTP:                                                               [127/12172]\r\njava.lang.IllegalStateException: attempt to re-open an already-closed object: SQLiteQuery: SELECT f.rowid as _id, f.email, f.name, f.share_location, f\r\n.shares_location, f.avatar, f.existence, f.type, f.description, f.description_branding, f.poke_description, f.qualified_identifier, f.organization_typ\r\ne, f.callbacks, f.flags, f.profile_data, f.content_branding_hash, f.actions, IFNULL(c.id, f.email) AS cat_id, ifnull(c.name, f.name) AS cat_name, c.av\r\natar, count(f.email) FROM friend f LEFT OUTER JOIN friend_category c ON c.id = f.category_id WHERE (f.existence = 0 OR f.existence = 4) AND f.type = 2\r\n GROUP BY cat_id ORDER BY cat_name COLLATE NOCASE\r\n        at android.database.sqlite.SQLiteClosable.acquireReference(SQLiteClosable.java:55)\r\n        at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:58)\r\n        at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:163)\r\n        at android.database.sqlite.SQLiteCursor.onMove(SQLiteCursor.java:135)\r\n        at android.database.AbstractCursor.moveToPosition(AbstractCursor.java:214)\r\n        at android.widget.AlphabetIndexer.getSectionForPosition(AlphabetIndexer.java:257)\r\n        at com.mobicage.rogerthat.FriendListAdapter.getSectionForPosition(FriendListAdapter.java:194)\r\n        at android.widget.FastScroller.getPosFromItemCount(FastScroller.java:1265)\r\n        at android.widget.FastScroller.onItemCountChanged(FastScroller.java:520)\r\n        at android.widget.AbsListView.onLayout(AbsListView.java:2262)\r\n        at android.view.View.layout(View.java:16009)\r\n        at android.view.ViewGroup.layout(ViewGroup.java:5181)\r\n        at android.widget.LinearLayout.setChildFrame(LinearLayout.java:1990)\r\n        at android.widget.LinearLayout.layoutVertical(LinearLayout.java:1844)\r\n        at android.widget.LinearLayout.onLayout(LinearLayout.java:1753)\r\n        at android.view.View.layout(View.java:16009)\r\n        at android.view.ViewGroup.layout(ViewGroup.java:5181)\r\n        at android.widget.LinearLayout.setChildFrame(LinearLayout.java:1990)\r\n        at android.widget.LinearLayout.layoutVertical(LinearLayout.java:1844)\r\n        at android.widget.LinearLayout.onLayout(LinearLayout.java:1753)\r\n        at android.view.View.layout(View.java:16009)\r\n        at android.view.ViewGroup.layout(ViewGroup.java:5181)\r\n        at android.support.design.widget.CoordinatorLayout.layoutChild(CoordinatorLayout.java:1167)\r\n        at android.support.design.widget.CoordinatorLayout.onLayoutChild(CoordinatorLayout.java:852)\r\n        at android.support.design.widget.CoordinatorLayout.onLayout(CoordinatorLayout.java:871)\r\n        at android.view.View.layout(View.java:16009)\r\n        at android.view.ViewGroup.layout(ViewGroup.java:5181)\r\n        at android.support.v4.widget.DrawerLayout.onLayout(DrawerLayout.java:1193)\r\n        at android.view.View.layout(View.java:16009)\r\n        at android.view.ViewGroup.layout(ViewGroup.java:5181)\r\n        at android.widget.FrameLayout.layoutChildren(FrameLayout.java:639)\r\n        at android.widget.FrameLayout.onLayout(FrameLayout.java:574)\r\n        at android.view.View.layout(View.java:16009)\r\n        at android.view.ViewGroup.layout(ViewGroup.java:5181)\r\n        at android.widget.LinearLayout.setChildFrame(LinearLayout.java:1990)\r\n        at android.widget.LinearLayout.layoutVertical(LinearLayout.java:1844)\r\n        at android.widget.LinearLayout.onLayout(LinearLayout.java:1753)\r\n        at android.view.View.layout(View.java:16009)\r\n        at android.view.ViewGroup.layout(ViewGroup.java:5181)\r\n        at android.widget.FrameLayout.layoutChildren(FrameLayout.java:639)\r\n        at android.widget.FrameLayout.onLayout(FrameLayout.java:574)\r\n        at android.view.View.layout(View.java:16009)\r\n        at android.view.ViewGroup.layout(ViewGroup.java:5181)\r\n        at android.widget.LinearLayout.setChildFrame(LinearLayout.java:1990)\r\n        at android.widget.LinearLayout.layoutVertical(LinearLayout.java:1844)\r\n        at android.widget.LinearLayout.onLayout(LinearLayout.java:1753)\r\n        at android.view.View.layout(View.java:16009)\r\n        at android.view.ViewGroup.layout(ViewGroup.java:5181)\r\n        at android.widget.FrameLayout.layoutChildren(FrameLayout.java:639)\r\n        at android.widget.FrameLayout.onLayout(FrameLayout.java:574)\r\n        at android.view.View.layout(View.java:16009)\r\n        at android.view.ViewGroup.layout(ViewGroup.java:5181)\r\n        at android.view.ViewRootImpl.performLayout(ViewRootImpl.java:2483)\r\n        at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:2180)\r\n        at android.view.ViewRootImpl.doTraversal(ViewRootImpl.java:1292)\r\n        at android.view.ViewRootImpl$TraversalRunnable.run(ViewRootImpl.java:6598)\r\n        at android.view.Choreographer$CallbackRecord.run(Choreographer.java:800)\r\n        at android.view.Choreographer.doCallbacks(Choreographer.java:603)\r\n        at android.view.Choreographer.doFrame(Choreographer.java:572)\r\n        at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:786)\r\n        at android.os.Handler.handleCallback(Handler.java:815)\r\n        at android.os.Handler.dispatchMessage(Handler.java:104)\r\n        at android.os.Looper.loop(Looper.java:194)\r\n        at android.app.ActivityThread.main(ActivityThread.java:5660)\r\n        at java.lang.reflect.Method.invoke(Native Method)\r\n        at java.lang.reflect.Method.invoke(Method.java:372)\r\n        at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:963)\r\n        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:758)\r\n\r\n```"}}
{"actor":{"display_login":"lucasvanhalst"}}