
Traceback (most recent call last):


 "avg_store_sales.py", line 38, in <module>

df = pd.read_sql_query(query, engine)


 "C:\Program 
s\Anaconda2\lib\site-packages\pandas\io\sql.py", line 332, in read_sql_query

parse_dates=parse_dates, chunksize=chunksize)


 "C:\Program 
s\Anaconda2\lib\site-packages\pandas\io\sql.py", line 1092, in read_query

result = self.execute(*args)


 "C:\Program 
s\Anaconda2\lib\site-packages\pandas\io\sql.py", line 983, in execute

return self.connectable.execute(*args, **kwargs)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\engine\base.py", line 2054, in execute

connection = self.contextual_connect(close_with_result=True)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\engine\base.py", line 2103, in contextual_connect

self._wrap_pool_connect(self.pool.connect, None),


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\engine\base.py", line 2138, in _wrap_pool_connect

return fn()


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\pool.py", line 387, in connect

return _ConnectionFairy._checkout(self)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\pool.py", line 766, in _checkout

fairy = _ConnectionRecord.checkout(pool)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\pool.py", line 516, in checkout

rec = pool._do_get()


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\pool.py", line 1138, in _do_get

self._dec_overflow()


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\util\langhelpers.py", line 60, in __exit__

compat.reraise(exc_type, exc_value, exc_tb)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\pool.py", line 1135, in _do_get

return self._create_connection()


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\pool.py", line 333, in _create_connection

return _ConnectionRecord(self)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\pool.py", line 461, in __init__

self.__connect(first_connect_check=True)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\pool.py", line 661, in __connect

exec_once(self.connection, self)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\event\attr.py", line 246, in exec_once

self(*args, **kw)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\event\attr.py", line 256, in __call__

fn(*args, **kw)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\util\langhelpers.py", line 1321, in go

return once_fn(*arg, **kw)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\engine\strategies.py", line 181, in first_connect

dialect.initialize(c)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\dialects\postgresql\psycopg2.py", line 538, in initialize

super(PGDialect_psycopg2, self).initialize(connection)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\dialects\postgresql\base.py", line 2063, in initialize

super(PGDialect, self).initialize(connection)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\engine\default.py", line 245, in initialize

self._get_server_version_info(connection)


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\dialects\postgresql\base.py", line 2271, in _get_server_version_info

v = connection.execute("select version()").scalar()


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\engine\result.py", line 1224, in scalar

return row[0]


 "C:\Program 
s\Anaconda2\lib\site-packages\sqlalchemy\engine\result.py", line 563, in _key_fallback

expression._string_or_unprintable(key))
sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column '0'"
`FAILED! => {"changed": false, "failed": true, "module_stderr": "", "module_stdout": "Traceback (most recent call last):\r\n

 \"/tmp/ansible_lWusF9/ansible_module_docker_service.py\", line 760, in <module>\r\n
main()\r\n

 \"/tmp/ansible_lWusF9/ansible_module_docker_service.py\", line 755, in main\r\n
result = ContainerManager(client).exec_module()\r\n

 \"/tmp/ansible_lWusF9/ansible_module_docker_service.py\", line 510, in exec_module\r\n
result = self.cmd_up()\r\n

 \"/tmp/ansible_lWusF9/ansible_module_docker_service.py\", line 613, in cmd_up\r\n
aliases=inspection['NetworkSettings']['Networks'][key]['Aliases'],\r\nKeyError: 'Aliases'\r\n", "msg": "MODULE FAILURE", "parsed": false}`