[
https://issues.apache.org/jira/browse/TRAFODION-1117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14716711#comment-14716711
]
Suresh Subbiah commented on TRAFODION-1117:
-------------------------------------------
Aruna Sadashiva (aruna-sadashiva) wrote on 2015-04-01: #1
This is a DCS issue, happens with trafci and any tool/program using odbc/jdbc
drivers.
Changed in trafodion:
assignee: Aruna Sadashiva (aruna-sadashiva) → nobody
assignee: nobody → Anuradha (anuradha-hegde)
Aruna Sadashiva (aruna-sadashiva) wrote on 2015-04-01: #2
Also, Chirag, before restarting dcs you should kill any leftover mxosrvrs if
dcsstop did not stop all mxosrvrs.
Chirag Bhalgami (chirag-bhalgami) wrote on 2015-04-07: #3
providing loadcmd=ul resolve the issue... ul=upsert load
e.g.
./odb64luo -l
src=nofile:tgt=<table_name>:max=1000:loadcmd=ul:map=<file.map>:rows=500:parallel=4
-u <userid> -p <password> -d TDM_Default_DataSource
Chirag Bhalgami (chirag-bhalgami) on 2015-04-08
Changed in trafodion:
milestone: none → r1.2
> 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: Chirag Bhalgami
> Assignee: Anuradha Hegde
> Priority: Blocker
> Fix For: 2.0-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)
