Database connection stuck
mrbigseo
HOBBYOP

4 months ago

Postgres deployed but still tru connect.

Here is a log af last deploy.

2025-07-23 20:39:29.777 UTC [2] LOG: starting PostgreSQL 16.3 (Debian 16.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

2025-07-23 20:39:29.777 UTC [2] LOG: listening on IPv4 address "0.0.0.0", port 5432

2025-07-23 20:39:29.777 UTC [2] LOG: listening on IPv6 address "::", port 5432

2025-07-23 20:39:29.791 UTC [2] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"

2025-07-23 20:39:29.814 UTC [25] LOG: database system was interrupted; last known up at 2025-07-23 20:20:03 UTC

2025-07-23 20:39:29.874 UTC [25] LOG: database system was not properly shut down; automatic recovery in progress

2025-07-23 20:39:29.880 UTC [25] LOG: redo starts at 0/6DB92D0

2025-07-23 20:39:29.880 UTC [25] LOG: invalid record length at 0/6DB93B8: expected at least 24, got 0

2025-07-23 20:39:29.880 UTC [25] LOG: redo done at 0/6DB9380 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s

2025-07-23 20:39:29.890 UTC [23] LOG: checkpoint starting: end-of-recovery immediate wait

2025-07-23 20:39:29.915 UTC [23] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.009 s, sync=0.003 s, total=0.029 s; sync files=2, longest=0.002 s, average=0.002 s; distance=0 kB, estimate=0 kB; lsn=0/6DB93B8, redo lsn=0/6DB93B8

2025-07-23 20:39:29.924 UTC [2] LOG: database system is ready to accept connections

Solved$10 Bounty

6 Replies


itsrems
EMPLOYEE

4 months ago

Hi, could you share more details on where the connection is "stuck" ?


Status changed to Awaiting User Response Railway 5 months ago


mrbigseo
HOBBYOP

4 months ago

Hi. In Postgres - database connection stiil loading


Status changed to Awaiting Railway Response Railway 5 months ago


itsrems
EMPLOYEE

4 months ago

There are no such logs in the Postgres service. I'm assuming you mean in another service where you're calling postgres?


Status changed to Awaiting User Response Railway 5 months ago


mrbigseo
HOBBYOP

4 months ago

Sorry I dont exactly say about my issue. I use this template - https://railway.com/deploy/n8n-with-workers


Status changed to Awaiting Railway Response Railway 5 months ago


itsrems
EMPLOYEE

4 months ago

gotcha - let me push this to our bounty board where the community can help you figure out this n8n issue


Status changed to Awaiting User Response Railway 5 months ago


itsrems
EMPLOYEE

4 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 itsrems 5 months ago


Status changed to Solved mrbigseo 4 months ago


Loading...