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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions