db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5245) instability in test StreamingColumnTest; testDerby500_verifyVarcharStreams: junit.framework.ComparisonFailure: Unexpected SQL state. expected:<...N017> but was:<...J001>
Date Tue, 24 May 2011 17:49:47 GMT
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.3
         Environment: Windows XP, ibm 1.6 SR9 FP1
            Reporter: Myrna van Lunteren
            Priority: Minor


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 is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message