You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anuradha Hegde (JIRA)" <ji...@apache.org> on 2016/06/06 16:10:21 UTC
[jira] [Updated] (TRAFODION-1117) LP Bug: 1438961 - ODB doesn't
terminate connections with DB when execution is interrupted
[ https://issues.apache.org/jira/browse/TRAFODION-1117?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anuradha Hegde updated TRAFODION-1117:
--------------------------------------
Reporter: Weiqing Xu (was: Chirag Bhalgami)
> 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: Anuradha Hegde
> Priority: Blocker
> Fix For: 2.1-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.3.4#6332)