[BUG]: after running a while, insert postgres db return: CONNECT_TIMEOUT

[guotie]

What version of drizzle-orm are you using?

0.29.0

What version of drizzle-kit are you using?

0.20.6

Describe the Bug

After run a while, insert postsql db return:

error: write CONNECT_TIMEOUT 127.0.0.1:5432
 code: "CONNECT_TIMEOUT"

Expected behavior

No response

Environment & setup

No response

[guotie]

24 |     }, options.path ? {} : { port: port }
25 |   )
26 |   Error.captureStackTrace(error, connection)
27 |   return error
28 | }
29 | 
             ^
error: write CONNECT_TIMEOUT 127.0.0.1:5432
 code: "CONNECT_TIMEOUT"

      at connection (/node_modules/postgres/src/errors.js:29:9)
      at connectTimedOut (/node_modules/postgres/src/connection.js:626:5)
      at done (/node_modules/postgres/src/connection.js:1035:12)

[guotie]

I think this problem is the same with this:

porsager/postgres#738

And I use bun too.

[AndriiSherman]

It's postgres.js driver bug, but I can leave this issue for any references

[calebbehayilu]

@guotie did find any solution?

[guotie]

porsager/postgres#738

the latest postgres driver seems solved.

[gregory-krieger]

Well, for me it wasn't solved, so I replaced this :

import "dotenv/config";

import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";
import * as schema from "./schema";

const connectionString = process.env.DATABASE_URL;

// Disable prefetch as it is not supported for "Transaction" pool mode
export const client = postgres(connectionString!, {
  prepare: false,
  ssl: false,
});
export const db = drizzle(client, { schema });

with this :

import "dotenv/config";
import { PostgresJsDatabase, drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";
import * as schema from "./schema";

const connectionString = process.env.DATABASE_URL;

const drizzleClient = drizzle(
  postgres(connectionString!, {
    prepare: false,
  }),
  { schema },
);

declare global {
  var database: PostgresJsDatabase<typeof schema> | undefined;
}

export const db = global.database || drizzleClient;
if (process.env.NODE_ENV !== "production") global.database = db;