Skip to content

Instantly share code, notes, and snippets.

@bgirardot
Created March 14, 2017 11:01
Show Gist options
  • Save bgirardot/711ee5bcc84925d9a20e92c5f0c71deb to your computer and use it in GitHub Desktop.
Save bgirardot/711ee5bcc84925d9a20e92c5f0c71deb to your computer and use it in GitHub Desktop.
TM2 Edit Project Error
app_green_1 | StaleDataError: DELETE statement on table 'project_priority_areas' expected to delete 1 row(s); Only 2 were matched.
app_green_1 | [2017-03-14 10:49:37 +0000] [19] [ERROR] Error handling request /project/2333/edit
app_green_1 | Traceback (most recent call last):
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 135, in handle
app_green_1 | self.handle_request(listener, req, client, addr)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 176, in handle_request
app_green_1 | respiter = self.wsgi(environ, resp.start_response)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__
app_green_1 | response = self.invoke_subrequest(request, use_tweens=True)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest
app_green_1 | response = handle_request(request)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween
app_green_1 | response = handler(request)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid_exclog/__init__.py", line 115, in exclog_tween
app_green_1 | _handle_error(request, getLogger, get_message)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid_exclog/__init__.py", line 111, in exclog_tween
app_green_1 | return handler(request)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 119, in tm_tween
app_green_1 | reraise(*exc_info)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 98, in tm_tween
app_green_1 | response = handler(request)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid/router.py", line 145, in handle_request
app_green_1 | view_name
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid/view.py", line 527, in _call_view
app_green_1 | response = view_callable(context, request)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid/config/views.py", line 243, in _secured_view
app_green_1 | return view(context, request)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid/config/views.py", line 352, in rendered_view
app_green_1 | result = view(context, request)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/pyramid/config/views.py", line 506, in _requestonly_view
app_green_1 | response = view(request)
app_green_1 | File "/opt/app/osmtm/views/project.py", line 308, in project_edit
app_green_1 | DBSession.flush()
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py", line 150, in do
app_green_1 | return getattr(self.registry(), name)(*args, **kwargs)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1985, in flush
app_green_1 | self._flush(objects)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2103, in _flush
app_green_1 | transaction.rollback(_capture_exception=True)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
app_green_1 | compat.reraise(exc_type, exc_value, exc_tb)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2067, in _flush
app_green_1 | flush_context.execute()
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute
app_green_1 | rec.execute(self)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 481, in execute
app_green_1 | self.dependency_processor.process_saves(uow, states)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/sqlalchemy/orm/dependency.py", line 1090, in process_saves
app_green_1 | secondary_update, secondary_delete)
app_green_1 | File "/opt/app/env/lib/python2.7/site-packages/sqlalchemy/orm/dependency.py", line 1111, in _run_crud
app_green_1 | result.rowcount)
app_green_1 | StaleDataError: DELETE statement on table 'project_priority_areas' expected to delete 1 row(s); Only 2 were matched.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment