db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-977) jdbcapi/xaSimplePositive.sql fails
Date Thu, 16 Feb 2006 19:03:10 GMT
    [ http://issues.apache.org/jira/browse/DERBY-977?page=comments#action_12366663 ] 

Mike Matrigali commented on DERBY-977:
--------------------------------------

If you look in the actual test you will see the explanation of this diff:
ij(XA)> -- NOTE: The following call to "xa_recover xa_startrscan" is apt to
-- return the result set rows in reverse order when changes to
-- the Derby engine affect the number of transactions that it takes
-- to create a database.  The transactions are stored in a hash table
-- based on a global and local id, and when the number of transactions
-- changes, the (internal) local id can change, which may lead to a
-- change in the result set order.  This order is determined by the
-- JVM's hashing algorithm. Examples of changes to the engine that
-- can affect this include ones that cause more commits or that
-- change the amount of data being stored, such as changes to the
-- metadata statements (which is what prompted this explanation in
-- the first place).  Ultimately, the problem is that there is no
-- way to order the return values from "xa_recover" since it is an
-- ij internal statement, not SQL...
xa_recover xa_startrscan;
Recovered 2 in doubt transactions
Transaction 1 : (1,FILTERED,FILTERED)
Transaction 2 : (2,FILTERED,FILTERED)

> jdbcapi/xaSimplePositive.sql fails
> ----------------------------------
>
>          Key: DERBY-977
>          URL: http://issues.apache.org/jira/browse/DERBY-977
>      Project: Derby
>         Type: Test
>   Components: Regression Test Failure
>     Versions: 10.2.0.0
>  Environment: Solaris 10 3/05 s10_74L2a X86 - SunOS 5.10 Generic, JVM: Sun Microsystems
Inc. 1.5.0_04
>     Reporter: Ole Solberg

>
> "Signature":
> ********* Diff file xa/xa/xaSimplePositive.diff
> *** Start: xaSimplePositive jdk1.5.0_04 xa:xa 2006-02-14 03:03:46 ***
> 97 del
> < Transaction 1 : (1,FILTERED,FILTERED)
> 98 del
> < Transaction 2 : (2,FILTERED,FILTERED)
> 98a97,98
> > Transaction 1 : (2,FILTERED,FILTERED)
> > Transaction 2 : (1,FILTERED,FILTERED)
> Test Failed.
> *** End:   xaSimplePositive jdk1.5.0_04 xa:xa 2006-02-14 03:03:50 ***
> http://www.multinet.no/~solberg/public/Apache/TinderBox_Derby/Limited/testSummary-377554.html

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