Assigned Categories are not shown in the transaction treeview

[simpsus]

And the console is spammed with:

Traceback (most recent call last):
  File "/home/bastian/workspace/avernus/avernus/gui/account/account_transactions_tab.py", line 336, in visible_cb
    transaction = model[iterator][0]
  File "/usr/lib/python2.7/dist-packages/gi/overrides/Gtk.py", line 1136, in __getitem__
    return self.model.get_value(self.iter, key)
  File "/usr/lib/python2.7/dist-packages/gi/types.py", line 47, in function
    return info.invoke(*args, **kwargs)
ValueError: 0 not in range -2147483648 to 2147483647

The categories "work" in the sense that the charts show them and clicking on a category displays only the transactions in said category, but not even then are they shown in the treeview

[simpsus (bastian-kennel)]

Addition: After a restart all the category assignments are gone, and a click on one of the categories gives:

  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 168, in __get__
    return self.impl.get(instance_state(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 508, in _load_for_state
    return self._emit_lazyload(session, state, ident_key)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 574, in _emit_lazyload
    result = q.all()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2115, in all
    return 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'UPDATE account_transaction SET category_id=? WHERE account_transaction.id = ?' (5, 9)
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(instance_state(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 508, in _load_for_state
    return self._emit_lazyload(session, state, ident_key)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 574, in _emit_lazyload
    result = q.all()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2115, in all
    return 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/pyth...