Thierry, Would you mind putting together a test-case on this? I haven't experienced that before, and I authored that feature in the debugtoolbar. If I can recreate it, I'll put together a fix and work with the pyramid team to get a new release out asap.
On Wednesday, January 27, 2021 at 8:32:34 AM UTC-5 tfl...@gmail.com wrote: > Hi, > I'm actually using SQLAlchemy with Pyramid and zope.sqlalchemy packages. > My main database connection is a ZODB connection and, when required, I > create an SQLAlchemy session which is joined to main transaction using this > kind of code: > > from sqlalchemy.orm import scoped_session, sessionmaker > > from zope.sqlalchemy import register > from zope.sqlalchemy.datamanager import join_transaction > > _engine = get_engine(engine, use_pool) > if use_zope_extension: > factory = scoped_session(sessionmaker(bind=_engine, twophase=True)) > else: > factory = sessionmaker(bind=_engine, twophase=True) > session = factory() > if use_zope_extension: > register(session, initial_state=STATUS_ACTIVE) > if join: > join_transaction(session, initial_state=STATUS_ACTIVE) > > Everything is working correctly! > > So my only question is that I also use Pyramid_debugtoolbar package, which > is tracking many SQLAlchemy events, including two-phase commits > transactions, and which in this context receives transaction IDs as a three > values tuple instead of a simple string (like, for example: (4660, > '12345678901234567890123456789012', '00000000000000000000000000000009'), > which is raising an exception)! > Is it normal behaviour, and what does this value mean? > > Best regards, > Thierry > > -- > https://www.ulthar.net -- http://pyams.readthedocs.io > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/8728dadd-102f-4751-a798-d1a5794145den%40googlegroups.com.