2021-01-18 00:45:24,781: Exception on /espace_personnel/editer_photographie/5122 [POST] Traceback (most recent call last): File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1284, in _execute_context cursor, statement, parameters, context File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: UNIQUE constraint failed: catalogage.N_inventaire_index NO MATCH The above exception was the direct cause of the following exception: NO MATCH Traceback (most recent call last): File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/app.py", line 2447, in wsgi_app response = self.full_dispatch_request() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/app.py", line 1952, in full_dispatch_request rv = self.handle_user_exception(e) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/app.py", line 1821, in handle_user_exception reraise(exc_type, exc_value, tb) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise raise value File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/app.py", line 1950, in full_dispatch_request rv = self.dispatch_request() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/app.py", line 1936, in dispatch_request return self.view_functionsrule.endpoint File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask_login/utils.py", line 272, in decorated_view return func(*args, *kwargs) File "/home/ParisHistoriqueInventaire/InventaireParisHistorique/app/routes/catalogage.py", line 201, in editer_photographie db.session.commit() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/scoping.py", line 163, in do return getattr(self.registry(), name)(args, **kwargs) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1042, in commit self.transaction.commit() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 504, in commit self._prepare_impl() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 483, in _prepare_impl self.session.flush() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2523, in flush self._flush(objects) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2664, in _flush transaction.rollback(_capture_exception=True) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit exc_value, with_traceback=exctb, File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise raise exception File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2624, in _flush flush_context.execute() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute rec.execute(self) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute uow, File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 236, in save_obj update, File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 995, in _emit_update_statements statement, multiparams File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1020, in execute return meth(self, multiparams, params) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_clauseelement distilled_params, File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1324, in _execute_context e, statement, parameters, cursor, context File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1518, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=excinfo[2], from=e File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_ raise exception File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1284, in _execute_context cursor, statement, parameters, context File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: catalogage.N_inventaire_index [SQL: UPDATE catalogage SET "N_inventaire_index"=?, "N_inventaire"=?, "Legende"=?, "Auteur"=? WHERE catalogage."N_inventaire_index" = ?] [parameters: (3631, 3631, 'Le Voeu de Louis XIII : Piéta et maître-autel', 22, 5122)] (Background on this error at: http://sqlalche.me/e/gkpj)
Est survenu plusieurs fois
2021-01-18 00:45:24,781: Exception on /espace_personnel/editer_photographie/5122 [POST] Traceback (most recent call last): File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1284, in _execute_context cursor, statement, parameters, context File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: UNIQUE constraint failed: catalogage.N_inventaire_index NO MATCH The above exception was the direct cause of the following exception: NO MATCH Traceback (most recent call last): File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/app.py", line 2447, in wsgi_app response = self.full_dispatch_request() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/app.py", line 1952, in full_dispatch_request rv = self.handle_user_exception(e) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/app.py", line 1821, in handle_user_exception reraise(exc_type, exc_value, tb) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise raise value File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/app.py", line 1950, in full_dispatch_request rv = self.dispatch_request() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask/app.py", line 1936, in dispatch_request return self.view_functionsrule.endpoint File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/flask_login/utils.py", line 272, in decorated_view return func(*args, *kwargs) File "/home/ParisHistoriqueInventaire/InventaireParisHistorique/app/routes/catalogage.py", line 201, in editer_photographie db.session.commit() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/scoping.py", line 163, in do return getattr(self.registry(), name)(args, **kwargs) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1042, in commit self.transaction.commit() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 504, in commit self._prepare_impl() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 483, in _prepare_impl self.session.flush() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2523, in flush self._flush(objects) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2664, in _flush transaction.rollback(_capture_exception=True) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit exc_value, with_traceback=exctb, File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise raise exception File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2624, in _flush flush_context.execute() File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute rec.execute(self) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute uow, File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 236, in save_obj update, File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 995, in _emit_update_statements statement, multiparams File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1020, in execute return meth(self, multiparams, params) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_clauseelement distilled_params, File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1324, in _execute_context e, statement, parameters, cursor, context File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1518, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=excinfo[2], from=e File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_ raise exception File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1284, in _execute_context cursor, statement, parameters, context File "/home/ParisHistoriqueInventaire/.virtualenvs/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: catalogage.N_inventaire_index [SQL: UPDATE catalogage SET "N_inventaire_index"=?, "N_inventaire"=?, "Legende"=?, "Auteur"=? WHERE catalogage."N_inventaire_index" = ?] [parameters: (3631, 3631, 'Le Voeu de Louis XIII : Piéta et maître-autel', 22, 5122)] (Background on this error at: http://sqlalche.me/e/gkpj)