It works for a year, but down today. It’s urgent, please help me.
I restarted a lot times, but it never work.
fly machine restart xx891eddf40xxxxx -a goodidea-db
2024-05-30T04:40:58Z app[4d891eddf40d87] hkg [info]keeper | 2024-05-30T04:40:58.574Z ERROR cmd/keeper.go:719 cannot get configured pg parameters {"error": "dial unix /tmp/.s.PGSQL.5433: connect: no such file or directory"}
full log is:
2024-05-30T04:31:03Z app[4d891eddf40d87] hkg [info]proxy | [WARNING] 150/043103 (354) : Server bk_db/pg1 administratively READY thanks to valid DNS answer.
2024-05-30T04:31:03Z app[4d891eddf40d87] hkg [info]keeper | 2024-05-30T04:31:03.873Z ERROR cmd/keeper.go:719 cannot get configured pg parameters {"error": "dial unix /tmp/.s.PGSQL.5433: connect: no such file or directory"}
2024-05-30T04:31:04Z app[4d891eddf40d87] hkg [info]checking stolon status
2024-05-30T04:31:04Z app[4d891eddf40d87] hkg [info]keeper is healthy, db is healthy, role: master
2024-05-30T04:31:06Z app[4d891eddf40d87] hkg [info]keeper | 2024-05-30T04:31:06.374Z ERROR cmd/keeper.go:719 cannot get configured pg parameters {"error": "dial unix /tmp/.s.PGSQL.5433: connect: no such file or directory"}
2024-05-30T04:31:08Z app[4d891eddf40d87] hkg [info]exporter | INFO[0005] Established new database connection to "fdaa:1:1ee6:a7b:a8:5ddb:31b6:2:5433". source="postgres_exporter.go:970"
2024-05-30T04:31:08Z app[4d891eddf40d87] hkg [info]keeper | 2024-05-30T04:31:08.874Z ERROR cmd/keeper.go:719 cannot get configured pg parameters {"error": "dial unix /tmp/.s.PGSQL.5433: connect: no such file or directory"}
2024-05-30T04:31:09Z app[4d891eddf40d87] hkg [info]exporter | ERRO[0006] Error opening connection to database (postgresql://flypgadmin:PASSWORD_REMOVED@[fdaa:1:1ee6:a7b:a8:5ddb:31b6:2]:5433/postgres?sslmode=disable): dial tcp [fdaa:1:1ee6:a7b:a8:5ddb:31b6:2]:5433: connect: connection refused source="postgres_exporter.go:1658"
2024-05-30T04:31:09Z app[4d891eddf40d87] hkg [info]error connecting to local postgres context deadline exceeded
2024-05-30T04:31:09Z app[4d891eddf40d87] hkg [info]checking stolon status
2024-05-30T04:31:10Z app[4d891eddf40d87] hkg [info]proxy | [WARNING] 150/043110 (354) : Backup Server bk_db/pg is DOWN, reason: Layer7 timeout, check duration: 5001ms. 1 active and 0 backup servers left. 0 sessions active, 0 requeued, 0 remaining in queue.
2024-05-30T04:31:10Z app[4d891eddf40d87] hkg [info]proxy | [WARNING] 150/043110 (354) : Server bk_db/pg1 is DOWN, reason: Layer7 timeout, check duration: 5007ms. 0 active and 0 backup servers left. 0 sessions active, 0 requeued, 0 remaining in queue.
2024-05-30T04:31:10Z app[4d891eddf40d87] hkg [info]proxy | [NOTICE] 150/043110 (354) : haproxy version is 2.2.9-2+deb11u5
2024-05-30T04:31:10Z app[4d891eddf40d87] hkg [info]proxy | [NOTICE] 150/043110 (354) : path to executable is /usr/sbin/haproxy
2024-05-30T04:31:10Z app[4d891eddf40d87] hkg [info]proxy | [ALERT] 150/043110 (354) : backend 'bk_db' has no server available!
2024-05-30T04:31:10Z app[4d891eddf40d87] hkg [info]keeper is healthy, db is healthy, role: master
2024-05-30T04:31:11Z app[4d891eddf40d87] hkg [info]keeper | 2024-05-30T04:31:11.375Z ERROR cmd/keeper.go:719 cannot get configured pg parameters {"error": "dial unix /tmp/.s.PGSQL.5433: connect: no such file or directory"}
2024-05-30T04:31:13Z app[4d891eddf40d87] hkg [info]keeper | 2024-05-30T04:31:13.875Z ERROR cmd/keeper.go:719 cannot get configured pg parameters {"error": "dial unix /tmp/.s.PGSQL.5433: connect: no such file or directory"}
2024-05-30T04:31:14Z app[4d891eddf40d87] hkg [info]keeper | 2024-05-30 04:31:14.600 UTC [383] LOG: starting PostgreSQL 14.6 (Debian 14.6-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2024-05-30T04:31:14Z app[4d891eddf40d87] hkg [info]keeper | 2024-05-30 04:31:14.600 UTC [383] LOG: listening on IPv6 address "fdaa:1:1ee6:a7b:a8:5ddb:31b6:2", port 5433