Skip to content

[Bug]: User can not create an account if the "username" (the first part of email) is already in the system. #8208

@matusdrobuliak66

Description

@matusdrobuliak66

Ex. user: [email protected] is in the database, then user with email [email protected] can not create an account with error. Also this error is not handled and 500 is send to frontend.

aiohttp.monitoring:middleware_handler(124) | log_uid=None | log_oec=None| log_msg=Unexpected server error ""<class 'sqlalchemy.exc.IntegrityError'>"" from access: 10.0.4.171 ""POST /v0/auth/register"" done in 3.73 secs. Responding with status 500
Traceback (most recent call last):
  File ""/home/scu/.venv/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py"", line 442, in _prepare_and_execute
    self._rows = await prepared_stmt.fetch(*parameters)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File ""/home/scu/.venv/lib/python3.11/site-packages/asyncpg/prepared_stmt.py"", line 176, in fetch
    data = await self.__bind_execute(args, 0, timeout)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File ""/home/scu/.venv/lib/python3.11/site-packages/asyncpg/prepared_stmt.py"", line 241, in __bind_execute
    data, status, _ = await self.__do_execute(
                      ^^^^^^^^^^^^^^^^^^^^^^^^
  File ""/home/scu/.venv/lib/python3.11/site-packages/asyncpg/prepared_stmt.py"", line 230, in __do_execute
    return await executor(protocol)
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File ""asyncpg/protocol/protocol.pyx"", line 201, in bind_execute
asyncpg.exceptions.UniqueViolationError: duplicate key value violates unique constraint ""user_name_ukey""
DETAIL:  Key (name)=(matus) already exists.
  • Experienced by inhouse user in the osparc.speag.com
  • Additionally:
    • if user wants to create an account and the account is already in the system, error is not handled and 500 is returned.
    • if user wants to reset a password of account that is not in the system, error is not handled and 500 is returned

Metadata

Metadata

Assignees

Labels

bugbuggy, it does not work as expected

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions