Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

xenial-black
xenial-black1/25/2024

can’t use pooling url in prisma

while making use of the pooling flag for my database url, i get errors trying to run queries from prisma using $queryRaw “prepared statement “s0” already exists” sometimes the number is different though like s3, s4 etc. ...
eastern-cyan
eastern-cyan1/24/2024

CONNECT_TIMEOUT Issue

Hello all, had an issue with a sporadic CONNECT_TIMEOUT across many services connecting to the same DB for about a 5min span a few nights ago. This seems to have happened again for less than a minute last night. Wanted to see if there's any way to debug this kind of issue? My DB doesn't auto-sleep, and there's no indication anywhere on my dashboard that there was an outage. Oh, also I'm using the provided pooler/pgbouncer URL. I have multiple services running in various locations that all had their DB connections timeout at the same time-- this is what gives me confidence that the issue was with Neon....
genetic-orange
genetic-orange1/24/2024

NeonDbError: prepared statement "s4908" already exists

Getting the following error: NeonDbError: prepared statement "s4908" already exists And now also: NeonDbError: prepared statement "s5046" does not exist Not sure what could cause this, as I am not using prepared statements. If it matters, I'm using Drizzle, and this is how I instantiate the db...
eastern-cyan
eastern-cyan1/23/2024

Preview Branch auto-starting

Hi friends. I have a preview database branch auto made from Vercel integration. The problem is that branch auto-starts every 10 minutes using all of my active time. How can I disable this? There is no cron jobs, the test branching os auto-starting even when the main branch is off....
No description
optimistic-gold
optimistic-gold1/23/2024

DB loads insanely slow

Hello, we’re using wundergraph + neon and noticing load times of up to 7 seconds for a simple query. We are on the free plan as we’re testing things out but is it really supposed to be this slow?
No description
unwilling-turquoise
unwilling-turquoise1/22/2024

NeonDbError: Console request failed with 422 Unprocessable Entity: active endpoints limit exceeded

Intermittently getting the following error messages in my logs for my production application: NeonDbError: Console request failed with 422 Unprocessable Entity: active endpoints limit exceeded Not sure why this is happening and how I can prevent it from happening....
continuing-cyan
continuing-cyan1/22/2024

Uploading large files takes too long

I'm trying to upload a 500kb file to the neon db, but it takes around 27s. My colleague's upload speed is almost instantaneously. Could this be a latency issue? Any clues on how to solve the problem would be much appreciated! ```bash...
other-emerald
other-emerald1/21/2024

Neon pricing

Hi guys this might be a bit dumb questions but i didn't understand with neon pricing. i also compared neon with planetscale, cloudflare d1, turso etc they explicitly tell me how much the price per gb per month meanwhile in neon i cannot find it. ...
typical-coral
typical-coral1/20/2024

Crystal Lang DB Connection Issues

Hey, there! I'm trying to move my production applications written in Crystal (using the Lucky web framework) from Render to Neon. Got everything migrated from a data perspective, but when I went to actually change the DB connection string I got a weird error:...
fair-rose
fair-rose1/19/2024

permission denied

when i run a ALTER SYSTEM COMMAND , i get ERROR: permission denied to set parameter "wal_level" (SQLSTATE 42501) , i'm a neon superuser , so why could this be happening , or i don't have permission to run a ALTER SYSTEM command in neon db ?
wee-brown
wee-brown1/17/2024

Migrating to Neon using PgLoader

Im trying to use pgloader to migrate from aurora serverless mysql to Neon :neon: ? Im basically running something like ``` pgloader mysql://mysql_username:password@mysql_serverip/source_database_name postgresql://postgresql_role_name:password@postgresql_server_ip/target_database_name...
harsh-harlequin
harsh-harlequin1/16/2024

neon reporting database disk is full

I have only written 4GB of data to the database and now it's reporting that the disc is full I have upgraded to the pro plan I should be able to write a lot more data
old-apricot
old-apricot1/16/2024

Connecting to Neon from Skyvia.com

I'm trying to connect to Neon from Skyvia.com, which is an integration tool. I don't know how to fill in the SSL section on Skyvia. Where do I get the SSL CA Cert, SSL Cert and SSL Key details? The Neon help page suggests getting the cert from my own company, but that doesn't make sense to me? https://neon.tech/docs/connect/connect-securely...
No description
unwilling-turquoise
unwilling-turquoise1/14/2024

Help: How to connect laravel project to database ?

I have this error in my console when migrating tables. this is my laravel setup Sorry for my english, thank you...
No description
xenial-black
xenial-black1/13/2024

Connection to Zapier not working

I followed all the steps and even added the endpoint to the password field but I'm getting this error message: authentication failed: Could not connect with retool and provided password. The response we got from the server is included below for debugging purposes. (psycopg2.OperationalError) ERROR: password authentication failed for user 'retool' ERROR: connection is insecure (try using sslmode=require) (Background on this error at: https://sqlalche.me/e/14/e3q8)...
stormy-gold
stormy-gold1/11/2024

INSERT Statement Truncation?

What: When making larger text column insertions into the DB (using Kysely, the neon serverless driver, and kysely-neon dialect) I get errors that seem to be the result of my SQL statements being truncated. Why: I am storing document embeddings for an LLM application. How: I am using the Langchain Document model in conjunction with the Unstructured.io to clean and partition my document texts into a number of rows representing the full contents of a given document (PDF, docx, etc). The inserted rows consist of strings of text (possibly in the form of HTML tables), vector embeddings, and optional metadata. I am inserting these rows within a transaction using Kysely and the other technologies mentioned earlier....
exotic-emerald
exotic-emerald1/10/2024

Organization

Is there anything that exists, or that is planned, to be able to manage "Organisations" on Neon? So that several people can manage a db in production?...
passive-yellow
passive-yellow1/10/2024

Why is my connection refused when I try to connect to my DB from my website?

I have a website running react hosted on hostgater which contains a PHP that is simply trying to connect to my DB on neon and return a single line of data from the DB but I get this error: "<b>Warning</b>: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused". When I checked my neon dashboard, I can see the connection attempted to be started but was suspended. This is weird because when I run aamps and use the same PHP script I am able to connect with no problems. Is there a config script somewhere that I am missing?...
fair-rose
fair-rose1/8/2024

Remix integration issue

I integrated the postgres npm in my Remix project and used the sample code given on the Remix guide page. Everything is same as instructed on the guide but I get an error when I run the project: [server] TypeError: Unsupported scheme "cloudflare" for module "cloudflare:sockets". Supported schemes: [ "data", "blob", "file",...
sunny-green
sunny-green1/8/2024

Serverless Driver for Java

Hey! Has their been any plan to implement the Neon Serverless Driver for Java? Creating a AWS Lambda Java Function and the normal JDBC connection takes 2 seconds for a mere initial connection. Looking for a way to get this down...