cjbottaro
Are there any callbacks that I can hook into to reconnect, including redoing DNS resolution?
We’ve having some strange issues with Aurora. Not sure exactly what’s going on, but it looks like it’s failing over. When this happens, the primaries become read only and all our Ecto connections start raising exceptions about the database being read only.
ERROR 25006 (read_only_sql_transaction) cannot execute UPDATE in a read-only transaction
Restarting all our pods fixes the issue because we get fresh new connections.
Looking for a way to automatically handle this scenario. Currently we get alerted to all the failures, then we manually cycle out our pods.
Thanks for the help.
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Courses that'll move you from confusion to "Aha, now I get it!"
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
- #ecto-query
- #elixirconf-us
- #ai
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
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 1 to 4- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
christhekeele
It looks like module-based
Ecto.Repos only have a few callbacks. I would have expected to see something analogous to the traditionalterminate/1callback here if this were possible, but perhaps I’m looking in the wrong place?adw632
Postgrex disconnect_all might help.
Also review your setup using pgbouncer:
cjbottaro
We used RDS Proxy, but since Rails sets state on connections, it completely broke the proxy.
I’m not sure if Postgrex/Ecto sets any state on the connections that would cause that pinning. If not, then maybe we could use RDS Proxy for our Elixir apps only.
maartenvanvliet
Did you explore the options Postgrex has to handle failovers?
E.g. *
:disconnect_on_error_codes, which can me combined with multiple endpoints for dealing with failoverSee Postgrex — Postgrex v0.22.2