Prisma migrate dev error

berkanbasaran05PRO

a year ago

the issue is like that; when i start project normally. it works and it connect database . there is no problem. but when i try with custom start command so its like that ; "npx prisma migrate deploy && npm start", it give bug which say it cant connect data base. how can i solve this problem. i have to migrate my prisma changes.. please help me
erorr is like that;
Prisma schema loaded from prisma/schema.prisma

Datasource "db": PostgreSQL database "railway", schema "public" at "viaduct.proxy.rlwy.net:38891"

Error: P1001: Can't reach database server at viaduct.proxy.rlwy.net:38891

Please make sure your database server is running at viaduct.proxy.rlwy.net:38891.

npm WARN config production Use --omit=dev instead.

Environment variables loaded from .env

Prisma schema loaded from prisma/schema.prisma

0 Replies

a year ago

are you committing your .env file to your repo?


berkanbasaran05PRO

a year ago

yes but i delete database_url on my env file


berkanbasaran05PRO

a year ago

should i delete whole .env file


a year ago

yes, I'm not saying that fixes your issue, but you never want to commit your .env file


berkanbasaran05PRO

a year ago

1235214625390330000


berkanbasaran05PRO

a year ago

how can i try that


a year ago

go into the database's setting and remove the tcp proxy, then add it back


berkanbasaran05PRO

a year ago

okay im trying now


berkanbasaran05PRO

a year ago

thanks a alot


berkanbasaran05PRO

a year ago

i will come back


berkanbasaran05PRO

a year ago

after i tryt


berkanbasaran05PRO

a year ago

i cant see tcp proxy


a year ago

screenshot please


berkanbasaran05PRO

a year ago

1235215399021187000


a year ago

scroll back to the top


berkanbasaran05PRO

a year ago

1235215565052842200


a year ago

it's right there under public networking, remove it then add the same 5432 port back


berkanbasaran05PRO

a year ago

1235215837447848000


a year ago

add it back


berkanbasaran05PRO

a year ago

1235217344461144000


berkanbasaran05PRO

a year ago

i got this error


berkanbasaran05PRO

a year ago

i dont understand really


berkanbasaran05PRO

a year ago

it wasnt like that


berkanbasaran05PRO

a year ago

can i connect server with ssh root @….


a year ago

have you added the tcp proxy back to the database?


berkanbasaran05PRO

a year ago

1235219428283519000
1235219428527050800


berkanbasaran05PRO

a year ago

can you connect to my project ?


berkanbasaran05PRO

a year ago

i can give my project id


a year ago

i dont work for railway, so i wouldnt have access to such things


a year ago

can you connect to the database locally from something like dbgate


berkanbasaran05PRO

a year ago

dude


berkanbasaran05PRO

a year ago

you know whats intersting. when i start project without custom start .it connect succesfully


a year ago

that is indeed odd


berkanbasaran05PRO

a year ago

but when i want to migrate project


berkanbasaran05PRO

a year ago

it give error


a year ago

can you try to add a 3 second sleep before the migration command


berkanbasaran05PRO

a year ago

for backend or for database


berkanbasaran05PRO

a year ago

1235220633567367400


a year ago

i didnt mention anything about app sleeping


berkanbasaran05PRO

a year ago

i will freak out


a year ago

okay?


berkanbasaran05PRO

a year ago

it doesnt work


a year ago

please try adding a 3 second sleep before the migration command


berkanbasaran05PRO

a year ago

should i delete and restart project?


a year ago

no


berkanbasaran05PRO

a year ago

bro im so sorry i feel like stupid but i have to ask you how can ii add


a year ago

whats your current start command and where is it set


berkanbasaran05PRO

a year ago

1235221729966821400


a year ago

send the start command here please


berkanbasaran05PRO

a year ago

i alread do it


a year ago

in text


berkanbasaran05PRO

a year ago

npx prisma migrate dev && npm start


a year ago

why send an id?


berkanbasaran05PRO

a year ago

sorry


berkanbasaran05PRO

a year ago

accidenlty


a year ago

sleep 3 && npx prisma migrate dev && npm start


berkanbasaran05PRO

a year ago

im doing now bro


berkanbasaran05PRO

a year ago

1235225151633625300


berkanbasaran05PRO

a year ago

bro can i connect this server with ssh root


berkanbasaran05PRO

a year ago

?


berkanbasaran05PRO

a year ago

i have to connect


a year ago

you are no longer getting connection errors


berkanbasaran05PRO

a year ago

is there method like that


a year ago

there is not, why is that needed though?


berkanbasaran05PRO

a year ago

bro i solved that thanks a lot


a year ago

awsome!