aio-libs / aio-libs/aiopg

Issues with connecting to Google Cloud SQL via sql proxy

Open
#370 4 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1.4k
Forks
170
PR merge metrics
No merged PRs in 30d

Description

I went through [official guide](https://cloud.google.com/sql/docs/postgres/connect-container-engine) from Google on how to connect to Cloud PostgreSQL.
Unfortunately I get this traceback in logs:
```
2017-08-16T13:05:54.966574354Z Traceback (most recent call last):
2017-08-16T13:05:54.966585403Z File "main.py", line 24, in
2017-08-16T13:05:54.966589301Z web.run_app(app, host='0.0.0.0', port=8000)
2017-08-16T13:05:54.966592142Z File "/usr/local/lib/python3.6/site-packages/aiohttp/web.py", line 422, in run_app
2017-08-16T13:05:54.966596332Z loop.run_until_complete(app.startup())
2017-08-16T13:05:54.966600292Z File "uvloop/loop.pyx", line 1203, in uvloop.loop.Loop.run_until_complete (uvloop/loop.c:25632)
2017-08-16T13:05:54.966603161Z File "/usr/local/lib/python3.6/site-packages/aiohttp/web.py", line 259, in startup
2017-08-16T13:05:54.966606143Z yield from self.on_startup.send(self)
2017-08-16T13:05:54.966608657Z File "/usr/local/lib/python3.6/site-packages/aiohttp/signals.py", line 51, in send
2017-08-16T13:05:54.966611358Z yield from self._send(*args, **kwargs)
2017-08-16T13:05:54.966613597Z File "/usr/local/lib/python3.6/site-packages/aiohttp/signals.py", line 17, in _send
2017-08-16T13:05:54.966616198Z yield from res
2017-08-16T13:05:54.966618974Z File "/opt/broadcasts/storage.py", line 18, in init
2017-08-16T13:05:54.966621447Z password=DB_PASSWORD,
2017-08-16T13:05:54.966623587Z File "/usr/local/lib/python3.6/site-packages/aiopg/utils.py", line 72, in __await__
2017-08-16T13:05:54.966626117Z resp = yield from self._coro
2017-08-16T13:05:54.966628477Z File "/usr/local/lib/python3.6/site-packages/aiopg/sa/engine.py", line 67, in _create_engine
2017-08-16T13:05:54.966630969Z loop=loop, timeout=timeout, **kwargs)
2017-08-16T13:05:54.966633311Z File "/usr/local/lib/python3.6/site-packages/aiopg/utils.py", line 67, in __iter__
2017-08-16T13:05:54.966635821Z resp = yield from self._coro
2017-08-16T13:05:54.966638103Z File "/usr/local/lib/python3.6/site-packages/aiopg/pool.py", line 46, in _create_pool
2017-08-16T13:05:54.966640578Z yield from pool._fill_free_pool(False)
2017-08-16T13:05:54.966643043Z File "/usr/local/lib/python3.6/site-packages/aiopg/pool.py", line 203, in _fill_free_pool
2017-08-16T13:05:54.96664552Z **self._conn_kwargs)
2017-08-16T13:05:54.966647841Z File "/usr/local/lib/python3.6/site-packages/aiopg/utils.py", line 67, in __iter__
2017-08-16T13:05:54.966650378Z resp = yield from self._coro
2017-08-16T13:05:54.966652511Z File "/usr/local/lib/python3.6/site-packages/aiopg/connection.py", line 74, in _connect
2017-08-16T13:05:54.966656672Z yield from conn._poll(waiter, timeout)
2017-08-16T13:05:54.966658967Z File "/usr/local/lib/python3.6/site-packages/aiopg/connection.py", line 239, in _poll
2017-08-16T13:05:54.966661307Z yield from asyncio.shield(cancel(), loop=self._loop)
2017-08-16T13:05:54.966663591Z File "/usr/local/lib/python3.6/site-packages/aiopg/connection.py", line 225, in cancel
2017-08-16T13:05:54.966672795Z self._conn.cancel()
2017-08-16T13:05:54.966675518Z psycopg2.OperationalError: asynchronous connection attempt underway
```
However, when I run application locally and connect via proxy running under docker with my laptop as I host it works fine.
Anyone had problems with Google Cloud like mine?

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.