R

Railway

βœ‹ο½œhelp

Join Server

cannot restart my database please help

Ddrewlonious5/12/2023
I cant restart my database.. says
"Plugin Stopped

Plugin was stopped due to exeeding usage limits. Click the button below to start the plugin again!"

and when clicking to restart the plugin

"Error starting plugin. Problem processing request"
Ddrewlonious5/12/2023
2087cf6c-e961-4d84-9695-a5fbf6706848
Bbrody5/12/2023
have you upgraded to the dev plan yet?
Ddrewlonious5/12/2023
yes indeed
Bbrody5/12/2023
discord does not show you as having the dev account role
Ddrewlonious5/12/2023
Ddrewlonious5/12/2023
this is correct?
Bbrody5/12/2023
yep
Bbrody5/12/2023
okay i will flag this thread for team review
Ddrewlonious5/12/2023
thank you. my data should still be there correct?
Ddrewlonious5/12/2023
I dont mind paying to restart
Bbrody5/12/2023
correct
Bbrody5/12/2023
upgrade to dev plan is all that is needed, there seems to just be a little hiccup, the team will get you sorted when they have time, dont worry
Ddrewlonious5/12/2023
ty
Rrc5/12/2023
Heya, we're aware of this issue. I'll update you when this is fixed πŸ™‚
Ddrewlonious5/12/2023
hi rc! any updates?
Bbrody5/12/2023
I'll update you when this is fixed
Ddrewlonious5/16/2023
Hello @Brody and @rc is there any update on this? Wonder if theres a priority on this, kind of urgent, thank you
Bbrody5/16/2023
sorry it's been awhile, I have brought this back up to the team
Ddrewlonious5/16/2023
how long could this take? in a rush to update content, already upgraded to the developer plan
Bbrody5/16/2023
I'm sorry I don't know, you can always make a new database in the mean time
Ddrewlonious5/16/2023
i have alot of data in the database
Bbrody5/16/2023
ah gotcha, well my answer stands, unfortunately I don't know when the team can get to this. going forward please make sure to keep daily backups of your database
Ddrewlonious5/16/2023
I've been waiting a few days and it's been said to be an easy fix
Ddrewlonious5/16/2023
would love some support with this
Bbrody5/16/2023
support is coming, but please be patient
Ddrewlonious5/16/2023
i see. also my database and servers keep crashing
Ddrewlonious5/16/2023
why is this?
Bbrody5/16/2023
I will let the team look into that
Ddrewlonious5/16/2023
railway doesnt scale? and charge for extra usage?
Bbrody5/16/2023
are you talking about the teams plan?
Ddrewlonious5/16/2023
developer
Bbrody5/16/2023
railway only has vertical scaling at the moment, and you pay for any usage above 5$
Ddrewlonious5/16/2023
yeah but it seems to just crash for exceeding limits
Bbrody5/16/2023
you are exceeding what limits?
Ddrewlonious5/16/2023
Bbrody5/16/2023
?
Ddrewlonious5/16/2023
Bbrody5/16/2023
what limits please
Ddrewlonious5/16/2023
it doesnt say
Bbrody5/16/2023
you would have too look at the metrics yourself
Ddrewlonious5/16/2023
you can't see anything
Bbrody5/16/2023
but anyway, let's just leave this thread for now, please wait until a team member can come assist
Ddrewlonious5/16/2023
it's all locked since the plugin stopped
Ddrewlonious5/16/2023
is there a way i can dump my databsae into a new one?
Bbrody5/16/2023
not when it has stopped, going forward please do daily backups
Bbrody5/16/2023
i will however tag you in this - @Angelo
Aangelo5/16/2023
Cheers- @drewlonious, I am going to open up the runbook to get ya unblocked.
Aangelo5/16/2023
jumping on the box
Aangelo5/16/2023
Okay- unlocked, now restarting
Aangelo5/16/2023
Okay you are back @drewlonious
Aangelo5/16/2023
Sorry this took so long
Bbrody5/16/2023
@drewlonious can you confirm that your database is back online with the data available?
Ddrewlonious5/17/2023
@Brody we;re back online!
Ddrewlonious5/17/2023
thank you!
Ddrewlonious5/17/2023
Could you tell what the issue was so i could avoid it in the future?
Bbrody5/17/2023
it wasnt your fault
Bbrody5/17/2023
nothing you did
Bbrody5/17/2023
but to avoid total disruptions going forward, do daily database backups
Ddrewlonious5/17/2023
copy
Ddrewlonious5/17/2023
also have another question, my database and my server seems to crash very often
Ddrewlonious5/17/2023
i'm using strapi, is this a common occurance with it?
Bbrody5/17/2023
i have a hunch
Bbrody5/17/2023
explain to me the problem?
Ddrewlonious5/17/2023
mainly the server crashes and fails to restart
yarn run v1.22.19
$ strapi start
[2023-05-12 04:15:41.821] debug: ⛔️ Server wasn't able to start properly.
[2023-05-12 04:15:41.823] error: connect ECONNREFUSED 35.227.154.77:7899
Error: connect ECONNREFUSED 35.227.154.77:7899
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1159:16)
error Command failed with exit code 1.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.
yarn run v1.22.19
Bbrody5/17/2023
is this on railway or locally?
Ddrewlonious5/17/2023
on railway
Bbrody5/17/2023
do you have a repo for your strapi
Ddrewlonious5/17/2023
indeed
Bbrody5/17/2023
please send
Ddrewlonious5/17/2023
it's private, do you have an email
Ddrewlonious5/17/2023
or i can copy paste a specific file
Bbrody5/17/2023
send your database.js
Ddrewlonious5/17/2023
const { parse } = require("pg-connection-string"); module.exports = ({ env }) => { const { host, port, database, user, password } = parse(env("DATABASE_URL")); return { connection: { client: "postgres", connection: { host, port, database, user, password }, debug: false, } }; };
Bbrody5/17/2023
now thats odd
Bbrody5/17/2023
never seen someone do it like that
Bbrody5/17/2023
show me a screenshot of your service variables please?
Ddrewlonious5/17/2023
i could be doing it wrong haha, what's the typical?
Bbrody5/17/2023
we will do whats typical, but first i need that screenshot
Ddrewlonious5/17/2023
service varialbes as in database env variables?
Bbrody5/17/2023
as in the service variables
Ddrewlonious5/17/2023
which file would that be?
Bbrody5/17/2023
the service variables, in railway
Ddrewlonious5/17/2023
Ddrewlonious5/17/2023
safe to share keys here? private thread?
Bbrody5/17/2023
i dont need whats under the hidden text
Bbrody5/17/2023
this should be a drop in replacement for your entire database.js file
https://github.com/railwayapp-templates/strapi/blob/main/config/database.js
Ddrewlonious5/17/2023
ah i see
Ddrewlonious5/17/2023
pushing up to see if anything breaks, on sec pls
Ddrewlonious5/17/2023
seems to be working, will ask back if any issues occurs
Bbrody5/17/2023
sounds good!