db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2871) XATransactionTest gets XaException: Error executing a XAResource.commit(), server returned XAER_PROTO.
Date Tue, 05 Feb 2008 20:21:07 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12565866#action_12565866
] 

Daniel John Debrunner commented on DERBY-2871:
----------------------------------------------

Can some comments be added to this in the test, it's a little unclear what's going on in the
catch block.
The exception that caused the failure is being thrown away, this is a problem if the test
fails in the future, the exception normally points to where the problem is, losing that information
makes debugging much harder, especially with an intermittent problem.

+        try {
+            stm = getConnection().createStatement();
+            rs = stm.executeQuery("select count(*) from XATT");
+            rs.next();
+        } catch (SQLException e) {
+            rs = stm.executeQuery("select global_xid from syscs_diag.transaction_table "
+                                + "where global_xid is not null order by global_xid");
+            StringBuffer sb = new StringBuffer("Global transactions in progress:\n"); 
+            while (rs.next()) {
+                sb.append(rs.getString(1));
+                sb.append("\n");
+            }
+            Assert.fail(sb.toString());
+        }



> XATransactionTest gets XaException: Error executing a XAResource.commit(), server returned
XAER_PROTO.
> ------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2871
>                 URL: https://issues.apache.org/jira/browse/DERBY-2871
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.3.1.4
>         Environment: OS: HP-UX v1.11 i 
> JDK: HP 1.5.0.03 
>            Reporter: Henri van de Scheur
>            Assignee: Julius Stroffek
>            Priority: Minor
>         Attachments: d2871-test.diff, d2871-test.stat, d2871.diff, d2871.diff, d2871.diff,
d2871.stat, d2871.stat, d2871.stat, DERBY-2871_020108.diff
>
>
> Method: org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest
> Signature:
> %XAER_PROTO : Error executing a XAResource.commit(), server returned XAER_PROTO%
> Also see: http://dbtg.thresher.com/derby/test/10.3.1.0_RC/jvm1.5/testing/testlog/hpux/548006-suitesAll_diff.txt

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message