Railway•2y ago

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:

reference this on how to set it pool.min to 0 https://github.com/railwayapp-templates/strapi/blob/main/config/database.js...

Jump to solution

53 Replies

Percy•2y ago

Project ID: N/A

TerryOP•2y ago

sorry, looking for the project ID

Brody•2y ago

dont worry about it its of no use to me

TerryOP•2y ago

[2023-07-07 15:25:23.215] error: select count("t0"."id") as "count" from "public"."admin_users" as "t0" limit $1 - Connection terminated unexpectedly
Error: select count("t0"."id") as "count" from "public"."admin_users" as "t0" limit $1 - Connection terminated unexpectedly

[2023-07-07 15:25:23.215] error: select count("t0"."id") as "count" from "public"."admin_users" as "t0" limit $1 - Connection terminated unexpectedly
Error: select count("t0"."id") as "count" from "public"."admin_users" as "t0" limit $1 - 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
Error: select count("t0"."id") as "count" from "public"."admin_users" as "t0" limit $1 - 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
Error: select count("t0"."id") as "count" from "public"."admin_users" as "t0" limit $1 - Connection terminated unexpectedly

Jack•2y ago

This is postgresql, correct?

TerryOP•2y ago

Yes

Brody•2y ago

what is your pool.min set to?

TerryOP•2y ago

Where do I find that?

Brody•2y ago

one sec please

TerryOP•2y ago

it's default

Brody•2y ago

if you have it set, it would be in the database.js config file

TerryOP•2y ago

Nope, never have it set

Brody•2y ago

there you go

Jack•2y ago

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

Brody•2y ago

reference this on how to set it pool.min to 0 https://github.com/railwayapp-templates/strapi/blob/main/config/database.js

TerryOP•2y ago

it' default from Strapi. I never had this issues before but found it in my database.js

      pool: {
        min: env.int("DATABASE_POOL_MIN", 2),
        max: env.int("DATABASE_POOL_MAX", 10),
      },

      pool: {
        min: env.int("DATABASE_POOL_MIN", 2),
        max: env.int("DATABASE_POOL_MAX", 10),
      },

Brody•2y ago

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

TerryOP•2y ago

Thank you, I just changed it to 0 and leave max to 10 unless you think I should change it

Brody•2y ago

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

TerryOP•2y ago

Thank you! Off subject - Did you just add Pro plan?

Brody•2y ago

was added July 3rd, and there's is absolutely nothing different from the previous team plan, only the name

TerryOP•2y ago

I just noticed but didn't see the Pro plan. Only saw Hobby at the time. I'm tempting

Brody•2y ago

haha what do you think you need pro for?

TerryOP•2y ago

I have about 30 - 40 websites 🙂

Brody•2y ago

do any of them generate income?

TerryOP•2y ago

Yes some

Brody•2y ago

enough to justify paying 20$ a month? sorry if that's too personal

TerryOP•2y ago

Better than paying $300 a month for DS I'm looking up the policy of the Railway

Brody•2y ago

there's not really a super strict policy surrounding when to upgrade to pro

TerryOP•2y ago

Is this hosted from Google Cloud?

Brody•2y ago

yes, gcp us-west1

TerryOP•2y ago

Then one of the sites can't be on Google Cloud because one of them is adult toys ecommerce.

Brody•2y ago

you can't run that on gcp? sure it's 18+ but still a legitimate business what's the reasoning behind not allowing that

TerryOP•2y ago

https://webmasters.stackexchange.com/questions/19328/does-google-app-engine-allow-adult-content

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...

Brody•2y ago

oh well railway doesn't use Google app engine

TerryOP•2y ago

https://cloud.google.com/terms/aup?csw=1

Google Cloud

Google Cloud Platform Acceptable Use Policy

TerryOP•2y ago

I guess it isn't anymore It was

Jack•2y ago

I’m sure you can distribute it, just not publish pornographic photography. Google Cloud found the area where they were losing revenue 💀

TerryOP•2y ago

oh come on. I can't say what I want to say 😛

Jack•2y ago

Haha.

TerryOP•2y ago

it has products that looks dirty but nothing visible. Jeez, how much prohibit are the wording

Brody•2y ago

I don't see anything in those terms that would prevent you from running an adult toy store?

Jack•2y ago

Yeah I’m assuming that’s entirely acceptable.

TerryOP•2y ago

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

Brody•2y ago

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

TerryOP•2y ago

I have a few other eCommerce but they are pretty much G rated.

Brody•2y ago

as long as they aren't shady, then I don't see anything wrong with them

TerryOP•2y ago

Thank you for your time

Brody•2y ago

no problem!

Jack•2y ago

Of course, happy shipping!

Brody•2y ago

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

TerryOP•2y ago

Thank you mark solution? ✅

Brody•2y ago

all good

Gaming

Programming

Connection terminated unexpectedly