kuanysh-nabiyev
Because of many configuration settings on ecto like timeout, pool_size, queue_target, queue_interval and etc, I want to disable it. Instead of ecto pool I want to use only pgbouncer.
Ecto pool settings is like magic to right now, because when I have set timeout was 15 seconds I got many pool timeout errors. And I when I set to 120 seconds I also got many pool timeout errors sometimes (20-500 errors in one minute and then worked correctly).
Only after changing to 65 seconds application started to works without any pool timeout errors.
Everything is ok right now, but I am afraid that the problem can be returned.
My ecto database configuration:
hostname: “10.128.0.3”,
pool_size: 200,
queue_target: 5_000,
queue_interval: 20_000,
prepare: :unnamed,
timeout: 65_000
Error:
(DBConnection.ConnectionError) tcp recv: closed (the connection was closed by the pool, possibly due to a timeout or because the pool has been terminated)
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Build Elixir applications with speed and confidence.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ai
- #ecto-query
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #metaprogramming
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Master modern tools, write cleaner code, and tackle real-world challenges.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 2 to 1- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
LostKobrakai
Yeah you’d want to figure out why the db server was unhappy with you connecting. Running into timeouts was likely just a sideeffect of your server refusing to cooperate.
al2o3cr
For what it’s worth, this error frequently happens because the database server has shut down the connection from its end. Adjusting the configuration of the pool isn’t going to directly affect that.