Unlink explicitly committed / rolled back transaction from its session.

[tseaver]

Each session holds onto a reference to its "active" transaction. If the application commits or rolls back that transaction explicitly (rather than via our APIs), it should be unlinked from the session.