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 · GitH…

Only other thing I could recommend trying is: Can you start Postgrex to specify unnamed queries from Ecto?

Can you provide a sample query similar to the one executed in API.Domain.Accounts.get_user_by_phone_number/2 ?

Nothing fancy, just the usual Repo.get_by(User, phone_number: phone_number).

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 try…

Mentioned issue says that it was fixed in v0.15.5 of postgrex library. Please check if you’re using that or a higher version.

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.

Yeap, checked. It’s already using 0.15.5.

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 narrowe…

Yes, I’m using PGBouncer. I tried appending binary_parameters=yes as suggested in the article but it still throws error randomly.

Wow! This is it! Thank you so much!

Great! Glad to be of help :slightly_smiling_face:

Elixir Programming Language Forum

Can someone please shed some light on this error?

Questions & Help Questions

hazardfn July 31, 2020, 12:56pm 12

Great! Glad to be of help