test.engine.test_transaction.TLTransactionTest.test_two_phase_transaction ... INFO:sqlalchemy.pool.QueuePool.0x...0x9b:Connection <PyConnection user='postgres', url='jdbc:postgresql://localhost/test?loglevel=2'> checked out from pool
INFO:sqlalchemy.engine.threadlocal.TLEngine.0x...0x9c:INSERT INTO query_users (user_id, user_name) VALUES (?, ?)
INFO:sqlalchemy.engine.threadlocal.TLEngine.0x...0x9c:[1, 'user1']
15:47:29.700 (14) simple execute, handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@51684c4e, maxRows=0, fetchSize=0, flags=1
15:47:29.700 (14)  FE=> Bind(stmt=S_1,portal=null)
15:47:29.700 (14)  FE=> Execute(portal=null,limit=0)
15:47:29.700 (14)  FE=> Parse(stmt=null,query="INSERT INTO query_users (user_id, user_name) VALUES ($1, $2)",oids={23,1043})
15:47:29.700 (14)  FE=> Bind(stmt=null,portal=null,$1=<1>,$2=<user1>)
15:47:29.700 (14)  FE=> Describe(portal=null)
15:47:29.700 (14)  FE=> Execute(portal=null,limit=0)
15:47:29.701 (14)  FE=> Sync
15:47:29.701 (14)  <=BE BindComplete [null]
15:47:29.701 (14)  <=BE CommandStatus(BEGIN)
15:47:29.701 (14)  <=BE ParseComplete [null]
15:47:29.701 (14)  <=BE BindComplete [null]
15:47:29.701 (14)  <=BE NoData
15:47:29.701 (14)  <=BE CommandStatus(INSERT 0 1)
15:47:29.701 (14)  <=BE ReadyForQuery(T)
INFO:sqlalchemy.engine.threadlocal.TLEngine.0x...0x9c:PREPARE TRANSACTION '_sa_d1275cce16caf39839ee0dd7606f25db'
INFO:sqlalchemy.engine.threadlocal.TLEngine.0x...0x9c:()
15:47:29.703 (14) simple execute, handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@d9f72c5, maxRows=0, fetchSize=0, flags=1
15:47:29.704 (14)  FE=> Parse(stmt=null,query="PREPARE TRANSACTION '_sa_d1275cce16caf39839ee0dd7606f25db'",oids={})
15:47:29.704 (14)  FE=> Bind(stmt=null,portal=null)
15:47:29.704 (14)  FE=> Describe(portal=null)
15:47:29.704 (14)  FE=> Execute(portal=null,limit=0)
15:47:29.704 (14)  FE=> Sync
15:47:29.994 (14)  <=BE ParseComplete [null]
15:47:29.994 (14)  <=BE BindComplete [null]
15:47:29.994 (14)  <=BE NoData
15:47:29.994 (14)  <=BE CommandStatus(PREPARE TRANSACTION)
15:47:29.994 (14)  <=BE ReadyForQuery(I)
INFO:sqlalchemy.engine.threadlocal.TLEngine.0x...0x9c:COMMIT PREPARED '_sa_d1275cce16caf39839ee0dd7606f25db'
INFO:sqlalchemy.engine.threadlocal.TLEngine.0x...0x9c:()
15:47:29.998 (14) simple execute, handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@3cb04ab4, maxRows=0, fetchSize=0, flags=1
15:47:29.998 (14)  FE=> Bind(stmt=S_1,portal=null)
15:47:29.998 (14)  FE=> Execute(portal=null,limit=0)
15:47:29.998 (14)  FE=> Parse(stmt=null,query="COMMIT PREPARED '_sa_d1275cce16caf39839ee0dd7606f25db'",oids={})
15:47:29.998 (14)  FE=> Bind(stmt=null,portal=null)
15:47:29.998 (14)  FE=> Describe(portal=null)
15:47:29.998 (14)  FE=> Execute(portal=null,limit=0)
15:47:29.998 (14)  FE=> Sync
15:47:29.999 (14)  <=BE BindComplete [null]
15:47:29.999 (14)  <=BE CommandStatus(BEGIN)
15:47:29.999 (14)  <=BE ParseComplete [null]
15:47:29.999 (14)  <=BE BindComplete [null]
15:47:29.999 (14)  <=BE NoData
15:47:29.999 (14)  <=BE ErrorMessage(ERROR: COMMIT PREPARED cannot run inside a transaction block)
org.postgresql.util.PSQLException: ERROR: COMMIT PREPARED cannot run inside a transaction block