DT
Drizzle Team•11mo ago
dumbboy

[Fixed] - Next.js remaining connection slots are reserved for non-replication superuser connections

I am frequently getting the above error. Database: Supabase Github: https://github.com/ShaikRehan123/questionPaperCreation I recently shifted from prisma to drizzle, help appreciated.
GitHub
GitHub - ShaikRehan123/questionPaperCreation
Contribute to ShaikRehan123/questionPaperCreation development by creating an account on GitHub.
Solution:
Did you try to restart your Supabase instance? It happened to me sometime after a deploy on fly.io (with Remix, so we can agree it's not related to a specific platform/framework)
Jump to solution
4 Replies
Solution
rphlmr ⚡
rphlmr ⚡•11mo ago
Did you try to restart your Supabase instance? It happened to me sometime after a deploy on fly.io (with Remix, so we can agree it's not related to a specific platform/framework)
rphlmr ⚡
rphlmr ⚡•11mo ago
I don't know if Nextjs required something specific when deployed on vercel/edge
dumbboy
dumbboy•11mo ago
Thanks @Raphaël Moreau , It works on restart.
dumbboy
dumbboy•11mo ago
Future Reference. If still facing this issue, check this out. https://github.com/orgs/supabase/discussions/5212#discussioncomment-2069444
GitHub
Error querying the database: db error: FATAL: remaining connection ...
We have an app hosted on Vercel with Supabase providing the database. The app is in development and I am often the only one using it but I frequently get this error: Error querying the database: db...
Want results from more Discord servers?
Add your server
More Posts
[drizzle-zod] How to make all fields of a schema derived from a table required ?I just tried the plugin and I'm happy to move from manually creating zod schemas. However, I came inIs there a way to declare a custom SQL index?I'm trying to create an index on the lowercase value of a column using Postgres. I tried ```js uniqHow should I set this up?https://gist.github.com/barrybtw/f4c54bf7bdac98af34069363d7b1be87sqlite code first with in-memory dbHey, I thought it'd be rather easy to create a schema from scratch without running a "migration" (frDrizzle-Kit: incorrect schema.ts being usedI have some schema files in a subfolder. I have referenced the path in the drizzle.config.ts, but inGroup by Multiple columns with drizzleI have a schema that looks rougly like this: ```date | location | name | quantity``` I want to gro[Fixed] is not assignable to parameter type Record<string, PgColumnBuilder>Hi, Trying to install Drizzle, using the basic example from the docs. Getting the following error: `What is the Drizzle convention for storing the `db` object?In the "Quick Start" guide, it showcases connecting to the database at the root of a module. HoweverDefault value for Array creates an incorrect SQL migrationI'm currently adding a new field `roles` to my PG table, `users`, such as: ```typescript export consBug: drizzle-kit generate:pg didn't see the changes in the schemaOn my uniqueIndex i added a where clause to not check the soft delete records. When running generate