Connection terminated unexpectedly
Connection Error: Connection ended unexpectedly
[2023-07-07 15:25:28.860] error: select count("t0"."id") as "count" from "public"."admin_users" as "t0" limit $1 - Connection terminated unexpectedly
Solution:Jump to solution
reference this on how to set it pool.min to 0
https://github.com/railwayapp-templates/strapi/blob/main/config/database.js...
53 Replies
Project ID:
N/Asorry, looking for the project ID
dont worry about it
its of no use to me
This is postgresql, correct?
Yes
what is your pool.min set to?
Where do I find that?
one sec please
it's default
if you have it set, it would be in the database.js config file
Nope, never have it set
there you go
Found another user thats had this issue and been resolved; https://github.com/strapi/strapi/issues/13646#issuecomment-1184763834
GitHub
GraphQL - Apollo Server (DOS, persistent queries) · Issue #13646 · ...
Bug report Required System information Node.js version: v16.15.1 NPM version: 8.11.0 Strapi version: 4.2.0 Database: Postgres Operating system: Docker, node:lts-alpine, AWS ECS package.json depende...
Solution
reference this on how to set it pool.min to 0
https://github.com/railwayapp-templates/strapi/blob/main/config/database.js
it' default from Strapi. I never had this issues before but found it in my database.js
yep just a caveat of running strapi in a docker container, the strapi docs even tell you to set pool.min to 0 when running in docker
Thank you, I just changed it to 0 and leave max to 10 unless you think I should change it
max 10 is fine
as long as the min is fixed at 0
let us know if you have any problems like this again, since you won't see improvements right away
Thank you! Off subject - Did you just add Pro plan?
was added July 3rd, and there's is absolutely nothing different from the previous team plan, only the name
I just noticed but didn't see the Pro plan. Only saw Hobby at the time. I'm tempting
haha what do you think you need pro for?
I have about 30 - 40 websites 🙂
do any of them generate income?
Yes some
enough to justify paying 20$ a month?
sorry if that's too personal
Better than paying $300 a month for DS
I'm looking up the policy of the Railway
there's not really a super strict policy surrounding when to upgrade to pro
Is this hosted from Google Cloud?
yes, gcp us-west1
Then one of the sites can't be on Google Cloud because one of them is adult toys ecommerce.
you can't run that on gcp?
sure it's 18+ but still a legitimate business
what's the reasoning behind not allowing that
Webmasters Stack Exchange
Does Google App Engine allow adult content?
I am going to make a social photo album site with explicit adult content. I am wondering whether Google allows adult content/sites to be hosted on GAE? If so can you show some examples? if not, whe...
oh well railway doesn't use Google app engine
I guess it isn't anymore
It was
I’m sure you can distribute it, just not publish pornographic photography.
Google Cloud found the area where they were losing revenue 💀
oh come on. I can't say what I want to say 😛
Haha.
it has products that looks dirty but nothing visible.
Jeez, how much prohibit are the wording
I don't see anything in those terms that would prevent you from running an adult toy store?
Yeah I’m assuming that’s entirely acceptable.
It used to be, I didn't noticed the policy was updated so like Jack said, found the area where they were losing revenue
Anyway, you sold me the pen
yeah running a full blown business on railway does at least require the pro plan
but for example if you made a little e-commerce site for your parents to sell their honey, that's perfectly fine on hobby
true story
I have a few other eCommerce but they are pretty much G rated.
as long as they aren't shady, then I don't see anything wrong with them
Thank you for your time
no problem!
Of course, happy shipping!
Percy seems to be a little broken right now, so feel free to ping me when you've upgraded to pro so I can give you the pro badge if you wanted it
Thank you
mark solution?
✅
all good