prepared statement "sqlx_s_1" already exists

[MrSpock]

Hi,

I have app running with PostgreSQL via sqlx that I can run once, next time I'm getting cryptic error like this:
Error: error returned from database: prepared statement "sqlx_s_1" already exists

When I remove this statement manually from psql cli (DEALLOCATE PREPARE sqlx_s_1) I can run app again .. once.

Can someone help me why is this happening ?

[richin13]

Found a solution from this comment: supabase/supavisor#239 (comment)

Assuming you're using a Supabase DB, switch the port number from 6543 to 5432 👍🏼

[sebCS222]

This is it! ChatGPT O1 took me in circles and made me change all my handlers 😢

[abonander]

Hence why I don't like GPT/LLMs. The current generation is incapable of saying "I don't know". No answer is better than the wrong answer.

[Peterksharma]

Confirmed it works

[DevWonder01]

December 2024 and i must say this fixed my error
I'm using a supabase DB, thanks ser

[yogithesymbian]

Found a solution from this comment: supabase/supavisor#239 (comment)

Assuming you're using a Supabase DB, switch the port number from 6543 to 5432 👍🏼

u saved my life thankyou works like a charm

use port 5432 instead of 6543 .env

DATABASE_URL=postgresql://postgres.[xxx]:[xx]@aws-xxx.pooler.supabase.com:5432/postgres

on first step its work , dunno why after deleted 1 event on supabase then re-run test i always got the error . now solved by change the port like a magic

[CommanderStorm]

Could you share a minimal example? Are you using something in between Postgres and sqlx?

[MrSpock]

I don't know if there is something between PSQL and sqlx.
I can use PostgreSQL admin tool to use the same credentials as my code and it looks like normal PostgreSQL.

This is effectively basic code using sqlx however question is rather complicated (3 selects combined with UNION for single result).
sqlx::query_as(..).

[CommanderStorm]

bisecting your code to only the minimal tooling and then posting that would be how you can get help.
This migth be a bug in sqlx, but without a reproduction, this is hard to say..