Cannot close prepared statement

I'm not using CLOSE statement on my query

AJR•11/20/24, 3:43 PM

Can you share or DM some example queries that you're using, and your Hyperdrive ID?

AAJR Can you share or DM some example queries that you're using, and your Hyperdrive ...

Agung VivekanandaOP•11/20/24, 3:45 PM

I already DM you

Agung VivekanandaOP•11/20/24, 4:02 PM

Is the cause of problem because i don't put c.executionCtx.waitUntil(sql.end()) after execute the query?

AJR•11/20/24, 4:12 PM

No, that should not cause this specific issue.

AJR•11/20/24, 4:12 PM

Prepared statements are per-connection. It's trying to close a statement that the connection does not have.

AJR•11/20/24, 4:12 PM

Ohhhh. You're using supabase's pooler, I bet

AJR•11/20/24, 4:13 PM

Stacking multiple connection poolers can cause issues exactly like this. We recommend connecting Hyperdrive directly to your database.

Agung VivekanandaOP•11/20/24, 4:24 PM

You are right, i use connection poolers. Currently supabase only support IPV6 for direct connection

Agung VivekanandaOP•11/20/24, 4:24 PM

is Cloudflare Hyperdrive support IPV6?

AAgung Vivekananda is Cloudflare Hyperdrive support IPV6?

Matt Silverlock•11/20/24, 5:00 PM

Yes - you can try it directly

thomasgauvin•11/20/24, 7:06 PM

@Agung Vivekananda to add on to Matt's response, Hyperdrive will be able to connect to supabase's database directly (without the supabase connection pooler).

If you attempt to develop locally with your supabase database with npx wrangler devnpx wrangler dev, you may encounter errors in case your ISP does not support IPV6. If that is the case, consider using the npx wrangler dev --remotenpx wrangler dev --remote option.

Agung VivekanandaOP•11/20/24, 7:25 PM

Ahh okay thank you very much for your suggestion, i will use direct connection from now, hope this problem will gone

Cannot close prepared statement

Similar Threads

Similar Threads

Similar Threads