You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2014/01/15 14:45:21 UTC

[jira] [Commented] (DERBY-5245) instability in test StreamingColumnTest; testDerby500_verifyVarcharStreams: junit.framework.ComparisonFailure: Unexpected SQL state. expected:<...N017> but was:<...J001>

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

Rick Hillegas commented on DERBY-5245:
--------------------------------------

Saw this on private distribution (10.6.2.3 svn 1557765) on JDK6 on Solaris 11 sparc.

> instability in test StreamingColumnTest; testDerby500_verifyVarcharStreams: junit.framework.ComparisonFailure: Unexpected SQL state. expected:<...N017> but was:<...J001>
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5245
>                 URL: https://issues.apache.org/jira/browse/DERBY-5245
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.6.2.4
>         Environment: Windows XP, ibm 1.6 SR9 FP1
>            Reporter: Myrna van Lunteren
>            Priority: Minor
>              Labels: derby_triage10_10
>
> I saw this failure in nightly tests on the 10.6 branch, built with branch synced to revision level: 1102940.
> This run is (until cleanup happens) under link: 
> http://people.apache.org/~myrnavl/derby_test_results/v10_6/windows/testlog/ibm16/1102940-suites.All_diff.txt
> Here's the stack trace: 
> 1) testDerby500_verifyVarcharStreams(org.apache.derbyTesting.functionTests.tests.store.StreamingColumnTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<...N017> but was:<...J001>
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:762)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:797)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:797)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:811)
> 	at org.apache.derbyTesting.functionTests.tests.store.StreamingColumnTest.testDerby500_verifyVarcharStreams(StreamingColumnTest.java:1565)
> 	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:109)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:16)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:16)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:16)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:16)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:16)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:16)
> Caused by: java.sql.SQLNonTransientConnectionException: Java exception: 'Stream read error on client side when transferring user data to server.: java.io.IOException'.
> 	at java.lang.Throwable.<init>(Throwable.java:67)
> 	at java.sql.SQLException.<init>(SQLException.java:101)
> 	at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
> 	at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
> 	at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
> 	at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown Source)
> 	at org.apache.derbyTesting.functionTests.tests.store.StreamingColumnTest.testDerby500_verifyVarcharStreams(StreamingColumnTest.java:1555)
> 	... 53 more
> Caused by: org.apache.derby.client.am.SqlException: Java exception: 'Stream read error on client side when transferring user data to server.: java.io.IOException'.
> 	at org.apache.derby.client.am.SqlException.<init>(Unknown Source)
> 	at org.apache.derby.client.am.SqlException.<init>(Unknown Source)
> 	at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
> 	at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source)
> 	at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown Source)
> 	at org.apache.derby.client.net.StatementReply.readExecute(Unknown Source)
> 	at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown Source)
> 	at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown Source)
> 	at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
> 	at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source)
> 	... 55 more
> This issue has been seen before on this branch; on April 26, 2011, Rick Hillegas asked about this instability, see this thread: http://mail-archives.apache.org/mod_mbox/db-derby-dev/201004.mbox/%3C4BD5F0EC.7000501@oracle.com%3E
> This is the first time I noticed it.
> As an aside, note that this test run also showed some other intermittent issues: this failure:
> 2) Upgrade test for 10.6junit.framework.AssertionFailedError: extinout
> 	at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:116)
>  Like DERBY-4916
> and this error:
> 1) testReplication_Local_1_Indexing(org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing)
> java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create database '[editedpath]\db_master\wombat', 
> see the next exception for details.::SQLSTATE: XBM0JDirectory [editedpath]\db_master\
> [editedpath]\db_master\wombat already exists.
>   which is like DERBY-4635.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)