use proper log paths for Docker

2 files changed, 159 insertions, 1 deletions

diff --git a/api.py b/api.py
index fa70cf5..570dcec 100644
--- a/api.py
+++ b/api.py
@@ -183,7 +183,10 @@ async def startup():
     await worker.start(4)
 
 logging.basicConfig(
-    filename="logs/processor.log",
+    filename=os.path.realpath(
+        os.path.join(os.getcwd(),
+                     os.path.dirname(__file__))) +
+        "/logs/processor.log",
     filemode="a",
     level=logging.DEBUG
 )
diff --git a/logs/processor.log b/logs/processor.log
new file mode 100644
index 0000000..be470e4
--- /dev/null
+++ b/logs/processor.log
@@ -0,0 +1,155 @@
+DEBUG:asyncio:Using selector: EpollSelector
+WARNING:root:connecting to database
+INFO:root:loaded query 'match'
+INFO:root:loaded query 'player'
+INFO:root:loaded query 'roster'
+INFO:root:loaded query 'participant'
+DEBUG:root:820: running 'match' query
+DEBUG:root:812: running 'match' query
+DEBUG:root:812: running 'player' query
+DEBUG:root:813: running 'match' query
+DEBUG:root:813: running 'player' query
+DEBUG:root:820: running 'player' query
+DEBUG:root:812: running 'roster' query
+DEBUG:root:814: running 'match' query
+DEBUG:root:814: running 'player' query
+DEBUG:root:812: running 'participant' query
+DEBUG:root:813: running 'roster' query
+DEBUG:root:813: running 'participant' query
+DEBUG:root:815: running 'match' query
+DEBUG:root:815: running 'player' query
+DEBUG:root:816: running 'match' query
+DEBUG:root:816: running 'player' query
+ERROR:asyncio:Task exception was never retrieved
+future: <Task finished coro=<Worker.run() done, defined at /apps/api/api.py:164> exception=DeadlockDetectedError('deadlock detected',)>
+Traceback (most recent call last):
+  File "/apps/api/api.py", line 168, in run
+    await self._work()
+  File "/apps/api/api.py", line 161, in _work
+    await self._execute_job(jobid, payload, priority)
+  File "/apps/api/api.py", line 79, in _execute_job
+    data["name"] == explicit_player)
+  File "/apps/api/api.py", line 134, in _playerinto
+    objid = await conn.fetchval(query, *data.values())
+  File "/usr/local/lib/python3.6/site-packages/asyncpg/connection.py", line 289, in fetchval
+    False, timeout)
+  File "asyncpg/protocol/protocol.pyx", line 165, in bind_execute (asyncpg/protocol/protocol.c:55643)
+asyncpg.exceptions.DeadlockDetectedError: deadlock detected
+ERROR:asyncio:Task exception was never retrieved
+future: <Task finished coro=<Worker.run() done, defined at /apps/api/api.py:164> exception=DeadlockDetectedError('deadlock detected',)>
+Traceback (most recent call last):
+  File "/apps/api/api.py", line 168, in run
+    await self._work()
+  File "/apps/api/api.py", line 161, in _work
+    await self._execute_job(jobid, payload, priority)
+  File "/apps/api/api.py", line 79, in _execute_job
+    data["name"] == explicit_player)
+  File "/apps/api/api.py", line 134, in _playerinto
+    objid = await conn.fetchval(query, *data.values())
+  File "/usr/local/lib/python3.6/site-packages/asyncpg/connection.py", line 289, in fetchval
+    False, timeout)
+  File "asyncpg/protocol/protocol.pyx", line 165, in bind_execute (asyncpg/protocol/protocol.c:55643)
+asyncpg.exceptions.DeadlockDetectedError: deadlock detected
+ERROR:asyncio:Task exception was never retrieved
+future: <Task finished coro=<Worker.run() done, defined at /apps/api/api.py:164> exception=DeadlockDetectedError('deadlock detected',)>
+Traceback (most recent call last):
+  File "/apps/api/api.py", line 168, in run
+    await self._work()
+  File "/apps/api/api.py", line 161, in _work
+    await self._execute_job(jobid, payload, priority)
+  File "/apps/api/api.py", line 79, in _execute_job
+    data["name"] == explicit_player)
+  File "/apps/api/api.py", line 141, in _playerinto
+    """, lmcd)
+  File "/usr/local/lib/python3.6/site-packages/asyncpg/connection.py", line 174, in execute
+    True, timeout)
+  File "asyncpg/protocol/protocol.pyx", line 165, in bind_execute (asyncpg/protocol/protocol.c:55643)
+asyncpg.exceptions.DeadlockDetectedError: deadlock detected
+DEBUG:root:816: running 'roster' query
+DEBUG:root:816: running 'participant' query
+DEBUG:root:817: running 'match' query
+DEBUG:root:817: running 'player' query
+DEBUG:root:817: running 'roster' query
+DEBUG:root:817: running 'participant' query
+DEBUG:root:818: running 'match' query
+DEBUG:root:818: running 'player' query
+DEBUG:root:818: running 'roster' query
+DEBUG:root:818: running 'participant' query
+DEBUG:root:819: running 'match' query
+DEBUG:root:819: running 'player' query
+DEBUG:root:819: running 'roster' query
+DEBUG:root:819: running 'participant' query
+DEBUG:root:880: running 'match' query
+DEBUG:root:880: running 'player' query
+DEBUG:root:880: running 'roster' query
+DEBUG:root:880: running 'participant' query
+DEBUG:root:881: running 'match' query
+DEBUG:root:881: running 'player' query
+DEBUG:root:881: running 'roster' query
+DEBUG:root:881: running 'participant' query
+DEBUG:root:882: running 'match' query
+DEBUG:root:882: running 'player' query
+DEBUG:root:882: running 'roster' query
+DEBUG:root:882: running 'participant' query
+DEBUG:root:883: running 'match' query
+DEBUG:root:883: running 'player' query
+DEBUG:root:883: running 'roster' query
+DEBUG:root:883: running 'participant' query
+DEBUG:root:884: running 'match' query
+DEBUG:root:884: running 'player' query
+DEBUG:root:884: running 'roster' query
+DEBUG:root:884: running 'participant' query
+DEBUG:asyncio:Using selector: EpollSelector
+WARNING:root:connecting to database
+DEBUG:asyncio:Using selector: EpollSelector
+WARNING:root:connecting to database
+INFO:root:loaded query 'match'
+INFO:root:loaded query 'player'
+INFO:root:loaded query 'roster'
+INFO:root:loaded query 'participant'
+DEBUG:asyncio:Using selector: EpollSelector
+WARNING:root:connecting to database
+INFO:root:loaded query 'match'
+INFO:root:loaded query 'player'
+INFO:root:loaded query 'roster'
+INFO:root:loaded query 'participant'
+DEBUG:root:928: running 'match' query
+DEBUG:root:928: running 'player' query
+DEBUG:root:928: running 'roster' query
+DEBUG:root:929: running 'match' query
+DEBUG:root:929: running 'player' query
+DEBUG:root:930: running 'match' query
+DEBUG:root:930: running 'player' query
+DEBUG:root:928: running 'participant' query
+DEBUG:root:931: running 'match' query
+DEBUG:root:931: running 'player' query
+DEBUG:root:929: running 'roster' query
+DEBUG:root:929: running 'participant' query
+DEBUG:root:932: running 'match' query
+DEBUG:root:932: running 'player' query
+DEBUG:root:931: running 'roster' query
+DEBUG:root:931: running 'participant' query
+DEBUG:root:930: running 'roster' query
+DEBUG:root:930: running 'participant' query
+DEBUG:root:932: running 'roster' query
+DEBUG:root:932: running 'participant' query
+DEBUG:root:977: running 'match' query
+DEBUG:root:977: running 'player' query
+DEBUG:root:977: running 'roster' query
+DEBUG:root:977: running 'participant' query
+DEBUG:root:978: running 'match' query
+DEBUG:root:978: running 'player' query
+DEBUG:root:974: running 'match' query
+DEBUG:root:978: running 'roster' query
+DEBUG:root:974: running 'player' query
+DEBUG:root:978: running 'participant' query
+DEBUG:root:975: running 'match' query
+DEBUG:root:975: running 'player' query
+DEBUG:root:974: running 'roster' query
+DEBUG:root:974: running 'participant' query
+DEBUG:root:976: running 'match' query
+DEBUG:root:976: running 'player' query
+DEBUG:root:975: running 'roster' query
+DEBUG:root:975: running 'participant' query
+DEBUG:root:976: running 'roster' query
+DEBUG:root:976: running 'participant' query