db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fernanda Pizzorno (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1475) lang/procedure.java intermittently fails on SunOS-5.10_i86
Date Wed, 05 Jul 2006 08:50:30 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1475?page=all ]

Fernanda Pizzorno updated DERBY-1475:
-------------------------------------

    Attachment: derby-1475.diff
                derby-1475.stat

I had not seen the new diff in DERBY-1320 after the applying the same fix as for setTransactionIsolation.
These problems seem to be related. Thank you Myrna for pointing it out.

The attached patch (derby-1475.diff) fixes the problem by closing the result sets before setting
them to null in org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows, when
the parameter p2 = 199. Closing the result sets before setting them to null, prevents later
tests (calling the Connection.setTransactionIsolation() method) to fail if these result sets
have not yet been garbage collected.

I have run lang/procedure.java more than 4000 consecutive times without failure with this
patch.

Can someone please review the patch?


> lang/procedure.java intermittently fails on SunOS-5.10_i86
> ----------------------------------------------------------
>
>          Key: DERBY-1475
>          URL: http://issues.apache.org/jira/browse/DERBY-1475
>      Project: Derby
>         Type: Bug

>   Components: Test
>  Environment: Java Version:    1.5.0_06
> OS name:         SunOS
> OS version:      5.10
>     Reporter: Fernanda Pizzorno
>     Assignee: Fernanda Pizzorno
>  Attachments: derby-1475.diff, derby-1475.stat
>
> Diff:
> *** Start: procedure jdk1.5.0_06 2006-07-04 13:39:05 ***
> 219 del
> < auto commit is true
> 220 del
> < lock count before execution 0
> [...]
> 1017 del
> < JIRA-492 successful -- no hang!
> 1018 del
> < testImplicitClose(): PASSED
> 1018 add
> > ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
> > ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
> Test Failed.
> *** End:   procedure jdk1.5.0_06 2006-07-04 13:39:11 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message