{"action":"created","issue":{"url":"https://api.github.com/repos/playframework/play-slick/issues/336","labels_url":"https://api.github.com/repos/playframework/play-slick/issues/336/labels{/name}","comments_url":"https://api.github.com/repos/playframework/play-slick/issues/336/comments","events_url":"https://api.github.com/repos/playframework/play-slick/issues/336/events","html_url":"https://github.com/playframework/play-slick/issues/336","id":115011640,"number":336,"title":"PlaySlick with Postgres [info] play.api.UnexpectedException: Unexpected exception[SQLTimeoutException: Timeout after 30004ms of waiting for a connection.]","user":{"login":"ngoctranfire","id":3119704,"avatar_url":"https://avatars.githubusercontent.com/u/3119704?v=3","gravatar_id":"","url":"https://api.github.com/users/ngoctranfire","html_url":"https://github.com/ngoctranfire","followers_url":"https://api.github.com/users/ngoctranfire/followers","following_url":"https://api.github.com/users/ngoctranfire/following{/other_user}","gists_url":"https://api.github.com/users/ngoctranfire/gists{/gist_id}","starred_url":"https://api.github.com/users/ngoctranfire/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ngoctranfire/subscriptions","organizations_url":"https://api.github.com/users/ngoctranfire/orgs","repos_url":"https://api.github.com/users/ngoctranfire/repos","events_url":"https://api.github.com/users/ngoctranfire/events{/privacy}","received_events_url":"https://api.github.com/users/ngoctranfire/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-04T09:36:11Z","updated_at":"2015-11-10T07:14:02Z","closed_at":null,"body":"I keep getting this error. Can you tell me why this happens. It happens specifically when I have this type of configuration\r\n\r\nslick.dbs.default.driver=\"slick.driver.PostgresDriver$\"\r\nslick.dbs.default.db.driver=\"org.postgresql.Driver\"\r\nslick.dbs.default.db.dataSourceClass = \"slick.jdbc.DatabaseUrlDataSource\"\r\nslick.dbs.default.db.url=\"jdbc:postgresql://localhost:5432/play_blog_sample\"\r\nslick.dbs.default.db.connectionTimeout = 30s\r\nslick.dbs.default.db.user=\"my_user\"\r\nslick.dbs.default.db.password=\"new_password\"\r\n\r\nIf I include: \r\nslick.dbs.default.db.connectionPool = \"disabled\", it leads to the following error:\r\n\r\nSQLException: Required parameter \"url\" missing in DriverDataSource\r\n\r\nCan you help me figure out why this is happening T_T I can include the stack trace if u need it.\r\n "},"comment":{"url":"https://api.github.com/repos/playframework/play-slick/issues/comments/155337119","html_url":"https://github.com/playframework/play-slick/issues/336#issuecomment-155337119","issue_url":"https://api.github.com/repos/playframework/play-slick/issues/336","id":155337119,"user":{"login":"dotta","id":703748,"avatar_url":"https://avatars.githubusercontent.com/u/703748?v=3","gravatar_id":"","url":"https://api.github.com/users/dotta","html_url":"https://github.com/dotta","followers_url":"https://api.github.com/users/dotta/followers","following_url":"https://api.github.com/users/dotta/following{/other_user}","gists_url":"https://api.github.com/users/dotta/gists{/gist_id}","starred_url":"https://api.github.com/users/dotta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dotta/subscriptions","organizations_url":"https://api.github.com/users/dotta/orgs","repos_url":"https://api.github.com/users/dotta/repos","events_url":"https://api.github.com/users/dotta/events{/privacy}","received_events_url":"https://api.github.com/users/dotta/received_events","type":"User","site_admin":false},"created_at":"2015-11-10T07:14:02Z","updated_at":"2015-11-10T07:14:02Z","body":"Hi @ngoctranfire, usage questions should be asked on the [playframework-user mailing list](https://groups.google.com/forum/#!forum/play-framework). The issue tracker is for confirmed issues.\r\n\r\nThe likely reason why you are getting a `SQLTimeoutException` is because there aren't any connection available. The usual reason for this is that you are leaking connections, but this should be hard now with Slick 3+. However, to tell exactly one should have a look at your code. You may find the following discussion useful for debugging the problem https://github.com/brettwooldridge/HikariCP/issues/104\r\n\r\n> If I include: \r\n> slick.dbs.default.db.connectionPool = \"disabled\", it leads to the following error:\r\n>\r\n> SQLException: Required parameter \"url\" missing in DriverDataSource\r\n\r\nThat seems like a bug. Is this happening with the latest play-slick 1.1.1? I'm asking because it seems somewhat similar to https://github.com/playframework/play-slick/issues/324, and the linked issue was fixed in 1.1.1. If you can reproduce the issue with 1.1.1, could you please open a ticket for it. Thanks!\r\n\r\nCheers,\r\nMirco"}}