ODB doesn't terminate connections with DB when execution is interrupted
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
New
|
Critical
|
Anuradha |
Bug Description
If execution of ODB is interrupted then it does not terminate connections with DB (Trafodion) .
Restarting DCS does not help. It shows odb app is still occupying MXOSRVRs.
Also, re-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
-------
ODB version: odb64luo
Trafodion Build: Release [1.0.0-
Hadoop Distro: HDP 2.2
HBase Version: 0.98.4.2.2.0.0
Changed in trafodion: | |
milestone: | none → r1.2 |
This is a DCS issue, happens with trafci and any tool/program using odbc/jdbc drivers.