Opened 11 years ago

Closed 11 years ago

Last modified 11 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:



Stacktrace (most recent call last):

  File "raven/", line 28, in __call__
    for event in self.application(environ, start_response):
  File "mediagoblin/", line 243, in __call__
    return self.call_backend(environ, start_response)
  File "mediagoblin/", line 220, in call_backend
    response = controller(request)
  File "mediagoblin/", line 48, in new_controller_func
    return controller(request, *args, **kwargs)
  File "mediagoblin/edit/", line 276, in delete_account
  File "mediagoblin/db/", line 93, in delete
    media.delete(del_orphan_tags=False, commit=False)
  File "mediagoblin/db/", line 258, in delete
    super(MediaEntry, self).delete(**kwargs)
  File "mediagoblin/db/", line 57, in delete
  File "sqlalchemy/orm/", line 1297, in delete
    'delete', state))
  File "sqlalchemy/orm/", line 1821, in cascade_iterator
    parent_dict, visited_states, halt_on))
  File "sqlalchemy/orm/", line 821, in cascade_iterator
  File "sqlalchemy/orm/", line 122, in value_as_iterable
    x = impl.get(self, dict_, passive=passive)
  File "sqlalchemy/orm/", line 453, in get
    value = self.callable_(state, passive)
  File "sqlalchemy/orm/", line 508, in _load_for_state
    return self._emit_lazyload(session, state, ident_key)
  File "sqlalchemy/orm/", line 552, in _emit_lazyload
    return q._load_on_ident(ident_key)
  File "sqlalchemy/orm/", line 2461, in _load_on_ident
  File "sqlalchemy/orm/", line 2133, in one
    ret = list(self)
  File "sqlalchemy/orm/", line 2176, in __iter__
    return self._execute_and_instances(context)
  File "sqlalchemy/orm/", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "sqlalchemy/engine/", line 1450, in execute
  File "sqlalchemy/engine/", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params
  File "sqlalchemy/engine/", line 1697, in _execute_context
  File "sqlalchemy/engine/", line 1690, in _execute_context
  File "sqlalchemy/engine/", 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}


Change History (2)

comment:1 by joar, 11 years ago

Resolution: worksforme
Status: newclosed

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

comment:2 by Elrond, 11 years ago


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.