{"comment":{"url":"https://api.github.com/repos/metabase/metabase/comments/35295585","html_url":"https://github.com/metabase/metabase/commit/b5cf9dc6c00c0bee1d8410765ce5de37337d35c1#commitcomment-35295585","id":35295585,"node_id":"MDEzOkNvbW1pdENvbW1lbnQzNTI5NTU4NQ==","user":{"login":"dzebawag","id":49686090,"node_id":"MDQ6VXNlcjQ5Njg2MDkw","avatar_url":"https://avatars2.githubusercontent.com/u/49686090?v=4","gravatar_id":"","url":"https://api.github.com/users/dzebawag","html_url":"https://github.com/dzebawag","followers_url":"https://api.github.com/users/dzebawag/followers","following_url":"https://api.github.com/users/dzebawag/following{/other_user}","gists_url":"https://api.github.com/users/dzebawag/gists{/gist_id}","starred_url":"https://api.github.com/users/dzebawag/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dzebawag/subscriptions","organizations_url":"https://api.github.com/users/dzebawag/orgs","repos_url":"https://api.github.com/users/dzebawag/repos","events_url":"https://api.github.com/users/dzebawag/events{/privacy}","received_events_url":"https://api.github.com/users/dzebawag/received_events","type":"User","site_admin":false},"position":null,"line":null,"path":null,"commit_id":"b5cf9dc6c00c0bee1d8410765ce5de37337d35c1","created_at":"2019-09-30T15:16:26Z","updated_at":"2019-09-30T15:16:26Z","author_association":"NONE","body":"Per https://github.com/metabase/metabase/issues/9955 (closed) this was originally targeted for 33.0, then 33.1, we're at 33.3. @camsaul  working on https://github.com/metabase/metabase/issues/9989 \"I have been trying to crack this nut for a while now. I will look at tweaking our connection pool so it kills dead connections automatically\" We're seeing the same issue of Active Jetty Thread count growing from 50 at docker restart, to 150 within 45 min.  We've labeled as kruft as many tables and schemas as possible to limit the failing queries and we're trying not to affect the image at all. The ability to kill existing threads/queries gracefully seems necessary until the logic can be unwound. Any help here would be much appreciated. Godspeed @camsaul \r\n\r\n09-30 11:00:24 ERROR sql-jdbc.execute :: nil\r\n09-30 11:00:25 ERROR sql-jdbc.execute :: Failed to set timezone:\r\n SQLException:\r\n Message: [Amazon](500310) Invalid operation: permission denied for relation awsdms_changes8f591543277dcede;\r\n SQLState: 42501\r\n Error Code: 500310\r\n\r\n{\r\n \"browser-info\": {\r\n \"language\": \"en-US\",\r\n \"platform\": \"Win32\",\r\n \"userAgent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36\",\r\n \"vendor\": \"Google Inc.\"\r\n },\r\n \"system-info\": {\r\n \"java.runtime.name\": \"OpenJDK Runtime Environment\",\r\n \"java.runtime.version\": \"11.0.4+11\",\r\n \"java.vendor\": \"AdoptOpenJDK\",\r\n \"java.vendor.url\": \"https://adoptopenjdk.net/\",\r\n \"java.version\": \"11.0.4\",\r\n \"java.vm.name\": \"OpenJDK 64-Bit Server VM\",\r\n \"java.vm.version\": \"11.0.4+11\",\r\n \"os.name\": \"Linux\",\r\n \"os.version\": \"5.0.0-1014-azure\",\r\n \"user.language\": \"en\",\r\n \"user.timezone\": \"GMT\"\r\n },\r\n \"metabase-info\": {\r\n \"databases\": [\r\n \"redshift\",\r\n \"postgres\",\r\n \"snowflake\",\r\n \"teradata\",\r\n \"h2\"\r\n ],\r\n \"hosting-env\": \"unknown\",\r\n \"application-database\": \"postgres\",\r\n \"run-mode\": \"prod\",\r\n \"version\": {\r\n \"date\": \"2019-09-20\",\r\n \"tag\": \"v0.33.3\",\r\n \"branch\": \"release-0.33.x\",\r\n \"hash\": \"86d32bf\"\r\n },\r\n \"settings\": {\r\n \"report-timezone\": \"UTC\"\r\n }\r\n }\r\n}"}}
{"actor":{"display_login":"dzebawag"}}