Postgres SSL issue
mmichaud93
PROOP

2 months ago

Hello, my server has been having trouble connecting to the connected postgres service.

Logs:

```

Failed to initialize services: KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?

at PostgreSqlKnexDialect.acquireConnection (/app/node_modules/knex/lib/client.js:332:26)

at runNextTicks (node:internal/process/task_queues:60:5)

at listOnTimeout (node:internal/timers:545:9)

at process.processTimers (node:internal/timers:519:7)

at async Runner.ensureConnection (/app/node_modules/knex/lib/execution/runner.js:305:28)

at async Runner.run (/app/node_modules/knex/lib/execution/runner.js:30:19)

at async executeQuery.query (/app/node_modules/@mikro-orm/knex/AbstractSqlConnection.js:145:25)

at async PostgreSqlConnection.executeQuery (/app/node_modules/@mikro-orm/core/connections/Connection.js:103:25)

at async PostgreSqlSchemaHelper.databaseExists (/app/node_modules/@mikro-orm/knex/schema/SchemaHelper.js:269:25)

at async SqlSchemaGenerator.ensureDatabase (/app/node_modules/@mikro-orm/knex/schema/SqlSchemaGenerator.js:27:24) {

sql: "select 1 from pg_database where datname = 'railway'",

bindings: undefined

}

```

Havent had any code changes or deploys. Just randomly stopped working. Tried restarting and redeploying and nothing.

Not sure how long it's been going on but this is really not great . I want to be able to use Railway for actual production code but you can understand that when stuff like this happens randomly, it makes me 1. not want to use this service for anything real and 2. definitely not recommend it to my peers.

Also, the agent hallucinated that I should reach out to support@railway.com which, when I emailed it, I got a response back that that email is not for support. Stellar.

Solved$20 Bounty

Pinned Solution

2 months ago

Hey, your issue coincides with a network degradation incident on US East (https://status.railway.com/cmmwzdxah016mtv8gcnc3vmi4) which is now resolved.

Is everything working as expected?

3 Replies

2 months ago

This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.

Status changed to Open brody 2 months ago


mmichaud93
PROOP

2 months ago

Update: I redeployed it 3 more times and it finally decided to work on its own.


2 months ago

Hey, your issue coincides with a network degradation incident on US East (https://status.railway.com/cmmwzdxah016mtv8gcnc3vmi4) which is now resolved.

Is everything working as expected?


mmichaud93
PROOP

2 months ago

Yes the issue is seemingly resolved now.


Status changed to Solved medim about 1 month ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...