[
https://issues.apache.org/jira/browse/TRAFODION-1117?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Weiqing Xu updated TRAFODION-1117:
----------------------------------
Fix Version/s: (was: 2.1-incubating)
2.3-incubating
> LP Bug: 1438961 - ODB doesn't terminate connections with DB when execution is
> interrupted
> -----------------------------------------------------------------------------------------
>
> Key: TRAFODION-1117
> URL: https://issues.apache.org/jira/browse/TRAFODION-1117
> Project: Apache Trafodion
> Issue Type: Bug
> Components: db-utility-odb
> Reporter: Weiqing Xu
> Assignee: Weiqing Xu
> Priority: Blocker
> Fix For: 2.3-incubating
>
>
> 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-304-ga977ee7_Bld14], branch a977ee7-master,
> date 20150329_083001)
> Hadoop Distro: HDP 2.2
> HBase Version: 0.98.4.2.2.0.0
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
