Skip to content
CI

Tests: check existing username case-insensitive #343

Sign in to view logs

Tests: check existing username case-insensitive

Tests: check existing username case-insensitive #343

Triggered via pull request March 18, 2024 12:09
@ptamaritptamarit
reopened #167
ptamarit:username-case-insensitive-uniqueness-check
Status Failure
Total duration 1m 52s
Artifacts –

tests.yml

on: pull_request
Matrix: Tests
Fit to window
Zoom out
Zoom in

Annotations

21 errors and 2 warnings
Tests (3.9, pypi, postgresql12): tests/test_views.py#L191
test_profile_name_exists sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_accounts_user_username" DETAIL: Key (username)=(existingname) already exists. [SQL: UPDATE accounts_user SET updated=%(updated)s, username=%(username)s, displayname=%(displayname)s, version_id=%(version_id)s, profile=%(profile)s WHERE accounts_user.id = %(accounts_user_id)s AND accounts_user.version_id = %(accounts_user_version_id)s] [parameters: {'updated': datetime.datetime(2024, 3, 18, 12, 10, 42, 551836), 'username': 'existingname', 'displayname': 'eXISTINGnAME', 'version_id': 3, 'profile': '{"full_name": "Another name", "affiliations": ""}', 'accounts_user_id': 2, 'accounts_user_version_id': 2}] (Background on this error at: https://sqlalche.me/e/14/gkpj)
Tests (3.9, pypi, postgresql12)
Process completed with exit code 1.
Tests (3.9, pypi, postgresql14)
The job was canceled because "_3_9_pypi_postgresql12" failed.
Tests (3.9, pypi, postgresql14): tests/test_views.py#L191
test_profile_name_exists sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_accounts_user_username" DETAIL: Key (username)=(existingname) already exists. [SQL: UPDATE accounts_user SET updated=%(updated)s, username=%(username)s, displayname=%(displayname)s, version_id=%(version_id)s, profile=%(profile)s WHERE accounts_user.id = %(accounts_user_id)s AND accounts_user.version_id = %(accounts_user_version_id)s] [parameters: {'updated': datetime.datetime(2024, 3, 18, 12, 10, 44, 828346), 'username': 'existingname', 'displayname': 'eXISTINGnAME', 'version_id': 3, 'profile': '{"full_name": "Another name", "affiliations": ""}', 'accounts_user_id': 2, 'accounts_user_version_id': 2}] (Background on this error at: https://sqlalche.me/e/14/gkpj)
Tests (3.9, pypi, postgresql14)
Process completed with exit code 1.
Tests (3.9, pypi, mysql8)
The job was canceled because "_3_9_pypi_postgresql12" failed.
Tests (3.9, pypi, postgresql13)
The job was canceled because "_3_9_pypi_postgresql12" failed.
Tests (3.9, pypi, mysql8): tests/test_views.py#L191
test_profile_name_exists sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_accounts_user_username" DETAIL: Key (username)=(existingname) already exists. [SQL: UPDATE accounts_user SET updated=%(updated)s, username=%(username)s, displayname=%(displayname)s, version_id=%(version_id)s, profile=%(profile)s WHERE accounts_user.id = %(accounts_user_id)s AND accounts_user.version_id = %(accounts_user_version_id)s] [parameters: {'updated': datetime.datetime(2024, 3, 18, 12, 10, 50, 52067), 'username': 'existingname', 'displayname': 'eXISTINGnAME', 'version_id': 3, 'profile': '{"full_name": "Another name", "affiliations": ""}', 'accounts_user_id': 2, 'accounts_user_version_id': 2}] (Background on this error at: https://sqlalche.me/e/14/gkpj)
Tests (3.9, pypi, postgresql13): tests/test_views.py#L191
test_profile_name_exists sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_accounts_user_username" DETAIL: Key (username)=(existingname) already exists. [SQL: UPDATE accounts_user SET updated=%(updated)s, username=%(username)s, displayname=%(displayname)s, version_id=%(version_id)s, profile=%(profile)s WHERE accounts_user.id = %(accounts_user_id)s AND accounts_user.version_id = %(accounts_user_version_id)s] [parameters: {'updated': datetime.datetime(2024, 3, 18, 12, 10, 50, 284944), 'username': 'existingname', 'displayname': 'eXISTINGnAME', 'version_id': 3, 'profile': '{"full_name": "Another name", "affiliations": ""}', 'accounts_user_id': 2, 'accounts_user_version_id': 2}] (Background on this error at: https://sqlalche.me/e/14/gkpj)
Tests (3.9, pypi, mysql8)
The operation was canceled.
Tests (3.9, pypi, postgresql13)
The operation was canceled.
Tests (3.8, pypi, postgresql13)
The job was canceled because "_3_9_pypi_postgresql12" failed.
Tests (3.8, pypi, postgresql13): tests/test_views.py#L191
test_profile_name_exists sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_accounts_user_username" DETAIL: Key (username)=(existingname) already exists. [SQL: UPDATE accounts_user SET updated=%(updated)s, username=%(username)s, displayname=%(displayname)s, version_id=%(version_id)s, profile=%(profile)s WHERE accounts_user.id = %(accounts_user_id)s AND accounts_user.version_id = %(accounts_user_version_id)s] [parameters: {'updated': datetime.datetime(2024, 3, 18, 12, 10, 53, 528705), 'username': 'existingname', 'displayname': 'eXISTINGnAME', 'version_id': 3, 'profile': '{"full_name": "Another name", "affiliations": ""}', 'accounts_user_id': 2, 'accounts_user_version_id': 2}] (Background on this error at: https://sqlalche.me/e/14/gkpj)
Tests (3.8, pypi, postgresql13)
The operation was canceled.
Tests (3.8, pypi, postgresql14)
The job was canceled because "_3_9_pypi_postgresql12" failed.
Tests (3.8, pypi, postgresql14)
The operation was canceled.
Tests (3.8, pypi, postgresql12)
The job was canceled because "_3_9_pypi_postgresql12" failed.
Tests (3.8, pypi, postgresql12): tests/test_views.py#L191
test_profile_name_exists sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_accounts_user_username" DETAIL: Key (username)=(existingname) already exists. [SQL: UPDATE accounts_user SET updated=%(updated)s, username=%(username)s, displayname=%(displayname)s, version_id=%(version_id)s, profile=%(profile)s WHERE accounts_user.id = %(accounts_user_id)s AND accounts_user.version_id = %(accounts_user_version_id)s] [parameters: {'updated': datetime.datetime(2024, 3, 18, 12, 10, 58, 368270), 'username': 'existingname', 'displayname': 'eXISTINGnAME', 'version_id': 3, 'profile': '{"full_name": "Another name", "affiliations": ""}', 'accounts_user_id': 2, 'accounts_user_version_id': 2}] (Background on this error at: https://sqlalche.me/e/14/gkpj)
Tests (3.8, pypi, postgresql12)
The operation was canceled.
Tests (3.8, pypi, mysql8)
The job was canceled because "_3_9_pypi_postgresql12" failed.
Tests (3.8, pypi, mysql8)
The operation was canceled.
Tests (3.9, pypi, postgresql12)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v2, actions/setup-python@v2, actions/cache@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Tests (3.9, pypi, postgresql12)
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/checkout@v2, actions/setup-python@v2, actions/cache@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/