# Can't seem to connect to database

**URL:** <https://forum.ansible.com/t/cant-seem-to-connect-to-database/26556>\
**Category:** AWX Project\
**Tags:** awx\
**Created:** [January 24, 2018, 4:28pm UTC](https://forum.ansible.com/t/cant-seem-to-connect-to-database/26556 "2018-01-24T16:28:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark\_Constant](https://avatars.discourse-cdn.com/v4/letter/m/7ea924/32.png) [@Mark\_Constant](https://forum.ansible.com/u/Mark_Constant)\
**Post date:** [January 24, 2018, 4:28pm UTC](https://forum.ansible.com/t/cant-seem-to-connect-to-database/26556/1 "2018-01-24T16:28:22Z")

</div>

For some reason there is an issue when deploying where it won’t connect to the postres database. I get

[2018-01-24 16:24:29,905: CRITICAL/MainProcess] Unrecoverable error: OperationalError(‘could not connect to server: No route to host\n\tIs the server running on host “postgres” (172.17.0.8) and accepting\n\tTCP/IP connections on port 5432?\n’,)  
Traceback (most recent call last):  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/worker/worker.py”, line 203, in start  
self.blueprint.start(self)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/bootsteps.py”, line 119, in start  
step.start(parent)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/bootsteps.py”, line 370, in start  
return self.obj.start()  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/worker/consumer/consumer.py”, line 320, in start  
blueprint.start(self)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/bootsteps.py”, line 119, in start  
step.start(parent)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/worker/consumer/consumer.py”, line 596, in start  
c.loop(\*c.loop\_args())  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/worker/loops.py”, line 49, in asynloop  
consumer.consume()  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/kombu/messaging.py”, line 477, in consume  
self.\_basic\_consume(T, no\_ack=no\_ack, nowait=False)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/kombu/messaging.py”, line 598, in \_basic\_consume  
no\_ack=no\_ack, nowait=nowait)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/kombu/entity.py”, line 737, in consume  
arguments=self.consumer\_arguments)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/amqp/channel.py”, line 1564, in basic\_consume  
wait=None if nowait else spec.Basic.ConsumeOk,  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/amqp/abstract\_channel.py”, line 59, in send\_method  
return self.wait(wait, returns\_tuple=returns\_tuple)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/amqp/abstract\_channel.py”, line 79, in wait  
self.connection.drain\_events(timeout=timeout)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/amqp/connection.py”, line 471, in drain\_events  
while not self.blocking\_read(timeout):  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/amqp/connection.py”, line 477, in blocking\_read  
return self.on\_inbound\_frame(frame)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/amqp/method\_framing.py”, line 77, in on\_frame  
callback(channel, msg.frame\_method, msg.frame\_args, msg)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/amqp/connection.py”, line 481, in on\_inbound\_method  
method\_sig, payload, content,  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/amqp/abstract\_channel.py”, line 128, in dispatch\_method  
listener(\*args)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/amqp/channel.py”, line 1599, in \_on\_basic\_deliver  
fun(msg)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/kombu/messaging.py”, line 624, in \_receive\_callback  
return on\_m(message) if on\_m else self.receive(decoded, message)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/worker/consumer/consumer.py”, line 570, in on\_task\_received  
callbacks,  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/worker/strategy.py”, line 110, in task\_message\_handler  
if (req.expires or req.id in revoked\_tasks) and req.revoked():  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/worker/request.py”, line 279, in revoked  
‘expired’ if expired else ‘revoked’, False, None, expired,  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/worker/request.py”, line 262, in \_announce\_revoked  
self.id, reason, request=self, store\_result=self.store\_errors,  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/backends/base.py”, line 192, in mark\_as\_revoked  
traceback=None, request=request)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/celery/backends/base.py”, line 309, in store\_result  
request=request, \*\*kwargs)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django\_celery\_results/backends/database.py”, line 29, in \_store\_result  
meta=meta,  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django\_celery\_results/managers.py”, line 50, in \_inner  
return fun(\*args, \*\*kwargs)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django\_celery\_results/managers.py”, line 119, in store\_result  
obj, created = self.get\_or\_create(task\_id=task\_id, defaults=fields)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/manager.py”, line 85, in manager\_method  
return getattr(self.get\_queryset(), name)(\*args, \*\*kwargs)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/query.py”, line 464, in get\_or\_create  
return self.get(\*\*lookup), False  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/query.py”, line 374, in get  
num = len(clone)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/query.py”, line 232, in **len**  
self.\_fetch\_all()  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/query.py”, line 1118, in \_fetch\_all  
self.\_result\_cache = list(self.\_iterable\_class(self))  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/query.py”, line 53, in **iter**  
results = compiler.execute\_sql(chunked\_fetch=self.chunked\_fetch)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/sql/compiler.py”, line 882, in execute\_sql  
cursor = self.connection.cursor()  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/backends/base/base.py”, line 254, in cursor  
return self.\_cursor()  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/backends/base/base.py”, line 229, in \_cursor  
self.ensure\_connection()  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/backends/base/base.py”, line 213, in ensure\_connection  
self.connect()  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/utils.py”, line 94, in **exit**  
six.reraise(dj\_exc\_type, dj\_exc\_value, traceback)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/backends/base/base.py”, line 213, in ensure\_connection  
self.connect()  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/backends/base/base.py”, line 189, in connect  
self.connection = self.get\_new\_connection(conn\_params)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/backends/postgresql/base.py”, line 176, in get\_new\_connection  
connection = Database.connect(\*\*conn\_params)  
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/psycopg2/ **init**.py”, line 130, in connect  
conn = \_connect(dsn, connection\_factory=connection\_factory, \*\*kwasync)  
OperationalError: could not connect to server: No route to host  
Is the server running on host “postgres” (172.17.0.8) and accepting  
TCP/IP connections on port 5432?

When I do a docker container ls for postgres I see  
f3b662abdf19 postgres:9.6 “docker-entrypoint…” 21 hours ago Restarting (1) 27 seconds ago postgres

---

<div class="post-metadata">

**Author:** ![jmitchel](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/jmitchel/32/10148_2.png) [@jmitchel](https://forum.ansible.com/u/jmitchel)\
**Post date:** [January 24, 2018, 4:50pm UTC](https://forum.ansible.com/t/cant-seem-to-connect-to-database/26556/2 "2018-01-24T16:50:36Z")

</div>

It looks as if it is in status “restarting” and thus not up. You can test by trying to interactively open a shell into the container.

`docker exec -it postgres bash`

---

<div class="post-metadata">

**Author:** ![mkempster22uu](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@mkempster22uu](https://forum.ansible.com/u/mkempster22uu)\
**Post date:** [January 25, 2018, 8:10am UTC](https://forum.ansible.com/t/cant-seem-to-connect-to-database/26556/3 "2018-01-25T08:10:13Z")

</div>

Here’s the github issues related to this. It seems to be an error with the installer at the moment

[https://github.com/ansible/awx/issues/1047](https://github.com/ansible/awx/issues/1047)  
[https://github.com/ansible/awx/issues/1046](https://github.com/ansible/awx/issues/1046)

---

<div class="post-metadata">

**Author:** ![mkempster22uu](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@mkempster22uu](https://forum.ansible.com/u/mkempster22uu)\
**Post date:** [January 26, 2018, 8:38am UTC](https://forum.ansible.com/t/cant-seem-to-connect-to-database/26556/4 "2018-01-26T08:38:40Z")

</div>

Did you manage to solve this issue? Both my dev and prod servers cant update to the latest update from this error