[Bug]: OTP token cannot be validated / "prepared statement 's0' does not exist" about shelf.nu

[oleggtro]

Oh sorry, so it was indeed an error on my end.
My DATABASE_URL was indeed malformed, I was missing the pgbouncer=true at the end.
Thanks!

[DonKoko]

Hey @oleggtro.
The prepeared statement issue tells me that the DB connection string is not correctly placed. You need to connect to supabase pooler in transaction mode.

As for the migrations, those use a different connection string than the app, due to how supabase and prisma work. Here is one example of an issue describing it: prisma/prisma#11643

[DonKoko]

@oleggtro yeah that basically tells supavisor to simulate the pgBouncer prepared statements. Glad its resolved.