6 months ago
Since yesterday I am getting postgres errors and in my Architecture tab in console I cant see the architecture anymore. There should be Rust backend, Postgres and Redis instances in architecture. It looks like is loading or something. But when I deploy I get no errors.
Errors in logs:
{ "message": "2025-11-12 14:12:19.581 UTC [27] LOG: checkpoint starting: time", "attributes": { "level": "error" }, "tags": { "project": "732cc2bc-fed3-47c6-9793-b39d97b95d68", "environment": "e412222b-9ac4-48fa-9c04-8c4b8e237209", "service": "37caa0a3-2ca0-4e25-ba82-d3cda61a479b", "deployment": "103e05ad-29bf-422d-83d7-268646281380", "replica": "36fe69d8-3004-43fa-92d2-c57db2058c3c" }, "timestamp": "2025-11-12T14:12:21.171737590Z" }
{ "message": "2025-11-12 14:12:20.588 UTC [27] LOG: checkpoint complete: wrote 10 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.917 s, sync=0.020 s, total=1.007 s; sync files=3, longest=0.018 s, average=0.007 s; distance=175 kB, estimate=176 kB; lsn=0/240C16E8, redo lsn=0/240C1690", "attributes": { "level": "error" }, "tags": { "project": "732cc2bc-fed3-47c6-9793-b39d97b95d68", "environment": "e412222b-9ac4-48fa-9c04-8c4b8e237209", "service": "37caa0a3-2ca0-4e25-ba82-d3cda61a479b", "deployment": "103e05ad-29bf-422d-83d7-268646281380", "replica": "36fe69d8-3004-43fa-92d2-c57db2058c3c" }, "timestamp": "2025-11-12T14:12:21.171749830Z" }
2 Replies
6 months ago
Hey there! We've found the following might help you get unblocked faster:
- 🧵 Railway Postgres error
- 🧵 Recurring Timeout Issues on n8n Server - Postgres Checkpoint Blocking System
- 🧵 Postgres LOG is logged as error
- 🧵 Postgres Database Connection Error
If you find the answer from one of these, please let us know by solving the thread!
6 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 • 6 months ago
2 months ago
I was able to add an environment variable LOG_TO_STDOUT as true to my Postgres service and now my checkpoint logs are not coming through as errors in the railway logs.
However, this may classify ALL postgres logs as severity level info. Something to keep in mind.
You can see this environment variable usage in the railway postgres wrapper.sh script:
https://github.com/railwayapp-templates/postgres-ssl/blob/main/wrapper.sh