[
https://issues.apache.org/jira/browse/TRAFODION-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16136923#comment-16136923
]
Sandhya Sundaresan commented on TRAFODION-2724:
-----------------------------------------------
Debugging shows that if the caller of the Extract API specifies the exact
length of the lob data to be extracted, there was a "less than" condition that
did not pass and hence the cursor never got closed. If they passed in a length
larger than the extracted length , then the cursor was closed. In both cases
the data and length extracted are what is used to return to the claler. SO the
results were correct. But in one case we exit without closing the cursor and
hence the leak.
> 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)
