Neon

The official Neon Database Discord

Join

Neon

The official Neon Database Discord

Join

🙏｜feedback

❓｜questions-and-answers

🐘｜postgres

genetic-orange

2/13/2024

Long Cold-Start Times on US East 2

I'm seeing some very long cold start times on my free-tier instance (project id: weathered-voice-16568128). Performance is great after the first read, but that read can take 13s (as measured by the Neon Console operations time). I'm using the free-tier now leading up to the launch of a product I'm working on. Before the launch, I plan to upgrade to the Launch tier. As described here, I don't see any mention of scaling control or cold-start priority. I wanted to write this in case there's something worth looking into. I also have two questions:...

deep-jade

2/12/2024

How do I turn off new branch being created for each non-main deployments on Vercel?

Currently each feature branch deployment is spinning up an empty DB and causing errors.

wise-white

2/10/2024

Laravel migrations are failing

Preface: Testing Vercel for Laravel deployments. Created a PostgreSQL database through Vercel UI. Deployment of Laravel app is successful, a test endpoint without any DB connection works and responds as expected. I have added php artisan migrate to composer.json's scripts section. It runs after deps are installed. The first SQL command (creating the first table) goes through, the second one fails with the following error:...

magic-amber

2/10/2024

No space left on device

Hello! We are seeing this exception in our production environment: "could not resize shared memory segment "/PostgreSQL.154498794" to 4194304 bytes: No space left on device". We are confused that it refers to "device space" and are wondering in what kind of situation the Neon DB can run out of device space. Is this "expected"? It started to happen suddenly without much change to our queries or data. We have also scaled up the cluster from 4 CU to 7CU with no difference....

absent-sapphire

2/10/2024

Getting the error in Jupyter Notebook "name 'run_sql' is not defined"

Hello Team, I am using Neod Free Tier DB hosted on web and trying to connect my pythin code via localJupyter Notebook to this DB. I get this error, while running the code. Please help me that what am I doing wrong? NameError: name 'run_sql' is not defined...

manual-pink

2/10/2024

Local Deployment Error when starting endpoint node.

I want to try neon on my local machine and followed the instructions for macOS on https://github.com/neondatabase/neon. The process worked until i want to start the endpoint node. I get this error: cargo neon endpoint start main...

stormy-gold

2/9/2024

Fetch failed when using serverless driver running many function instances

I’m receiving ‘fetch failed’ for some of my functions using drizzle in a GCP cloud function. We’re running a batch process that runs up to about 300 instances and some of them end up with ‘fetch failed’ error. I’m using drizzle with the pooled connection, connecting exactly how the documentation says. I don’t understand why we are getting this error. We’re on the pro plan and I’ve enabled autoscaling up to 1 cpu which, according to the docs should allow me to have more than enough connections....

ambitious-aqua

2/9/2024

Do you provide credits for startups?

Abhishe this side, Co-founder & tech lead EddyFinance I wanted to use Neon db for our smart contract events Do you guys provide startup credits for the same? Let me know if you want to create a dedicated group on telegram with us:...

exotic-emerald

2/9/2024

ConnectorError prepared statement \"s0\" does not exist

So I am getting this error manifesting, but in a weird way that seems counter to everything I could find on it. Basically I am accessing this database using prisma from a different application in a monorepo that is not hosted on vercel. I have the following settings on the URL ?sslmode=require&pgbouncer=true&connect_timeout=15&statement_cache_size=0&schema=public and I have a non pooling url configured for direct connection....

eastern-cyan

2/8/2024

consuming input failed: server login has been failing, try again later (server_login_retry)

We have been seeing uptick in these errors past couple days, is this a known issue?

stormy-gold

2/7/2024

can't deploy autoscaling in a local k8s cluster

Hi, I am not sure if I should post this message here. I see some issues when practicing autoscaling using v0.24.0. The attached file contains all the steps I did and there is an error, "cgroup change of group failed" at some points. Thank you!

autoscaling-cgroup-e...

rare-sapphire

