Add test case for session with local transactions.
Add a timeout in case of hang.