After migrating to new database my application get crashed donot know how? Please help
my site ssdo.org.pk get crashed please help , I am running strapi at the backend
46 Replies
Project ID:
c646e44b-a2dd-41c4-94de-c0f00566da1dc646e44b-a2dd-41c4-94de-c0f00566da1d
What errors do you get in logs?
Server was not able to start properly
These are the deploy logs
It looks like it can't connect to an external server.
because of the ECONNREFUSED
Some problems with envirnomental varialbes?
Maybe, try changing the variable to what you use now if it is a variable
Which variable I try
Hm, it seems like it's a google cloud ip.
You said this is the frontend?
After migration which env variables are changed?
The database URLs
Database url means database host?
No, the url contains the host. the host is something like this: roundhouse.proxy.rlwy.net
Copy the private URL then paste it where it needs it
containers-us-west-136.railway.app , i was using this before
yea, it probably changed from the migration
go to the new service and go to variables
then find MYSQL_PRIVATE_URL
then paste it into your service
I m using postgres
Ok let me find that for that
new service means strapi
DATABASE_PRIVATE_URL
from where i copy it
from my postgres
database
in the variabled
in my strapi application I use this ${{Postgres.DATABASE_URL}} in my Database_url, there is no database_private_url in strapi
that should work, but you'll be charged for egress. can you send the full logs?
https://bookmarklets.up.railway.app/log-downloader/
deploy logs?
yea
ok
how can i send the logs
you drag the file it downloaded here
copy paste is not acceptable here
not able to send the txt file
how come?
you said this is the backend or frontend?
strapi is the used as admin for the database
basically its a headless cms
ok i'll see if i can reproduce
postgres is the database and strapi is the service using it
ok
strapi is showing the records of postgres database
and strapi is crashed after migration while migration runs successfully according to the railway dashboard
hm
yea
sounds like something might have went wrong?
thank you for helping, but please do not instruct people to copy paste database variables, that is exactly what has caused this issue in the first place, please use reference variables
i meant the variable name
not the value itself
it can be misinterpreted, please instruct direct use of the reference variables
sorry
no worries I appreciate the help
Thanks for your positive response.....I have corrected the error
no need to do anything now, site is up and running , thanks
happy to hear!