Locking issue with sherlock cache

[gpfrancis]

('ZTF20abckvit','AGN',%s) ON DUPLICATE KEY UPDATE class=VALUES(class), crossmatch=VALUES(crossmatch) Traceback (most recent call last): File "/wrapper.py", line 372, in run(conf, log) File "/wrapper.py", line 305, in run n = consume(conf, log, alerts, consumer) File "/wrapper.py", line 82, in consume n_classified = classify(conf, log, alerts) File "/wrapper.py", line 235, in classify cursor.execute(query, crossmatches) File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')

[tms-epcc]

14/JUL/21

• @gpfrancis explained this is currently blocked by a Sherlock issue

[tms-epcc]

06/OCT/21

• as discussed with @gpfrancis via email, this is not a priority for Lasair cycle 5 and hence is moved into the backlog.