Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#702 closed defect (cant-reproduce)

Deleting account raises stl-table-related SQLAlchemy exception

Reported by: joar Owned by:
Priority: critical Milestone: 0.4.0
Component: programming Keywords: sql
Cc: Aeva, Elrond Parent Tickets:

Description

Trace:

Stacktrace (most recent call last):

  File "raven/middleware.py", line 28, in __call__
    for event in self.application(environ, start_response):
  File "mediagoblin/app.py", line 243, in __call__
    return self.call_backend(environ, start_response)
  File "mediagoblin/app.py", line 220, in call_backend
    response = controller(request)
  File "mediagoblin/decorators.py", line 48, in new_controller_func
    return controller(request, *args, **kwargs)
  File "mediagoblin/edit/views.py", line 276, in delete_account
    request.user.delete()
  File "mediagoblin/db/models.py", line 93, in delete
    media.delete(del_orphan_tags=False, commit=False)
  File "mediagoblin/db/models.py", line 258, in delete
    super(MediaEntry, self).delete(**kwargs)
  File "mediagoblin/db/base.py", line 57, in delete
    sess.delete(self)
  File "sqlalchemy/orm/session.py", line 1297, in delete
    'delete', state))
  File "sqlalchemy/orm/mapper.py", line 1821, in cascade_iterator
    parent_dict, visited_states, halt_on))
  File "sqlalchemy/orm/properties.py", line 821, in cascade_iterator
    passive=passive)
  File "sqlalchemy/orm/state.py", line 122, in value_as_iterable
    x = impl.get(self, dict_, passive=passive)
  File "sqlalchemy/orm/attributes.py", line 453, in get
    value = self.callable_(state, passive)
  File "sqlalchemy/orm/strategies.py", line 508, in _load_for_state
    return self._emit_lazyload(session, state, ident_key)
  File "sqlalchemy/orm/strategies.py", line 552, in _emit_lazyload
    return q._load_on_ident(ident_key)
  File "sqlalchemy/orm/query.py", line 2461, in _load_on_ident
    return q.one()
  File "sqlalchemy/orm/query.py", line 2133, in one
    ret = list(self)
  File "sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)
  File "sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "sqlalchemy/engine/base.py", line 1450, in execute
    params)
  File "sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params
  File "sqlalchemy/engine/base.py", line 1697, in _execute_context
    context)
  File "sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)
  File "sqlalchemy/engine/default.py", line 335, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) relation "stl__mediadata" does not exist
LINE 2: FROM stl__mediadata 
             ^
 'SELECT stl__mediadata.media_entry AS stl__mediadata_media_entry, stl__mediadata.center_x AS stl__mediadata_center_x, stl__mediadata.center_y AS stl__mediadata_center_y, stl__mediadata.center_z AS stl__mediadata_center_z, stl__mediadata.width AS stl__mediadata_width, stl__mediadata.height AS stl__mediadata_height, stl__mediadata.depth AS stl__mediadata_depth, stl__mediadata.file_type AS stl__mediadata_file_type \nFROM stl__mediadata \nWHERE stl__mediadata.media_entry = %(param_1)s' {'param_1': 2738}

Sentry: http://sentry.talka.tv/mediagoblin/gobblin/group/466/

Subtickets

Change History (2)

comment:1 Changed 7 years ago by joar

Resolution: worksforme
Status: newclosed

Hi Joar, you should try running bin/gmg dbupdate!

comment:2 Changed 7 years ago by Elrond

Milestone: 0.4.10.4.0

This one definitely not fixed for 0.4.1 (we didn't release that at all).
Probably fixed/worksforme for the upcoming 0.4.0 release.

Note: See TracTickets for help on using tickets.