Can't connect to supabase db using transaction mode

[Andres]

ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: “42P05”, message: “prepared statement "s1" already exists”, severity: “ERROR”, detail: None, column: None, hint: None }), transient: false })

I’m trying to connect to a supabase database in transaction mode with port 6543 but I’m getting that error…

I don’t know if I have to add any special option to fly to work with this?

fly.toml file generated for sharely-develop on 2023-08-23T17:34:02-05:00

app = “sharely-develop”
kill_signal = “SIGINT”
kill_timeout = 5
processes =

[env]
PORT = “8080”

[[services]]
internal_port = 8080
processes = [“app”]
protocol = “tcp”
[services.concurrency]
hard_limit = 25
soft_limit = 20
type = “connections”

[[services.ports]]
force_https = true
handlers = [“http”]
port = 80

[[services.ports]]
handlers = [“tls”, “http”]
port = 443

[ktosiek]

The error mentions prepared statements. Prepared statements are created per connection, not per transaction: you’ll need to disable them in your app to use transaction mode pooling.

References:

• Supabase docs for Transaction mode: Connecting to your database | Supabase Docs
  “Transaction mode does not support prepared statements. To avoid errors, turn off prepared statements for your specific connection library.”
• PostgreSQL docs for “PREPARE”: PostgreSQL: Documentation: 17: PREPARE
  “Prepared statements only last for the duration of the current database session.”