Created
March 3, 2021 10:44
-
-
Save mtreacy002/09ce6d8bebd9f2a5ec3e79fe1566411b to your computer and use it in GitHub Desktop.
terminal error pr-189
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
127.0.0.1 - - [03/Mar/2021 21:18:35] "PUT /organization HTTP/1.1" 500 - | |
INFO:werkzeug:127.0.0.1 - - [03/Mar/2021 21:18:35] "PUT /organization HTTP/1.1" 500 - | |
Traceback (most recent call last): | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context | |
context) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute | |
cursor.execute(statement, parameters) | |
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "uq_organizations_name" | |
DETAIL: Key (name)=(MTreacy.Co) already exists. | |
The above exception was the direct cause of the following exception: | |
Traceback (most recent call last): | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2463, in __call__ | |
return self.wsgi_app(environ, start_response) | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2449, in wsgi_app | |
response = self.handle_exception(e) | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/api.py", line 599, in error_router | |
return original_handler(f) | |
File "/usr/local/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function | |
return cors_after_request(app.make_response(f(*args, **kwargs))) | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1866, in handle_exception | |
reraise(exc_type, exc_value, tb) | |
File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise | |
raise value | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/api.py", line 597, in error_router | |
return self.handle_error(e) | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app | |
response = self.full_dispatch_request() | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request | |
rv = self.handle_user_exception(e) | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/api.py", line 599, in error_router | |
return original_handler(f) | |
File "/usr/local/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function | |
return cors_after_request(app.make_response(f(*args, **kwargs))) | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception | |
reraise(exc_type, exc_value, tb) | |
File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise | |
raise value | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/api.py", line 597, in error_router | |
return self.handle_error(e) | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request | |
rv = self.dispatch_request() | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request | |
return self.view_functions[rule.endpoint](**req.view_args) | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/api.py", line 339, in wrapper | |
resp = resource(*args, **kwargs) | |
File "/usr/local/lib/python3.7/site-packages/flask/views.py", line 89, in view | |
return self.dispatch_request(*args, **kwargs) | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/resource.py", line 44, in dispatch_request | |
resp = meth(*args, **kwargs) | |
File "/Users/mayatreacy/Devel/bridge-in-tech-backend/app/api/resources/organizations.py", line 139, in put | |
return OrganizationDAO.update_organization(data) | |
File "/Users/mayatreacy/Devel/bridge-in-tech-backend/app/api/dao/organization.py", line 65, in update_organization | |
return update(organization, data, messages.ORGANIZATION_SUCCESSFULLY_CREATED, HTTPStatus.CREATED) | |
File "/Users/mayatreacy/Devel/bridge-in-tech-backend/app/api/dao/organization.py", line 174, in update | |
organization.save_to_db() | |
File "/Users/mayatreacy/Devel/bridge-in-tech-backend/app/database/models/bit_schema/organization.py", line 117, in save_to_db | |
db.session.commit() | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/scoping.py", line 153, in do | |
return getattr(self.registry(), name)(*args, **kwargs) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 943, in commit | |
self.transaction.commit() | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 467, in commit | |
self._prepare_impl() | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 447, in _prepare_impl | |
self.session.flush() | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2254, in flush | |
self._flush(objects) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2380, in _flush | |
transaction.rollback(_capture_exception=True) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__ | |
compat.reraise(exc_type, exc_value, exc_tb) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 187, in reraise | |
raise value | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2344, in _flush | |
flush_context.execute() | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 391, in execute | |
rec.execute(self) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 556, in execute | |
uow | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj | |
mapper, table, insert) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 866, in _emit_insert_statements | |
execute(statement, params) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute | |
return meth(self, multiparams, params) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection | |
return connection._execute_clauseelement(self, multiparams, params) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement | |
compiled_sql, distilled_params | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context | |
context) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception | |
exc_info | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause | |
reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 186, in reraise | |
raise value.with_traceback(tb) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context | |
context) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute | |
cursor.execute(statement, parameters) | |
sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_organizations_name" | |
DETAIL: Key (name)=(MTreacy.Co) already exists. | |
[SQL: 'INSERT INTO bitschema.organizations (rep_id, rep_department, name, email, about, address, website, timezone, phone, status, join_date) VALUES (%(rep_id)s, %(rep_department)s, %(name)s, %(email)s, %(about)s, %(address)s, %(website)s, %(timezone)s, %(phone)s, %(status)s, %(join_date)s) RETURNING bitschema.organizations.id'] [parameters: {'rep_id': 5, 'rep_department': 'HRD', 'name': 'MTreacy.Co', 'email': 'bs@sfbs.vsb', 'about': 'This is about MTreacy.Co', 'address': 'London, UK', 'website': 'http://mtreacy_co.com', 'timezone': 'AMERICA_ARGENTINA_BUENOS_AIRES', 'phone': '123-321-12345', 'status': 'PUBLISH', 'join_date': 1614766715.6570141}] (Background on this error at: http://sqlalche.me/e/gkpj) | |
CRITICAL:root:{'id': 5, 'name': 'Billy Smith', 'username': 'bsmith01', 'email': 'billy@smith.com', 'terms_and_conditions_checked': True, 'is_admin': False, 'registration_date': 1598594329.11893, 'is_email_verified': True, 'email_verification_date': '2020-08-28T15:59:03.849633', 'bio': None, 'location': None, 'occupation': None, 'current_organization': None, 'slack_username': None, 'social_media_links': None, 'skills': None, 'interests': None, 'resume_url': None, 'photo_url': None, 'need_mentoring': True, 'available_to_mentor': True, 'current_mentorship_role': None, 'membership_status': None} | |
CRITICAL:root:{'access_token': 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2MTQ3NjY5ODQsIm5iZiI6MTYxNDc2Njk4NCwianRpIjoiYmY5N2JiOTktZmRkOC00ODAyLWJhOTMtM2NjYzEzNmY4ZmZlIiwiZXhwIjoxNjE1MzcxNzg0LCJpZGVudGl0eSI6NSwiZnJlc2giOmZhbHNlLCJ0eXBlIjoiYWNjZXNzIn0.k9xivc2v05afz-K0uqWKkTcLxFRIiUPgXX0_--pljR8', 'access_expiry': None} | |
127.0.0.1 - - [03/Mar/2021 21:23:04] "POST /login HTTP/1.1" 200 - | |
INFO:werkzeug:127.0.0.1 - - [03/Mar/2021 21:23:04] "POST /login HTTP/1.1" 200 - | |
127.0.0.1 - - [03/Mar/2021 21:27:30] "PUT /organization HTTP/1.1" 400 - | |
INFO:werkzeug:127.0.0.1 - - [03/Mar/2021 21:27:30] "PUT /organization HTTP/1.1" 400 - | |
127.0.0.1 - - [03/Mar/2021 21:27:42] "PUT /organization HTTP/1.1" 201 - | |
INFO:werkzeug:127.0.0.1 - - [03/Mar/2021 21:27:42] "PUT /organization HTTP/1.1" 201 - | |
127.0.0.1 - - [03/Mar/2021 21:28:33] "PUT /organization HTTP/1.1" 500 - | |
INFO:werkzeug:127.0.0.1 - - [03/Mar/2021 21:28:33] "PUT /organization HTTP/1.1" 500 - | |
Traceback (most recent call last): | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context | |
context) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute | |
cursor.execute(statement, parameters) | |
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "uq_organizations_name" | |
DETAIL: Key (name)=(MTreacy.Co) already exists. | |
The above exception was the direct cause of the following exception: | |
Traceback (most recent call last): | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2463, in __call__ | |
return self.wsgi_app(environ, start_response) | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2449, in wsgi_app | |
response = self.handle_exception(e) | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/api.py", line 599, in error_router | |
return original_handler(f) | |
File "/usr/local/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function | |
return cors_after_request(app.make_response(f(*args, **kwargs))) | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1866, in handle_exception | |
reraise(exc_type, exc_value, tb) | |
File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise | |
raise value | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/api.py", line 597, in error_router | |
return self.handle_error(e) | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app | |
response = self.full_dispatch_request() | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request | |
rv = self.handle_user_exception(e) | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/api.py", line 599, in error_router | |
return original_handler(f) | |
File "/usr/local/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function | |
return cors_after_request(app.make_response(f(*args, **kwargs))) | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception | |
reraise(exc_type, exc_value, tb) | |
File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise | |
raise value | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/api.py", line 597, in error_router | |
return self.handle_error(e) | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request | |
rv = self.dispatch_request() | |
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request | |
return self.view_functions[rule.endpoint](**req.view_args) | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/api.py", line 339, in wrapper | |
resp = resource(*args, **kwargs) | |
File "/usr/local/lib/python3.7/site-packages/flask/views.py", line 89, in view | |
return self.dispatch_request(*args, **kwargs) | |
File "/usr/local/lib/python3.7/site-packages/flask_restx/resource.py", line 44, in dispatch_request | |
resp = meth(*args, **kwargs) | |
File "/Users/mayatreacy/Devel/bridge-in-tech-backend/app/api/resources/organizations.py", line 139, in put | |
return OrganizationDAO.update_organization(data) | |
File "/Users/mayatreacy/Devel/bridge-in-tech-backend/app/api/dao/organization.py", line 65, in update_organization | |
return update(organization, data, messages.ORGANIZATION_SUCCESSFULLY_CREATED, HTTPStatus.CREATED) | |
File "/Users/mayatreacy/Devel/bridge-in-tech-backend/app/api/dao/organization.py", line 174, in update | |
organization.save_to_db() | |
File "/Users/mayatreacy/Devel/bridge-in-tech-backend/app/database/models/bit_schema/organization.py", line 117, in save_to_db | |
db.session.commit() | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/scoping.py", line 153, in do | |
return getattr(self.registry(), name)(*args, **kwargs) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 943, in commit | |
self.transaction.commit() | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 467, in commit | |
self._prepare_impl() | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 447, in _prepare_impl | |
self.session.flush() | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2254, in flush | |
self._flush(objects) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2380, in _flush | |
transaction.rollback(_capture_exception=True) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__ | |
compat.reraise(exc_type, exc_value, exc_tb) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 187, in reraise | |
raise value | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2344, in _flush | |
flush_context.execute() | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 391, in execute | |
rec.execute(self) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 556, in execute | |
uow | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj | |
mapper, table, insert) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 866, in _emit_insert_statements | |
execute(statement, params) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute | |
return meth(self, multiparams, params) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection | |
return connection._execute_clauseelement(self, multiparams, params) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement | |
compiled_sql, distilled_params | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context | |
context) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception | |
exc_info | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause | |
reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 186, in reraise | |
raise value.with_traceback(tb) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context | |
context) | |
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute | |
cursor.execute(statement, parameters) | |
sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_organizations_name" | |
DETAIL: Key (name)=(MTreacy.Co) already exists. | |
[SQL: 'INSERT INTO bitschema.organizations (rep_id, rep_department, name, email, about, address, website, timezone, phone, status, join_date) VALUES (%(rep_id)s, %(rep_department)s, %(name)s, %(email)s, %(about)s, %(address)s, %(website)s, %(timezone)s, %(phone)s, %(status)s, %(join_date)s) RETURNING bitschema.organizations.id'] [parameters: {'rep_id': 5, 'rep_department': 'HRD', 'name': 'MTreacy.Co', 'email': 'bsmith01@test.com', 'about': 'This is about MTreacy.Co', 'address': 'London, UK', 'website': 'string', 'timezone': 'AMERICA_ARGENTINA_BUENOS_AIRES', 'phone': '123-456-789', 'status': 'PUBLISH', 'join_date': 1614767313.701453}] (Background on this error at: http://sqlalche.me/e/gkpj) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment