Prisma can't connect to database on new deploy, no change in code
stefanflorea00
PROOP

a year ago

When we deploy again, without changing code, on the deployed service, it can't connect to prisma anymore.

Running locally from the same code and dockerfile, there is no issue


Error: P1001: Can't reach database server at `postgres.railway.internal:5432`

Please make sure your database server is running at `postgres.railway.internal:5432`.```

Using public connection for DB doesn't change.

Dockerfile:

Use a specific version of the Node.js base image

FROM node:18-slim as builder

Install openssl

RUN apt-get update && apt-get install -y openssl

Create app directory

WORKDIR /usr/src/app

RUN ln -s /usr/lib/libssl.so.3 /lib/libssl.so.3

Copy package.json and package-lock.json

COPY package*.json ./

Install production dependencies only

RUN npm install

Copy the rest of the application code

COPY . .

RUN npm run build

Generate Prisma client

RUN npx prisma generate

--- Production image ---

FROM node:18-slim

Install openssl

RUN apt-get update && apt-get install -y openssl

Create app directory

WORKDIR /usr/src/app

RUN ln -s /usr/lib/libssl.so.3 /lib/libssl.so.3

Copy only the necessary files from the builder stage

COPY --from=builder /usr/src/app /usr/src/app

ENV NODE_ENV=production

Run Prisma migrations before starting the application

CMD ["sh", "-c", "npx prisma migrate deploy && node dist/index.js"]

Previously used alpine, changed to node:18-slim,
Worked for a few days, deployed (without changing anything related), and the issue started happening again.
Also used debian:bullseye instead, still not working
Rolling back to previous deploy works

Could anyone help?

Related to previous thread: https://help.railway.com/questions/prisma-suddenly-crashes-on-today-s-deplo-1d3c525f
Project ID: `6bd43efc-3425-4163-bbce-f4a714622bd9`
Solved

5 Replies

stefanflorea00
PROOP

a year ago

My bad, switching runtime from legacy to v2 fixed it

1318913545420673148


stefanflorea00
PROOP

a year ago

!s


stefanflorea00
PROOP

a year ago

Solved


a year ago

Awesome, glad you got it working

For context, legacy builder doesn't support private network during build


a year ago

!s


Status changed to Solved dev over 1 year ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...