Birdzai
Birdzai
RRailway
Created by CoolCheetah on 12/13/2023 in #✋|help
Hi! Not sure how I'm supposed to use the migration tool. This is the error I'm getting:
I retried the migration and it works now. Any reason why the service names for the database and data volume refer to it as "Postgres Legacy"?
23 replies
RRailway
Created by CoolCheetah on 12/13/2023 in #✋|help
Hi! Not sure how I'm supposed to use the migration tool. This is the error I'm getting:
I attempted it twice. Each time I've got some "Postgres Legacy" services being created that have no deploys. Can I go ahead and delete those? Or should I just wait?
23 replies
RRailway
Created by CoolCheetah on 12/13/2023 in #✋|help
Hi! Not sure how I'm supposed to use the migration tool. This is the error I'm getting:
Yes, I'm getting the same migration error when attempting to migrate my Postgres database. ID: 5422b575-5139-402a-a9be-c93af8b0c44e
23 replies
RRailway
Created by Birdzai on 9/19/2022 in #✋|help
Server Error after period of Inactivity
OK, I think I have a solution, which I'm posting here if anyone should encounter the same issue re Strapi. Turns out that for Docker-based deployments I have to change a DB connection pool setting. The Strapi docs state the following:
✋ CAUTION

When using Docker, change the pool min value to 0 as Docker will kill any idle connections, making it impossible to keep any open connections to the database (see Tarn.js's pool (opens new window)settings used by Knex.js for more information).
✋ CAUTION

When using Docker, change the pool min value to 0 as Docker will kill any idle connections, making it impossible to keep any open connections to the database (see Tarn.js's pool (opens new window)settings used by Knex.js for more information).
So that should solve my issue.
31 replies
RRailway
Created by Birdzai on 9/19/2022 in #✋|help
Server Error after period of Inactivity
Hmmm...never heard of Easypanel before....interesting. I'm using something similar (Dokku) on Digital Ocean...no problems with Postgres connections over there.
31 replies
RRailway
Created by Birdzai on 9/19/2022 in #✋|help
Server Error after period of Inactivity
Thanks everyone....this may indeed be the reason for the server error, but I'm still confused as to why the same github deploy works on other PaaS platforms (Heroku and Digital Ocean). Shouldn't I also be seeing the same behavior there as well?
31 replies
RRailway
Created by Birdzai on 9/19/2022 in #✋|help
Server Error after period of Inactivity
Thanks anyway for commenting.
31 replies
RRailway
Created by Birdzai on 9/19/2022 in #✋|help
Server Error after period of Inactivity
it's an open source headless CMS project (Strapi). It's been working fine on other PaaS offerings. I doubt it's a coding error in light of that.
31 replies
RRailway
Created by Birdzai on 9/19/2022 in #✋|help
Server Error after period of Inactivity
The app is running fine now, I just get that server error the first time i hit it after inactivity. Doing a browser refresh and everything is then fine
31 replies
RRailway
Created by Birdzai on 9/19/2022 in #✋|help
Server Error after period of Inactivity
31 replies
RRailway
Created by Birdzai on 9/19/2022 in #✋|help
Server Error after period of Inactivity
And works fine immediately on the second request.
31 replies
RRailway
Created by Birdzai on 9/19/2022 in #✋|help
Server Error after period of Inactivity
The same git deployment works fine on Heroku and Digital Ocean (I'm evaluating deployment platforms). It's only a problem here on Railway
31 replies
RRailway
Created by Birdzai on 9/19/2022 in #✋|help
Server Error after period of Inactivity
[2022-09-19 18:24:49.577] debug: ⛔️ Server wasn't able to start properly. [2022-09-19 18:24:49.578] error: select "t0"."id" from "admin_users" as "t0" limit $1 - Connection terminated unexpectedly Error: select "t0"."id" from "admin_users" as "t0" limit $1 - Connection terminated unexpectedly at Connection.<anonymous> (/app/node_modules/pg/lib/client.js:132:73) at Object.onceWrapper (node:events:627:28) at Connection.emit (node:events:513:28) at Connection.emit (node:domain:489:12) at Socket.<anonymous> (/app/node_modules/pg/lib/connection.js:57:12) at Socket.emit (node:events:525:35) at Socket.emit (node:domain:489:12) at TCP.<anonymous> (node:net:757:14) error Command failed with exit code 1.
31 replies