sqlite3.IntegrityError on websocket thread #39

Closed
opened 2019-01-15 03:34:29 +00:00 by thrrgilag · 2 comments
thrrgilag commented 2019-01-15 03:34:29 +00:00 (Migrated from gitlab.com)
No description provided.
thrrgilag commented 2019-01-15 03:35:54 +00:00 (Migrated from gitlab.com)
-- Logs begin at Mon 2019-01-14 05:34:41 UTC, end at Tue 2019-01-15 03:29:10 UTC. --
Jan 14 16:24:20 zoidberg.monkeystew.net python[12384]: ERROR:websocket:error from callback : (sqlite3.IntegrityError) column pnut_user is not unique [SQL: 'INSERT INTO avat
ars (pnut_user, avatar) VALUES (?, ?)'] [parameters: ('blumenkraft', 'https://d26y28lt6cxszo.cloudfront.net/avatar/eDN6QG5yEmB9VQOrd3cCdgCF5IO4DMDAWvBkP8OEZ6q3I5updwi0t-653ozpE14blQYGrs')] (Background on this er
ror at: http://sqlalche.me/e/gkpj)
Jan 14 16:41:22 zoidberg.monkeystew.net python[12384]: ERROR:root:Connection is already closed.
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: Exception in thread Thread-2:
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: Traceback (most recent call last):
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/usr/lib64/python3.6/threading.py", line 916, in _bootstrap_inner
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: self.run()
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/usr/lib64/python3.6/threading.py", line 864, in run
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: self._target(*self._args, **self._kwargs)
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/pnut-matrix.py", line 273, in run
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: ws.send(".")
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/env/lib64/python3.6/site-packages/websocket/_app.py", line 153, in send
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: if not self.sock or self.sock.send(data, opcode) == 0:
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/env/lib64/python3.6/site-packages/websocket/_core.py", line 250, in send
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: return self.send_frame(frame)
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/env/lib64/python3.6/site-packages/websocket/_core.py", line 275, in send_frame
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: l = self._send(data)
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/env/lib64/python3.6/site-packages/websocket/_core.py", line 445, in _send
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: return send(self.sock, data)
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/env/lib64/python3.6/site-packages/websocket/_socket.py", line 114, in send
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: raise WebSocketConnectionClosedException("socket is already closed.")
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: websocket._exceptions.WebSocketConnectionClosedException: socket is already closed.
Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: ERROR:websocket:error from callback : threads can only be started once

By Morgan McMillian on 2019-01-15T03:35:54 (imported from GitLab project)

<pre> -- Logs begin at Mon 2019-01-14 05:34:41 UTC, end at Tue 2019-01-15 03:29:10 UTC. -- Jan 14 16:24:20 zoidberg.monkeystew.net python[12384]: ERROR:websocket:error from callback <function on_message at 0x7f1efc5417b8>: (sqlite3.IntegrityError) column pnut_user is not unique [SQL: 'INSERT INTO avat ars (pnut_user, avatar) VALUES (?, ?)'] [parameters: ('blumenkraft', 'https://d26y28lt6cxszo.cloudfront.net/avatar/eDN6QG5yEmB9VQOrd3cCdgCF5IO4DMDAWvBkP8OEZ6q3I5updwi0t-653ozpE14blQYGrs')] (Background on this er ror at: http://sqlalche.me/e/gkpj) Jan 14 16:41:22 zoidberg.monkeystew.net python[12384]: ERROR:root:Connection is already closed. Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: Exception in thread Thread-2: Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: Traceback (most recent call last): Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/usr/lib64/python3.6/threading.py", line 916, in _bootstrap_inner Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: self.run() Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/usr/lib64/python3.6/threading.py", line 864, in run Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: self._target(*self._args, **self._kwargs) Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/pnut-matrix.py", line 273, in run Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: ws.send(".") Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/env/lib64/python3.6/site-packages/websocket/_app.py", line 153, in send Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: if not self.sock or self.sock.send(data, opcode) == 0: Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/env/lib64/python3.6/site-packages/websocket/_core.py", line 250, in send Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: return self.send_frame(frame) Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/env/lib64/python3.6/site-packages/websocket/_core.py", line 275, in send_frame Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: l = self._send(data) Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/env/lib64/python3.6/site-packages/websocket/_core.py", line 445, in _send Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: return send(self.sock, data) Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: File "/home/nuttybot/pnut-matrix/env/lib64/python3.6/site-packages/websocket/_socket.py", line 114, in send Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: raise WebSocketConnectionClosedException("socket is already closed.") Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: websocket._exceptions.WebSocketConnectionClosedException: socket is already closed. Jan 14 16:41:32 zoidberg.monkeystew.net python[12384]: ERROR:websocket:error from callback <function on_close at 0x7f1efc5418c8>: threads can only be started once </pre> *By Morgan McMillian on 2019-01-15T03:35:54 (imported from GitLab project)*
thrrgilag commented 2019-01-17 01:37:58 +00:00 (Migrated from gitlab.com)

closed via commit 3d3f7d0681

By Morgan McMillian on 2019-01-17T01:37:58 (imported from GitLab project)

closed via commit 3d3f7d068161a3dc549eb88c0967f0916860580f *By Morgan McMillian on 2019-01-17T01:37:58 (imported from GitLab project)*
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: spacenerdmo/pnut-matrix#39
No description provided.