wsteitz
commented
11 years ago I tried a few times and was not able to reproduce this. Do you remember what you did exactly?
Open simpsus opened 11 years ago
wsteitz
commented
11 years ago I tried a few times and was not able to reproduce this. Do you remember what you did exactly?
sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (OperationalError) database is locked u'DELETE FROM account_category WHERE account_category.id = ?' (26,) Traceback (most recent call last): File "/home/bastian/workspace/avernus/avernus/gui/account/account_transactions_tab.py", line 348, in visible_cb if not transaction.category: File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 168, in get return self.impl.get(instancestate(instance),dict) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 453, in get value = self.callable_(state, passive) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 490, in _load_for_state passive File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 531, in _get_ident_for_use_get for pk in self.mapper.primary_key File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1646, in _get_state_attr_bycolumn return state.manager[prop.key].impl.get(state, dict, passive=passive) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 451, in get value = callable_(passive) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/state.py", line 285, in call self.manager.deferred_scalar_loader(self, toload) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1714, in _load_scalar_attributes only_load_props=attribute_names) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2512, in _load_on_ident return q.one() File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2184, in one ret = list(self) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in iter return self._execute_and_instances(context) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2240, in _execute_and_instances close_with_result=True) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2231, in _connection_from_session kw) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 777, in connection close_with_result=close_with_result) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 781, in _connection_for_bind return self.transaction._connection_for_bind(engine) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 289, in _connection_for_bind self._assert_is_active() File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 213, in _assert_is_active % self._rollback_exception sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (OperationalError) database is locked u'DELETE FROM account_category WHERE account_category.id = ?' (26,) Traceback (most recent call last): File "/home/bastian/workspace/avernus/avernus/gui/account/account_transactions_tab.py", line 348, in visible_cb if not transaction.category: File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 168, in get return self.impl.get(instancestate(instance),dict) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 453, in get value = self.callable_(state, passive) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 490, in _load_for_state passive File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 531, in _get_ident_for_use_get for pk in self.mapper.primary_key File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1646, in _get_state_attr_bycolumn return state.manager[prop.key].impl.get(state, dict, passive=passive) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 451, in get value = callable_(passive) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/state.py", line 285, in call self.manager.deferred_scalar_loader(self, toload) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1714, in _load_scalar_attributes only_load_props=attribute_names) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2512, in _load_on_ident return q.one() File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2184, in one ret = list(self) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in iter return self._execute_and_instances(context) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2240, in _execute_and_instances close_with_result=True) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2231, in _connection_from_session kw) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 777, in connection close_with_result=close_with_result) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 781, in _connection_for_bind return self.transaction._connection_for_bind(engine) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 289, in _connection_for_bind self._assert_is_active() File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 213, in _assert_is_active % self._rollback_exception