2/7/2024

Neon + Vercel Integration missmatch in the environment variables

I have the integration of neon and vercel in my NextJS project, everything was working fine until a couple of days ago that we started to see that the PG_HOST and DATABASE_URL do not match in the environment variables that neon sets in vercel. Next steps: - I push my branch to github - it creates me a neon branch for my database ...

afraid-scarlet

2/7/2024

DATABASE_URL conflict between Vercel and Neon?

Hi everyone. I am setting up Neon with github actions for a project using the tutorial provided here: https://neon.tech/blog/branching-with-preview-environments#:~:text=When%20you%20open%20the%20deploy%2Dproduction.yml%20file%2C%20you%20will%20see%20the%20following%3A It looks like it's working fine : when I generate + migrate the prisma schema, I can see the tables being created in Neon. However, when using the app, it seems that the DATABASE_URL that it points to is still the one indicated in the vercel environment variables. Therefore, my tables remain desperately empty. Note: I am not (yet?) using the Neon integration in vercel....

sensitive-blue

2/7/2024

Looking for Prisma + Vercel production guide

Hey people! I am exploring neon for my next project and wanted to make things right from the very start. I plan to use Prisma + Neon hosted on Vercel. Is there any good guide that would show me how to set it up, mainly migration-wise. I see a lot of good guides in terms of just setting up the connections, pg-bouncer, and stuff but kinda missing the step-by-step guide on how to properly evolve the schema & database on production. I assume I would create new neon branches for PRs, then migrate there, and then somehow reconcile the neon feature branch into the prod branch when merging the feature. ...

metropolitan-bronze

2/7/2024

Vercel syd1 instance not coming online

I created a syd1 deployment of Vercel Postgres Storage. This configuration seems to now work with Vercel at the moment. The "Status" state seems to just be in limbo. I've tried a couple more times to no avail....

unwilling-turquoise

2/6/2024

Guide on how to apply migrations (Nextjs/ @neondatabase/serverless)

Recently decided to try Neon for my portfolio V2 api. I'm working with Nextjs 14, drizzle and Neon. I'm having difficulties applyinig migrations to Neon locally. Here is my migrate file ```javascript import { neonConfig } from "@neondatabase/serverless";...

conscious-sapphire

2/6/2024

neonctl auth never completes

Hi, just installed neonctl and then I run neonctl auth. Browser opens, I click log with email and I am redirected to the projects page. However the cli tool never completes the login but hangs around waiting forever...

eastern-cyan

2/6/2024

Socket Hangup when connecting to Neon from node (Drizzle ORM)

Hello, I recently switched to Neon - I'm building a serverless Remix app using Drizzle as an ORM. I'm able to use neon successfully, but my coworker is unable to connect due to a socket hangup issue. Has anyone else ran into this issue?

{"message":"Error connecting to database: request to https://db-url-pooler.us-east-2.aws.neon.tech/sql failed, reason: socket hang up"}

{"message":"Error connecting to database: request to https://db-url-pooler.us-east-2.aws.neon.tech/sql failed, reason: socket hang up"}

...

continuing-cyan

2/6/2024

Use of TCP in Neon

Hello! I am looking to deploy Neon to run some networking benchmarks. Based on what I've read in documentation/GitHub, it seems like Neon uses TCP between the disaggregated compute and storage, as well within the storage (between pageservers, safekeepers, and object storage). Am I correct that I can deploy Neon using just TCP?

constant-blue

2/5/2024

Pooled connection TS error with PrismaNeon

I'm using the Neon Serverless driver with Prisma, but have a TS issue I'm not sure how to address. I tried extending the object type to add a "flavour" but that failed. I'm following this documentation:

https://neon.tech/docs/guides/prisma#use-the-neon-serverless-driver-with-prisma

https://neon.tech/docs/guides/prisma#use-the-neon-serverless-driver-with-prisma

...

Previous Next

Gaming

Programming

Neon

The official Neon Database Discord

Neon

The official Neon Database Discord