]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
two_phase_recover, COMMIT PREPARED in transaction
authorTony Locke <tlocke@tlocke.org.uk>
Sat, 26 Jul 2014 19:10:36 +0000 (20:10 +0100)
committerTony Locke <tlocke@tlocke.org.uk>
Sat, 2 Aug 2014 14:29:36 +0000 (15:29 +0100)
commited1bbbed272d6413561a2b5a29873f1021890c0d
treef7b359455b1d4a0a9597a23f211e19669c6851d5
parent2e44749b76af4e9e1a2fd6e52dd329dc1e980216
two_phase_recover, COMMIT PREPARED in transaction

In test/engine/test_transaction/test_two_phase_recover(), a COMMIT
PREPARED is issued while in a transaction. This causes an error, and
a prepared transaction is left hanging around which causes
the subsequent test to hang. I've altered the test to execute the
offending query with autocommit=true, then when it gets to the COMMIT
PRPARED it can go ahead.

There's another complication for pg8000 because its tpc_recover() method
started a transaction if one wasn't already in progress. I've decided
that this is incorrect behaviour and so from pg8000-1.9.13 this method
never starts or stops a transaction.
test/engine/test_transaction.py
test/requirements.py