agdsn-sentry[bot]

Sentry Issue: [PYCROFT-6A](https://sentry.agdsn.de/organizations/sentry/issues/1272/?referrer=github_integration) ``` NumericValueOutOfRange: integer out of range File "sqlalchemy/engine/base.py", line 1965, in _exec_single_context self.dialect.do_execute( File "sqlalchemy/engine/default.py", line 921, in do_execute cursor.execute(statement, parameters) DataError: (psycopg2.errors.NumericValueOutOfRange) integer out of range...

user_memberships_query sometimes returns [None]

1

Sentry Issue: [PYCROFT-5N](https://sentry.agdsn.de/organizations/sentry/issues/1171/?referrer=github_integration) ``` ValidationError: 1 validation error for MembershipRow denies.0 Input should be a valid string [type=string_type, input_value=None, input_type=NoneType] For further information visit https://errors.pydantic.dev/2.0.3/v/string_type (2 additional frame(s) were not...

Sentry Issue: [PYCROFT-5M](https://sentry.agdsn.de/organizations/sentry/issues/1165/?referrer=github_integration) ``` 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...

MultipleResultsFound: Multiple rows were found when one or none was required

1

Sentry Issue: [PYCROFT-3G](https://sentry.agdsn.de/organizations/sentry/issues/694/?referrer=github_integration) ``` MultipleResultsFound: Multiple rows were found when one or none was required (12 additional frame(s) were not displayed) ... File "pycroft/lib/user.py", line 364, in move_in room =...

Sentry Issue: [PYCROFT-7E](https://sentry.agdsn.de/organizations/sentry/issues/1429/?referrer=github_integration) ``` Unable to send mail: "Bitte bestätige deine E-Mail Adresse // Please confirm your email address" to "[email protected]": SMTPRecipientsRefused({'[email protected]': (450, b'4.1.1 : Recipient address rejected: unverified address:...

N+1 Query in `user.member_request_edit`

4

This causes 41(!!) lazy fetches on every request, adding up to `~120ms`. Sentry Issue: [PYCROFT-9D](https://sentry.agdsn.de/organizations/sentry/issues/1611/?referrer=github_integration) | | | | ------------- | --------------- | | **Offending Spans** | db - SELECT...

N+1 Query in `user_show_logs_json`

1

Sentry Issue: [PYCROFT-9C](https://sentry.agdsn.de/organizations/sentry/issues/1610/?referrer=github_integration) | | | | ------------- | --------------- | | **Offending Spans** | db - SELECT "user".account_id AS user_account_i...