IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if th...

[agdsn-sentry]

Sentry Issue: PYCROFT-5M

UniqueViolation: duplicate key value violates unique constraint "interface_mac_key"
DETAIL:  Key (mac)=(b4:b0:24:06:47:1f) already exists.

  File "sqlalchemy/engine/base.py", line 1968, in _exec_single_context
    self.dialect.do_execute(
  File "sqlalchemy/engine/default.py", line 920, in do_execute
    cursor.execute(statement, parameters)

IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "interface_mac_key"
DETAIL:  Key (mac)=(b4:b0:24:06:47:1f) already exists.

[SQL: UPDATE interface SET mac=%(mac)s WHERE interface.id = %(interface_id)s]
[parameters: {'mac': 'b4b02406471f', 'interface_id': 16750}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)
(26 additional frame(s) were not displayed)
...
  File "sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
  File "sqlalchemy/engine/base.py", line 1987, in _exec_single_context
    self._handle_dbapi_exception(
  File "sqlalchemy/engine/base.py", line 2344, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "sqlalchemy/engine/base.py", line 1968, in _exec_single_context
    self.dialect.do_execute(
  File "sqlalchemy/engine/default.py", line 920, in do_execute
    cursor.execute(statement, parameters)

Unexpected error when handling web response