sammkj
As far as I’ve observed, I don’t notice any consistent pattern when this gets thrown. Seems the error gets thrown randomly. I tried searching on Google and found this Got Postgrex.Error prepared statement "ecto_insert_posts" does not exist in ecto_sql tests · Issue #160 · elixir-ecto/ecto_sql · GitHub. But the Github issue doesn’t seem related though. Can someone please show some guidance?
** (exit) an exception was raised:
** (Postgrex.Error) ERROR 26000 (invalid_sql_statement_name) prepared statement "ecto_419" does not exist
(ecto_sql) lib/ecto/adapters/sql.ex:593: Ecto.Adapters.SQL.raise_sql_call_error/1
(ecto_sql) lib/ecto/adapters/sql.ex:526: Ecto.Adapters.SQL.execute/5
(ecto) lib/ecto/repo/queryable.ex:192: Ecto.Repo.Queryable.execute/4
(ecto) lib/ecto/repo/queryable.ex:17: Ecto.Repo.Queryable.all/3
(ecto) lib/ecto/repo/queryable.ex:112: Ecto.Repo.Queryable.one/3
(api) lib/api/domain/accounts/accounts.ex:337: API.Domain.Accounts.get_user_by_phone_number/2
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Bringing learning, work and compliance together since 1987.
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
- #metaprogramming
- #hex
- #security
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Bringing learning, work and compliance together since 1987.
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 10- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
speeddragon
Can you provide a sample query similar to the one executed in
API.Domain.Accounts.get_user_by_phone_number/2?sammkj
Nothing fancy, just the usual
Repo.get_by(User, phone_number: phone_number).speeddragon
This might be tricky to diagnose. Can you provide more detail like Postgres version? If this happened in other projects before? If you tried to change the Postgres version and check?
I’m not super familiar with Ecto and Postgres, but looks like Ecto created a prepared statement, and when it was trying to execute that with the parameters provided that didn’t exist. For some reason, Ecto of Postgres might be clearing prepared statements.
vfsoraki
Mentioned issue says that it was fixed in
v0.15.5ofpostgrexlibrary. Please check if you’re using that or a higher version.sammkj
I’m using Postgres 12. I suspect the error might be coming from Sage sage | Hex . The above query is wrapped inside a Sage transaction.
sammkj
Yeap, checked. It’s already using
0.15.5.hazardfn
Are you by any chance using something like PGBouncer?
PgBouncer and prepared statements | Yet Another Dev Blog see “prepared statements issue”. If you’re having issues and not using PGBouncer you can maybe still try the binary parameters fix the blog post recommends and at least then you’ve narrowed down your issue if it works.
sammkj
Yes, I’m using PGBouncer.
I tried appending
binary_parameters=yesas suggested in the article but it still throws error randomly.hazardfn
Only other thing I could recommend trying is: Can you start Postgrex to specify unnamed queries from Ecto?
sammkj
Wow! This is it! Thank you so much!