cannot restart my database please help
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"
68 Replies
Project ID:
2087cf6c-e961-4d84-9695-a5fbf67068482087cf6c-e961-4d84-9695-a5fbf6706848
have you upgraded to the dev plan yet?
yes indeed
discord does not show you as having the dev account role
this is correct?
yep
okay i will flag this thread for team review
thank you. my data should still be there correct?
I dont mind paying to restart
Flagging this thread. A team member will be with you shortly.
correct
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
ty
Heya, we're aware of this issue. I'll update you when this is fixed 🙂
hi rc! any updates?
I'll update you when this is fixed
Hello @Brody and @rc is there any update on this? Wonder if theres a priority on this, kind of urgent, thank you
sorry it's been awhile, I have brought this back up to the team
how long could this take? in a rush to update content, already upgraded to the developer plan
I'm sorry I don't know, you can always make a new database in the mean time
i have alot of data in the database
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
I've been waiting a few days and it's been said to be an easy fix
would love some support with this
support is coming, but please be patient
i see. also my database and servers keep crashing
why is this?
I will let the team look into that
railway doesnt scale? and charge for extra usage?
are you talking about the teams plan?
developer
railway only has vertical scaling at the moment, and you pay for any usage above 5$
yeah but it seems to just crash for exceeding limits
you are exceeding what limits?
?
what limits please
it doesnt say
you would have too look at the metrics yourself
you can't see anything
but anyway, let's just leave this thread for now, please wait until a team member can come assist
it's all locked since the plugin stopped
is there a way i can dump my databsae into a new one?
not when it has stopped, going forward please do daily backups
i will however tag you in this - @Angelo
Cheers- @drewlonious, I am going to open up the runbook to get ya unblocked.
jumping on the box
Okay- unlocked, now restarting
Okay you are back @drewlonious
Sorry this took so long
@drewlonious can you confirm that your database is back online with the data available?
@Brody we;re back online!
thank you!
Could you tell what the issue was so i could avoid it in the future?
it wasnt your fault
nothing you did
but to avoid total disruptions going forward, do daily database backups
copy
also have another question, my database and my server seems to crash very often
i'm using strapi, is this a common occurance with it?
i have a hunch
explain to me the problem?
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
is this on railway or locally?
on railway
do you have a repo for your strapi
indeed
please send
it's private, do you have an email
or i can copy paste a specific file
send your database.js
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,
}
};
};
now thats odd
never seen someone do it like that
show me a screenshot of your service variables please?
i could be doing it wrong haha, what's the typical?
we will do whats typical, but first i need that screenshot
service varialbes as in database env variables?
as in the service variables
which file would that be?
the service variables, in railway
safe to share keys here? private thread?
i dont need whats under the hidden text
this should be a drop in replacement for your entire database.js file
https://github.com/railwayapp-templates/strapi/blob/main/config/database.js
and read this commit message
https://github.com/railwayapp-templates/strapi/commit/e923d3d79b3f7a818ef90efd36fcde7974da04ae
ah i see
pushing up to see if anything breaks, on sec pls
seems to be working, will ask back if any issues occurs
sounds good!