Open rajacsp opened 4 years ago
Traceback (most recent call last): File "/Users/rj/projects/tact-api-2/services/user_service.py", line 73, in add_user session.commit() File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1026, in commit self.transaction.commit() File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 493, in commit self._prepare_impl() File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 472, in _prepare_impl self.session.flush() File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2451, in flush self._flush(objects) File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2589, in _flush transaction.rollback(_capture_exception=True) File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__ compat.reraise(exc_type, exc_value, exc_tb) File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 129, in reraise raise value File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2549, in _flush flush_context.execute() File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute rec.execute(self) File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute uow, File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj insert, File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 1120, in _emit_insert_statements statement, params File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 988, in execute return meth(self, multiparams, params) File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement distilled_params, File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context e, statement, parameters, cursor, context File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception util.raise_from_cause(sqlalchemy_exception, exc_info) File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 128, in reraise raise value.with_traceback(tb) File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context cursor, statement, parameters, context File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: TCT_USER.EMAIL [SQL: INSERT INTO tct_user (username, email, password, fullname, phone, location, linkedin_link, github_link, bitbucket_link, medium_link, website_link, token, token_updated_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('che', 'rj1@gmail.com', 'e223c280550e8a84b0d654a5eabc3c056d6e33d571de7b5972c6041bdb668b8cc3f8ade884b8d776e2613a7b39b2863e3b844ad1099d086c0969b69fb329fbde', None, None, None, None, None, None, None, None, None, None, None)] (Background on this error at: http://sqlalche.me/e/gkpj) 2019-08-19 14:15:27 127.0.0.1 - - [19/Aug/2019 14:15:27] "POST /user/register?username=che&password=test&email=rj1@gmail.com HTTP/1.1" 200 -