[DERBY-5800] test failure in AutoloadTest; AssertionFailedError: Test process failed:Spawned caused by SQLNonTransientConnectionException - Software caused connection abort: recv failed.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.9.1.0, 10.9.2.2
• Fix Version/s: 10.9.2.2, 10.10.2.0, 10.11.1.1
• Component/s: Test
• Labels: derby_triage10_10
• Urgency: Normal
• Bug behavior facts: Regression Test Failure
• Assignee: Mike Matrigali
• Reporter: Myrna van Lunteren
• Created: 06/Jun/12 13:57
• Updated: 22/Oct/14 19:23
• Resolved: 15/Apr/13 16:57

Description

I've seen a couple of these during my testing of the 10.9.1 release candidate.

On AIX I saw 4 issues with this test; on rerun, it seemed to be intermittent.
It seemed to go better when I used -Xmx512M, and also it seems using -Dderby.tests.basePort interfered, so perhaps I was using ports already in use on the system - I'll check on that when all other testing is complete.

This example is from a Windows 2008 ibm 1.6 run, where there was just 1 failure:
spawnProcess:JDBCDriversEmbeddedTest(org.apache.derbyTesting.functionTests.tests.jdbcapi.AutoloadTest)junit.framework.AssertionFailedError: Test process failed:Spawned org.apache.derbyTesting.functionTests.tests.jdbcapi.JDBCDriversEmbeddedTest exitCode=1
STDOUT:
...........F...
Time: 5.312
There was 1 failure:
1) testExplicitLoad(org.apache.derbyTesting.functionTests.tests.jdbcapi.AutoloadTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<0800[4]> but was:<0800[6]>
at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:853)
at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:896)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.AutoloadTest.testUnsuccessfulConnect(AutoloadTest.java:414)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.AutoloadTest.explicitLoad(AutoloadTest.java:457)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.AutoloadTest.testExplicitLoad(AutoloadTest.java:426)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:424)
at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:441)
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)
Caused by: java.sql.SQLNonTransientConnectionException: A communications error has been detected: Software caused connection abort: recv failed.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:379)
at java.sql.DriverManager.getConnection(DriverManager.java:415)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.AutoloadTest.testUnsuccessfulConnect(AutoloadTest.java:409)
... 33 more
Caused by: org.apache.derby.client.am.DisconnectException: A communications error has been detected: Software caused connection abort: recv failed.
at org.apache.derby.client.net.NetAgent.throwCommunicationsFailure(Unknown Source)
at org.apache.derby.client.net.Reply.fill(Unknown Source)
at org.apache.derby.client.net.Reply.ensureALayerDataInBuffer(Unknown Source)
at org.apache.derby.client.net.Reply.readDssHeader(Unknown Source)
at org.apache.derby.client.net.Reply.startSameIdChainParse(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.readExchangeServerAttributes(Unknown Source)
at org.apache.derby.client.net.NetConnection.readServerAttributesAndKeyExchange(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowServerAttributesAndKeyExchange(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown Source)
... 37 more
Caused by: java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.read(SocketInputStream.java:140)
... 49 more

Issue Links

• duplicates: DERBY-6178 AutoloadTest does not proprogate original jvm -D flags to spawned JVM, leading to LAB regression test failures