[jira] [Created] (TRAFODION-2724) JDBC LOB tests show symptoms of a leaked statement handle

["Sandhya Sundaresan (JIRA)" <ji...@apache.org>]

Sandhya Sundaresan created TRAFODION-2724:
---------------------------------------------

             Summary: JDBC LOB tests show symptoms of a leaked statement handle
                 Key: TRAFODION-2724
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2724
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
    Affects Versions: 2.2-incubating
            Reporter: Sandhya Sundaresan
            Assignee: Sandhya Sundaresan
             Fix For: 2.2-incubating


The number of opens for any mxosrvr is limited to 13 due to a recent change. This exposed an issue where we were not closing some internal statements during an extract statement . JDBC driver uses the SQL extract statment to implement the stream API. This exposed the issue.
The test failed with this error:

> 2017-08-16 01:12:27 Running testBatchInsertFKNotExist......
> 2017-08-16 01:12:56 Batch Update Failed, See next exception for 
> details
> 2017-08-16 01:12:56 *** ERROR[8103] The operation is prevented by 
> referential integrity constraint
> TRAFODION.T4QA.BATCH_TEST_TABLE_FK_911645628_4551 on table 
> TRAFODION.T4QA.BATCH_TEST_TABLE_FK.
> 2017-08-16 01:13:11 *** ERROR[2026] Server Process $ZSM0 has reached 
> allowed depth for nowait operation from the process 0,15846.
> [2017-08-16 01:13:11]
> 

Debugging and dumping hte open and fetch statements in the context at that point showed this pattern :

There were around 13 statements in OPEN or FETCH statement with the 
> source string "select dataOffset, chunkLen, stringParam from 
> table(ghost table
> "TRAFODION"."T4QA"."LOBDescChunks__08574991311373262837_0002")
> where descPartnKey = and descSyskey = "
> 
> These internal statements should be closed for the jdbc_test_cdh to 
> pass or comment out the tests that triggers these internal statements 
> for time being.




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)