MXOSRVRs don't get released after interrupting execution of the client application (ODB)

[Chirag Bhalgami]

MXOSRVRs are not getting released when ODB application is interrupted during execution.

After restarting DCS, it still shows that odb app is occupying MXOSRVRs.

Also, executing odb throws following error message:

-----------------------------------------------------------------------------
odb [2015-03-31 21:19:11]: starting ODBC connection(s)... (1) 1 2 3 4
Connected to HP Database
[3] 5,000 records inserted [commit]
[2] odb [Oloadbuff(9477)] - Error (State: 25000, Native -8606)
[Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit transaction. [2015-03-31 21:39:47]
[2] 0 records inserted [commit]
[3] odb [Oloadbuff(9477)] - Error (State: 25000, Native -8606)
[Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit transaction. [2015-03-31 21:39:47]
[3] 5,000 records inserted [commit]
[4] odb [Oloadbuff(9477)] - Error (State: 25000, Native -8606)
[Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit transaction. [2015-03-31 21:39:47]
[4] 0 records inserted [commit]
[1] odb [Oloadbuff(9477)] - Error (State: 25000, Native -8606)
[Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit transaction. [2015-03-31 21:39:47]
[1] 0 records inserted [commit]
odb [sigcatch(4125)] - Received SIGINT. Exiting
-----------------------------------------------------------------------------

Trafodion Build: Release [1.0.0-304-ga977ee7_Bld14], branch a977ee7-master, date 20150329_083001)
Hadoop Distro: HDP 2.2
HBase Version: 0.98.4.2.2.0.0

[Daniel Lu (ping-lu)]

not familiar with ODB.
is it reproducible with a regular ODBC application? or reproducible regularly.
looks like some TM component raise error when client interrupt the execution/preparation from client side.
can we supply more pstack dump on the pending mxosrvr? so we can get some context where we are pending on.