{"action":"created","issue":{"url":"https://api.github.com/repos/osmdroid/osmdroid/issues/455","repository_url":"https://api.github.com/repos/osmdroid/osmdroid","labels_url":"https://api.github.com/repos/osmdroid/osmdroid/issues/455/labels{/name}","comments_url":"https://api.github.com/repos/osmdroid/osmdroid/issues/455/comments","events_url":"https://api.github.com/repos/osmdroid/osmdroid/issues/455/events","html_url":"https://github.com/osmdroid/osmdroid/issues/455","id":184683222,"number":455,"title":"Moving tiles to database possible glitch?","user":{"login":"InI4","id":4115837,"avatar_url":"https://avatars.githubusercontent.com/u/4115837?v=3","gravatar_id":"","url":"https://api.github.com/users/InI4","html_url":"https://github.com/InI4","followers_url":"https://api.github.com/users/InI4/followers","following_url":"https://api.github.com/users/InI4/following{/other_user}","gists_url":"https://api.github.com/users/InI4/gists{/gist_id}","starred_url":"https://api.github.com/users/InI4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/InI4/subscriptions","organizations_url":"https://api.github.com/users/InI4/orgs","repos_url":"https://api.github.com/users/InI4/repos","events_url":"https://api.github.com/users/InI4/events{/privacy}","received_events_url":"https://api.github.com/users/InI4/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-10-23T10:46:01Z","updated_at":"2016-10-30T16:40:33Z","closed_at":"2016-10-30T16:40:33Z","body":"It seems I just merged the \"moving tiles from filesystem to database\" stuff in my private branch.\r\n\r\nI observer the following 3 issues.\r\n\r\n1. It takes long, making the map not starting up for a while. I see lots of those: `10-23 12:30:56.980 19168-20993/de.spieleck.app.badgers.debug W/SQLiteConnectionPool: The connection pool for database '+storage+emulated+0+osmdroid+tiles+cache_db' has been unable to grant a connection to thread 324302 (sqlcache) with flags 0x1 for 28.005001 seconds.\r\n                                                                                     Connections: 1 active, 0 idle, 0 available.\r\n                                                                                     \r\n                                                                                     Requests in progress:\r\n                                                                                       executeForCursorWindow started 28075ms ago - running, sql=\"SELECT tile, expires FROM tiles WHERE key = 16675580836 and provider = 'Mapnik'\"`\r\n\r\n2. It does not really help, rather hurt, as long as there are other apps on my phone, which use an older version of osmdroid. Don't  those just lose their cache and reload stuff new on next start?\r\n\r\n3. Well, maybe not, cause the files in the file system are not gone. Well, this interacts with 2, so I wonder, when does this deletion happen? At least the database import does not happen again on next start."},"comment":{"url":"https://api.github.com/repos/osmdroid/osmdroid/issues/comments/257162033","html_url":"https://github.com/osmdroid/osmdroid/issues/455#issuecomment-257162033","issue_url":"https://api.github.com/repos/osmdroid/osmdroid/issues/455","id":257162033,"user":{"login":"spyhunter99","id":1975321,"avatar_url":"https://avatars.githubusercontent.com/u/1975321?v=3","gravatar_id":"","url":"https://api.github.com/users/spyhunter99","html_url":"https://github.com/spyhunter99","followers_url":"https://api.github.com/users/spyhunter99/followers","following_url":"https://api.github.com/users/spyhunter99/following{/other_user}","gists_url":"https://api.github.com/users/spyhunter99/gists{/gist_id}","starred_url":"https://api.github.com/users/spyhunter99/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spyhunter99/subscriptions","organizations_url":"https://api.github.com/users/spyhunter99/orgs","repos_url":"https://api.github.com/users/spyhunter99/repos","events_url":"https://api.github.com/users/spyhunter99/events{/privacy}","received_events_url":"https://api.github.com/users/spyhunter99/received_events","type":"User","site_admin":false},"created_at":"2016-10-30T16:40:33Z","updated_at":"2016-10-30T16:40:33Z","body":"k, reopen if the issue comes up again"}}
{"actor":{"display_login":"spyhunter99"}}