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

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

     [ https://issues.apache.org/jira/browse/TRAFODION-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sandhya Sundaresan resolved TRAFODION-2724.
-------------------------------------------
    Resolution: Fixed

> 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)