Getting Connection closed. randomly
We have been using Vercel/Next.js/Prisma for a bit and in one specific spot we have
prisma.salesOrder.findMany() including a bunch of other tables (not ideal I know).
When we use order by in this operation, we get "Connection closed.". Things I have done so far:
- Changing the connection string from connect_timeout=15&connection_limit=20&pool_timeout=60 to connect_timeout=60&connection_limit=30&pool_timeout=0...How to have both RLS via JWT and interactive transactions?
I'm working on a codebase where the db connection is using @neon/serverless and Pool, which makes interactive transactions with rollbacks possible. Recently we've started looking into having RLS as well. Following the guide for Neon Authorize, it seems we need to use @neon/http as a driver and pass the JWT token as an
authToken while initializing the database. But then we'll get No transactions support in neon-http driver.
So I am just a little confused on whether we can have both RLS and interactive transactions. One thing I've tried is just passing the JWT token as a local session variable inside each transactions, which allowed the RLS policies to work while keeping our existing interactive transaction. But I am wondering if there's a better way to do it than that
TIA...Question about data recovery
Hi there,
I recently lost some very important files on my Free Plan account due to an accidental deletion that occurred over 24 hours ago.
I know the free plan only keeps 24 hours of history. If I upgrade to a paid plan now, would I be able to go back further in time and recover my old files?...
Control plane request failed
Hello, I am noticing that our nightly import of orders from other platforms keeps on failing with "Control plane request failed". We have
node-cron running at UTC 00:00
```
{
"code":"XX000",...
quota
My free-plan project was automatically suspended for exceeding the 5 GB egress limit. Could you temporarily re-enable the compute for ~30 minutes? I just need enough time to run a compressed backup (pg_dump -Fc -Z9),
Thanks a lot for your help!...
When is Supabase Auth-like SMS/email OTP delivery coming to Neon Auth?
Hi Team, wondering if there are any plans to add OTP delivery to the in-beta Neon Auth? I'll be considering migrating to Supabase Auth, if not- hence the question.
Need help in connecting and referencing table in `neon_auth` schema
Recently started using stack auth with neon. The data for users is coming in
users_sync under neon_auth schema. I am having a problem while connecting to this schema. My Drizzle config defaults to public schema and creates a new table named users_sync.
Here is my table structure in Drizzle,
```
import {
pgTable,...I am trying to reach the sales team for a couple days but there is no response
I am trying to reach the sales team for a couple days but there is no response. I raised a ticket through the website 5 days back and there is no response yet. I scheduled a meeting today and i joined and was waiting for more than an hour and the host hasn't joined yet
Neon branches for custom vercel environments
Hi All, there was a similar question asked about a year ago here (https://discord.com/channels/1176467419317940276/1249785408959807529), but I didn't see a clear answer to the question. Basically we have nearly the same workflow as the OP of the post linked above. We use preview deployments for PRs, but our default/trunk branch is called 'staging' and we merge our PRs into that, which triggers a deploy to our custom vercel staging environment. Then when we want to deploy to production, we creat...
Payment Support team not responding for days
The autopay failed so i tried contacting support for invoice, they haven't responded for over 7 days.
Vercel < > Neon Integration for Branching on Preview Deploys not working (possible bug)
I've been following the official Neon docs to setup the Vercel <> Neon integration, but I'm in a weird state where I am successfully using Neon as my DB in my NextJS app, but I can't setup the preview deploys to automatically create a new db branch.
In the integration section on Neon, I see "Manage Neon Subscription" under the vercel integration (see screenshot)
But clicking it takes me to Neon settings, which don't have the same options that @mahmoud 's videos show for setting up the integration. It's just taking me to the billing page. Any ideas where to go from here?...
Timed out trying to acquire a postgres advisory lock
I get this for 4/5 deploys, even when I'm not running a migration. Why is this???
...
Context: Timed out trying to acquire a postgres advisory lock (SELECT pg_advisory_lock(72707369)). Elapsed: 10000ms. See https://pris.ly/d/migrate-advisory-locking for details.
Context: Timed out trying to acquire a postgres advisory lock (SELECT pg_advisory_lock(72707369)). Elapsed: 10000ms. See https://pris.ly/d/migrate-advisory-locking for details.
Laravel Migration to Neon Error
When I try to migrate my laravel database to Neon's server, I keep getting this error:
for context:...
SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: alter table "provinces" add constraint "provinces_country_id_foreign" foreign key ("country_id") references "countries" ("id") on delete cascade)
SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: alter table "provinces" add constraint "provinces_country_id_foreign" foreign key ("country_id") references "countries" ("id") on delete cascade)
Neon through neon.com vs vercel
Hi all,
I was wondering if there was any difference between subscribing to neon through neon.com or using vercel to subscribe.
Thank,
Greg...
all logs show success but db on neon does not update.
i. am. so. done. with. this.
I have a db which has a table called
users, when i login with clerk, it makes a user. after login, the website takes the user to /onboarding where the user has to enter additional information like phone number, postcode and "about me." on submit, the db should be updated with the new details, for the same user, on the same users table. but it is not happening.
I have taken logs from the frontend and the backend with all returning status 200 with all the right details in json format. the db connection is working as well, checked with a simple GET API route and by running pnpm prisma studio. The status 200 logs: ...NeonDbError: Error connecting to database: Failed to fetch
thsi is the error id : adab2f74a00a4eaa8a328b47cbc5a743
Is the database down currently??
Error connecting to database: Failed to fetch
NeonDbError: Error connecting to database: Failed to fetch...
Cannot read file '/node_modules/.pnpm/@neondatabase+api-client@2.1.0/node_modules/tsconfig.base.json
I'm getting the above typescript error