Skip to content

sqlalchemy.exc.InvalidRequestError: This session is in 'prepared' state; no further SQL can be emitted within this transaction. #2759

@SIGSTACKFAULT

Description

@SIGSTACKFAULT

Upon launching Pyfa, i get the "Error!" popup with this message. It tells me to file a GitHub issue, so here I am.

pyfa v2.66.3
EVE Data Version: 3326071 (2026-04-30 09:25:40)

OS version: Linux-6.19.14-arch1-1-x86_64-with-glibc2.40
Python version: 3.12.12 (main, Nov 10 2011, 15:00:00) [GCC 14.3.0]
wxPython version: 4.2.2 (wxWidgets 3.2.6)
SQLAlchemy version: 1.4.50
Logbook version: 1.7.0.post0
Requests version: 2.31.0
Dateutil version: 2.8.2

####################

Traceback (most recent call last):
  File "/app/lib/pyfa/gui/builtinViews/fittingView.py", line 93, in fitSelected
    view.fitSelected(event)
  File "/app/lib/pyfa/gui/builtinViews/fittingView.py", line 353, in fitSelected
    self.slotsChanged()
  File "/app/lib/pyfa/gui/builtinViews/fittingView.py", line 612, in slotsChanged
    self.generateMods()
  File "/app/lib/pyfa/gui/builtinViews/fittingView.py", line 549, in generateMods
    fit = sFit.getFit(self.activeFitID)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/pyfa/service/fit.py", line 349, in getFit
    self.recalc(fit)
  File "/app/lib/pyfa/service/fit.py", line 538, in recalc
    fit.clear()
  File "/app/lib/pyfa/eos/saveddata/fit.py", line 544, in clear
    self.modules,
    ^^^^^^^^^^^^
  File "/app/lib/pyfa/eos/saveddata/fit.py", line 309, in modules
    return self.__modules
           ^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 487, in __get__
    return self.impl.get(state, dict_)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 959, in get
    value = self._fire_loader_callables(state, key, passive)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 995, in _fire_loader_callables
    return self.callable_(state, passive)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state
    return self._emit_lazyload(
           ^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/strategies.py", line 1050, in _emit_lazyload
    result = result.unique().scalars().all()
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/engine/result.py", line 1476, in all
    return self._allrows()
           ^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/engine/result.py", line 401, in _allrows
    rows = self._fetchall_impl()
           ^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/engine/result.py", line 1389, in _fetchall_impl
    return self._real_result._fetchall_impl()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/engine/result.py", line 1813, in _fetchall_impl
    return list(self.iterator)
           ^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/loading.py", line 151, in chunks
    rows = [proc(row) for row in fetch]
            ^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/loading.py", line 984, in _instance
    state.manager.dispatch.load(state, context)
  File "/app/lib/python3.12/site-packages/sqlalchemy/event/attr.py", line 334, in __call__
    fn(*args, **kw)
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/mapper.py", line 3702, in _event_on_load
    instrumenting_mapper._reconstructor(state.obj())
  File "/app/lib/pyfa/eos/saveddata/module.py", line 117, in init
    self.build()
  File "/app/lib/pyfa/eos/saveddata/module.py", line 141, in build
    self.__itemModifiedAttributes.overrides = self._item.overrides
                                              ^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/pyfa/eos/gamedata.py", line 288, in overrides
    overrides = eos.db.getOverrides(self.ID)
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/pyfa/eos/db/saveddata/queries.py", line 518, in getOverrides
    return saveddata_session.query(Override).filter(Override.itemID == itemID).all()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/query.py", line 2773, in all
    return self._iter().all()
           ^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
    result = self.session.execute(
             ^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 1716, in execute
    conn = self._connection_for_bind(bind)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 1555, in _connection_for_bind
    return self._transaction._connection_for_bind(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 724, in _connection_for_bind
    self._assert_active()
  File "/app/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 597, in _assert_active
    raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: This session is in 'prepared' state; no further SQL can be emitted within this transaction.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions