GoogleCloudPlatform / GoogleCloudPlatform/elixir-runtime

Connection/Pooling Issue with Cloud SQL

Open
#20 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Elixir
Stars
183
Forks
14
PR merge metrics
No merged PRs in 30d

Description

I've gotten my app and my database talking to each other, but my SQL and App Engine logs are being absolutely flooded by connection errors anyway.

On the App Engine side, I'm seeing the usual `/cloudsql/project:region:database/.s.PSQL.5432` not found error. But on the Cloud SQL side, I'm seeing `FATAL: remaining connection slots are reserved for non-replication superuser connections`

Again: I have pages that launch DB queries that I can load reliably without 500s, so they are actually talking to each other, but something else is clearly going on here.

My limited research has shown that a base PostgresQL instance can support up to 100 connections, and the default pool size I've seen for Phoenix in production is 20.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.