User unable to sign into TDP

### User unable to sign into TDP since 10/6/2023 from user: > From: Scott Boyle <SBoyle@gratonrancheria.com> Sent: Friday, October 6, 2023 3:17 PM To: TANF Data (ACF) <TANFData@acf.hhs.gov> Subject: TANF Data Portal > When I log in to login.gov and click the link to “continue to TANF Data Portal” I get the below message > > ![](https://hackmd.io/_uploads/H1OhKrVZ6.png) It appears that this user was attempting to sign in after getting a deactivation warning email. We asked him to re-attempt the login on 10/10/23, so that we could capture any tracebacks. it is captured below: ``` 16:02:28.203: [APP/PROC/WEB.0] /home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/fields/__init__.py:1416: RuntimeWarning: DateTimeField User.access_requested_date received a naive datetime (0001-01-01 00:00:00) while time zone support is active. 16:02:28.203: [APP/PROC/WEB.0] warnings.warn("DateTimeField %s received a naive datetime (%s)" 16:02:28.209: [APP/PROC/WEB.0] [2023-10-10 20:02:28,205 ERROR login.py::get:L268 : Error attempting to login/register user: duplicate key value violates unique constraint "users_user_username_key" 16:02:28.209: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 16:02:28.209: [APP/PROC/WEB.0] at... 16:02:28.209: [APP/PROC/WEB.0] Traceback (most recent call last): 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute 16:02:28.209: [APP/PROC/WEB.0] return self.cursor.execute(sql, params) 16:02:28.209: [APP/PROC/WEB.0] psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "users_user_username_key" 16:02:28.209: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 16:02:28.209: [APP/PROC/WEB.0] The above exception was the direct cause of the following exception: 16:02:28.209: [APP/PROC/WEB.0] Traceback (most recent call last): 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/api/login.py", line 233, in get 16:02:28.209: [APP/PROC/WEB.0] user = self.handle_user(request, id_token, decoded_payload) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/api/login.py", line 183, in handle_user 16:02:28.209: [APP/PROC/WEB.0] user = User.objects.create_user(email, email=email, **auth_options) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/models.py", line 152, in create_user 16:02:28.209: [APP/PROC/WEB.0] return self._create_user(username, email, password, **extra_fields) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/models.py", line 146, in _create_user 16:02:28.209: [APP/PROC/WEB.0] user.save(using=self._db) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/models.py", line 234, in save 16:02:28.209: [APP/PROC/WEB.0] super(User, self).save(*args, **kwargs) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/base_user.py", line 67, in save 16:02:28.209: [APP/PROC/WEB.0] super().save(*args, **kwargs) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 739, in save 16:02:28.209: [APP/PROC/WEB.0] self.save_base(using=using, force_insert=force_insert, 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 776, in save_base 16:02:28.209: [APP/PROC/WEB.0] updated = self._save_table( 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 881, in _save_table 16:02:28.209: [APP/PROC/WEB.0] results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 919, in _do_insert 16:02:28.209: [APP/PROC/WEB.0] return manager._insert( 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/manager.py", line 85, in manager_method 16:02:28.209: [APP/PROC/WEB.0] return getattr(self.get_queryset(), name)(*args, **kwargs) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/query.py", line 1270, in _insert 16:02:28.209: [APP/PROC/WEB.0] return query.get_compiler(using=using).execute_sql(returning_fields) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1416, in execute_sql 16:02:28.209: [APP/PROC/WEB.0] cursor.execute(sql, params) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 66, in execute 16:02:28.209: [APP/PROC/WEB.0] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers 16:02:28.209: [APP/PROC/WEB.0] return executor(sql, params, many, context) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 79, in _execute 16:02:28.209: [APP/PROC/WEB.0] with self.db.wrap_database_errors: 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/utils.py", line 90, in __exit__ 16:02:28.209: [APP/PROC/WEB.0] raise dj_exc_value.with_traceback(traceback) from exc_value 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute 16:02:28.209: [APP/PROC/WEB.0] return self.cursor.execute(sql, params) 16:02:28.209: [APP/PROC/WEB.0] django.db.utils.IntegrityError: duplicate key value violates unique constraint "users_user_username_key" 16:02:28.209: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 16:02:28.209: [APP/PROC/WEB.0] Error attempting to login/register user: duplicate key value violates unique constraint "users_user_username_key" 16:02:28.209: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 16:02:28.209: [APP/PROC/WEB.0] at... 16:02:28.209: [APP/PROC/WEB.0] Traceback (most recent call last): 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute 16:02:28.209: [APP/PROC/WEB.0] return self.cursor.execute(sql, params) 16:02:28.209: [APP/PROC/WEB.0] psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "users_user_username_key" 16:02:28.209: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 16:02:28.209: [APP/PROC/WEB.0] The above exception was the direct cause of the following exception: 16:02:28.209: [APP/PROC/WEB.0] Traceback (most recent call last): 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/api/login.py", line 233, in get 16:02:28.209: [APP/PROC/WEB.0] user = self.handle_user(request, id_token, decoded_payload) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/api/login.py", line 183, in handle_user 16:02:28.209: [APP/PROC/WEB.0] user = User.objects.create_user(email, email=email, **auth_options) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/models.py", line 152, in create_user 16:02:28.209: [APP/PROC/WEB.0] return self._create_user(username, email, password, **extra_fields) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/models.py", line 146, in _create_user 16:02:28.209: [APP/PROC/WEB.0] user.save(using=self._db) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/models.py", line 234, in save 16:02:28.209: [APP/PROC/WEB.0] super(User, self).save(*args, **kwargs) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/base_user.py", line 67, in save 16:02:28.209: [APP/PROC/WEB.0] super().save(*args, **kwargs) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 739, in save 16:02:28.209: [APP/PROC/WEB.0] self.save_base(using=using, force_insert=force_insert, 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 776, in save_base 16:02:28.209: [APP/PROC/WEB.0] updated = self._save_table( 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 881, in _save_table 16:02:28.209: [APP/PROC/WEB.0] results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 919, in _do_insert 16:02:28.209: [APP/PROC/WEB.0] return manager._insert( 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/manager.py", line 85, in manager_method 16:02:28.209: [APP/PROC/WEB.0] return getattr(self.get_queryset(), name)(*args, **kwargs) 16:02:28.209: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/query.py", line 1270, in _insert 16:02:28.209: [APP/PROC/WEB.0] return query.get_compiler(using=using).execute_sql(returning_fields) 16:02:28.210: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1416, in execute_sql 16:02:28.210: [APP/PROC/WEB.0] cursor.execute(sql, params) 16:02:28.210: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 66, in execute 16:02:28.210: [APP/PROC/WEB.0] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) 16:02:28.210: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers 16:02:28.210: [APP/PROC/WEB.0] return executor(sql, params, many, context) 16:02:28.210: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 79, in _execute 16:02:28.210: [APP/PROC/WEB.0] with self.db.wrap_database_errors: 16:02:28.210: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/utils.py", line 90, in __exit__ 16:02:28.210: [APP/PROC/WEB.0] raise dj_exc_value.with_traceback(traceback) from exc_value 16:02:28.210: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute 16:02:28.210: [APP/PROC/WEB.0] return self.cursor.execute(sql, params) 16:02:28.210: [APP/PROC/WEB.0] django.db.utils.IntegrityError: duplicate key value violates unique constraint "users_user_username_key" 16:02:28.210: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 16:02:28.211: [APP/PROC/WEB.0] WARNING Bad Request: /v1/login/ ``` We asked the user how he accessed TDP, and they said the following: > I just typed in login.gov and it brought me to the log-in page. It might have been saved from an old attempt from an old link. To be sure there was no issue with logging in, we signed into TDP (prod) using gmail credentials, which was successful. We also tried logging in first via login.gov and then navigated to TDP to sign in via login.gov and it was also successful. Additionally, the logs show evidence that other users can successfully login and submit data. --- #### on 10/11/2023, user reported back that they tried again and got the same results. traceback below: ``` 12:23:50.805: [APP/PROC/WEB.0] [2023-10-11 16:23:50,804 ERROR login.py::get:L268 : Error attempting to login/register user: duplicate key value violates unique constraint "users_user_username_key" 12:23:50.805: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 12:23:50.805: [APP/PROC/WEB.0] at... 12:23:50.805: [APP/PROC/WEB.0] Traceback (most recent call last): 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute 12:23:50.805: [APP/PROC/WEB.0] return self.cursor.execute(sql, params) 12:23:50.805: [APP/PROC/WEB.0] psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "users_user_username_key" 12:23:50.805: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 12:23:50.805: [APP/PROC/WEB.0] The above exception was the direct cause of the following exception: 12:23:50.805: [APP/PROC/WEB.0] Traceback (most recent call last): 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/api/login.py", line 233, in get 12:23:50.805: [APP/PROC/WEB.0] user = self.handle_user(request, id_token, decoded_payload) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/api/login.py", line 183, in handle_user 12:23:50.805: [APP/PROC/WEB.0] user = User.objects.create_user(email, email=email, **auth_options) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/models.py", line 152, in create_user 12:23:50.805: [APP/PROC/WEB.0] return self._create_user(username, email, password, **extra_fields) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/models.py", line 146, in _create_user 12:23:50.805: [APP/PROC/WEB.0] user.save(using=self._db) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/models.py", line 234, in save 12:23:50.805: [APP/PROC/WEB.0] super(User, self).save(*args, **kwargs) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/base_user.py", line 67, in save 12:23:50.805: [APP/PROC/WEB.0] super().save(*args, **kwargs) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 739, in save 12:23:50.805: [APP/PROC/WEB.0] self.save_base(using=using, force_insert=force_insert, 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 776, in save_base 12:23:50.805: [APP/PROC/WEB.0] updated = self._save_table( 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 881, in _save_table 12:23:50.805: [APP/PROC/WEB.0] results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 919, in _do_insert 12:23:50.805: [APP/PROC/WEB.0] return manager._insert( 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/manager.py", line 85, in manager_method 12:23:50.805: [APP/PROC/WEB.0] return getattr(self.get_queryset(), name)(*args, **kwargs) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/query.py", line 1270, in _insert 12:23:50.805: [APP/PROC/WEB.0] return query.get_compiler(using=using).execute_sql(returning_fields) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1416, in execute_sql 12:23:50.805: [APP/PROC/WEB.0] cursor.execute(sql, params) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 66, in execute 12:23:50.805: [APP/PROC/WEB.0] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers 12:23:50.805: [APP/PROC/WEB.0] return executor(sql, params, many, context) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 79, in _execute 12:23:50.805: [APP/PROC/WEB.0] with self.db.wrap_database_errors: 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/utils.py", line 90, in __exit__ 12:23:50.805: [APP/PROC/WEB.0] raise dj_exc_value.with_traceback(traceback) from exc_value 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute 12:23:50.805: [APP/PROC/WEB.0] return self.cursor.execute(sql, params) 12:23:50.805: [APP/PROC/WEB.0] django.db.utils.IntegrityError: duplicate key value violates unique constraint "users_user_username_key" 12:23:50.805: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 12:23:50.805: [APP/PROC/WEB.0] Error attempting to login/register user: duplicate key value violates unique constraint "users_user_username_key" 12:23:50.805: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 12:23:50.805: [APP/PROC/WEB.0] at... 12:23:50.805: [APP/PROC/WEB.0] Traceback (most recent call last): 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute 12:23:50.805: [APP/PROC/WEB.0] return self.cursor.execute(sql, params) 12:23:50.805: [APP/PROC/WEB.0] psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "users_user_username_key" 12:23:50.805: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 12:23:50.805: [APP/PROC/WEB.0] The above exception was the direct cause of the following exception: 12:23:50.805: [APP/PROC/WEB.0] Traceback (most recent call last): 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/api/login.py", line 233, in get 12:23:50.805: [APP/PROC/WEB.0] user = self.handle_user(request, id_token, decoded_payload) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/api/login.py", line 183, in handle_user 12:23:50.805: [APP/PROC/WEB.0] user = User.objects.create_user(email, email=email, **auth_options) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/models.py", line 152, in create_user 12:23:50.805: [APP/PROC/WEB.0] return self._create_user(username, email, password, **extra_fields) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/models.py", line 146, in _create_user 12:23:50.805: [APP/PROC/WEB.0] user.save(using=self._db) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/app/tdpservice/users/models.py", line 234, in save 12:23:50.805: [APP/PROC/WEB.0] super(User, self).save(*args, **kwargs) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/contrib/auth/base_user.py", line 67, in save 12:23:50.805: [APP/PROC/WEB.0] super().save(*args, **kwargs) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 739, in save 12:23:50.805: [APP/PROC/WEB.0] self.save_base(using=using, force_insert=force_insert, 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 776, in save_base 12:23:50.805: [APP/PROC/WEB.0] updated = self._save_table( 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 881, in _save_table 12:23:50.805: [APP/PROC/WEB.0] results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/base.py", line 919, in _do_insert 12:23:50.805: [APP/PROC/WEB.0] return manager._insert( 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/manager.py", line 85, in manager_method 12:23:50.805: [APP/PROC/WEB.0] return getattr(self.get_queryset(), name)(*args, **kwargs) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/query.py", line 1270, in _insert 12:23:50.805: [APP/PROC/WEB.0] return query.get_compiler(using=using).execute_sql(returning_fields) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1416, in execute_sql 12:23:50.805: [APP/PROC/WEB.0] cursor.execute(sql, params) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 66, in execute 12:23:50.805: [APP/PROC/WEB.0] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers 12:23:50.805: [APP/PROC/WEB.0] return executor(sql, params, many, context) 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 79, in _execute 12:23:50.805: [APP/PROC/WEB.0] with self.db.wrap_database_errors: 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/utils.py", line 90, in __exit__ 12:23:50.805: [APP/PROC/WEB.0] raise dj_exc_value.with_traceback(traceback) from exc_value 12:23:50.805: [APP/PROC/WEB.0] File "/home/vcap/deps/1/python/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute 12:23:50.805: [APP/PROC/WEB.0] return self.cursor.execute(sql, params) 12:23:50.805: [APP/PROC/WEB.0] django.db.utils.IntegrityError: duplicate key value violates unique constraint "users_user_username_key" 12:23:50.805: [APP/PROC/WEB.0] DETAIL: Key (username)=(sboyle@gratonrancheria.com) already exists. 12:23:50.806: [APP/PROC/WEB.0] WARNING Bad Request: /v1/login/ 12:23:50.806: [APP/PROC/WEB.0] 10.255.54.110 - - [11/Oct/2023:16:23:50 +0000] "GET /v1/login/?code=82174a6a-89ce-4260-9ec8-734e274028d2&state=5fe8081abf080d6e8667a201f1103dc43789f2402167bc22dc5513e2d19e0a87 HTTP/1.0" 400 83 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.60" ``` --- ### 11/17/2023 Update User returned the following screenshot which suggests account was created and connected to TDP on the day the user reached out. So to resolved, the user's TDP account was deleted. He can request access again. evidence below: ![SB_user](https://hackmd.io/_uploads/r1jGa4BV6.png) ``` In [1]: user = User.objects.get(username='sboyle@gratonrancheria.com') In [2]: user Out[2]: <User: sboyle@gratonrancheria.com> In [3]: user.delete() Out[3]: (10, {'admin.LogEntry': 8, 'users.User_groups': 1, 'users.User': 1}) ```

Syntax	Example	Reference
# Header	Header	基本排版
- Unordered List	Unordered List
1. Ordered List	Ordered List
- [ ] Todo List	Todo List
> Blockquote	Blockquote
Bold font	Bold font
Italics font	Italics font
~~Strikethrough~~	~~Strikethrough~~
19^th^	19^th
H~2~O	H₂O
++Inserted text++	Inserted text
==Marked text==	Marked text
[link text](https:// "title")	Link
![image alt](https:// "title")	Image
`Code`	`Code`	在筆記中貼入程式碼
```javascript var i = 0; ```	`var i = 0;`
:smile:		Emoji list
{%youtube youtube_id %}	Externals
$L^aT_eX$	L^aT_eX
:::info This is a alert area. :::	This is a alert area.