Recovery bug: prepared transaction belongs to another database
This post has NOT been accepted by the mailing list yet.
I think I found bug in Bitronix. If I have pending transactions, bitronix is trying to repair it and execute rollback or commit commands. But in PostgreSQL you have to execute "commit prepared" command only in database where it belongs.
- I work with several databases from single JVM.
- I have 16 pending transactions in database (it's ok.)
- bitronix chooses one for recovery
- and executes commit prepared in wrong database.