db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julius Stroffek (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2871) XATransactionTest gets XaException: Error executing a XAResource.commit(), server returned XAER_PROTO.
Date Wed, 08 Aug 2007 16:24:59 GMT

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

Julius Stroffek updated DERBY-2871:
-----------------------------------

    Attachment: d2871-test.stat
                d2871-test.diff

I rewrote the test that it will not close the connections and they will not be garbage collected
neither since I call the XAConnection.close method on every connection at the end of the test.

I ran all the tests (suites.All and derbyall) without failures on my box for 'd2871-test'
patch also with a patch for DERBY-2953 without any failures. I tried to run those test also
on a HP-UX box where the test was originally failing. The rewritten test always fails with
the message 

---
1) testXATransactionTimeout(org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest)java.sql.SQLException:
A communications e
rror has been detected: Broken pipe (errno:32).
        at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:46)
        at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:362)
        at org.apache.derby.client.ClientPooledConnection.<init>(ClientPooledConnection.java:115)
        at org.apache.derby.client.ClientXAConnection.<init>(ClientXAConnection.java:48)
        at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newClientXAConnection(ClientJDBCObjectFactoryImpl.java:76)
        at org.apache.derby.jdbc.ClientXADataSource.getXAConnectionX(ClientXADataSource.java:88)
        at org.apache.derby.jdbc.ClientXADataSource.getXAConnection(ClientXADataSource.java:72)
        at org.apache.derby.jdbc.ClientXADataSource.getXAConnection(ClientXADataSource.java:65)
        at org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest.testXATransactionTimeout(XATransactionTest.java:188)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
        at junit.extensions.TestSetup.run(TestSetup.java:25)
        at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
        at junit.extensions.TestSetup.run(TestSetup.java:25)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
        at junit.extensions.TestSetup.run(TestSetup.java:25)
        at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Caused by: org.apache.derby.client.am.DisconnectException: A communications error has been
detected: Broken pipe (errno:32).
        at org.apache.derby.client.net.NetAgent.throwCommunicationsFailure(NetAgent.java:413)
        at org.apache.derby.client.net.NetAgent.sendRequest(NetAgent.java:387)
        at org.apache.derby.client.net.NetAgent.flush_(NetAgent.java:265)
        at org.apache.derby.client.am.Agent.flowOutsideUOW(Agent.java:196)
        at org.apache.derby.client.net.NetConnection.flowServerAttributesAndKeyExchange(NetConnection.java:773)
        at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(NetConnection.java:617)
        at org.apache.derby.client.net.NetConnection.flowConnect(NetConnection.java:435)
        at org.apache.derby.client.net.NetConnection.initialize(NetConnection.java:296)
        at org.apache.derby.client.net.NetConnection.<init>(NetConnection.java:280)
        at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(ClientJDBCObjectFactoryImpl.java:264)
        at org.apache.derby.client.net.NetXAConnection.createNetConnection(NetXAConnection.java:269)
        at org.apache.derby.client.net.NetXAConnection.<init>(NetXAConnection.java:73)
        at org.apache.derby.client.ClientPooledConnection.getNetXAConnection(ClientPooledConnection.java:331)
        at org.apache.derby.client.ClientPooledConnection.<init>(ClientPooledConnection.java:108)
        ... 44 more
Caused by: java.net.SocketException: Broken pipe (errno:32)
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:97)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:141)
        at org.apache.derby.client.net.Request.sendBytes(Request.java:1388)
        at org.apache.derby.client.net.Request.flush(Request.java:1382)
        at org.apache.derby.client.net.NetAgent.sendRequest(NetAgent.java:385)
        ... 56 more
---


I explored a problem a bit and discovered that the problem occurs due to the limit of the
number of open files and I have created a simple code to verify this...

        int count = 1000;
        XAConnection xaConn[] = new XAConnection[count];

        try {
            // start-up the server
            NetworkServerControl server = new NetworkServerControl();
            server.start (null);

            for (int i=0; i < count; i++) {
                System.out.print("Creating connection number " + i + "...");
                xaConn[i] = createXAConnection(connString, "", "");
                System.out.println("Ok.");
            }

            for (int i=0; i < count; i++) {
                xaConn[i].close();
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }

which will throw an exception after creating a connection number 391

org.apache.derby.client.am.DisconnectException: java.net.SocketException : Error connecting
to server localhost on port 1527 with message File table overflow (errno:23).
        at org.apache.derby.client.net.NetAgent.<init>(NetAgent.java:129)
        at org.apache.derby.client.net.NetConnection.newAgent_(NetConnection.java:1086)
        at org.apache.derby.client.am.Connection.initConnection(Connection.java:218)
        at org.apache.derby.client.am.Connection.<init>(Connection.java:169)
        at org.apache.derby.client.net.NetConnection.<init>(NetConnection.java:278)
        at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(ClientJDBCObjectFactoryImpl.java:264)
        at org.apache.derby.client.net.NetXAConnection.createNetConnection(NetXAConnection.java:269)
        at org.apache.derby.client.net.NetXAConnection.<init>(NetXAConnection.java:73)
        at org.apache.derby.client.ClientPooledConnection.getNetXAConnection(ClientPooledConnection.java:331)
        at org.apache.derby.client.ClientPooledConnection.<init>(ClientPooledConnection.java:108)
        ... 8 more
Caused by: java.net.SocketException: File table overflow (errno:23)
        at java.net.Socket.createImpl(Socket.java:397)
        at java.net.Socket.<init>(Socket.java:359)
        at java.net.Socket.<init>(Socket.java:178)
        at javax.net.DefaultSocketFactory.createSocket(SocketFactory.java:196)
        at org.apache.derby.client.net.OpenSocketAction.run(OpenSocketAction.java:62)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.derby.client.net.NetAgent.<init>(NetAgent.java:127)
        ... 17 more
------

> 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.0
>         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.stat
>
>
> 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