Cloud Run与Cloud SQL Proxy协同工作异常问题排查求助

架构老林

2026-7-9

Cloud Run 中 Cloud SQL Proxy 连接数据库失败排查

问题核心情况

为Cloud Run使用的服务账号授予了充足权限（涵盖Cloud SQL Admin、Cloud Run Admin，甚至Project Owner），但数据库连接仍异常
在Cloud Run外部场景（部署sidecar、本地用该账号认证）下，通过Cloud SQL Proxy连接数据库完全正常
主机处于GCP后端VPC内部，可排除防火墙层面问题
无法获取Cloud SQL Proxy连接尝试的日志，仅能看到应用容器的报错信息，缺少根因排查线索

应用报错日志

2023-09-28 20:30:41 DEBUG rasa.core.tracker_store - Attempting to connect to database via 'postgresql://user1:***@localhost/rasa-oss-001'.
2023-09-28 20:30:41 ERROR rasa.core.tracker_store - Could not create tables: (psycopg2.OperationalError) connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused

结构化日志详情

{
  "insertId": "6515e27100075a076642487a",
  "labels": {1},
  "logName": "projects/bdt-eng-play/logs/run.googleapis.com%2Fstderr",
  "receiveTimestamp": "2023-09-28T20:30:41.492307554Z",
  "resource": {2},
  "textPayload": "2023-09-28 20:30:41 ERROR    rasa.core.tracker_store  - Could not create tables: (psycopg2.OperationalError) connection to server at \"localhost\" (127.0.0.1), port 5432 failed: Connection refused",
  "timestamp": "2023-09-28T20:30:41.481799Z"
}