MXOSRVRs don't get released after interrupting execution of the client application (ODB)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
High
|
Daniel Lu |
Bug Description
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-
Hadoop Distro: HDP 2.2
HBase Version: 0.98.4.2.2.0.0
description: | updated |
description: | updated |
Changed in trafodion: | |
milestone: | none → r1.2 |
assignee: | nobody → Daniel Lu (ping-lu) |
Changed in trafodion: | |
status: | New → In Progress |
not familiar with ODB. preparation from client side.
is it reproducible with a regular ODBC application? or reproducible regularly.
looks like some TM component raise error when client interrupt the execution/
can we supply more pstack dump on the pending mxosrvr? so we can get some context where we are pending on.