Hey @pierremdl. You mentioned adding the environment variables to the .env file, but that wouldn't normally be uploaded to your remote repo. Did you add the environment variables for production to the Project Settings?

https://vercel.com/docs/projects/environment-variables

Hi @amyegan My local .env file is not committed nor is uploaded during deployment to vercel. Instead, it is my understanding that by "connecting a project" the database's necessary environment variables are made accessible to the project automatically:

From the Neon database Dashboard in Storage:

From the project's environment variables menu in Settings:

Then the @vercel/postgres SDK would take care of getting the corresponding environment variable it needs. This is what I understand from the documentation.

I misread your original post. Yes, the environment variables are automatically managed when you connect a project with Vercel Postgres. That wouldn't be the problem.

The UND_ERR_CONNECT_TIMEOUT means the connection is timing out. It sometimes happens with missing credentials, which is why I originally suggested that, but it could also be caused by limited serverless function max duration.

If the fetch is requesting a large amount of data, it could take too long and time out. You can try to extended using the maxDuration config or change the request so it returns a smaller chunk of data.

Please give that a try and let me know if it works for you

I am not getting any data back from the database at all, it is a purely log-this-and-basta write to database. I'm on the Hobby plan, from your link to documentation it looks like that plan's default serverless function max duration is 10s, which are not reached before that error happens. Upgrading the settings to the "max max duration" for that plan which is 60s doesn't do anything.

If we're considering a credentials problem, I'm wondering why in about 10% of the cases the action does result in a write to database?

As a side note (I don't think it relates to the problem but I might be wrong), I noticed that the POSTGRES_URL environment variable in the Neon storage dashboard specifies the port number while the same environment variable in the project settings doesn't have it. It doesn't seem to be a bug or at least it doesn't seem to matter since I can use the url with or without that port number locally.

Thanks for trying the max duration configuration. We've ruled out a credential problem since the Postgres connection is managing that for you and some writes are successful. It sounds like a timing issue or unhandled error in this case.

I recommend using try/catch statements to handle errors and collect more info about what's going wrong. Runtime logs can also be helpful with this.

So here is a new version of the code that writes to DB (adapted from @vercel/postgres github's docs):

1import { sql, createPool, createClient } from '@vercel/postgres';23export async function addLocation(sessionId: string, lat: number, long: number, isGpsLocation: boolean, message: string | undefined, tagNumber: number | undefined): Promise<void> {4    // Instead of this5    // sql`INSERT INTO entries (session_id, is_gps, latitude, longitude, message, tag_number) VALUES (${sessionId}, ${isGpsLocation}, ${lat}, ${long}, ${message}, ${tagNumber})`;6    console.log('start addLocation');7    const client = await sql.connect();8    console.log('connected the client')9    const { rows } = await client.sql`INSERT INTO entries (session_id, is_gps, latitude, longitude, message, tag_number) VALUES (${sessionId}, ${isGpsLocation}, ${lat}, ${long}, ${message}, ${tagNumber})`;10    console.log('contacted the db and got a response')11    console.table(rows);12    client.release();13    console.log('released client');14}

Going several times in a row on the website, that function is called and:

• First a few times all the steps are successful, the database is indeed hit and all logs are made;
• Then suddenly the function seems to never resolve after the client connection, sometimes with an error (server crash), sometimes without (website displays, no database hit).

Uncaught Exception: Error: Connection terminated unexpectedly at cn. (file:///var/task/node_modules/@neondatabase/serverless/index.mjs:1250:44) at Object.onceWrapper (file:///var/task/node_modules/@neondatabase/serverless/index.mjs:410:15) at cn.emit (file:///var/task/node_modules/@neondatabase/serverless/index.mjs:397:12) at E. (file:///var/task/node_modules/@neondatabase/serverless/index.mjs:1202:66) at E.emit (file:///var/task/node_modules/@neondatabase/serverless/index.mjs:397:12) at WebSocket. (file:///var/task/node_modules/@neondatabase/serverless/index.mjs:989:51) at callListener (/var/task/node_modules/ws/lib/event-target.js:290:14) at WebSocket.onClose (/var/task/node_modules/ws/lib/event-target.js:220:9) at WebSocket.emit (node:events:519:28) at WebSocket.emitClose (/var/task/node_modules/ws/lib/websocket.js:272:10) Node.js process exited with exit status: 129. The logs above can help with debugging the issue.

I'm thinking could it be a sort of throttle thing from Neon? But in that case that would be a pretty strict one...

It looks like you've tried a few different approaches in the file and have some stray imports. I'm wondering if you get a different result using another method. There are a few different options in the SDK Reference. What happens if you do something like this:

1import { sql } from '@vercel/postgres';23export async function addLocation(sessionId: string, lat: number, long: number, isGpsLocation: boolean, message: string | undefined, tagNumber: number | undefined): Promise<void> {4  try {5    console.log('attempting to connect to database...')6    await sql`INSERT INTO entries (session_id, is_gps, latitude, longitude, message, tag_number) VALUES (${sessionId}, ${isGpsLocation}, ${lat}, ${long}, ${message}, ${tagNumber})`;7    console.log('done')8  } catch (error) {9    console.error(error);10  }11}

or this:

1import { db } from '@vercel/postgres';23export async function addLocation(sessionId: string, lat: number, long: number, isGpsLocation: boolean, message: string | undefined, tagNumber: number | undefined): Promise<void> {4  try {5    console.log('attempting to connect to database...')6    const client = await db.connect();7    await client.sql`INSERT INTO entries (session_id, is_gps, latitude, longitude, message, tag_number) VALUES (${sessionId}, ${isGpsLocation}, ${lat}, ${long}, ${message}, ${tagNumber})`;8    console.log('done')9  } catch (error) {10    console.error(error);11  }12}