Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-1117

LP Bug: 1438961 - ODB doesn't terminate connections with DB when execution is interrupted

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Blocker
    • Resolution: Unresolved
    • None
    • 2.4
    • db-utility-odb
    • None

    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-304-ga977ee7_Bld14], branch a977ee7-master, date 20150329_083001)
      Hadoop Distro: HDP 2.2
      HBase Version: 0.98.4.2.2.0.0

      Attachments

        Activity

          People

            weiqxu Weiqing Xu
            weiqxu Weiqing Xu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: